JDBC 5.1.31 results above 23.000 drop with error?
Posted by: R van der Wal
Date: June 12, 2014 07:00AM

I have a query that gives a result of more than 23.000 rows. when i do this with a MySQL browser it correctly returns all rows.

When i use the JDBC driver on Glassfish it stops without a warning, retrieving less then 22.000 rows with a limit in the query gives me all resulting rows.

"select * from mytable limit 22000" gives 22.000 rows
"select * from mytable limit 23000" gives 0 rows
total rows in database = 23.700

When i enable profiling i see the following error message:
[#|2014-06-12T14:55:12.846+0200|SEVERE|glassfish3.1.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=26;_ThreadName=Thread-2;|Thu Jun 12 14:55:12 CEST 2014 INFO: Profiler Event: [FETCH]

** BEGIN NESTED EXCEPTION **

java.lang.Throwable

STACKTRACE:

java.lang.Throwable
at com.mysql.jdbc.log.LogUtils.expandProfilerEventIfNecessary(LogUtils.java:49)
at com.mysql.jdbc.log.StandardLogger.logInternal(StandardLogger.java:293)
at com.mysql.jdbc.log.StandardLogger.logInfo(StandardLogger.java:196)
at com.mysql.jdbc.profiler.LoggingProfilerEventHandler.consumeEvent(LoggingProfilerEventHandler.java:46)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2931)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2834)
at com.mysql.jdbc.ConnectionImpl.setTransactionIsolation(ConnectionImpl.java:5674)
at com.mysql.jdbc.jdbc2.optional.ConnectionWrapper.setTransactionIsolation(ConnectionWrapper.java:374)
at com.sun.gjc.spi.ManagedConnectionFactory.setIsolation(ManagedConnectionFactory.java:487)
at com.sun.gjc.spi.ManagedConnectionFactory.validateAndSetIsolation(ManagedConnectionFactory.java:637)
at com.sun.gjc.spi.CPManagedConnectionFactory.createManagedConnection(CPManagedConnectionFactory.java:157)
at com.sun.enterprise.resource.allocator.LocalTxConnectorAllocator.createResource(LocalTxConnectorAllocator.java:87)
at com.sun.enterprise.resource.pool.ConnectionPool.createSingleResource(ConnectionPool.java:907)
at com.sun.enterprise.resource.pool.ConnectionPool.createResource(ConnectionPool.java:1185)
at com.sun.enterprise.resource.pool.datastructure.ListDataStructure.addResource(ListDataStructure.java:126)
at com.sun.enterprise.resource.pool.ConnectionPool.addResource(ConnectionPool.java:282)
at com.sun.enterprise.resource.pool.ConnectionPool.createResourceAndAddToPool(ConnectionPool.java:1501)
at com.sun.enterprise.resource.pool.ConnectionPool.createResourceAndAddToPool(ConnectionPool.java:1199)
at com.sun.enterprise.resource.pool.resizer.Resizer.ensureSteadyPool(Resizer.java:134)
at com.sun.enterprise.resource.pool.resizer.Resizer.resizePool(Resizer.java:120)
at com.sun.enterprise.resource.pool.resizer.Resizer.run(Resizer.java:93)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)


** END NESTED EXCEPTION **

duration: 0 ms, connection-id: 9482, statement-id: 999, resultset-id: 0|#]

Options: ReplyQuote


Subject
Written By
Posted
JDBC 5.1.31 results above 23.000 drop with error?
June 12, 2014 07:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.