[Hsqldb-developers] Problems connecting to hsqldb

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Hi *,

Im doing some tests with hsqldb again. so I have dowloaded the code from 
cvs today and built with netbeans 3.5 and JDK1.4.2 on W2K. this works fine.

then I tried to connect with OpenOfffice.org. There I get the message 
that the connection is broken. So I tried with my own DB-Monitor. with 
this I get a Connection and can use hsqldb. So I switched on tracing and 
for me it seems that their could be some wrong things with the 
user-management, because I connect as user sa and tracing says the 
connect performs with user null. If I try the same settings with 
OpenOffice.org, tracing stops before.

So please can someone take a look at the tracing and give me some hints 
to go on:

trace with my monitor, where I can connect and collect only some metadata:
72617]: [Thread[listener,5,Server@f72617]]: 
handleConnection(Socket[addr=/127.0.0.1,port=1045,localport=9001]) entered
[Server@f72617]: [Thread[listener,5,Server@f72617]]: checkRunning(true) 
entered
[Server@f72617]: [Thread[listener,5,Server@f72617]]: checkRunning() exited
[Server@f72617]: [Thread[listener,5,Server@f72617]]: handleConnection() 
exited
[Server@f72617]: [Thread[ServerConnection@1617189,5,connections]]: 
4:trying to connect user null
[Server@f72617]: 4:CLI:GETCONNECTIONATTRS
[Server@f72617]: 4:call "org.hsqldb.Library.getDatabaseProductName"()
[Server@f72617]: 4:call "org.hsqldb.Library.getDatabaseProductVersion"()
[Server@f72617]: 4:CALL USER()
[Server@f72617]: 4:CALL "org.hsqldb.Library.isReadOnlyDatabase"()
[Server@f72617]: 4:SELECT * FROM SYSTEM_TABLETYPES
[Server@f72617]: 4:SELECT * FROM SYSTEM_TYPEINFO
[Server@f72617]: 4:SELECT * FROM SYSTEM_CATALOGS
[Server@f72617]: 4:SELECT * FROM SYSTEM_TABLES  WHERE 1=1
[Server@f72617]: 4:SELECT * FROM SYSTEM_TABLEPRIVILEGES  WHERE 1=1  AND 
TABLE_NAME LIKE '%'
[Server@f72617]: 4:SELECT * FROM SYSTEM_PRIMARYKEYS  WHERE 1=1  AND 
TABLE_NAME = 'ITEM'
[Server@f72617]: 4:SELECT * FROM SYSTEM_COLUMNPRIVILEGES  WHERE 1=1  AND 
TABLE_NAME = 'ITEM' AND COLUMN_NAME LIKE '%'
[Server@f72617]: 4:SELECT * FROM SYSTEM_COLUMNS  WHERE 1=1  AND 
TABLE_NAME = 'ITEM' AND COLUMN_NAME LIKE '%'
[Server@f72617]: 4:SELECT * FROM SYSTEM_CROSSREFERENCE  WHERE 1=1  AND 
PKTABLE_NAME = 'ITEM'
[Server@f72617]: 4:SELECT * FROM SYSTEM_CROSSREFERENCE  WHERE 1=1  AND 
FKTABLE_NAME = 'ITEM' ORDER BY PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, 
KEY_SEQ
[Server@f72617]: 4:SELECT * FROM SYSTEM_CROSSREFERENCE  WHERE 1=1  AND 
PKTABLE_NAME = 'ITEM'
file sync interval: 60141
file sync: 0

now try to connect with OpenOffice.org, where I get only connection is 
broken:

[Server@f72617]: [Thread[listener,5,Server@f72617]]: 
handleConnection(Socket[addr=/127.0.0.1,port=1048,localport=9001]) entered
[Server@f72617]: [Thread[listener,5,Server@f72617]]: checkRunning(true) 
entered
[Server@f72617]: [Thread[listener,5,Server@f72617]]: checkRunning() exited
[Server@f72617]: [Thread[listener,5,Server@f72617]]: handleConnection() 
exited

and with your runManager.bat I get:

