6 Replies Latest reply on Sep 17, 2001 12:06 AM by jayeshpk

JDBC Persistencemanager start up error

sundaram Sep 13, 2001 5:48 PM

Hi,

I changed persistencemanager to JDBC, then i started jboss its giving the follwoing error message.



DefaultDS

What is wrong with this one??

[JBossMQService] Initialized

[StateManager] Initializing

[StateManager] Initialized

[PersistenceManager] Initializing

[PersistenceManager] Initialization failed

javax.naming.ConfigurationException: No valid Context.PROVIDER_URL was found

at org.jnp.interfaces.NamingContext.checkRef(NamingContext.java:785)

at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:340)

at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:333)

at javax.naming.InitialContext.lookup(InitialContext.java:350)

at org.jboss.mq.pm.jdbc.PersistenceManager.initService(PersistenceManager.java:100)

at org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:82)

at java.lang.reflect.Method.invoke(Native Method)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)

at $Proxy0.init(Unknown Source)

at org.jboss.util.ServiceControl.init(ServiceControl.java:55)

at java.lang.reflect.Method.invoke(Native Method)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

at org.jboss.Main.(Main.java:209)

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] javax.naming.ConfigurationException: No valid Context.PROVIDER_URL was found

[Configuration] at org.jnp.interfaces.NamingContext.checkRef(NamingContext.java:785)

[Configuration] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:340)

[Configuration] at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:333)

[Configuration] at javax.naming.InitialContext.lookup(InitialContext.java:350)

[Configuration] at org.jboss.mq.pm.jdbc.PersistenceManager.initService(PersistenceManager.java:100)

[Configuration] at org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:82)

[Configuration] at java.lang.reflect.Method.invoke(Native Method)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

[Configuration] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)

[Configuration] at $Proxy0.init(Unknown Source)

[Configuration] at org.jboss.util.ServiceControl.init(ServiceControl.java:55)

[Configuration] at java.lang.reflect.Method.invoke(Native Method)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

[Configuration] at org.jboss.Main.(Main.java:209)

[Configuration] at org.jboss.Main$1.run(Main.java:116)

[Configuration] at java.security.AccessController.doPrivileged(Native Method)

[Configuration] at org.jboss.Main.main(Main.java:112)

[JVMServerILService] Initializing

[JVMServerILService] Initialized

[RMIServerILService] Initializing

[RMIServerILService] Initialized

[OILServerILService] Initializing

[OILServerILService] Initialized

[UILServerILService] Initializing

[UILServerILService] Initialized

[TopicManager] Initializing

[TopicManager] Initialized

[TopicManager] Initializing

[TopicManager] Initialized

[TopicManager] Initializing

[TopicManager] Initialized

[QueueManager] Initializing

[QueueManager] Initialization failed

java.lang.NullPointerException:

at org.jboss.mq.server.PersistentQueue.(PersistentQueue.java:22)

at org.jboss.mq.server.JMSQueue.(JMSQueue.java:42)

at org.jboss.mq.server.QueueManager.initService(QueueManager.java:68)

at org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:82)

at java.lang.reflect.Method.invoke(Native Method)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)

at $Proxy0.init(Unknown Source)

at org.jboss.util.ServiceControl.init(ServiceControl.java:55)

at java.lang.reflect.Method.invoke(Native Method)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

at org.jboss.Main.(Main.java:209)

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.mq.server.PersistentQueue.(PersistentQueue.java:22)

[Configuration] at org.jboss.mq.server.JMSQueue.(JMSQueue.java:42)

[Configuration] at org.jboss.mq.server.QueueManager.initService(QueueManager.java:68)

[Configuration] at org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:82)

[Configuration] at java.lang.reflect.Method.invoke(Native Method)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

[Configuration] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)

[Configuration] at $Proxy0.init(Unknown Source)

[Configuration] at org.jboss.util.ServiceControl.init(ServiceControl.java:55)

[Configuration] at java.lang.reflect.Method.invoke(Native Method)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

[Configuration] at org.jboss.Main.(Main.java:209)

[Configuration] at org.jboss.Main$1.run(Main.java:116)

[Configuration] at java.security.AccessController.doPrivileged(Native Method)

[Configuration] at org.jboss.Main.main(Main.java:112)

[QueueManager] Initializing

[QueueManager] Initialization failed

java.lang.NullPointerException:

at org.jboss.mq.server.PersistentQueue.(PersistentQueue.java:22)

at org.jboss.mq.server.JMSQueue.(JMSQueue.java:42)

at org.jboss.mq.server.QueueManager.initService(QueueManager.java:68)

at org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:82)

at java.lang.reflect.Method.invoke(Native Method)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)

at $Proxy0.init(Unknown Source)

at org.jboss.util.ServiceControl.init(ServiceControl.java:55)

at java.lang.reflect.Method.invoke(Native Method)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

at org.jboss.Main.(Main.java:209)

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.mq.server.PersistentQueue.(PersistentQueue.java:22)

[Configuration] at org.jboss.mq.server.JMSQueue.(JMSQueue.java:42)

[Configuration] at org.jboss.mq.server.QueueManager.initService(QueueManager.java:68)

[Configuration] at org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:82)

[Configuration] at java.lang.reflect.Method.invoke(Native Method)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

