Please post the full stack trace for this error.
Also, what database are you using? And by saying "odbc database" are you implying that you are using the JDBC-to-ODBC driver to access the database?
the 1st and 2nd rows are debug prints. You see the statement which causes the error ... stmt.executeQuery(sql)
The next lines are the usualy printed debuggings from jboss startup.
09:37:22,436 INFO [STDOUT] SearchTools.executeQuery() connection.createStatement()
09:37:22,436 INFO [STDOUT] SearchTools.executeQuery() stmt.executeQuery(query)
Error 8. Lost connection to server
09:37:25,272 INFO [Server] Starting JBoss (MX MicroKernel)...
09:37:25,272 INFO [Server] Release ID: JBoss [Trinity] 4.2.2.GA (build: SVNTag=JBoss_4_2_2_GA date=
the database is an odbc datasource connection to an external GIS application (it's quite special, i know) .
The driver is sun.jdbc.odbc.JdbcOdbcDriver.
The thing i wonder about is that the same code running as desktop app is working well (even the same java version). There seems to be some kind of influence between the jboss threads an the ODBC-connection.
I do not recognize the class "SearchTools". I scanned through the classes provided with JBossAS 4.2.2 (and even the classes in jDK 1.5) and no such class exists. What package or library contains this class?
Oh, and you will have to ask the owners of this class what the error means and how to correct the problem.
OK, I think I get it now. SearchTools is your class and it is printing out debug statements.
Are you using JDBC to get a database connection, or are you using a data source? If you are using JDBC, I suggest you switch to using a data source.
Also, does the server.log file give any more information about what is going on?