Re: [castor-user] Whats the change in Release 1.1.2

Wed, 10 Oct 2007 02:45:07 -0700 

Rajesh,

any feedback ?

Werner

Werner Guttmann wrote:

I have got a few questions re: your usage of Castor JDO on JBoss.

a) Is your JDBC DataSource a plain one, or is it (XA) transaction enabled ?
b) Are you sure not other Exception/Throwable is thrown as a result of your try/catch statement ? A finally clause will be invoked at all times, I mean.
When you say to tried older version to find out where this problem starts appearing, what problem are we talking about ? The 'close' problem or the 'date' problem ? 

Werner

Rajesh Muthu wrote:

Hi
We are using Castor1.0. For some reason we are having problems with dates. JDO's with date column "increase by 1 year and 1 hour" even we got the object with AccessMode.Readonly. I tried the Castor 1.1.2.1 with Tomcat 5.0. It works fine. When I tried to run in Jboss 3.2.6 it's having problems with Database.close() throwing persistence exception error. I traced back to which version has the change that causes this problem. I found out its Castor1.1.2. 
I have copied by database.xml , the error and the code  below.

Can any one help me with this problem?
Is there any settings or configuration that I'm missing?

Thanks in advance

<?xml version="1.0" ?>
<!DOCTYPE databases PUBLIC "-//EXOLAB/Castor JDO Configuration DTD Version 1.0//EN" 
                          "http://castor.codehaus.org/jdo-conf.dtd";>
<jdo-conf>
   <database name="oracleDatabase" engine="oracle">
       <jndi name="java:/comp/env/jdbc/myoracle"/>
       <mapping href="resources/mapping.xml" />
       <mapping href="resources/assessment_mapping_V2.xml" />
<mapping href="resources/mapping-provider-settlement.xml" /> <mapping href="resources/patient_statement_mapping.xml" /> 
       <mapping href="resources/claim_info_mapping.xml" />
   </database>
   <transaction-demarcation mode="local" >
       <transaction-manager name="local" />
   </transaction-demarcation>
