Hi,
It looks like H2 is waiting for a response from Sybase. Maybe the
query is slow. To find out how the query looks like, could you enable
the trace option in H2 by appending ;TRACE_LEVEL_FILE=3 to the
database URL? In that case all queries that are sent to Sybase is
written to the .trace.db file. Could you then run the query again, and
check the .trace.db file?
In the file SecondDumpH2.txt one of the stack traces looks like:
"H2 TCP Server (tcp://10.136.33.84:9093) thread" prio=6 tid=0x34705c00
nid=0x834 runnable [0x351ef000..0x351efd94]
java.lang.Thread.State: RUNNABLE
at
net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:133)
at
net.sourceforge.jtds.jdbc.ResponseStream.readString(ResponseStream.java:290)
at
net.sourceforge.jtds.jdbc.ResponseStream.readNonUnicodeString(ResponseStream.java:274)
at net.sourceforge.jtds.jdbc.TdsData.readData(TdsData.java:896)
at net.sourceforge.jtds.jdbc.TdsCore.tdsRowToken(TdsCore.java:3003)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2266)
at
net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:728)
at
net.sourceforge.jtds.jdbc.JtdsStatement.initialize(JtdsStatement.java:645)
at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:768)
at org.h2.index.LinkedIndex.find(LinkedIndex.java:138)
- locked <0x1299c668> (a org.h2.table.TableLinkConnection)
at org.h2.table.TableFilter.next(TableFilter.java:295)
at org.h2.command.dml.Select.queryFlat(Select.java:492)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:560)
at org.h2.command.dml.Query.query(Query.java:233)
at org.h2.command.CommandContainer.query(CommandContainer.java:81)
at org.h2.command.Command.executeQueryLocal(Command.java:141)
- locked <0x129197d0> (a org.h2.engine.Database)
Regards,
Thomas
On Thu, Feb 5, 2009 at 10:36 AM, t603 <[email protected]> wrote:
>
> Sent via e-mail to dbsupportATh2databaseDOTcom at 10:35. Thank You,
> Stepan
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
