From: Hermann K. <he...@ki...> - 2003-09-04 19:38:18
|
Hi again and sorry for asking again, but it seems like I beeing too stupid for what I want/need, I took another look at my tracing, and lets say what I done: starting Server out of Netbeans3.5 with Sun JDK1.4.2, I get [Server@f72617]: Startup sequence initiated from main() method [Server@f72617]: Loading properties from [C:\\server] where comes this path from? [Server@f72617]: [Thread[main,5,main]]: checkRunning(false) entered [Server@f72617]: [Thread[main,5,main]]: checkRunning() exited [Server@f72617]: [Thread[main,5,main]]: start() entered [Server@f72617]: [Thread[main,5,main]]: waitForStatus() entered [Server@f72617]: [Thread[listener,5,Server@f72617]]: run() entered [Server@f72617]: Initiating startup sequence... [Server@f72617]: [Thread[listener,5,Server@f72617]]: server.tls=false [Server@f72617]: [Thread[listener,5,Server@f72617]]: server.port=9001 [Server@f72617]: [Thread[listener,5,Server@f72617]]: server.trace=true [Server@f72617]: [Thread[listener,5,Server@f72617]]: server.database.0=test [Server@f72617]: [Thread[listener,5,Server@f72617]]: server.restart_on_shutdown=false [Server@f72617]: [Thread[listener,5,Server@f72617]]: server.no_system_exit=false [Server@f72617]: [Thread[listener,5,Server@f72617]]: server.silent=false [Server@f72617]: [Thread[listener,5,Server@f72617]]: server.default_page=index.html [Server@f72617]: [Thread[listener,5,Server@f72617]]: server.address=any [Server@f72617]: [Thread[listener,5,Server@f72617]]: server.dbname.0= [Server@f72617]: [Thread[listener,5,Server@f72617]]: server.root=./ [Server@f72617]: [Thread[listener,5,Server@f72617]]: openServerSocket() entered [Server@f72617]: [Thread[listener,5,Server@f72617]]: Got server socket: ServerSocket[addr=0.0.0.0/0.0.0.0,port=0,localport=9001] [Server@f72617]: Server socket opened successfully in 62 ms. [Server@f72617]: [Thread[listener,5,Server@f72617]]: openServerSocket() exiting [Server@f72617]: [Thread[listener,5,Server@f72617]]: openDB() entered [Server@f72617]: [Thread[listener,5,Server@f72617]]: Opening database: [file:test] writeScript [Server@f72617]: Database [0]:[file:test]:[] opened sucessfully in 1469 ms. [Server@f72617]: [Thread[listener,5,Server@f72617]]: openDB() exiting [Server@f72617]: [Thread[listener,5,Server@f72617]]: notifyStatus() entered [Server@f72617]: [Thread[main,5,main]]: waitForStatus() exited [Server@f72617]: [Thread[main,5,main]]: start() exiting [Server@f72617]: [Thread[listener,5,Server@f72617]]: notifyStatus() exited [Server@f72617]: Startup sequence completed in 1672 ms. [Server@f72617]: 2003-09-04 21:19:40.656 HSQLDB server 1.7.2 is online [Server@f72617]: To close normally, connect and execute SHUTDOWN SQL [Server@f72617]: From command line, use [Ctrl]+[C] to abort abruptly so now O connect with my application: [Server@f72617]: [Thread[listener,5,Server@f72617]]: handleConnection(Socket[addr=/127.0.0.1,port=1295,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@ece65,5,connections]]: 0:trying to connect user null [Server@f72617]: 0:CLI:GETCONNECTIONATTRS [Server@f72617]: 0:call "org.hsqldb.Library.getDatabaseProductName"() [Server@f72617]: 0:call "org.hsqldb.Library.getDatabaseProductVersion"() [Server@f72617]: 0:CALL USER() [Server@f72617]: 0:CALL "org.hsqldb.Library.isReadOnlyDatabase"() [Server@f72617]: 0:SELECT * FROM SYSTEM_TABLETYPES [Server@f72617]: 0:SELECT * FROM SYSTEM_TYPEINFO [Server@f72617]: 0:SELECT * FROM SYSTEM_CATALOGS [Server@f72617]: 0:SELECT * FROM SYSTEM_TABLES WHERE 1=1 [Server@f72617]: 0:SELECT * FROM SYSTEM_TABLEPRIVILEGES WHERE 1=1 AND TABLE_NAME LIKE '%' and with your Manager: file sync interval: 239718 file sync: 16 [Server@f72617]: [Thread[listener,5,Server@f72617]]: handleConnection(Socket[addr=/127.0.0.1,port=1296,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@f7f540,5,connections]]: 1:trying to connect user null [Server@f72617]: 1:SELECT * FROM SYSTEM_TABLES WHERE 1=1 AND TABLE_TYPE IN ('TABLE','GLOBAL TEMPORARY','VIEW') [Server@f72617]: 1:CALL USER() [Server@f72617]: 1:CLI:GETCONNECTIONATTRS [Server@f72617]: 1:CLI:GETCONNECTIONATTRS [Server@f72617]: 1:call "org.hsqldb.Library.getDatabaseProductName"() [Server@f72617]: 1:call "org.hsqldb.Library.getDatabaseProductVersion"() [Server@f72617]: 1:SELECT * FROM SYSTEM_TABLES WHERE 1=1 AND TABLE_TYPE IN ('TABLE','GLOBAL TEMPORARY','VIEW') [Server@f72617]: 1:CALL USER() [Server@f72617]: 1:CLI:GETCONNECTIONATTRS [Server@f72617]: 1:CLI:GETCONNECTIONATTRS [Server@f72617]: 1:call "org.hsqldb.Library.getDatabaseProductName"() [Server@f72617]: 1:call "org.hsqldb.Library.getDatabaseProductVersion"() so wy I always get the message trying to connect user null? If I use another user, trace say always trying to connect user null but so I see the user I created from the script works, because if I use another I get the error user/password are not right. and so I come to my first problem back why I cannot connect with OOo any more. If I try to connect I get in trace [Server@f72617]: [Thread[listener,5,Server@f72617]]: handleConnection(Socket[addr=/127.0.0.1,port=1301,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 then it stops, and in OOo I get the error: SQL-Status: 08003 and error-code; -3 Sorry again, but so much has changed in hsqldb. I really want get running it with OOo. But my java-skill seems too little for this. Where can I look for? what can I try? regards Hermann Kienlein |