JBMS with Ingres DB
pust Aug 28, 2006 10:57 AMI 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