3 Replies Latest reply on Aug 31, 2001 2:40 PM by Anil Tatineni

    JBoss connection pools appears even after deleted

    Anil Tatineni Newbie

      i am using jboss2.2 + tomcat 3.2 oracle 8i as my database and using oracle thin client to access the database. So i registerd the drivers and the datasource jboss.jcml and others as was given in the documentation. when jboss started everything was fine. then i had CMP EJB using that datasource which was deployed successfully. then later on i decided to change the name of the datasource so went in to jboss.jcml file and changed the name of the datasource and restarted jboss again. interestingly when i looked at the log seems like jboss is tryin to create a pool with old name and new name as well. also ichanged the datasource in my jaws.xml file to point ot the new one and redeployed it.
      so i went back to jboss.jcml and deleted the whole MBean entry for the datasource for oracle and then restarted again. guess what i see in the log. it started both the pools. but it said it had a null pointer exception for name binding. below is the log attached.

      this is what i see in the log for the pools
      [ContentDB] Initializing
      [ContentDB] Initialized
      [OracleDB] Initializing
      [OracleDB] Initialized

      oracleDB is the old name for the datasource(which i changed to contentDB).

      almost at the end is see this

      [ContentDB] Starting
      [ContentDB] XA Connection pool ContentDB bound to java:/ContentDB
      [ContentDB] Stopped
      [ContentDB] java.lang.NullPointerException
      [ContentDB] at org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(
      XAPoolDataSource.java:165)
      [ContentDB] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLo
      ader.java:330)
      [ContentDB] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.
      java:93)
      [ContentDB] at java.lang.reflect.Method.invoke(Native Method)
      [ContentDB] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
      .java:1628)
      [ContentDB] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
      .java:1523)
      [ContentDB] at org.jboss.util.ServiceControl.start(ServiceControl.java:97)
      [ContentDB] at java.lang.reflect.Method.invoke(Native Method)
      [ContentDB] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
      .java:1628)
      [ContentDB] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
      .java:1523)
      [ContentDB] at org.jboss.Main.(Main.java:217)
      [ContentDB] at org.jboss.Main$1.run(Main.java:121)
      [ContentDB] at java.security.AccessController.doPrivileged(Native Method)
      [ContentDB] at org.jboss.Main.main(Main.java:117)
      [Service Control] Could not start DefaultDomain:service=XADataSource,name=Conten
      tDB
      [Service Control] java.lang.NullPointerException
      [Service Control] at org.opentools.minerva.jdbc.xa.XAPoolDataSource.getCon
      nection(XAPoolDataSource.java:165)
      [Service Control] at org.jboss.jdbc.XADataSourceLoader.startService(XAData
      SourceLoader.java:330)
      [Service Control] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBean
      Support.java:93)
      [Service Control] at java.lang.reflect.Method.invoke(Native Method)
      [Service Control] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
      rverImpl.java:1628)
      [Service Control] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
      rverImpl.java:1523)
      [Service Control] at org.jboss.util.ServiceControl.start(ServiceControl.ja
      va:97)
      [Service Control] at java.lang.reflect.Method.invoke(Native Method)
      [Service Control] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
      rverImpl.java:1628)
      [Service Control] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
      rverImpl.java:1523)
      [Service Control] at org.jboss.Main.(Main.java:217)
      [Service Control] at org.jboss.Main$1.run(Main.java:121)
      [Service Control] at java.security.AccessController.doPrivileged(Native Me
      thod)
      [Service Control] at org.jboss.Main.main(Main.java:117)
      [OracleDB] Starting
      [OracleDB] XA Connection pool OracleDB bound to java:/OracleDB
      [OracleDB] Stopped
      [OracleDB] java.lang.NullPointerException
      [OracleDB] at org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(
      XAPoolDataSource.java:165)
      [OracleDB] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLo
      ader.java:330)
      [OracleDB] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.
      java:93)
      [OracleDB] at java.lang.reflect.Method.invoke(Native Method)
      [OracleDB] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
      .java:1628)
      [OracleDB] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
      .java:1523)
      [OracleDB] at org.jboss.util.ServiceControl.start(ServiceControl.java:97)
      [OracleDB] at java.lang.reflect.Method.invoke(Native Method)
      [OracleDB] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
      .java:1628)
      [OracleDB] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl
      .java:1523)
      [OracleDB] at org.jboss.Main.(Main.java:217)
      [OracleDB] at org.jboss.Main$1.run(Main.java:121)
      [OracleDB] at java.security.AccessController.doPrivileged(Native Method)
      [OracleDB] at org.jboss.Main.main(Main.java:117)
      [Service Control] Could not start DefaultDomain:service=XADataSource,name=Oracle
      DB
      [Service Control] java.lang.NullPointerException
      [Service Control] at org.opentools.minerva.jdbc.xa.XAPoolDataSource.getCon
      nection(XAPoolDataSource.java:165)
      [Service Control] at org.jboss.jdbc.XADataSourceLoader.startService(XAData
      SourceLoader.java:330)
      [Service Control] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBean
      Support.java:93)
      [Service Control] at java.lang.reflect.Method.invoke(Native Method)
      [Service Control] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
      rverImpl.java:1628)
      [Service Control] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
      rverImpl.java:1523)
      [Service Control] at org.jboss.util.ServiceControl.start(ServiceControl.ja
      va:97)
      [Service Control] at java.lang.reflect.Method.invoke(Native Method)
      [Service Control] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
      rverImpl.java:1628)
      [Service Control] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanSe
      rverImpl.java:1523)
      [Service Control] at org.jboss.Main.(Main.java:217)
      [Service Control] at org.jboss.Main$1.run(Main.java:121)
      [Service Control] at java.security.AccessController.doPrivileged(Native Me
      thod)
      [Service Control] at org.jboss.Main.main(Main.java:117)
      [Service Control] Started 27 services
      [Default] JBoss 2.2.2 Started in 0m:20s


      so somewhere in the registry server it is storing the database pool information .. i guess. is that supposed to do that. I dont want to do that. what would be my get around??

      thanks in advance