JMS Server and MySQL Persistent Store - Weblogic

This is a discussion on JMS Server and MySQL Persistent Store - Weblogic ; I set up a JDBC connection pool in Weblogic 8.1 with MySQL dbms. When I tried to create a JMS server and use the connection pool as the Persistent Store, then try to target the JMS to a managed server. ...

+ Reply to Thread
Results 1 to 2 of 2

Thread: JMS Server and MySQL Persistent Store

  1. JMS Server and MySQL Persistent Store


    I set up a JDBC connection pool in Weblogic 8.1 with MySQL dbms. When I tried to
    create a JMS server and use the connection pool as the Persistent Store, then
    try to target the JMS to a managed server. I got the following error, any idea
    what the problem is?

    weblogic.management.DistributedManagementException : Distributed Management [1
    exceptions]
    JMS JDBC store, connection pool = , prefix = : unsupported DBMS
    at weblogic.management.internal.ConfigurationMBeanImp l.updateConfigMBeans(ConfigurationMBeanImpl.java:1 133)
    at weblogic.management.internal.ConfigurationMBeanImp l.invoke(ConfigurationMBeanImpl.java:462)
    at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1557)
    at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1525)
    at weblogic.management.internal.RemoteMBeanServerImpl .invoke(RemoteMBeanServerImpl.java:765)
    at weblogic.management.internal.MBeanProxy.invoke(MBe anProxy.java:946)
    at weblogic.management.internal.MBeanProxy.invokeForC achingStub(MBeanProxy.java:481)
    at weblogic.management.configuration.ServerMBean_Stub .addDeployment(ServerMBean_Stub.java:7929)
    at weblogic.management.internal.DynamicMBeanImpl.unpr otectedUpdateDeployments(DynamicMBeanImpl.java:179 5)
    at weblogic.management.internal.DynamicMBeanImpl.acce ss$100(DynamicMBeanImpl.java:95)
    at weblogic.management.internal.DynamicMBeanImpl$2.ru n(DynamicMBeanImpl.java:1708)
    at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:317)
    at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:118)
    at weblogic.management.internal.DynamicMBeanImpl.upda teDeployments(DynamicMBeanImpl.java:1704)
    at weblogic.management.internal.DynamicMBeanImpl.setA ttribute(DynamicMBeanImpl.java:1128)
    at weblogic.management.internal.ConfigurationMBeanImp l.setAttribute(ConfigurationMBeanImpl.java:311)
    at com.sun.management.jmx.MBeanServerImpl.setAttribut e(MBeanServerImpl.java:1358)
    at com.sun.management.jmx.MBeanServerImpl.setAttribut e(MBeanServerImpl.java:1333)
    at weblogic.management.internal.RemoteMBeanServerImpl .setAttribute(RemoteMBeanServerImpl.java:367)
    at weblogic.management.internal.MBeanProxy.setAttribu te(MBeanProxy.java:741)
    at weblogic.management.internal.MBeanProxy.invokeForC achingStub(MBeanProxy.java:475)
    at weblogic.management.configuration.JMSServerMBean_S tub.setTargets(JMSServerMBean_Stub.java:1247)
    at weblogic.management.console.webapp._domain.__jmsse rver$ServerAndMigratableTargetAttribute.doSet(__jm sserver.java:109)
    at weblogic.management.console.actions.mbean.DoEditMB eanAction.perform(DoEditMBeanAction.java:256)
    at weblogic.management.console.actions.internal.Actio nServlet.doAction(ActionServlet.java:173)
    at weblogic.management.console.actions.internal.Actio nServlet.doPost(ActionServlet.java:85)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
    at weblogic.servlet.internal.ServletStubImpl$ServletI nvocationAction.run(ServletStubImpl.java:1053)
    at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:387)
    at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:305)
    at weblogic.servlet.internal.WebAppServletContext$Ser vletInvocationAction.run(WebAppServletContext.java :6310)
    at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:317)
    at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:118)
    at weblogic.servlet.internal.WebAppServletContext.inv okeServlet(WebAppServletContext.java:3622)
    at weblogic.servlet.internal.ServletRequestImpl.execu te(ServletRequestImpl.java:2569)
    at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:197)
    at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)
    java.io.IOException: JMS JDBC store, connection pool = , prefix = : unsupported
    DBMS
    at weblogic.jms.store.JDBCIOStream.throwIOException(J DBCIOStream.java:359)
    at weblogic.jms.store.JDBCIOStream.rebuildTables(JDBC IOStream.java:1613)
    at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream. java:426)
    at weblogic.jms.store.JMSStore.open(JMSStore.java:224 )
    at weblogic.jms.backend.BEStore.open(BEStore.java:262 )
    at weblogic.jms.backend.BEStore.start(BEStore.java:15 1)
    at weblogic.jms.backend.BackEnd.openStores(BackEnd.ja va:1171)
    at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1 287)
    at weblogic.jms.JMSService.addJMSServer(JMSService.ja va:2167)
    at weblogic.jms.JMSService.addDeployment(JMSService.j ava:1938)
    at weblogic.management.mbeans.custom.DeploymentTarget .addDeployment(DeploymentTarget.java:330)
    at weblogic.management.mbeans.custom.DeploymentTarget .addDeployment(DeploymentTarget.java:201)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at weblogic.management.internal.DynamicMBeanImpl.invo keLocally(DynamicMBeanImpl.java:747)
    at weblogic.management.internal.DynamicMBeanImpl.invo ke(DynamicMBeanImpl.java:726)
    at weblogic.management.internal.ConfigurationMBeanImp l.invoke(ConfigurationMBeanImpl.java:458)
    at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1557)
    at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1525)
    at weblogic.management.internal.RemoteMBeanServerImpl .invoke(RemoteMBeanServerImpl.java:765)
    at weblogic.management.internal.RemoteMBeanServerImpl _WLSkel.invoke(Unknown Source)
    at weblogic.rmi.internal.BasicServerRef.invoke(BasicS erverRef.java:466)
    at weblogic.rmi.internal.BasicServerRef$1.run(BasicSe rverRef.java:409)
    at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:353)
    at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:144)
    at weblogic.rmi.internal.BasicServerRef.handleRequest (BasicServerRef.java:404)
    at weblogic.rmi.internal.BasicExecuteRequest.execute( BasicExecuteRequest.java:30)
    at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:197)
    at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)
    --------------- nested within: ------------------
    weblogic.management.console.utils.SetException: An error occurred while updating
    MigratableTarget on [Caching Stub]Proxy for dotnet:Name=CSJMSServer,Type=JMSServer
    - with nested exception:
    [weblogic.management.DistributedManagementException : Distributed Management [1
    exceptions]
    JMS JDBC store, connection pool = , prefix = : unsupported DBMS]
    at weblogic.management.console.actions.mbean.DoEditMB eanAction.perform(DoEditMBeanAction.java:311)
    at weblogic.management.console.actions.internal.Actio nServlet.doAction(ActionServlet.java:173)
    at weblogic.management.console.actions.internal.Actio nServlet.doPost(ActionServlet.java:85)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
    at weblogic.servlet.internal.ServletStubImpl$ServletI nvocationAction.run(ServletStubImpl.java:1053)
    at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:387)
    at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:305)
    at weblogic.servlet.internal.WebAppServletContext$Ser vletInvocationAction.run(WebAppServletContext.java :6310)
    at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:317)
    at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:118)
    at weblogic.servlet.internal.WebAppServletContext.inv okeServlet(WebAppServletContext.java:3622)
    at weblogic.servlet.internal.ServletRequestImpl.execu te(ServletRequestImpl.java:2569)
    at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:197)
    at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)



    --------------------------------------------------------------------------------

    Console Release Build8.1.1.0Server Release Build8.1.1.0Server BuildWebLogic Server
    8.1 SP1 Fri Jun 20 23:06:40 PDT 2003 271009 All Server Product VersionsWebLogic
    Server 8.1 SP1 Fri Jun 20 23:06:40 PDT 2003 271009 WebLogic XMLX Module 8.1 SP1
    Fri Jun 20 23:06:40 PDT 2003 271009 WebLogic Server 8.1 SP1 Fri Jun 20 23:06:40
    PDT 2003 271009 WebLogic Server 8.1 SP1 Fri Jun 20 23:06:40 PDT 2003 271009 WebLogic
    Portal 8.1 Thu Jul 10 20:09:22 PDT 2003 84868


  2. Re: JMS Server and MySQL Persistent StoreQL

    Exactly what it says: unsupported DBMS.

    But but but...

    OK, I'll be nice (just couldn't resist).

    The next 8.1 SP will contain the DDL for MySQL, but for
    now you can run it manually. Prepend your catalog,
    schema, and prefix before JMSState and JMSStore to
    match what you configured as a prefix in your
    JMS JDBC store, and run the commands:

    CREATE TABLE JMSState (recordHandle int, recordState int,
    recordGeneration int);
    CREATE TABLE JMSStore (recordHandle int, recordState int, record longblob);

    CREATE INDEX JMSMSG_X ON JMSState (recordHandle);
    CREATE INDEX JMSMSGQ_X ON JMSStore (recordHandle);
    COMMIT;

    Note that a file store may be preferable instead
    of using a database store, there is
    likely no performance advantage to MySQL (in fact
    there is likely a significant performance penalty), and a file
    store is just as transactionally safe as a database
    store.

    Tom

    dahan wrote:
    > I set up a JDBC connection pool in Weblogic 8.1 with MySQL dbms. When I tried to
    > create a JMS server and use the connection pool as the Persistent Store, then
    > try to target the JMS to a managed server. I got the following error, any idea
    > what the problem is?
    >
    > weblogic.management.DistributedManagementException : Distributed Management [1
    > exceptions]
    > JMS JDBC store, connection pool = , prefix = : unsupported DBMS
    > at weblogic.management.internal.ConfigurationMBeanImp l.updateConfigMBeans(ConfigurationMBeanImpl.java:1 133)
    > at weblogic.management.internal.ConfigurationMBeanImp l.invoke(ConfigurationMBeanImpl.java:462)
    > at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1557)
    > at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1525)
    > at weblogic.management.internal.RemoteMBeanServerImpl .invoke(RemoteMBeanServerImpl.java:765)
    > at weblogic.management.internal.MBeanProxy.invoke(MBe anProxy.java:946)
    > at weblogic.management.internal.MBeanProxy.invokeForC achingStub(MBeanProxy.java:481)
    > at weblogic.management.configuration.ServerMBean_Stub .addDeployment(ServerMBean_Stub.java:7929)
    > at weblogic.management.internal.DynamicMBeanImpl.unpr otectedUpdateDeployments(DynamicMBeanImpl.java:179 5)
    > at weblogic.management.internal.DynamicMBeanImpl.acce ss$100(DynamicMBeanImpl.java:95)
    > at weblogic.management.internal.DynamicMBeanImpl$2.ru n(DynamicMBeanImpl.java:1708)
    > at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:317)
    > at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:118)
    > at weblogic.management.internal.DynamicMBeanImpl.upda teDeployments(DynamicMBeanImpl.java:1704)
    > at weblogic.management.internal.DynamicMBeanImpl.setA ttribute(DynamicMBeanImpl.java:1128)
    > at weblogic.management.internal.ConfigurationMBeanImp l.setAttribute(ConfigurationMBeanImpl.java:311)
    > at com.sun.management.jmx.MBeanServerImpl.setAttribut e(MBeanServerImpl.java:1358)
    > at com.sun.management.jmx.MBeanServerImpl.setAttribut e(MBeanServerImpl.java:1333)
    > at weblogic.management.internal.RemoteMBeanServerImpl .setAttribute(RemoteMBeanServerImpl.java:367)
    > at weblogic.management.internal.MBeanProxy.setAttribu te(MBeanProxy.java:741)
    > at weblogic.management.internal.MBeanProxy.invokeForC achingStub(MBeanProxy.java:475)
    > at weblogic.management.configuration.JMSServerMBean_S tub.setTargets(JMSServerMBean_Stub.java:1247)
    > at weblogic.management.console.webapp._domain.__jmsse rver$ServerAndMigratableTargetAttribute.doSet(__jm sserver.java:109)
    > at weblogic.management.console.actions.mbean.DoEditMB eanAction.perform(DoEditMBeanAction.java:256)
    > at weblogic.management.console.actions.internal.Actio nServlet.doAction(ActionServlet.java:173)
    > at weblogic.management.console.actions.internal.Actio nServlet.doPost(ActionServlet.java:85)
    > at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
    > at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
    > at weblogic.servlet.internal.ServletStubImpl$ServletI nvocationAction.run(ServletStubImpl.java:1053)
    > at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:387)
    > at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:305)
    > at weblogic.servlet.internal.WebAppServletContext$Ser vletInvocationAction.run(WebAppServletContext.java :6310)
    > at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:317)
    > at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:118)
    > at weblogic.servlet.internal.WebAppServletContext.inv okeServlet(WebAppServletContext.java:3622)
    > at weblogic.servlet.internal.ServletRequestImpl.execu te(ServletRequestImpl.java:2569)
    > at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:197)
    > at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)
    > java.io.IOException: JMS JDBC store, connection pool = , prefix = : unsupported
    > DBMS
    > at weblogic.jms.store.JDBCIOStream.throwIOException(J DBCIOStream.java:359)
    > at weblogic.jms.store.JDBCIOStream.rebuildTables(JDBC IOStream.java:1613)
    > at weblogic.jms.store.JDBCIOStream.open(JDBCIOStream. java:426)
    > at weblogic.jms.store.JMSStore.open(JMSStore.java:224 )
    > at weblogic.jms.backend.BEStore.open(BEStore.java:262 )
    > at weblogic.jms.backend.BEStore.start(BEStore.java:15 1)
    > at weblogic.jms.backend.BackEnd.openStores(BackEnd.ja va:1171)
    > at weblogic.jms.backend.BackEnd.resume(BackEnd.java:1 287)
    > at weblogic.jms.JMSService.addJMSServer(JMSService.ja va:2167)
    > at weblogic.jms.JMSService.addDeployment(JMSService.j ava:1938)
    > at weblogic.management.mbeans.custom.DeploymentTarget .addDeployment(DeploymentTarget.java:330)
    > at weblogic.management.mbeans.custom.DeploymentTarget .addDeployment(DeploymentTarget.java:201)
    > at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
    > at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
    > at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    > at java.lang.reflect.Method.invoke(Method.java:324)
    > at weblogic.management.internal.DynamicMBeanImpl.invo keLocally(DynamicMBeanImpl.java:747)
    > at weblogic.management.internal.DynamicMBeanImpl.invo ke(DynamicMBeanImpl.java:726)
    > at weblogic.management.internal.ConfigurationMBeanImp l.invoke(ConfigurationMBeanImpl.java:458)
    > at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1557)
    > at com.sun.management.jmx.MBeanServerImpl.invoke(MBea nServerImpl.java:1525)
    > at weblogic.management.internal.RemoteMBeanServerImpl .invoke(RemoteMBeanServerImpl.java:765)
    > at weblogic.management.internal.RemoteMBeanServerImpl _WLSkel.invoke(Unknown Source)
    > at weblogic.rmi.internal.BasicServerRef.invoke(BasicS erverRef.java:466)
    > at weblogic.rmi.internal.BasicServerRef$1.run(BasicSe rverRef.java:409)
    > at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:353)
    > at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:144)
    > at weblogic.rmi.internal.BasicServerRef.handleRequest (BasicServerRef.java:404)
    > at weblogic.rmi.internal.BasicExecuteRequest.execute( BasicExecuteRequest.java:30)
    > at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:197)
    > at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)
    > --------------- nested within: ------------------
    > weblogic.management.console.utils.SetException: An error occurred while updating
    > MigratableTarget on [Caching Stub]Proxy for dotnet:Name=CSJMSServer,Type=JMSServer
    > - with nested exception:
    > [weblogic.management.DistributedManagementException : Distributed Management [1
    > exceptions]
    > JMS JDBC store, connection pool = , prefix = : unsupported DBMS]
    > at weblogic.management.console.actions.mbean.DoEditMB eanAction.perform(DoEditMBeanAction.java:311)
    > at weblogic.management.console.actions.internal.Actio nServlet.doAction(ActionServlet.java:173)
    > at weblogic.management.console.actions.internal.Actio nServlet.doPost(ActionServlet.java:85)
    > at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
    > at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
    > at weblogic.servlet.internal.ServletStubImpl$ServletI nvocationAction.run(ServletStubImpl.java:1053)
    > at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:387)
    > at weblogic.servlet.internal.ServletStubImpl.invokeSe rvlet(ServletStubImpl.java:305)
    > at weblogic.servlet.internal.WebAppServletContext$Ser vletInvocationAction.run(WebAppServletContext.java :6310)
    > at weblogic.security.acl.internal.AuthenticatedSubjec t.doAs(AuthenticatedSubject.java:317)
    > at weblogic.security.service.SecurityManager.runAs(Se curityManager.java:118)
    > at weblogic.servlet.internal.WebAppServletContext.inv okeServlet(WebAppServletContext.java:3622)
    > at weblogic.servlet.internal.ServletRequestImpl.execu te(ServletRequestImpl.java:2569)
    > at weblogic.kernel.ExecuteThread.execute(ExecuteThrea d.java:197)
    > at weblogic.kernel.ExecuteThread.run(ExecuteThread.ja va:170)
    >
    >
    >
    > --------------------------------------------------------------------------------
    >
    > Console Release Build8.1.1.0Server Release Build8.1.1.0Server BuildWebLogic Server
    > 8.1 SP1 Fri Jun 20 23:06:40 PDT 2003 271009 All Server Product VersionsWebLogic
    > Server 8.1 SP1 Fri Jun 20 23:06:40 PDT 2003 271009 WebLogic XMLX Module 8.1 SP1
    > Fri Jun 20 23:06:40 PDT 2003 271009 WebLogic Server 8.1 SP1 Fri Jun 20 23:06:40
    > PDT 2003 271009 WebLogic Server 8.1 SP1 Fri Jun 20 23:06:40 PDT 2003 271009 WebLogic
    > Portal 8.1 Thu Jul 10 20:09:22 PDT 2003 84868
    >



+ Reply to Thread