Solved

JDBC Driver cannot be loaded

Posted on 2004-09-19
10
1,586 Views
Last Modified: 2008-01-09
I am currently doing an application which includes using stateless session bean, i am using oracle jdeveloper 10g as my IDE, bea weblogic 6.1 as my app server and mysql for database.. i have this code tat connects to the database however when i test my client script, there is this exception

java.sql.SQLException: JDBC driver class cannot be loaded

      at Db.Database.<init>(Database.java:22)

      at Member.MemberEJBBean.addMember(MemberEJBBean.java:23)

      at Member.MemberEJBBean_fow6gt_EOImpl.addMember(MemberEJBBean_fow6gt_EOImpl.java:36)

      at Member.MemberEJBBean_fow6gt_EOImpl_WLSkel.invoke(Unknown Source)

      at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:360)

      at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java:93)

      at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:329)

      at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:22)

      at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:140)

      at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:121)


anyone know y? i have already included the jar file in the library of the IDE
0
Comment
Question by:ginola29
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
10 Comments
 
LVL 9

Expert Comment

by:Venci75
ID: 12099555
What's the code that creates the conenction? Do you call:
Class.forName("oracle.jdbc.driver.OracleDriver");
0
 

Author Comment

by:ginola29
ID: 12099568
private final String driver = "com.mysql.jdbc.Driver";
private final String url = "jdbc:mysql://localhost/dvd";
private final String user = "";
private final String password = "";

/**
 * The constructor attempts to load the jdbc driver class.
 * If failed, the ClassNotFoundException is rethrown as SQLException
 **/
public Database() throws SQLException {
      try {
            Class.forName(driver);
      } catch (ClassNotFoundException ce) {
            throw (new SQLException("JDBC driver class cannot be loaded"));
      }
}
/**
 * Get a new connection.  User must close it after used.
 **/
public Connection getConnection() throws SQLException {
      return DriverManager.getConnection(url, user, password);
}

by the way, i am using mysql...i tik i have to setup a datasource at the weblogic console, but i just can't get it right, anyone can help me with that?
0
 
LVL 92

Expert Comment

by:objects
ID: 12099586
Its not finding your driver class, make sure the jar is available to the WL class loader.
eg. put the jar in <webapp>/WEB-INF/lib
0
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

 

Author Comment

by:ginola29
ID: 12099600
erm..my project doesn't have a web-inf folder, must i just create that folder? just under the folder <webapp>
0
 
LVL 92

Expert Comment

by:objects
ID: 12099614
yes where <webapp> is the folder that you webapplication is in.
0
 

Author Comment

by:ginola29
ID: 12099667
i still got the same error, driver cannot be loaded, must i do some configuration between weblogic server and mysql? can i know hw to if it is a must?
0
 
LVL 92

Accepted Solution

by:
objects earned 125 total points
ID: 12099694
0
 

Author Comment

by:ginola29
ID: 12099737
there are some errors i have encounter

i entered:
name : dvdProject
url: jdbc:mysql://localhost/dvd
driver classname: com.mysql.jdbc.Driver
properties: user=root

the rest all blanks

then i went to the target tab, and tried to deploy it, errors are returned.

weblogic.management.DistributedOperationUpdateException: Error creating connection pool - with nested exception:
[weblogic.management.DeploymentException: Error creating connection pool - with nested exception:
[weblogic.common.ResourceException: Cannot load driver class: com.mysql.jdbc.Driver]]
      at weblogic.management.internal.ConfigurationMBeanImpl.updateConfigMBeans(ConfigurationMBeanImpl.java:518)
      at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:376)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
      at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
      at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:468)
      at weblogic.management.in--------------- nested within: ------------------
weblogic.management.console.utils.SetException: An error occurred while updating Targets-Server on Proxy for mydomain:Name=dvdProject,Type=JDBCConnectionPool - with nested exception:
[java.lang.reflect.InvocationTargetException - with target exception:
[weblogic.management.DistributedManagementException: Distributed Management [1 exceptions]]]
      at weblogic.management.console.actions.mbean.DoEditMBeanAction.perform(DoEditMBeanAction.java:155)
      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.invokeServlet(ServletStubImpl.java:262)
      at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:198)
      at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:2678)
      at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2412)
      at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:140)
      at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:121)
0
 
LVL 92

Expert Comment

by:objects
ID: 12099764
still looks like its not finding your driver class
chechk the jar contains the specified class
0
 

Author Comment

by:ginola29
ID: 12099816
ok i got it solve, the classpath wasnt' set correctly at the right place in the startweblogic.cmd .. thx anyway
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question