</jdo-conf>
15:20:25,671 INFO [STDOUT] 15:20:25,671 DEBUG [PcpgoServlet] loadJdoinContext() - start 15:20:25,687 INFO [STDOUT] 15:20:25,687 DEBUG [JDOFactory] configureJDOManager() - start - getJDOManager() - start 15:20:26,296 INFO [Mapping] Loading mapping descriptors from resources/mapping.xml 15:20:26,312 INFO [Mapping] Loading mapping descriptors from resources/assessment_mapping_V2.xml 15:20:26,312 INFO [Mapping] Loading mapping descriptors from resources/mapping-provider-settlement.xml 15:20:26,312 INFO [Mapping] Loading mapping descriptors from resources/patient_statement_mapping.xml 15:20:26,312 INFO [Mapping] Loading mapping descriptors from resources/claim_info_mapping.xml 15:20:33,000 INFO [STDOUT] 15:20:33,000 DEBUG [JDOFactory] configureJDOManager() - end - getJDOManager() - end 15:20:34,187 INFO [STDOUT] 15:20:34,187 ERROR [PcpgoServlet] Persistence ExceptionThe database had an open transaction -- transaction rolledback 15:20:34,187 INFO [STDOUT] org.exolab.castor.jdo.PersistenceException: The database had an open transaction -- transaction rolledback 15:20:34,187 INFO [STDOUT] at org.exolab.castor.jdo.engine.LocalDatabaseImpl.close(LocalDatabaseImpl.java:98) 15:20:34,187 INFO [STDOUT] at com.PCPgo.prm.web.database.PcpgoServlet.loadCptAndIcdInContext(PcpgoServlet.java:281) 15:20:34,187 INFO [STDOUT] at com.PCPgo.prm.web.database.PcpgoServlet.init(PcpgoServlet.java:120) 15:20:34,187 INFO [STDOUT] at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1029) 15:20:34,187 INFO [STDOUT] at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:862) 15:20:34,187 INFO [STDOUT] at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4013) 15:20:34,187 INFO [STDOUT] at org.apache.catalina.core.StandardContext.start(StandardContext.java:4357) 15:20:34,187 INFO [STDOUT] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823) 15:20:34,187 INFO [STDOUT] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807) 15:20:34,187 INFO [STDOUT] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595) 15:20:34,187 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 15:20:34,187 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 15:20:34,187 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 15:20:34,187 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585) 15:20:34,187 INFO [STDOUT] at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503) 15:20:34,187 INFO [STDOUT] at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:149) 15:20:34,187 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473) 15:20:34,187 INFO [STDOUT] at org.apache.catalina.core.StandardContext.init(StandardContext.java:5441) 15:20:34,187 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 15:20:34,187 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 15:20:34,187 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 15:20:34,187 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585) 15:20:34,187 INFO [STDOUT] at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503) 15:20:34,187 INFO [STDOUT] at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:149) 15:20:34,187 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473) 15:20:34,187 INFO [STDOUT] at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeployInternal(TomcatDeployer.java:316) 15:20:34,187 INFO [STDOUT] at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeploy(TomcatDeployer.java:76) 15:20:34,187 INFO [STDOUT] at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:320) 15:20:34,187 INFO [STDOUT] at org.jboss.web.WebModule.startModule(WebModule.java:62) 15:20:34,203 INFO [STDOUT] at org.jboss.web.WebModule.startService(WebModule.java:40) 15:20:34,203 INFO [STDOUT] at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271) 15:20:34,203 INFO [STDOUT] at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221) 15:20:34,203 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) 15:20:34,203 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 15:20:34,203 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:82) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473) 15:20:34,203 INFO [STDOUT] at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:884) 
15:20:34,203 INFO  [STDOUT]     at $Proxy18.start(Unknown Source)
15:20:34,203 INFO [STDOUT] at org.jboss.system.ServiceController.start(ServiceController.java:414) 15:20:34,203 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) 15:20:34,203 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 15:20:34,203 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:82) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176) 
15:20:34,203 INFO  [STDOUT]     at $Proxy35.start(Unknown Source)
15:20:34,203 INFO [STDOUT] at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:363) 15:20:34,203 INFO [STDOUT] at org.jboss.deployment.MainDeployer.start(MainDeployer.java:829) 15:20:34,203 INFO [STDOUT] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:641) 15:20:34,203 INFO [STDOUT] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:604) 15:20:34,203 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source) 15:20:34,203 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 15:20:34,203 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:82) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176) 
15:20:34,203 INFO  [STDOUT]     at $Proxy8.deploy(Unknown Source)
15:20:34,203 INFO [STDOUT] at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:304) 15:20:34,203 INFO [STDOUT] at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:478) 15:20:34,203 INFO [STDOUT] at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201) 15:20:34,203 INFO [STDOUT] at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:274) 15:20:34,203 INFO [STDOUT] at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271) 15:20:34,203 INFO [STDOUT] at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221) 15:20:34,203 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) 15:20:34,203 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 15:20:34,203 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:82) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473) 15:20:34,203 INFO [STDOUT] at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:884) 
15:20:34,203 INFO  [STDOUT]     at $Proxy0.start(Unknown Source)
15:20:34,203 INFO [STDOUT] at org.jboss.system.ServiceController.start(ServiceController.java:414) 15:20:34,203 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) 15:20:34,203 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 15:20:34,203 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:82) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176) 
15:20:34,203 INFO  [STDOUT]     at $Proxy4.start(Unknown Source)
15:20:34,203 INFO [STDOUT] at org.jboss.deployment.SARDeployer.start(SARDeployer.java:251) 15:20:34,203 INFO [STDOUT] at org.jboss.deployment.MainDeployer.start(MainDeployer.java:829) 15:20:34,203 INFO [STDOUT] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:641) 15:20:34,203 INFO [STDOUT] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:604) 15:20:34,203 INFO [STDOUT] at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:588) 15:20:34,203 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 15:20:34,203 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 15:20:34,203 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 15:20:34,203 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:82) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:197) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473) 15:20:34,203 INFO [STDOUT] at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176) 
15:20:34,203 INFO  [STDOUT]     at $Proxy5.deploy(Unknown Source)
15:20:34,203 INFO [STDOUT] at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:407) 15:20:34,203 INFO [STDOUT] at org.jboss.system.server.ServerImpl.start(ServerImpl.java:311) 
15:20:34,203 INFO  [STDOUT]     at org.jboss.Main.boot(Main.java:145)
15:20:34,203 INFO  [STDOUT]     at org.jboss.Main$1.run(Main.java:399)
15:20:34,203 INFO  [STDOUT]     at java.lang.Thread.run(Thread.java:595)

My code is
      Database databaseConnection = null;
      JDOManager jdoManager = null;
       try {                    jdoManager = JDOFactory.getJDOManager();
           databaseConnection = jdoManager.getDatabase();
           databaseConnection.begin();
           List listA = LoadDB.getCodeList(databaseConnection);
           Map mapA= LoadDB.getPCodeList(databaseConnection);
           databaseConnection.commit();
                     Context initialContext = new InitialContext();
           if (listA != null && listA.size() > 0) {
               initialContext.bind(JNDI_LIST_A,listA );
           }
           if (mapA!= null && mapA.size() > 0) {
               initialContext.bind(JNDI_MAP_A,mapA);
           }
           initialContext.close();
                     if (logger.isInfoEnabled()) {
logger.info("listA size :" + listA .size() + " are loaded to the application."); logger.info("mapAsize :" + mapA.size() + " are loaded to the application."); 
           }
           ThreadService ths = new ThreadService();
           ths.init();
       } catch (PersistenceException pe) {
           databaseConnection.rollback();
           logger.error("PersistenceException : ", pe);
           throw pe;
       } catch (NamingException ne) {
           logger.error("Naming Exception :" + ne);
           throw new ServletException("Naming Exception" +ne);
       } finally {
           try {
               if (databaseConnection != null) {
                   if (!databaseConnection.isClosed()) {
databaseConnection.close(); <--------------------------------------Line 281 
                   }
               }
           } catch (PersistenceException pe) {
               throw pe;
           }
       }




---------------------------------------------------------------------
To unsubscribe from this list please visit:

   http://xircles.codehaus.org/manage_email





---------------------------------------------------------------------
To unsubscribe from this list please visit:

   http://xircles.codehaus.org/manage_email

Reply via email to