1 Reply Latest reply on Jan 22, 2004 7:51 AM by Viet

    JBoss3-2-3 + MySQL4.1.1alpha + Nukes

    Temple Cloud Newbie

       

      "Temple_Cloud" wrote:
      Hello,

      I am a newbie trying to get Nukes to work and I am having several problems concerning libraries. Currently I am using:

      JBoss3-2-3
      NukesRC1
      MySql4.1.1alpha (I really want subselects)
      mysql-connector-java-3.1-nightly-20040121-bin.jar (most recent)

      On my system this combination causes the main error (which I guess is from the JConnector) below. It also causes lots of digits to be printed out vertically to the output stream as follows:

      <snip>
      16:59:28,591 INFO [STDOUT]
      16:59:28,591 INFO [STDOUT]
      16:59:28,591 INFO [STDOUT]
      16:59:28,591 INFO [STDOUT]
      16:59:28,591 INFO [STDOUT] .
      16:59:28,591 INFO [STDOUT] .
      16:59:28,591 INFO [STDOUT] 00
      16:59:28,591 INFO [STDOUT] 00
      16:59:28,591 INFO [STDOUT] 04
      16:59:28,591 INFO [STDOUT] 54
      16:59:28,591 INFO [STDOUT] 72
      16:59:28,591 INFO [STDOUT] 75
      16:59:28,591 INFO [STDOUT] 65
      16:59:28,591 INFO [STDOUT]
      16:59:28,591 INFO [STDOUT] 01
      16:59:28,591 INFO [STDOUT]
      16:59:28,591 INFO [STDOUT] .
      16:59:28,591 INFO [STDOUT] .
      16:59:28,591 INFO [STDOUT] .
      16:59:28,591 INFO [STDOUT] .
      16:59:28,591 INFO [STDOUT] .
      16:59:28,591 INFO [STDOUT] .
      16:59:28,591 INFO [STDOUT] .
      16:59:28,591 INFO [STDOUT] .
      16:59:28,591 INFO [STDOUT] 03
      16:59:28,591 INFO [STDOUT] 03
      16:59:28,591 INFO [STDOUT] 03
      16:59:28,591 INFO [STDOUT] 03
      16:59:28,591 INFO [STDOUT] 00
      16:59:28,591 INFO [STDOUT] 01
      16:59:28,591 INFO [STDOUT] 00
      16:59:28,591 INFO [STDOUT] 00
      16:59:28,591 INFO [STDOUT]
      16:59:28,591 INFO [STDOUT] .
      16:59:28,591 INFO [STDOUT] .
      16:59:28,591 INFO [STDOUT] .
      16:59:28,591 INFO [STDOUT] .
      16:59:28,601 INFO [STDOUT] .
      16:59:28,601 INFO [STDOUT] .
      16:59:28,601 INFO [STDOUT] .
      16:59:28,601 INFO [STDOUT] .
      16:59:28,601 INFO [STDOUT] 00
      16:59:28,601 INFO [STDOUT]
      16:59:28,601 INFO [STDOUT]
      16:59:28,601 INFO [STDOUT]
      16:59:28,601 INFO [STDOUT]
      16:59:28,601 INFO [STDOUT]
      16:59:28,601 INFO [STDOUT] .
      16:59:28,601 INFO [STDOUT] .
      16:59:28,601 INFO [STDOUT] .
      16:59:28,601 INFO [STDOUT] T
      16:59:28,601 INFO [STDOUT] r
      16:59:28,601 INFO [STDOUT] u
      16:59:28,601 INFO [STDOUT] e
      16:59:28,601 INFO [STDOUT] 00
      16:59:28,601 INFO [STDOUT] 00
      16:59:28,601 INFO [STDOUT] 04
      16:59:28,601 INFO [STDOUT] 54
      16:59:28,601 INFO [STDOUT] 72
      16:59:28,601 INFO [STDOUT] 75
      16:59:28,601 INFO [STDOUT] 65
      16:59:28,601 INFO [STDOUT]
      16:59:28,601 INFO [STDOUT]
      16:59:28,601 INFO [STDOUT]
      16:59:28,601 INFO [STDOUT]
      16:59:28,601 INFO [STDOUT] .
      16:59:28,611 ERROR [LogInterceptor] EJBException, causedBy:
      java.sql.SQLException: Invalid value for getInt() - ' ' in column 4
      at com.mysql.jdbc.ResultSet.getIntFromString(ResultSet.java:4808)
      at com.mysql.jdbc.ResultSet.getNativeInt(ResultSet.java:4072)
      at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:1313)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil$24.readResult(JDBCUtil.java:876)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil$AbstractPrimitiveReader.get(JDBCUtil.java:803)
      at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.loadArgumentResults(JDBCAbstractCMPFieldBridge.java:424)
      at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.loadInstanceResults(JDBCAbstractCMPFieldBridge.java:373)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:188)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:72)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:612)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:594)
      at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:381)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity(CachedConnectionInterceptor.java:352)
      at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:239)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
      at org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:114)
      at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:163)
      at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:89)
      at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:54)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      at org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:489)
      at org.jboss.ejb.Container.invoke(Container.java:700)
      at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:375)
      at org.jboss.ejb.plugins.local.EntityProxy.invoke(EntityProxy.java:38)
      at $Proxy202.getCategory(Unknown Source)
      at org.jboss.nukes.addons.modules.bb.BBModule.updateStats(BBModule.java:380)
      at org.jboss.nukes.addons.modules.bb.BBModule.access$000(BBModule.java:151)
      at org.jboss.nukes.addons.modules.bb.BBModule$1.run(BBModule.java:325)
      at org.jboss.nukes.utils.Scheduler$SingleTimerTask.run(Scheduler.java:69)
      at java.util.TimerThread.mainLoop(Timer.java:432)
      at java.util.TimerThread.run(Timer.java:382)
      16:59:28,611 ERROR [STDERR] javax.ejb.EJBException: Internal error getting results for field member order; CausedByException is:
      Invalid value for getInt() - ' ' in column 4
      16:59:28,611 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.loadArgumentResults(JDBCAbstractCMPFieldBridge.java:434)
      16:59:28,611 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.loadInstanceResults(JDBCAbstractCMPFieldBridge.java:373)
      16:59:28,631 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:188)
      16:59:28,631 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:72)
      16:59:28,631 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:612)
      16:59:28,631 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:594)
      16:59:28,711 INFO [STDOUT]
      16:59:28,711 INFO [STDOUT]
      16:59:28,711 INFO [STDOUT] .
      16:59:28,711 INFO [STDOUT] .
      16:59:28,711 INFO [STDOUT] .
      16:59:28,711 INFO [STDOUT] T
      16:59:28,711 INFO [STDOUT] r
      16:59:28,711 INFO [STDOUT] u
      16:59:28,711 INFO [STDOUT] e
      16:59:28,711 INFO [STDOUT] 00
      16:59:28,711 INFO [STDOUT] 00
      16:59:28,711 INFO [STDOUT] 04
      16:59:28,711 INFO [STDOUT] 54
      16:59:28,711 INFO [STDOUT] 72
      16:59:28,711 INFO [STDOUT] 75
      16:59:28,711 ERROR [STDERR] at org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceManager.java:381)
      16:59:28,811 INFO [Engine] SingleSignOnContextConfig[]: Added certificates -> request attribute Valve
      16:59:28,811 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.loadEntity(CachedConnectionInterceptor.java:352)
      16:59:28,811 ERROR [STDERR] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySynchronizationInterceptor.java:239)
      16:59:28,811 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
      16:59:28,811 ERROR [STDERR] at org.jboss.ejb.plugins.EntityReentranceInterceptor.invoke(EntityReentranceInterceptor.java:114)
      16:59:28,811 ERROR [STDERR] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInterceptor.java:163)
      16:59:28,811 ERROR [STDERR] at org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor.java:89)
      16:59:28,811 ERROR [STDERR] at org.jboss.ejb.plugins.EntityCreationInterceptor.invoke(EntityCreationInterceptor.java:54)
      16:59:28,811 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
      16:59:28,811 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:267)
      16:59:28,811 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
      16:59:28,811 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
      16:59:28,811 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      16:59:28,821 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      16:59:28,821 ERROR [STDERR] at org.jboss.ejb.EntityContainer.internalInvoke(EntityContainer.java:489)
      16:59:28,821 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:700)
      16:59:28,831 INFO [STDOUT] 65
      16:59:28,831 INFO [STDOUT]
      16:59:28,831 INFO [STDOUT]
      16:59:28,831 INFO [STDOUT] .
      16:59:28,831 INFO [STDOUT] .
      16:59:28,831 INFO [STDOUT] .
      </snip>

      JBoss is not running any other application when it does this, and I have tried various stable and nightly builds of JConnector (I need fairly recent ones to work with 4.1.1alpha)

      Has anyone experienced similar problems? Has anyone got it working using this version of MYSQL?

      Heres hoping,

      Cheers,

      Tem