1 Reply Latest reply on Sep 6, 2006 5:33 PM by acoliver

    JBMS with Ingres DB

    pust

      I have a problem with the JBMS under a Ingres Database.
      JBMS inserts the schema correct in the database but when im trying
      to create a mailbox account i get this error:

      2006-08-28 16:49:01,085 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not log warnings
      ca.edbc.util.EdbcEx: A request was made on a closed connection.
      at ca.edbc.util.EdbcEx.get(EdbcEx.java:195)
      at ca.edbc.io.DbConnOut.begin(DbConnOut.java:370)at ca.edbc.jdbc.EdbcConnect.setAutoCommit(EdbcConnect.java:1391)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.getWarnings(WrappedConnection.java:401)at org.hibernate.util.JDBCExceptionReporter.logAndClearWarnings(JDBCExceptionReporter.java:22)at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:443)at org.hibernate.jdbc.ConnectionManager.cleanup(ConnectionManager.java:379)at org.hibernate.jdbc.ConnectionManager.close(ConnectionManager.java:318)
      at org.hibernate.impl.SessionImpl.close(SessionImpl.java:297)at org.hibernate.impl.SessionImpl.managedClose(SessionImpl.java:353)at org.hibernate.transaction.CacheSynchronization.afterCompletion(CacheSynchronization.java:90)at org.jboss.tm.TransactionImpl.doAfterCompletion(TransactionImpl.java:1523)at org.jboss.tm.TransactionImpl.completeTransaction(TransactionImpl.java:1195)
      at org.jboss.tm.TransactionImpl.rollback(TransactionImpl.java:410)
      at org.jboss.aspects.tx.TxPolicy.endTransaction(TxPolicy.java:167)
      at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:87)at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:192)at org.jboss.mail.mailbox.MailboxServiceImpl$createMailbox_7212583350872886280.invokeNext(MailboxServiceImpl$createMailbox_7212583350872886280.java)at org.jboss.mail.mailbox.MailboxServiceImpl.createMailbox(MailboxServiceImpl.java)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:585)at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)at org.jboss.jmx.adaptor.control.Server.invokeOpByName(Server.java:258)at org.jboss.jmx.adaptor.control.Server.invokeOp(Server.java:223)at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.invokeOp(HtmlAdaptorServlet.java:262)at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.processRequest(HtmlAdaptorServlet.java:100)at org.jboss.jmx.adaptor.html.HtmlAdaptorServlet.doPost(HtmlAdaptorServlet.java:82)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)at
      javax.servlet.http.HttpServlet.service(HttpServlet.java:810)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:54)at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:174)at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)at java.lang.Thread.run(Thread.java:595)


      My persistence.xml

      <?xml version="1.0" encoding="UTF-8"?>
      <persistence>
       <persistence-unit name="mail">
       <jta-data-source>java:/IngresDS</jta-data-source>
       <properties>
       <property name="jboss.entity.manager.jndi.name" value="java:/EntityManagers/mail"/>
       <property name="hibernate.connection.driver_class" value="ca.edbc.jdbc.EdbcDriver" />
       <property name="hibernate.connection.password" value="ingres" />
       <property name="hibernate.connection.url" value="jdbc:edbc://172.21.1.20:21071/test2" />
       <property name="hibernate.connection.username" value="ingres" />
       <property name="hibernate.dialect" value="org.hibernate.dialect.IngresDialect" />
       <property name="hibernate.hbm2ddl.auto" value="update"/>
       <property name="hibernate.connection.release_mode" value="auto" />
       <property name="hibernate.transaction.flush_before_completion" value="true" />
       <property name="hibernate.transaction.auto_close_session" value="true" />
       <property name="hibernate.connection.pool_size" value="0" />
       <property name="hibernate.query.factory_class" value="org.hibernate.hql.ast.ASTQueryTranslatorFactory" />
       <property name="hibernate.cache.provider_class" value="org.hibernate.cache.HashtableCacheProvider" />
       <property name="hibernate.connection.datasource" value="java:/IngresDS" />
       <property name="hibernate.jndi.java.naming.factory.initial" value="org.jnp.interfaces.NamingContextFactory" />
       <property name="hibernate.jndi.java.naming.factory.url.pkgs" value="org.jboss.naming:org.jnp.interfaces" />
       </properties>
       </persistence-unit>


      what can i do?????

      thnx


        • 1. Re: JBMS with Ingres DB
          acoliver

          I've not delt with Ingres. Any other errors? It could be a symptom and not the problem. You may also try asking the hibernate guys. Sorry, I'm just not familar with Ingres (other awareness of its existence).