memory « Database « JPA Q&A





1. HSQLDB is eating all my memory    stackoverflow.com

I'm using a HSQLDB for an application that stores research data and there is quite a lot of data. HSQLDB insists on always loading the tables into memory. I've tried fixing ...

2. JPA/HSQLDB is still eating all my memory    stackoverflow.com

I'm working on a program that parses data from a file and stores it into a HSQLDB database. As the parser encounters data it creates entities which are mapped to the ...

3. How to make hibernate 3.5.6-Final and in memory hsqldb 2.0.0 work together?    stackoverflow.com

After upgrading hsqldb dependency in pom.xml from 1.8.x to 2.0.0+ I started getting this error:

org.hsqldb.HsqlException: length must be specified in type definition: VARCHAR
Obviously, Hibernate generated incorrect CREATE TABLE expression according ...

4. Drop and re-create in-memory db    forum.hibernate.org

Hi, I'm struggle with dropping and re-creating an Derby in-memory-DB without shutting down the application. The contents of the db is to big to use delete (it took about 30 seconds), so I tried to drop db and re-create it but have problems doing this. The property below seems only to apply to re-start of the application, not seesionFactory.close(). create-drop ...

5. Problem with Running JUNITS using In Memory Hypersonic DB    forum.hibernate.org

Hi, We are trying to run JUNITS with in memory HSQL, We have some column named Min and Max in our database, now when I run a JUNIT the HyperSonic say it cannot create the tables as Min and Max are reserved keyword. Anyidea how can I fix this. I cannot alter coumn names. Thanks Binish

6. Problem using in-memory HSQLDB    forum.hibernate.org

Newbie Joined: Mon Apr 26, 2004 8:32 pm Posts: 2 I'm trying to use Hibernate with an in-memory HSQLDB data base. In my program, I load a configuration that specifies an in-memory database, then I create the database schema with SchemaUpdate (apparently successfully), then I attempt to save an object (unsuccessfully). What am I missing? Many thanks! Phil Hibernate 2.1 beta ...

7. Postgres's memory leak.    forum.hibernate.org

Hello. I use Hibernate 2.1.4 with Postgres 7.4 1-3 on cygwin. (using Tomcat, Axis.) [My project] (1)one session (Tomcat boot -> 1 open cofig. 2 create sessionFactory 3 load session 4 connect session) In my project, session never close. Because we want to Hibernate's session cache. My Hibernate's mapping file contains proxy, a lot of subclass(The table-per-hierarchy mapping), a lot of ...

8. in-memory HSQLDB issues    forum.hibernate.org

Hi, I was using my own PersistenceManager singleton which wrapped a Hibernate SessionFactory and did a session.open and session.close for all db operations and then switched all my DAOs to extend from Spring's HibernateDaoSupport (Hibernate 3). I had also been using in-memory HSQLDB with Tomcat in a web application. What I noticed is that before the migration the data would actually ...

9. Problem Hibernate 3.1rc1 and in-memory HSQLDB    forum.hibernate.org

Hi, I'm using in-memory HSQLDB for my unit tests. All my tests are ok using hibernate 3.0.5 and HSQLDB 1.7.2 or 1.8.0. I tried Hibernate 3.1rc1 (and beta3 before). Nothing is changed except the hibernate library. All my tests fail with the following exception: java.util.NoSuchElementException at org.hsqldb.lib.IntValueHashMap.get(Unknown Source) at org.hsqldb.CompiledStatementManager.getStatementID(Unknown Source) at org.hsqldb.Session.sqlPrepare(Unknown Source) at org.hsqldb.Session.execute(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source) at ...





10. Anmsoft : hibernate 3.1+DB2 7.2 - Memory leak after quries.    forum.hibernate.org

Newbie Joined: Mon Jan 30, 2006 11:28 am Posts: 13 Location: Mumbai India Hi, Problem : After performing query, closing the session, closing the session factory, memory is not released. I am using lazy collections (3.1.2 has this as a default one for collections). After performing query -> With lazy collections. 1) (Map) Session.persistenceContext -> Contains the reference of the returned ...

12. In Memory Database problems with HSQLDB    forum.hibernate.org

I'm currently trying to implement an in-memory database using Hibernate Annotations with HSQLDB and I'm running into a problem with Hibernate writing to disk. Currently I have a small class setup to add a single item into the database. After the transaction, and even after a call for the session to flush to disk, the program exits and nothing gets written ...

13. Is Decode function supported in hsqldb in memory database?    forum.hibernate.org

Is Decode function supported in hsqldb in memory database? I was trying to run Junit test on hsqldb. While selecting the record from database using JDBC query (which contains DECODE function), is giving error. So, is there any way to tell hibernate to use the sql functions like decode, rpad, case etc. while using hsqldb? Please suggest?