How to connect OpenBase DB using HSQL in JAVA

Question

can any one show code/tutorial? i googled the most.

Answer 1

OpenBase and HSQLDB are separate database products from different organisations, and it doesn't make much sense (to me) to talk about connecting to one using the other.

• If you are talking about using the JDBC driver from one database product to talk to a different database product, it is unlikely to work. Each JDBC driver uses a different proprietary "wire" protocols for communication between a Java app and the database server instance.

• If you are talking about HSQLDB's dialect of SQL with an OpenBase database, that might make sense, but you are liable to run into difference in the dialects or database engine behaviours.

The other possibility (I guess) is that you meant HQL not HSQL. If that is the case, you need to look at the Hibernate user documentation.