I don't know about the other stuff, but the reason the user always shows
null is because the tracing code was not fully updated/tested before Alpha N
went out. Sorry for that.
I have since done updates to the tracing code that should fix this and other
shortcomings. I will submit to Fred over the weekend.
//--
> [EMAIL PROTECTED]: Loading properties from [C:\\server]
>
> where comes this path from?
>
It should really say: [C:\\server.properties]. The HsqlProperties class
takes a String naming a file, but without the '.properties' extention. I
have updated this to report correctly as part of the updates mentioned
above.
//--
Obviously, a connection is taking place, since you are getting a trace of
the commands issued to the database.
-3 is the same as org.hsqldb.Trace.CONNECTION_IS_BROKEN = 3, // "08003
Connection is broken"
I do not know why the connection gets broken. I'd have to see what.
precisely the client side is trying to do at that point to understand what
is going wrong.
There is a new network protocol in place and it's entirely possible that a
number of cases have slipped through any QA that Fred an I have done. In
general, I run JDBCBench against a server instance and run the TestSelf
suite of tests each time I submitt work. I think Fred then runs a more
comprehensive suite of tests before commiting to CVS. But there are always
going to be things that slip past until we have a really comprehensive suite
of tests and they are all run in both embedded and both server modes. I
think Fred said he was going to upgrade the TestSelf unit test so that it
could/would run against an HSQL:// or HTTP:// protocol database connection.
This will certainly exercise a great range of cases than is current.
Sorry for any hassle, but thanks very much for the report. Everything helps
toward cleaning up the Alpha N to be RC quality.
----- Original Message -----
From: "Hermann Kienlein" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 04, 2003 1:37 PM
Subject: Re: [Hsqldb-developers] Problems connecting to hsqldb
> 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
>
> [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
>
-------------------------------------------------------
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
