5 Replies Latest reply on Oct 21, 2008 3:03 AM by jaikiran pai

    JBoss 3.2.3 Bundled Tomcat configuration with Oracle 9i

    ppaulakh Newbie

      I've had JBoss 3.0x running with oracle flawlessy for a while and took the plunge into using 3.2.3. I am getting an error when connecting to the database. It can parse my oracle-ds.xml just fine. This oracle-ds.xml works on a copy of JBoss running on the server, just not this box. I tested a telnet connection to the port I use, and was able to connect to the database on that port.

      So it seems I must have messed something up in the configuration. I can't for the life of me figure out what that might be though.
      The only thing I have made changes to in jboss are adding hot deploy directories, and adding the oracle-ds.xml and JDBC driver.

      Any help is welcome. The java stacktrace print is here :

      16:13:39,166 WARN [JBossManagedConnectionPool] Unable to fill pool
      org.jboss.resource.JBossResourceException: Could not create connection; - nested
      throwable: (java.sql.SQLException: Io exception: Got minus one from a read call
      )
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:160)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:477)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:422)
      at org.jboss.resource.connectionmanager.PoolFiller$1.run(PoolFiller.java:63)
      at java.lang.Thread.run(Thread.java:534)
      Caused by: java.sql.SQLException: Io exception: Got minus one from a read call
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)
      at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:269)
      at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:150)
      ... 4 more



      This is the head of the jboss stack dump :

      16:06:10,100 WARN [JBossManagedConnectionPool] Throwable while attempting to ge
      t a new connection:
      org.jboss.resource.JBossResourceException: Could not create connection; - nested
      throwable: (java.sql.SQLException: Io exception: Got minus one from a read call)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:160)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:477)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:213)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:496)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:425)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:318)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:477)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:122)
      at utilities.enterprise.ApplicationContext.getSecureConnection(Unknown Source)
      at dbconfig.ejb.iwnetwork.IWNetworkBean.queryNetwork(Unknown Source)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
      at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)