storing persistance messages to a database
Hai ,
Iam using JBOss-2.4.3 with combination of mysql. I wanted to store persistant data to jdbc store.I had created the related tables as of the following.........
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)
);
and my mbean for persistance manager in jboss.jcml file is
like the following.........
source1
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:mysql://host170:3306/rsems
1200000
raghav
10
raghav
false
false
false
true
120000
1800000
false
true
1.0
0
when i run the server iam getting the exception as
[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:220)
at org.jboss.Main$1.run(Main.java:127)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:123)
[Configuration] javax.naming.ConfigurationException: No valid Context.PROVIDER_URL was found
Can u plz suggest me where i had done mistake........
thanks in advance......
bye
raghav