ORACLE THIN in JBOSS is pointing to some alien db
connect.deepak Jul 31, 2013 11:47 AMHi All,
Recently, I am going through an issue related to jboss configuration and deployment. Hope you all guys will help me out to resolve the issue.
Please find following stack trace.
20:37:36,312 ERROR [STDERR] java.sql.SQLException: invalid schema name: sched in statement [Select count(*) as cnt from sched.User_Master where User_Id = 1]
20:37:36,328 ERROR [STDERR] at org.hsqldb.jdbc.Util.throwError(Unknown Source)
20:37:36,328 ERROR [STDERR] at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
20:37:36,328 ERROR [STDERR] at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
20:37:36,328 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:516)
20:37:36,328 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:504)
20:37:36,328 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:260)
20:37:36,328 ERROR [STDERR] at com.ssn.bean.ejb.UserBean.checkRecord(UserBean.java:224)
20:37:36,328 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
20:37:36,328 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
20:37:36,328 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
20:37:36,328 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
20:37:36,328 ERROR [STDERR] at org.jboss.invocation.Invocation.performCall(Invocation.java:386)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:233)
20:37:36,328 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:156)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:173)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.process(SecurityInterceptor.java:228)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:211)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.plugins.security.PreSecurityInterceptor.process(PreSecurityInterceptor.java:100)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.plugins.security.PreSecurityInterceptor.invoke(PreSecurityInterceptor.java:84)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:650)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:1092)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:436)
20:37:36,328 ERROR [STDERR] at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
I have two j2ee applications and have been deployed in same server and pointed to same database.
One application is working fine and another application is not working and throwing above error. Both applications are using same datasource.
I am astonished that why and how org.hsqldb.jdbc.jdbcConnection.prepareStatement comes into the picture while I am using Oracle thin.
Your help will be appreciated.
Regards Deepak