file sync interval: 2221453
file sync: 31
[Server@f72617]: [Thread[listener,5,Server@f72617]]: 
handleConnection(Socket[addr=/127.0.0.1,port=1050,localport=9001]) entered
[Server@f72617]: [Thread[listener,5,Server@f72617]]: checkRunning(true) 
entered
[Server@f72617]: [Thread[listener,5,Server@f72617]]: checkRunning() exited
[Server@f72617]: [Thread[listener,5,Server@f72617]]: handleConnection() 
exited
[Server@f72617]: [Thread[ServerConnection@1b383e9,5,connections]]: 
9:trying to connect user null
[Server@f72617]: 9:SELECT * FROM SYSTEM_TABLES  WHERE 1=1  AND 
TABLE_TYPE IN ('TABLE','GLOBAL TEMPORARY','VIEW')
[Server@f72617]: 9:SELECT * FROM SYSTEM_COLUMNS  WHERE 1=1  AND 
TABLE_NAME = 'CUSTOMER'
[Server@f72617]: 9:SELECT * FROM SYSTEM_INDEXINFO  WHERE 1=1  AND 
TABLE_NAME = 'CUSTOMER'
[Server@f72617]: 9:SELECT * FROM SYSTEM_COLUMNS  WHERE 1=1  AND 
TABLE_NAME = 'INVOICE'
[Server@f72617]: 9:SELECT * FROM SYSTEM_INDEXINFO  WHERE 1=1  AND 
TABLE_NAME = 'INVOICE'
[Server@f72617]: 9:SELECT * FROM SYSTEM_COLUMNS  WHERE 1=1  AND 
TABLE_NAME = 'ITEM'
[Server@f72617]: 9:SELECT * FROM SYSTEM_INDEXINFO  WHERE 1=1  AND 
TABLE_NAME = 'ITEM'
[Server@f72617]: 9:SELECT * FROM SYSTEM_COLUMNS  WHERE 1=1  AND 
TABLE_NAME = 'PRODUCT'
[Server@f72617]: 9:SELECT * FROM SYSTEM_INDEXINFO  WHERE 1=1  AND 
TABLE_NAME = 'PRODUCT'
[Server@f72617]: 9:CALL USER()
[Server@f72617]: 9:CLI:GETCONNECTIONATTRS
[Server@f72617]: 9:CLI:GETCONNECTIONATTRS
[Server@f72617]: 9:call "org.hsqldb.Library.getDatabaseProductName"()
[Server@f72617]: 9:call "org.hsqldb.Library.getDatabaseProductVersion"()
[Server@f72617]: 9:SELECT * FROM SYSTEM_TABLES  WHERE 1=1  AND 
TABLE_TYPE IN ('TABLE','GLOBAL TEMPORARY','VIEW')
[Server@f72617]: 9:SELECT * FROM SYSTEM_COLUMNS  WHERE 1=1  AND 
TABLE_NAME = 'CUSTOMER'
[Server@f72617]: 9:SELECT * FROM SYSTEM_INDEXINFO  WHERE 1=1  AND 
TABLE_NAME = 'CUSTOMER'
[Server@f72617]: 9:SELECT * FROM SYSTEM_COLUMNS  WHERE 1=1  AND 
TABLE_NAME = 'INVOICE'
[Server@f72617]: 9:SELECT * FROM SYSTEM_INDEXINFO  WHERE 1=1  AND 
TABLE_NAME = 'INVOICE'
[Server@f72617]: 9:SELECT * FROM SYSTEM_COLUMNS  WHERE 1=1  AND 
TABLE_NAME = 'ITEM'
[Server@f72617]: 9:SELECT * FROM SYSTEM_INDEXINFO  WHERE 1=1  AND 
TABLE_NAME = 'ITEM'
[Server@f72617]: 9:SELECT * FROM SYSTEM_COLUMNS  WHERE 1=1  AND 
TABLE_NAME = 'PRODUCT'
[Server@f72617]: 9:SELECT * FROM SYSTEM_INDEXINFO  WHERE 1=1  AND 
TABLE_NAME = 'PRODUCT'
[Server@f72617]: 9:CALL USER()
[Server@f72617]: 9:CLI:GETCONNECTIONATTRS
[Server@f72617]: 9:CLI:GETCONNECTIONATTRS
[Server@f72617]: 9:call "org.hsqldb.Library.getDatabaseProductName"()
[Server@f72617]: 9:call "org.hsqldb.Library.getDatabaseProductVersion"()

so thanks for any hints that point me to the next step where I can look 
for to get hsqldb with OOo running.
BTW. the last version where I could connect was 1.7.2M, with newer codes 
it failed always.

regards
Hermann Kienlein