facebook
  1. MyEclipse Archived
    2.  > 
  2. Application Servers and Deployment

connection pooling with mysql server

  1. MyEclipse Archived
    2.  > 
  2. Application Servers and Deployment
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • June 12, 2005 at 10:31 am #230919 Reply

    ram_kurra@yahoo.co.in
    Member

    Hello techies,
    I am very new to weblogic server and myeclipse.
    Iam using weblogic 7.0.
    mysql 4.1
    myeclipse3.8.4
    when i try to connect mysql server from weblogic server it is showing following error.
    <Jun 12, 2005 8:31:52 PM IST> <Error> <JDBC> <001060> <Cannot startup connection pool “MyJDBC Connection Pool” weblogic.common.ResourceException: Cannot load driver class: com.mysql.jdbc.Driver>

    I had opened the admin console from browser.
    and had given the following information
    In General Tab

    name : ramu
    url : jdbc:mysql://localhost:3306/test
    Driver Class Name:com.mysql.jdbc.Driver
    Properties: user = root
    ACLName : blank
    password : **********
    OpenString Password: blank

    In Targets tab
    i had given myserver and press apply.

    Now it is displaying the follwoing error

    Exception
    java.lang.NullPointerException
    at weblogic.management.console.utils.MBeans.getMBeanClassNameFor(MBeans.java:1153)
    at weblogic.management.console.actions.mbean.EditMBeanAction.getMBeanClass(EditMBeanAction.java:210)
    at weblogic.management.console.actions.mbean.EditMBeanAction.getDialogTypeKey(EditMBeanAction.java:188)
    at weblogic.management.console.actions.internal.InternalActionContext.setAction(InternalActionContext.java:158)
    at weblogic.management.console.actions.internal.ActionServlet.doAction(ActionServlet.java:170)
    at weblogic.management.console.actions.internal.ActionServlet.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$ServletInvocationAction.run(ServletStubImpl.java:945)
    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:332)
    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:242)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:5363)
    at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:721)
    at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3043)
    at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2466)
    at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:152)
    at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:133)
    ————— nested within: ——————
    weblogic.utils.NestedRuntimeException – with nested exception:
    [java.lang.NullPointerException]
    at weblogic.management.console.utils.MBeans.getMBeanClassNameFor(MBeans.java:1156)
    at weblogic.management.console.actions.mbean.EditMBeanAction.getMBeanClass(EditMBeanAction.java:210)
    at weblogic.management.console.actions.mbean.EditMBeanAction.getDialogTypeKey(EditMBeanAction.java:188)
    at weblogic.management.console.actions.internal.InternalActionContext.setAction(InternalActionContext.java:158)
    at weblogic.management.console.actions.internal.ActionServlet.doAction(ActionServlet.java:170)
    at weblogic.management.console.actions.internal.ActionServlet.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$ServletInvocationAction.run(ServletStubImpl.java:945)
    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:332)
    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:242)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:5363)
    at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:721)
    at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3043)
    at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2466)
    at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:152)
    at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:133)
    ————— nested within: ——————
    weblogic.management.console.actions.ActionException – with nested exception:
    [weblogic.utils.NestedRuntimeException – with nested exception:
    [java.lang.NullPointerException]]
    at weblogic.management.console.actions.ErrorAction.(ErrorAction.java:38)
    at weblogic.management.console.actions.internal.ActionServlet.doAction(ActionServlet.java:190)
    at weblogic.management.console.actions.internal.ActionServlet.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$ServletInvocationAction.run(ServletStubImpl.java:945)
    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:332)
    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:242)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:5363)
    at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:721)
    at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3043)
    at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2466)
    at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:152)
    at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:133)

    Why this error is occuring?
    can anybody tell me what are the changes that i have to make in connectionn pooling ??
    Is the driverclass name which i had given are correct??

    Is any thing to be entered in ACL entry??

    Actually iam able to connect to the mysql server using myEclipseDatabaseExplorer in myeclipse. With this am i able to connect to the mysql server from weblogic??

    If not how to make connection with mysql server from weblogic??

    thanks (in advance),
    ramu.

    June 12, 2005 at 9:01 pm #230932 Reply

    Riyad Kalla
    Member

    Ramu,
    The problem is that you have setup MyEclipse correctly, but WebLogic is executed outside of MyEclipse by our connector so it has no knowledge of the location of your JDBC JAR. What you need to do is append that JAR to your server’s classpath so it can find it. The way to do that is navigate to Window > Preferences > MyEclipse > Application Servers > WebLogic 7 > Paths, and just clickt he “Add” button next to the “Append to classpath” box and add the JAR(s) for your JDBC driver. Then restart your App server, everything should work (atleast the ClassNotFoundExpcetion should stop).

    June 13, 2005 at 5:03 am #230940 Reply

    ram_kurra@yahoo.co.in
    Member

    Hello Riyad,
    Iam using mysql jconnector—mysql-connector-java-3.1.8
    I had included the following jdbc jar files in path.

    mysql-connector-java-3.1.8-bin-g
    mysql-connector-java-3.1.8-bin
    aspectjrt
    aspectjtools
    jdbc2_0-stdext
    jta-spec1_0_1

    I opened the admin console n created a new connection pool.
    Now the following error is displayed in the server.

    <Jun 13, 2005 3:02:11 PM IST> <Notice> <WebLogicServer> <000365> <Server state changed to RUNNING>
    <Jun 13, 2005 3:02:11 PM IST> <Notice> <WebLogicServer> <000360> <Server started in RUNNING mode>
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> NonRegisteringDriver.java:223 com.mysql.jdbc.NonRegisteringDriver.acceptsURL(“jdbc:mysql://localhost:3306/ mysql”)
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> NonRegisteringDriver.java:339 com.mysql.jdbc.NonRegisteringDriver.parseURL(“jdbc:mysql://localhost:3306/ mysql”, null)
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> StringUtils.java:722 com.mysql.jdbc.StringUtils.startsWithIgnoreCase(“jdbc:mysql://localhost:3306/ mysql”, “jdbc:mysql://”)
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> StringUtils.java:738 com.mysql.jdbc.StringUtils.startsWithIgnoreCase(“jdbc:mysql://localhost:3306/ mysql”, 0, “jdbc:mysql://”)
    Mon Jun 13 15:06:32 IST 2005 TRACE: <– StringUtils.java:738 com.mysql.jdbc.StringUtils.startsWithIgnoreCase(..) returning true
    Mon Jun 13 15:06:32 IST 2005 TRACE: <– StringUtils.java:722 com.mysql.jdbc.StringUtils.startsWithIgnoreCase(..) returning true
    Mon Jun 13 15:06:32 IST 2005 TRACE: <– NonRegisteringDriver.java:339 com.mysql.jdbc.NonRegisteringDriver.parseURL(..) returning {HOST=localhost:3306, DBNAME= mysql}
    Mon Jun 13 15:06:32 IST 2005 TRACE: <– NonRegisteringDriver.java:223 com.mysql.jdbc.NonRegisteringDriver.acceptsURL(..) returning true
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> NonRegisteringDriver.java:127 com.mysql.jdbc.NonRegisteringDriver.getMajorVersion()
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> NonRegisteringDriver.java:569 com.mysql.jdbc.NonRegisteringDriver.getMajorVersionInternal()
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> NonRegisteringDriver.java:583 com.mysql.jdbc.NonRegisteringDriver.safeIntParse(“3”)
    Mon Jun 13 15:06:32 IST 2005 TRACE: <– NonRegisteringDriver.java:583 com.mysql.jdbc.NonRegisteringDriver.safeIntParse(..) returning 3
    Mon Jun 13 15:06:32 IST 2005 TRACE: <– NonRegisteringDriver.java:569 com.mysql.jdbc.NonRegisteringDriver.getMajorVersionInternal(..) returning 3
    Mon Jun 13 15:06:32 IST 2005 TRACE: <– NonRegisteringDriver.java:127 com.mysql.jdbc.NonRegisteringDriver.getMajorVersion(..) returning 3
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> NonRegisteringDriver.java:136 com.mysql.jdbc.NonRegisteringDriver.getMinorVersion()
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> NonRegisteringDriver.java:578 com.mysql.jdbc.NonRegisteringDriver.getMinorVersionInternal()
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> NonRegisteringDriver.java:583 com.mysql.jdbc.NonRegisteringDriver.safeIntParse(“1”)
    Mon Jun 13 15:06:32 IST 2005 TRACE: <– NonRegisteringDriver.java:583 com.mysql.jdbc.NonRegisteringDriver.safeIntParse(..) returning 1
    Mon Jun 13 15:06:32 IST 2005 TRACE: <– NonRegisteringDriver.java:578 com.mysql.jdbc.NonRegisteringDriver.getMinorVersionInternal(..) returning 1
    Mon Jun 13 15:06:32 IST 2005 TRACE: <– NonRegisteringDriver.java:136 com.mysql.jdbc.NonRegisteringDriver.getMinorVersion(..) returning 1
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> NonRegisteringDriver.java:261 com.mysql.jdbc.NonRegisteringDriver.connect(“jdbc:mysql://localhost:3306/ mysql”, {user=root, password=sanjay123})
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> NonRegisteringDriver.java:339 com.mysql.jdbc.NonRegisteringDriver.parseURL(“jdbc:mysql://localhost:3306/ mysql”, {user=root, password=sanjay123})
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> StringUtils.java:722 com.mysql.jdbc.StringUtils.startsWithIgnoreCase(“jdbc:mysql://localhost:3306/ mysql”, “jdbc:mysql://”)
    Mon Jun 13 15:06:32 IST 2005 TRACE: –> StringUtils.java:738 com.mysql.jdbc.StringUtils.startsWithIgnoreCase(“jdbc:mysql://localhost:3306/ mysql”, 0, “jdbc:mysql://”)
    Mon Jun 13 15:06:32 IST 2005 TRACE: <– StringUtils.java:738 com.mysql.jdbc.StringUtils.startsWithIgnoreCase(..) returning true
    Mon Jun 13 15:06:32 IST 2005 TRACE: <– StringUtils.java:722 com.mysql.jdbc.StringUtils.startsWithIgnoreCase(..) returning true
    Mon Jun 13 15:06:32 IST 2005 TRACE: <– NonRegisteringDriver.java:339 com.mysql.jdbc.NonRegisteringDriver.parseURL(..) returning {HOST=localhost:3306, user=root, password=sanjay123, DBNAME= mysql}
    ————— nested within: ——————
    javax.management.RuntimeOperationsException: RuntimeException thrown by the invoke method of the Dynamic MBean
    at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
    at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
    at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:920)
    at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:470)
    at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:198)
    at $Proxy9.addDeployment(Unknown Source)
    at weblogic.management.internal.DynamicMBeanImpl.updateDeployments(DynamicMBeanImpl.java:1720)
    at weblogic.management.internal.DynamicMBeanImpl.setAttribute(DynamicMBeanImpl.java:1020)
    at weblogic.management.internal.ConfigurationMBeanImpl.setAttribute(ConfigurationMBeanImpl.java:341)
    at com.sun.management.jmx.MBeanServerImpl.setAttribute(MBeanServerImpl.java:1356)
    at com.sun.management.jmx.MBeanServerImpl.setAttribute(MBeanServerImpl.java:1331)
    at weblogic.management.internal.RemoteMBeanServerImpl.setAttribute(RemoteMBeanServerImpl.java:866)
    at weblogic.management.internal.MBeanProxy.setAttribute(MBeanProxy.java:324)
    at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:193)
    at $Proxy80.setTargets(Unknown Source)
    at java.lang.reflect.Method.invoke(Native Method)
    at weblogic.management.console.info.FilteredMBeanAttribute.doSet(FilteredMBeanAttribute.java:92)
    at weblogic.management.console.actions.mbean.DoEditMBeanAction.perform(DoEditMBeanAction.java:146)
    at weblogic.management.console.actions.internal.ActionServlet.doAction(ActionServlet.java:171)
    at weblogic.management.console.actions.internal.ActionServlet.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$ServletInvocationAction.run(ServletStubImpl.java:945)
    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:332)
    at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:242)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:5363)
    at weblogic.security.service.SecurityServiceManager.runAs(SecurityServiceManager.java:721)
    at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3043)
    at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2466)
    at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:152)
    at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:133)

    I think weblogic7 doesnot support My Sql server??

    regards,
    ramu

    June 13, 2005 at 10:10 am #230952 Reply

    Riyad Kalla
    Member

    Ramu,
    I really don’t know, you can try googling for the problem?

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: connection pooling with mysql server

You must be logged in to post in the forum log in