java.lang.ClassNotFoundException

Question

I've installed MaxDB in my local machine and I'm trying to make a connection to it using Java.

And I'm getting this error when running :

Exception in thread "main" java.lang.ClassNotFoundException: com.sap.dbtech.jdbc.DriverSapDB

at java.net.URLClassLoader$1.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClassInternal(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at sap.maxdb.Hello.main(Hello.java:15)

This is the code I'm using :

package sap.maxdb;

import java.sql.*;

public class Hello
{
public static void main(String[] args) throws ClassNotFoundException, SQLException
{
String username = "DBM";
String password = "azerty";
String dbname = "SAPDB";

Class.forName ("com.sap.dbtech.jdbc.DriverSapDB");
String url = "jdbc:sapdb://" + dbname;

Connection connection = DriverManager.getConnection (url, username, password);
Statement stmt = connection.createStatement ();
ResultSet resultSet = stmt.executeQuery ("SELECT * FROM HOTEL.CUSTOMER");
resultSet.next ();
String hello = resultSet.getString (1);
System.out.println (hello);

resultSet.close ();
stmt.close();
connection.close ();
}
}

I did like they said in their website :

set CLASSPATH=%CLASSPATH%;C:\Program Files\sdb\programs\runtime\jar\sapdbc.jar

But I get always the same error.

I know that I'm missing something but can't find it °!°

Waiting for your help.

Thanks.

try set CLASSPATH="%CLASSPATH%;C:\Program Files\sdb\programs\runtime\jar\sapdbc.jar" — Buhake Sindi
– Buhake Sindi, Commented Jun 28, 2011 at 15:25
How are you running this? From an IDE, from the command line, from a script? A description of what you are doing, or better yet, the actual command/script you are running will help. — wolfcastle
– wolfcastle, Commented Jun 28, 2011 at 16:38

f4lco · Accepted Answer · 2011-06-28 15:59:30Z

1

What does "install" mean? Basically, the db server must be installed and running.

Step two is to add the driver (which you can find under C:\Program Files\sdb\programs\runtime\jar\sapdbc.jar, assuming this applies to your installation too) to the build path of your project. If the driver class cannot be found, it'll raise a ClassNotFoundException as you experienced.

You don't mention which IDE you are using, but try to set your project buildpath from the context menu.

answered Jun 28, 2011 at 15:59

f4lco

3,8345 gold badges30 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

f4lco Over a year ago

Then right click on the project, Build Path -> Configure Build Path -> Libraries tab -> Add External JARs. Select the sapdbc.jar from the file browser and click OK. Build path problems should be resolved now.

Olaf · Accepted Answer · 2011-06-28 15:55:59Z

1

Try adding the following code to make sure that your application picks up the CLASSPATH that you specified:

    Map<String, String> env = System.getenv();
    for (String envName : env.keySet()) {
        System.out.format("%s=%s%n", envName, env.get(envName));
    }

answered Jun 28, 2011 at 15:55

Olaf

6,2991 gold badge21 silver badges38 bronze badges

Comments

Igor · Accepted Answer · 2011-06-29 00:03:59Z

0

Copy the driver's jar file to the 'lib' folder of the server. Then restart the server.

answered Jun 29, 2011 at 0:03

Igor

1

Collectives™ on Stack Overflow

java.lang.ClassNotFoundException

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related