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,[EMAIL PROTECTED]: handleConnection(Socket[addr=/127.0.0.1,port=1045,localport=9001]) entered
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: checkRunning(true) entered
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: checkRunning() exited
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: handleConnection() exited
[EMAIL PROTECTED]: [EMAIL PROTECTED],5,connections]]: 4:trying to connect user null
[EMAIL PROTECTED]: 4:CLI:GETCONNECTIONATTRS
[EMAIL PROTECTED]: 4:call "org.hsqldb.Library.getDatabaseProductName"()
[EMAIL PROTECTED]: 4:call "org.hsqldb.Library.getDatabaseProductVersion"()
[EMAIL PROTECTED]: 4:CALL USER()
[EMAIL PROTECTED]: 4:CALL "org.hsqldb.Library.isReadOnlyDatabase"()
[EMAIL PROTECTED]: 4:SELECT * FROM SYSTEM_TABLETYPES
[EMAIL PROTECTED]: 4:SELECT * FROM SYSTEM_TYPEINFO
[EMAIL PROTECTED]: 4:SELECT * FROM SYSTEM_CATALOGS
[EMAIL PROTECTED]: 4:SELECT * FROM SYSTEM_TABLES WHERE 1=1
[EMAIL PROTECTED]: 4:SELECT * FROM SYSTEM_TABLEPRIVILEGES WHERE 1=1 AND TABLE_NAME LIKE '%'
[EMAIL PROTECTED]: 4:SELECT * FROM SYSTEM_PRIMARYKEYS WHERE 1=1 AND TABLE_NAME = 'ITEM'
[EMAIL PROTECTED]: 4:SELECT * FROM SYSTEM_COLUMNPRIVILEGES WHERE 1=1 AND TABLE_NAME = 'ITEM' AND COLUMN_NAME LIKE '%'
[EMAIL PROTECTED]: 4:SELECT * FROM SYSTEM_COLUMNS WHERE 1=1 AND TABLE_NAME = 'ITEM' AND COLUMN_NAME LIKE '%'
[EMAIL PROTECTED]: 4:SELECT * FROM SYSTEM_CROSSREFERENCE WHERE 1=1 AND PKTABLE_NAME = 'ITEM'
[EMAIL PROTECTED]: 4:SELECT * FROM SYSTEM_CROSSREFERENCE WHERE 1=1 AND FKTABLE_NAME = 'ITEM' ORDER BY PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, KEY_SEQ
[EMAIL PROTECTED]: 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:
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: handleConnection(Socket[addr=/127.0.0.1,port=1048,localport=9001]) entered
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: checkRunning(true) entered
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: checkRunning() exited
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: handleConnection() exited
and with your runManager.bat I get:
file sync interval: 2221453
file sync: 31
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: handleConnection(Socket[addr=/127.0.0.1,port=1050,localport=9001]) entered
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: checkRunning(true) entered
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: checkRunning() exited
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: handleConnection() exited
[EMAIL PROTECTED]: [EMAIL PROTECTED],5,connections]]: 9:trying to connect user null
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_TABLES WHERE 1=1 AND TABLE_TYPE IN ('TABLE','GLOBAL TEMPORARY','VIEW')
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_COLUMNS WHERE 1=1 AND TABLE_NAME = 'CUSTOMER'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_INDEXINFO WHERE 1=1 AND TABLE_NAME = 'CUSTOMER'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_COLUMNS WHERE 1=1 AND TABLE_NAME = 'INVOICE'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_INDEXINFO WHERE 1=1 AND TABLE_NAME = 'INVOICE'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_COLUMNS WHERE 1=1 AND TABLE_NAME = 'ITEM'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_INDEXINFO WHERE 1=1 AND TABLE_NAME = 'ITEM'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_COLUMNS WHERE 1=1 AND TABLE_NAME = 'PRODUCT'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_INDEXINFO WHERE 1=1 AND TABLE_NAME = 'PRODUCT'
[EMAIL PROTECTED]: 9:CALL USER()
[EMAIL PROTECTED]: 9:CLI:GETCONNECTIONATTRS
[EMAIL PROTECTED]: 9:CLI:GETCONNECTIONATTRS
[EMAIL PROTECTED]: 9:call "org.hsqldb.Library.getDatabaseProductName"()
[EMAIL PROTECTED]: 9:call "org.hsqldb.Library.getDatabaseProductVersion"()
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_TABLES WHERE 1=1 AND TABLE_TYPE IN ('TABLE','GLOBAL TEMPORARY','VIEW')
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_COLUMNS WHERE 1=1 AND TABLE_NAME = 'CUSTOMER'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_INDEXINFO WHERE 1=1 AND TABLE_NAME = 'CUSTOMER'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_COLUMNS WHERE 1=1 AND TABLE_NAME = 'INVOICE'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_INDEXINFO WHERE 1=1 AND TABLE_NAME = 'INVOICE'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_COLUMNS WHERE 1=1 AND TABLE_NAME = 'ITEM'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_INDEXINFO WHERE 1=1 AND TABLE_NAME = 'ITEM'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_COLUMNS WHERE 1=1 AND TABLE_NAME = 'PRODUCT'
[EMAIL PROTECTED]: 9:SELECT * FROM SYSTEM_INDEXINFO WHERE 1=1 AND TABLE_NAME = 'PRODUCT'
[EMAIL PROTECTED]: 9:CALL USER()
[EMAIL PROTECTED]: 9:CLI:GETCONNECTIONATTRS
[EMAIL PROTECTED]: 9:CLI:GETCONNECTIONATTRS
[EMAIL PROTECTED]: 9:call "org.hsqldb.Library.getDatabaseProductName"()
[EMAIL PROTECTED]: 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
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers