[Datasource Configuration] - Error in JBOSS
by skm2008
Hi,
I m trying to access one application in JBOSS. The configuration is comething like jboss with hibernate and i m connection to DB through datasource. While accessing my app i m facing following exception. Anyone have any locks..????
ERROR [org.apache.catalina.core.ContainerBase] Servlet.service() for servlet jsp threw exception
java.sql.SQLException: Closed Connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273)
at oracle.jdbc.driver.OracleConnection.setAutoCommit(OracleConnection.java:794)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:429)
at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:525)
at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:184)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:396)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:334)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
at org.hibernate.loader.Loader.doQuery(Loader.java:390)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
my hibernate.cfg.xml file is as follows::
sun.jdbc.odbc.JdbcOdbcDriver
org.hibernate.dialect.Oracle9Dialect
java:jndi name
false
auto
org.hibernate.cache.HashtableCacheProvider
oracle-ds.xml file is as follwos:
<local-tx-datasource>
<jndi-name>jndi name</jndi-name>
<connection-url>jdbc url</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>XXX</user-name>
XXX
<min-pool-size>5</min-pool-size>
<max-pool-size>10</max-pool-size>
<prepared-statement-cache-size>0</prepared-statement-cache-size>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<type-mapping>Oracle9i</type-mapping>
</local-tx-datasource>
Pleas let me know..!!
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4179264#4179264
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4179264
17 years, 6 months
[JBoss Messaging] - Re: JBoss MDB fails to consume from JBoss ESB queue
by idaplan
Hi Tim,
thank you for focusing me on this. It has been a while since we have been looking at that list of required jars.
In the meantime we tried JBoss AS 4.2.1.GA to host our MDB. This works fine now - just with adding the jboss-messaging-client.jar (without any changes to existing jars - like patching the jboss-remoting.jar).
I may also mention that the same combination: JBoss AS 4.2.2.GA MDB against a JBoss ESB 4.2.1 works on Windows/Windows too! But not on Linux/Linux :-(
I guess the list of jars mentioned in the user guides serves well when programming a standalone client program. I remember we used this before to get a simple client running with our ESB. But they will likely conflict with the rest of the jars of the JBoss AS. We tried to put jbossall-client.jar into the server/default/lib folder before (when we was still trying with 4.2.2) and it raised exceptions on startup.
Also I do not see how to control the order in which jars are loaded from the server/default/lib folder (e.g. to ensure that the patched jboss-remoting.jar is loaded before jbossall-client.jar).
I am wondering if so little people have this configuration: Running JBoss AS instances against a JBoss ESB using MDBs. It would be nice to have some more hints - for each release - which jars/settings have to be considered. I hardly found anything (googeling, searching the Wiki) regarding this combination.
Regards
Stefan
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4179256#4179256
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4179256
17 years, 6 months