On each get connection, getusername submits a query to the database
Hello,
Thread dump (attached file) shows an access to the database at each getusername:
"Thread-1173648" Id=1300821 RUNNABLE (in native) java.net.SocketInputStream.socketRead0(Native Method) java.net.SocketInputStream.read(SocketInputStream.java:129) com.sybase.jdbc3.timedio.RawDbio.reallyRead(Unknown Source) com.sybase.jdbc3.timedio.Dbio.doRead(Unknown Source) com.sybase.jdbc3.timedio.InStreamMgr.a(Unknown Source) com.sybase.jdbc3.timedio.InStreamMgr.doRead(Unknown Source) com.sybase.jdbc3.tds.TdsProtocolContext.getChunk(Unknown Source) com.sybase.jdbc3.tds.PduInputFormatter.a(Unknown Source) com.sybase.jdbc3.tds.PduInputFormatter.read(Unknown Source) com.sybase.jdbc3.tds.TdsInputStream.read(Unknown Source) com.sybase.jdbc3.tds.TdsInputStream.readUnsignedByte(Unknown Source) com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) com.sybase.jdbc3.jdbc.SybStatement.queryLoop(UnknownSource) com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source) com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source) com.sybase.jdbc3.jdbc.SybDatabaseMetaData.a(Unknown Source) com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getUserName(Unknown Source) org.objectweb.jonas.jdbc.MetaDataImpl.getUserName(MetaDataImpl.java:113) org.objectweb.jonas.jdbc.ConnectionImpl.setUser(ConnectionImpl.java:101) org.objectweb.jonas.resource.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:775) org.objectweb.jonas.jdbc.DataSourceImpl.getConnection(DataSourceImpl.java:78) com.caceis.stw2.sql.ConnectionCompImpl.getConnection(ConnectionCompImpl.java:175)
Can this behavior be optimized ? Best regards Pascale