2 Replies Latest reply on Mar 24, 2009 2:00 PM by David Jitendranath

    JBOSS Error

    sk mishra Newbie

      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..!!