0 Replies Latest reply on Mar 16, 2002 1:46 PM by raghav

    storing persistance messages to a database

    raghav Newbie

      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