[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Database problem in Jboss

[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=4179266#4179266

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4179266