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

    CMP don't read data modified from external application

    frederic Newbie

      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?)

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

          Jerome,

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

          • 5. 5468
            Ulrich Poppe Newbie

            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