hsqldb « Database « JPA Q&A





1. Hibernate on hypersonic in production?    stackoverflow.com

Developers of hypersonic promise increase of performance? But I'm afraid problems with administrating and other aspects of using hsqlDB. Are anybody using this in production? Is it good idea?

2. dynamicly add new typeAliases to hsqldb ( inet and text)    stackoverflow.com

I am working with hibernate and PostgreSQL for deployment and for testing I am using hsqldb. Is there a way that I can add Aliases ( without changing hsqdb source code ...

3. Hibernate3.5.6 problem with HSQLDB-2.1.0 dialect    coderanch.com

Hello All- Has anyone found a problem using Hibernate3.5.6 with HSQL-2.1.0? It appears as though hibernate is not understanding the dialect. I have a simple entity in my application, hibernate emits the following DDL (and the error it encounters) 09:13:21,971 ERROR SchemaUpdate:212 - Unsuccessful: create table FACULTY (id numeric(19,0) identity not null, FIRST_NAME varchar(255) null, LAST_NAME varchar(255) null, primary key (id)) ...

4. Strange Problems in hibernate with hsqldb    forum.hibernate.org

hi robert, thanks for your reply. I tried your suggestion but still not working. I have pasted the relevant part of my configuration file below: Code: false org.hsqldb.jdbcDriver ...

5. Problem with Hibernate / JPA / HSQLDB    forum.hibernate.org

6. Problem Using Hibernate with HSQLDB    forum.hibernate.org

Hi guys, please help if you can! I am using Hibernate with HSQLDB. I have a file-based HSQL database called "testdb". The problem is, when I try to connect to my HSQL file-string URL, the application hangs. It hangs right after this Hibernate output: Code: INFO: using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:file:testdb INFO: connection properties: {user=SA, password=****} Note that the problem ...

7. HSQLDB shutdown    forum.hibernate.org

8. HSQLDB alpha Q    forum.hibernate.org

Hi all, Is there someone on this forum using the latest alpha from Hypersonic SQL. The version I am currently using is ALPHA_M, which is running fine with my application. Moving to ALPHA_Q is giving strange errors. I get an SQL exception back claiming he could not find a certain column, though the column is there. Thanks. Kenneth

9. Using HSQLDB in IN-PROCESS (Standalone) MODE    forum.hibernate.org

It appears to me that if I let Hibernate manage the JDBC connection to HSQL I can't get HSQL running in IN-PROCESS (Standalone) MODE. According to the HSQL Doc, to do this you need to: Connection c = DriverManager.getConnection ("jdbc:hsqldb:testdb", "sa", ""); Which I guess Hibernate is not doing, so that as a result I felt I had to call JDBC ...





10. [HSQLDB] Strange behaviour - fails/success predictable    forum.hibernate.org

Hi forum, I 've created an HSQLDB+JUnit test suite while trying to adapt some things I've learned while reading the book 'Java Open Source Programming - with ...'. I am not a newbee to hibernate but slightly for HSQLDB + hibernate, maybe I am trying something stupid, but it seams too strange for me. What I have: -HSQLDB 1.7.1 -Hibernate 2.1 ...

11. HSQLDB in IN-PROCESS (Standalone) MODE    forum.hibernate.org

I'm having some problems with using HSQLDB and hibernate in IN-PROCESS mode. It seems that it's not handling multiple connections well. I'm fairly certain HSQLDB should be okay with this. At one point I did have this stuff working but it's broken somewhere along the way. Code: 10:15:01,562 DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider:78 - total checked-out connections: 1 10:15:01,562 DEBUG net.sf.hibernate.connection.DriverManagerConnectionProvider:94 - opening new ...

12. Hibernate 2.1.6 and HSQLDB 1.7.1    forum.hibernate.org

I was wondering if there was a way to use Hibernate 2.1.6 with HSQLDB 1.7.1. I've run into bugs with HSQLDB 1.7.2 (Not hibernate) and would rather not revert back to Hibernate 2.1.4. Specifically the generation of the database schema using Hibernate 2.1.6 from the mapping file seems to require HSQLDB 1.7.2 now, and there seems only to be one HSQL ...

13. hibernate & HSQLDB    forum.hibernate.org

i got it. thanks. may i ask another question? my application will be connect to two different database(one is MySQL and another is HSQLDB). i use JBoss as my application server and generate jboss-service.xml to connect MySQL. how my application connect to HSQLDB ? below is my jboss-service.xml. is it need to add another mbean for hsqldb? when do transaction, how ...

14. Hsqldb and Hibernate    forum.hibernate.org

Hi, I am using the hsqldb db version 1.7.3.3. I am able to create the tables and I see the tables from the Database Manager. Hibernate version is 3.0. When I run the example to save Product object I get SQL exception : Table Not Found in the insert statement "products". I am able to see the products table in the ...

15. Problem with Hibernate 2.x and HSQLDB 1.8.0    forum.hibernate.org

I am trying to use latest version of HSQLDB (1.8.0) with Hibernate (2.1.8) but I have strange exception. See stacttrace below. With 1.7.3.3 version my application work well. This is my config file Code: ...

16. hibernate and HSQLDB 1.8.0    forum.hibernate.org

I downloaded the hibernate package and ran the eg example with hsqldb 1.8.0. This worked fine, however when I altered the example so the tables were created and stored in one run and read in another run of the program (by commenting away the lines .setProperty(Environment.HBM2DDL_AUTO, "create"); and test.createTestAuctions(); ) the tables were no longer there. It seemed like hsqldb only ...





17. Hibernate HSQLDB Issue    forum.hibernate.org

18. Couldn't access hsqldb using hibernate in multiple thread ?    forum.hibernate.org

Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp 2.1.7: can't startup: private static final SessionFactory sessionFactory; static { try { sessionFactory = new Configuration().configure().buildSessionFactory(); } catch (HibernateException ex) { throw new RuntimeException("Exception building SessionFactory: " + ex.getMessage()); } } public static final ThreadLocal session = new ThreadLocal(); public static Session currentSession() throws HibernateException { Session s = (Session) session.get(); ...

19. How to run HSQLDB????    forum.hibernate.org

21. Generating The Database - Hibernate using HSQLDB    forum.hibernate.org

22. AbstractTransactionalDataSourceSpringContextTests vs HSQLDB    forum.hibernate.org

I used to use HSQLDB a lot. It is easy to start, easy to manipulate the data (in the script file) and doesn't take a lot of my notebook's resources. I found, hoever, the sequence generation harder to set up than Oracle. I also used to have a full install of Oracle 10g, but it ran like a dog and slowed ...

23. hsqldb port problems    forum.hibernate.org

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL []; SQL state [08000]; error code [-80]; socket creation error; nested exception is java.sql.SQLException: socket creation error org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:97) org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:258) org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364) org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351) org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:369) org.springframework.orm.hibernate.HibernateTemplate.update(HibernateTemplate.java:576) org.springframework.orm.hibernate.HibernateTemplate.update(HibernateTemplate.java:572) src.db.PhotoDaoHib.addPhotoinfo(PhotoDaoHib.java:21)

