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
[EMAIL PROTECTED]: Startup sequence initiated from main() method [EMAIL PROTECTED]: Loading properties from [C:\\server]
where comes this path from?
[EMAIL PROTECTED]: [Thread[main,5,main]]: checkRunning(false) entered
[EMAIL PROTECTED]: [Thread[main,5,main]]: checkRunning() exited
[EMAIL PROTECTED]: [Thread[main,5,main]]: start() entered
[EMAIL PROTECTED]: [Thread[main,5,main]]: waitForStatus() entered
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: run() entered
[EMAIL PROTECTED]: Initiating startup sequence...
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: server.tls=false
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: server.port=9001
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: server.trace=true
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: server.database.0=test
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: server.restart_on_shutdown=false
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: server.no_system_exit=false
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: server.silent=false
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: server.default_page=index.html
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: server.address=any
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: server.dbname.0=
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: server.root=./
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: openServerSocket() entered
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: Got server socket: ServerSocket[addr=0.0.0.0/0.0.0.0,port=0,localport=9001]
[EMAIL PROTECTED]: Server socket opened successfully in 62 ms.
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: openServerSocket() exiting
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: openDB() entered
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: Opening database: [file:test]
writeScript
[EMAIL PROTECTED]: Database [0]:[file:test]:[] opened sucessfully in 1469 ms.
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: openDB() exiting
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: notifyStatus() entered
[EMAIL PROTECTED]: [Thread[main,5,main]]: waitForStatus() exited
[EMAIL PROTECTED]: [Thread[main,5,main]]: start() exiting
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: notifyStatus() exited
[EMAIL PROTECTED]: Startup sequence completed in 1672 ms.
[EMAIL PROTECTED]: 2003-09-04 21:19:40.656 HSQLDB server 1.7.2 is online
[EMAIL PROTECTED]: To close normally, connect and execute SHUTDOWN SQL
[EMAIL PROTECTED]: From command line, use [Ctrl]+[C] to abort abruptly
so now O connect with my application:
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: handleConnection(Socket[addr=/127.0.0.1,port=1295,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]]: 0:trying to connect user null
[EMAIL PROTECTED]: 0:CLI:GETCONNECTIONATTRS
[EMAIL PROTECTED]: 0:call "org.hsqldb.Library.getDatabaseProductName"()
[EMAIL PROTECTED]: 0:call "org.hsqldb.Library.getDatabaseProductVersion"()
[EMAIL PROTECTED]: 0:CALL USER()
[EMAIL PROTECTED]: 0:CALL "org.hsqldb.Library.isReadOnlyDatabase"()
[EMAIL PROTECTED]: 0:SELECT * FROM SYSTEM_TABLETYPES
[EMAIL PROTECTED]: 0:SELECT * FROM SYSTEM_TYPEINFO
[EMAIL PROTECTED]: 0:SELECT * FROM SYSTEM_CATALOGS
[EMAIL PROTECTED]: 0:SELECT * FROM SYSTEM_TABLES WHERE 1=1
[EMAIL PROTECTED]: 0:SELECT * FROM SYSTEM_TABLEPRIVILEGES WHERE 1=1 AND TABLE_NAME LIKE '%'
and with your Manager:
file sync interval: 239718
file sync: 16
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: handleConnection(Socket[addr=/127.0.0.1,port=1296,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]]: 1:trying to connect user null
[EMAIL PROTECTED]: 1:SELECT * FROM SYSTEM_TABLES WHERE 1=1 AND TABLE_TYPE IN ('TABLE','GLOBAL TEMPORARY','VIEW')
[EMAIL PROTECTED]: 1:CALL USER()
[EMAIL PROTECTED]: 1:CLI:GETCONNECTIONATTRS
[EMAIL PROTECTED]: 1:CLI:GETCONNECTIONATTRS
[EMAIL PROTECTED]: 1:call "org.hsqldb.Library.getDatabaseProductName"()
[EMAIL PROTECTED]: 1:call "org.hsqldb.Library.getDatabaseProductVersion"()
[EMAIL PROTECTED]: 1:SELECT * FROM SYSTEM_TABLES WHERE 1=1 AND TABLE_TYPE IN ('TABLE','GLOBAL TEMPORARY','VIEW')
[EMAIL PROTECTED]: 1:CALL USER()
[EMAIL PROTECTED]: 1:CLI:GETCONNECTIONATTRS
[EMAIL PROTECTED]: 1:CLI:GETCONNECTIONATTRS
[EMAIL PROTECTED]: 1:call "org.hsqldb.Library.getDatabaseProductName"()
[EMAIL PROTECTED]: 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
[EMAIL PROTECTED]: [Thread[listener,5,[EMAIL PROTECTED]: handleConnection(Socket[addr=/127.0.0.1,port=1301,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 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
------------------------------------------------------- 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
