5 Replies Latest reply on Jul 19, 2004 12:00 AM by up

    CMP don't read data modified from external application

    frederic

      Hello,

      1. I wrote an application using CMP Ejbs providing informations from a database (only read DB) : customer name, city etc...

      2. I use another application (C++) to modify the database.

      3. When I commit the changes with this C++ application, CMP are not reloaded (data still cached in memory).

      How can I make CMP synchronize with my DB changes?

      Do I have to force jboss call reload() method each time I call getXXX()? (and how?)

        • 1. Re: CMP don't read data modified from external application
          delattrj

          Hi,

          You can look at commit-option in jboss.jcml
          http://www.jboss.org/documentation/HTML/ch06s16.html

          jerome.

          • 2. Re: CMP don't read data modified from external application
            cotovelo

            Jerome,

            The link you gave is broken. Can you post a valid link?? Has anybody solved this mistery yet???

            • 3. Re: CMP don't read data modified from external application
              atatinen
              • 4. Re: CMP don't read data modified from external application
                delattrj

                sorry ... perhaps they moved it ? bizarre
                http://www.jboss.org/documentation/HTML/ch07s16.html

                • 5. 5468
                  up

                  Ok, the pool works fine, but I'm getting this error, and frankly I'm nagged. Using a freetds derived driver from www.thinweb.com, type 4 jdbc 2.x, setup exactly as per the manual: http://www.jboss.org/documentation/HTML/ch04s11.html , I have 2 pools the Oracle one, and the MSSQL one, they both work, I repeat. The drivers load fine. Any ideas?


                  [XADataSourceLoader] Starting
                  [OracleDB] XA Connection pool OracleDB bound to java:/OracleDB
                  [XADataSourceLoader] Stopped
                  java.lang.NullPointerException
                  at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSourc
                  e.java:178)
                  at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.jav
                  a:407)
                  at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107
                  )
                  at java.lang.reflect.Method.invoke(Native Method)
                  at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
                  28)
                  at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
                  23)
                  at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Conf
                  igurationService.java:836)
                  at $Proxy0.start(Unknown Source)
                  at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
                  at java.lang.reflect.Method.invoke(Native Method)
                  at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
                  28)
                  at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
                  23)
                  at org.jboss.Main.(Main.java:210)
                  at org.jboss.Main$1.run(Main.java:116)
                  at java.security.AccessController.doPrivileged(Native Method)
                  at org.jboss.Main.main(Main.java:112)
                  [Configuration] java.lang.NullPointerException
                  [Configuration] at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection
                  (XAPoolDataSource.java:178)
                  [Configuration] at org.jboss.jdbc.XADataSourceLoader.startService(XAData
                  SourceLoader.java:407)
                  [Configuration] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBean
                  Support.java:107)
                  [Configuration] at java.lang.reflect.Method.invoke(Native Method)
                  [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
                  rverImpl.java:1628)
                  [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
                  rverImpl.java:1523)
                  [Configuration] at org.jboss.configuration.ConfigurationService$ServiceP
                  roxy.invoke(ConfigurationService.java:836)
                  [Configuration] at $Proxy0.start(Unknown Source)
                  [Configuration] at org.jboss.util.ServiceControl.start(ServiceControl.ja
                  va:81)
                  [Configuration] at java.lang.reflect.Method.invoke(Native Method)
                  [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
                  rverImpl.java:1628)
                  [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
                  rverImpl.java:1523)
                  [Configuration] at org.jboss.Main.(Main.java:210)
                  [Configuration] at org.jboss.Main$1.run(Main.java:116)
                  [Configuration] at java.security.AccessController.doPrivileged(Native Me
                  thod)
                  [Configuration] at org.jboss.Main.main(Main.java:112)
                  [XADataSourceLoader] Starting
                  [MicrosoftDB] XA Connection pool MicrosoftDB bound to java:/MicrosoftDB
                  [XADataSourceLoader] Started