[Configuration] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)

[Configuration] at $Proxy0.init(Unknown Source)

[Configuration] at org.jboss.util.ServiceControl.init(ServiceControl.java:55)

[Configuration] at java.lang.reflect.Method.invoke(Native Method)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

[Configuration] at org.jboss.Main.(Main.java:209)

[Configuration] at org.jboss.Main$1.run(Main.java:116)

[Configuration] at java.security.AccessController.doPrivileged(Native Method)

[Configuration] at org.jboss.Main.main(Main.java:112)

[QueueManager] Initializing

[QueueManager] Initialization failed

java.lang.NullPointerException:

at org.jboss.mq.server.PersistentQueue.(PersistentQueue.java:22)

at org.jboss.mq.server.JMSQueue.(JMSQueue.java:42)

at org.jboss.mq.server.QueueManager.initService(QueueManager.java:68)

at org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:82)

at java.lang.reflect.Method.invoke(Native Method)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)

at $Proxy0.init(Unknown Source)

at org.jboss.util.ServiceControl.init(ServiceControl.java:55)

at java.lang.reflect.Method.invoke(Native Method)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

at org.jboss.Main.(Main.java:209)

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.mq.server.PersistentQueue.(PersistentQueue.java:22)

[Configuration] at org.jboss.mq.server.JMSQueue.(JMSQueue.java:42)

[Configuration] at org.jboss.mq.server.QueueManager.initService(QueueManager.java:68)

[Configuration] at org.jboss.util.ServiceMBeanSupport.init(ServiceMBeanSupport.java:82)

[Configuration] at java.lang.reflect.Method.invoke(Native Method)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

[Configuration] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)

[Configuration] at $Proxy0.init(Unknown Source)

[Configuration] at org.jboss.util.ServiceControl.init(ServiceControl.java:55)

[Configuration] at java.lang.reflect.Method.invoke(Native Method)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)

[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)

[Configuration] at org.jboss.Main.(Main.java:209)

[Configuration] at org.jboss.Main$1.run(Main.java:116)

[Configuration] at java.security.AccessController.doPrivileged(Native Method)

[Configuration] at org.jboss.Main.main(Main.java:1

Thanks
-SR

1. Re: JDBC Persistencemanager start up error

wessorh Sep 14, 2001 3:03 PM (in response to sundaram)

I have the same error, the problem appears to be that
the PersistenceManager can't find the name to bind to durring inilization, the PersistenceManager also fails to startup which makes all the queues and topics
fail.

Also where is the DDL (SQL) that defines the jdbc queues and topics storage schema?

thanks,

-rick
Actions
2. Re: JDBC Persistencemanager start up error

jayeshpk Sep 14, 2001 6:18 PM (in response to sundaram)

use java:/JmsDB instead of DefaultDS
Actions
3. Re: JDBC Persistencemanager start up error

jayeshpk Sep 14, 2001 6:20 PM (in response to sundaram)

use java:/DefaultDS if you have setup your database as DefaultDS.

Also make sure you have the tables JMS_MESSAGES and JMS_TRANSACTIONS check message # 1111 on yahoo message board for the script.
Actions
4. Re: JDBC Persistencemanager start up error

wessorh Sep 16, 2001 12:23 AM (in response to sundaram)

I used java:/JmsDB and the schema below. The JDBCDataSourceLoader I used is below. I still get tons of errors as the PersistanceManager is initilizised.

Is there a single doc that explains how to set this stuff up, I've read just about everything related to using the jdbc persistance but can't get it to work.

thanks,

-rick

database schema
JmsDB
oracle.jdbc.pool.OracleDataSource
jdbc:oracle:thin:@host:1521:SID
jms
XXXX

Interbase :
CREATE TABLE JMS_MESSAGES
(
MESSAGEID CHAR(17) NOT NULL,
DESTINATION VARCHAR(30) NOT NULL,
MESSAGEBLOB BLOB,
PRIMARY KEY (MESSAGEID, DESTINATION)
);
CREATE INDEX JMS_MESSAGES_DEST ON JMS_MESSAGES(DESTINATION);

CREATE TABLE JMS_TRANSACTIONS
(
ID CHAR(17)
)

Oracle :
CREATE TABLE JMS_MESSAGES
(
MESSAGEID CHAR(17) NOT NULL,
DESTINATION VARCHAR(30) NOT NULL,
MESSAGEBLOB LONG RAW,
PRIMARY KEY (MESSAGEID, DESTINATION)
);
CREATE INDEX JMS_MESSAGES_DEST ON JMS_MESSAGES(DESTINATION);

CREATE TABLE JMS_TRANSACTIONS
(
ID CHAR(17)
)
Actions
5. Re: JDBC Persistencemanager start up error

sundaram Sep 16, 2001 9:29 AM (in response to sundaram)

How will i look yahoo message list #1111 can you post the URL for this link.

Thanks
Actions
6. Re: JDBC Persistencemanager start up error

jayeshpk Sep 17, 2001 12:06 AM (in response to sundaram)

http://groups.yahoo.com/group/spyderMQ/message/1111

This is outdated since we do not use jboss.jcml anymore.
BTW you need to checkout the most recent souce from cvs and build jbossmq.

Jayesh
Actions

Go to original post