24. HSQLDB and JPA    forum.hibernate.org

Hello guys, excuse me, my English is not very good, I hope you understand me, but I've a dude, and I'd like you resolve it. I'm working with JPA and hsqldb. My URL connection is jdbc:hsqldb:file:/home/luis/Desktop/Proyecto/SAETest/db/saedb. I created the DB with SQuierreL SQL Client Program, using DDL (Data Definition Language), this program generated 3 files : a)saedb.log, b)saedb.properties, c)saedb.script This last ...

25. Hibernate Tuple syntax and HSQLDB    forum.hibernate.org

Hi, I'm running tests with hibernate and HSQLDB and found that hibernate improperly generates a tuple syntax even if the HSQLDialect does not support rowvalueconstructor. This same tuple syntax works fine on Oracle10g. Why Hibernate would generate such SQL even for dialects that don't support row value constructor ? See org.hibernate.dialect.HSQLDialect.supportsRowValueConstructorSyntax() org.hibernate.dialect.HSQLDialect.supportsRowValueConstructorSyntaxInInList() Hibernate version: 3.2.6 Mapping documents: Code:

26. converting from hsqldb to postgresql in hibernate book    forum.hibernate.org

I'm trying to learn Hibernate and got through using an EJB container with hsqldb in the "Java Persistence with Hibernate' book. I then decided to convert to postgresql. I got it working with the first two example but when I try to use an EJB container (JBoss) I am having problems with the JNDI context when trying to deploy the schema. ...

27. HSQLDB issue when using hibernate only    forum.hibernate.org

I have installed and run the HSQLDB in my local machine. I created a table and inserted some data. In order to retrieve this data, first I tested with JDBC code and it returned the exact result. Code: Class.forName("org.hsqldb.jdbcDriver"); ...