Hypersonic SQL DB - JDBC connection fails
  Home FAQ Contact Sign in
comp.lang.java.databases only
 
Advanced search
POPULAR GROUPS

more...

comp.lang.java.databases Profile…
 Up
Hypersonic SQL DB - JDBC connection fails         


Author: Joydeep
Date: Oct 2, 2006 23:11

Hi,

I have OpenOffice.org 2.0.2 & I created an ".odb" file named "j2.odb"
with OpenOffice.org Base.

Previously I am able to successfully connect to MS Access using
JDBC-ODBC bridge driver with the same source code given below, but now
when I tried to connect with that "j2.odb" file with the help of
"hsqldb.jar" file and it is not a success.

When I am using Netbeans 5.5 runtime database connection with that
"hsqldb.jar" file, it is connected successfully but giving only 2
schemas (named "INFORMATION_SCHEMA" & "PUBLIC") which are not created
by me & at the same time I see a text file named "j2" is created with
the following code :

***** j2.txt ********
CREATE USER SA PASSWORD "" ADMIN
/*C1*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
***** end of .txt file *******
Show full article (4.60Kb)
2 Comments
Re: Hypersonic SQL DB - JDBC connection fails         


Author: Arne Vajhøj
Date: Oct 3, 2006 16:33

Joydeep wrote:
> When I am using Netbeans 5.5 runtime database connection with that
> "hsqldb.jar" file, it is connected successfully but giving only 2
> schemas (named "INFORMATION_SCHEMA" & "PUBLIC") which are not created
> by me & at the same time I see a text file named "j2" is created with
> the following code :
> *********** j2.properties ************
> #HSQL Database Engine
> #Mon Oct 02 22:14:04 IST 2006
> hsqldb.script_format=0
> runtime.gc_interval=0
> sql.enforce_strict_size=false
> hsqldb.cache_size_scale=8
> readonly=false
> hsqldb.nio_data_file=true
> hsqldb.cache_scale=14
> version=1.8.0
> hsqldb.default_table_type=memory

hsqldb.default_table_type=cached
Show full article (0.81Kb)
no comments
Re: Hypersonic SQL DB - JDBC connection fails         


Author: IchBin
Date: Oct 3, 2006 17:15

Joydeep wrote:
> Hi,
> [snip]
> schemas (named "INFORMATION_SCHEMA" & "PUBLIC") which are not created
> by me & at the same time I see a text file named "j2" is created with
> the following code :
>
INFORMATION_SCHEMA and PUBLIC SCHEMA are automatically built in a
database. If you do not define a database with a schema it is put under
a public schema. "INFORMATION_SCHEMA" is the information about the
database and contents.

Look at the documentation...

[snip]
> try
> {
> Class.forName("org.hsqldb.jdbcDriver");
> con =DriverManager.getConnection("jdbc:hsqldb:e:/j2",
> "","");

Your connect statement does not look correct:
Show full article (1.66Kb)
no comments

RELATED THREADS
SubjectArticles qty Group
SQL Profiler in SQL Server 20002 microsoft.public.sqlserver.programming ·