1 Reply Latest reply on Mar 10, 2008 3:53 AM by (prithviraj)

    Configuring JDBC agent in BAM workbench

      Hi,

      I am triying to define a new event in BAM application workbench.
      I am getting the following error even I use the predefined JDBC
      agent "adobe_jdbc_agent" in BAM workbench.The error detail is below.

      Could anyone tell me what is wrong and how can I fix it?

      Thanks

      Cihan

      Unable to get metadata for query [select commonname from edcprincipalentity] from database connection [ADOBE_JDBC_AGENT].
      Caused by:
      No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:

      ** BEGIN NESTED EXCEPTION **

      com.mysql.jdbc.CommunicationsException
      MESSAGE: Communications link failure due to underlying exception:

      ** BEGIN NESTED EXCEPTION **

      java.net.SocketException
      MESSAGE: Software caused connection abort: socket write error

      STACKTRACE:

      java.net.SocketException: Software caused connection abort: socket write error
      at java.net.SocketOutputStream.socketWrite0(Native Method)
      at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
      at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
      at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
      at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
      at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692)
      at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStat ement.java:211)
      at com.celequest.datasources.adapter.PreparedStatementManager.query(PreparedStatementManager .java:197)
      at com.celequest.datasources.adapter.JDBCAdapter.query(JDBCAdapter.java:175)
      at com.celequest.datasources.source.jdbcSource.bindAndExecuteUtil(jdbcSource.java:314)
      at com.celequest.datasources.source.jdbcSource.bindAndExecuteCreateIter(jdbcSource.java:351)
      at com.celequest.datasources.polling.JDBCPoller.executeQuery(JDBCPoller.java:109)
      at com.celequest.datasources.polling.Poller.doExecuteQuery(Poller.java:638)
      at com.celequest.datasources.polling.Poller.executeQuery(Poller.java:599)
      at com.celequest.datasources.polling.IntervalPoller.run(IntervalPoller.java:191)
      at com.celequest.datasources.polling.IntervalPoller$MyTimerTask.run(IntervalPoller.java:55)
      at java.util.TimerThread.mainLoop(Timer.java:512)
      at java.util.TimerThread.run(Timer.java:462)

      ** END NESTED EXCEPTION **

      Last packet sent to the server was 0 ms ago.

      STACKTRACE:

      com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

      ** BEGIN NESTED EXCEPTION **

      java.net.SocketException
      MESSAGE: Software caused connection abort: socket write error

      STACKTRACE:

      java.net.SocketException: Software caused connection abort: socket write error
      at java.net.SocketOutputStream.socketWrite0(Native Method)
      at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
      at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
      at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
      at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
      at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692)
      at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
      at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPrep