JBoss 3.2.3 Bundled Tomcat configuration with Oracle 9i

[ppaulakh]

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)

[darranl]

I haven't worked with Oracle but does it have an authentication mechanism similar to MySQL that also checks which host a user is connecting from?

[ppaulakh]

That's a good question, I am not sure.
I double checked connecting this morning with another program and got the same error, so it looks like some kind of configuration change at around the same time as I moved to 3.2.3, not JBoss related.
Nice when the left hand doesn't know what the right is doing, eh?
Thanks anyways.

[scr1701]

Is your problem solved? If so, ignore this. But have you verified that you have the correct sid? And what does the jmx-console tell you about the datasource?

[siddiq_sa]

Does anybody have a solution for the below mention problem.
I am facing the same problem of

org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: Got minus one from a read call)

Kindly let me know if you have a fix for this problem.

Regards
Siddiq.

[jaikiran]

This is a 4 year old thread and posting in this thread without providing any details about your setup and application might not get any answers. Please post additional details including JBoss version the Java vendor and version and the datasource configuration, the JDBC driver details and the entire exception stacktrace.

While posting the logs or code or xml content, remember to wrap it in a code block using the Code button in the message editor window and please hit the Preview button to make sure your post is correctly formatted