java.lang.ClassNotFoundException exception

Question

I am doing SqlServer2008 r2 connectivity with android.

My code is as follows:

public class MainActivity extends Activity {


    String url="jdbc:sqlserver://localhost;instance=14GRAFICALI\\MSSQLSERVER2008;databaseName=AndroidDB;integrated security=true";

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);


        TextView tvData=(TextView)findViewById(R.id.tvSelectedData);

        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
            Connection conn =DriverManager.getConnection(url);                   

            System.out.println("connected");
            Statement statement=conn.createStatement();
            ResultSet resultSet=statement.executeQuery("select * from AndroidDB");
            while(resultSet.next()){
                tvData.setText(" Data1 : "+resultSet.getString(1)+"  Data 2 : "+resultSet.getNString(2));
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
    }

This code is not working and giving me error on line:

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();

Error:

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

But when i checked this path, file was there with above path.

Have a look at it:

enter image description here

What can be the problem?

Please help me.

EDIT

Javabuildpath: enter image description here

Libs:

enter image description here

can you post a screen of java build path at your project properties? — Onur A., Sep 06 '13 at 10:31
@SunilMishra sir but there is no webservice involved in it? still its ok? — C Sharper, Sep 06 '13 at 10:37
add your all the libraries in libs folder and then import them in your project. — Mahaveer Muttha, Sep 06 '13 at 10:38
@MahaveerMuttha plz see my libs folder, how can i import it now? — C Sharper, Sep 06 '13 at 10:41
possibly your jar doesn't contain that class, double check it, and btw localhost should be 10.0.2.2 — Onur A., Sep 06 '13 at 10:42
Android != Java, a Java driver won't work unless recompiled specifically for Android. — Mark Rotteveel, Sep 06 '13 at 10:43
http://stackoverflow.com/questions/18672012/class-not-found-although-particular-jar-is-added-in-project?answertab=active#tab-top — C Sharper, Jan 16 '14 at 05:16

Sajal Dutta · Answer 1 · 2013-09-06T10:43:44.860

1

Make sure that the jar which contains SQLServerDriver class in your classpath as explained here.

If you are using Eclipse, right click on your project, then Java Build Path, under Libraries tab, check if the jar is there and no other version of the same jar exists.

edited Sep 06 '13 at 10:43

answered Sep 06 '13 at 10:37

Sajal Dutta

18,272
11
52
74

score 1 · Answer 2 · answered Sep 06 '13 at 10:42

1

According to this thread on the microsoft msdn forum using a different JDBC driver should work. I haven't tested it myself though.

answered Sep 06 '13 at 10:42

Ridcully

23,362
7
71
86

score 1 · Answer 3 · answered Sep 06 '13 at 10:48

The CLASSPATH variable is the search string that Java Virtual Machine (JVM) uses to locate the JDBC drivers on your computer. If the drivers are not listed in your CLASSPATH variable, you receive the following error message when you try to load the driver: java.lang.ClassNotFoundException: com/microsoft/jdbc/sqlserver/SQLServerDriver

The JDBC driver is not part of the Java SDK. If you want to use it, you must set the classpath to include the sqljdbc.jar file or the sqljdbc4.jar file. If the classpath is missing an entry for sqljdbc.jar or sqljdbc4.jar, your application will throw the common "Class not found" exception.

The sqljdbc.jar file and sqljdbc4.jar file are installed in the following location:

<installation directory>\sqljdbc_<version>\<language>\sqljdbc.jar
<installation directory>\sqljdbc_<version>\<language>\sqljdbc4.jar

The following is an example of the CLASSPATH statement that is used for a Windows application:

CLASSPATH =.;C:\Program Files\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\sqljdbc.jar

The following is an example of the CLASSPATH statement that is used for a Unix/Linux application:

CLASSPATH =.:/home/usr1/mssqlserverjdbc/Driver/sqljdbc_4.0/enu/sqljdbc.jar

You must make sure that the CLASSPATH statement contains only one Microsoft JDBC Driver for SQL Server, such as either sqljdbc.jar or sqljdbc4.jar.

score 0 · Accepted Answer · edited May 23 '17 at 12:13

0

There are Few Steps That need to be foolwed in case when we are connecting Android to directly a SQLServer.

I have mentioned each and every detailed steps in my answer over here:

Class not found although particular jar is added in project (android to sqlserver without webservice)

Please follow the stages and i am sure you will overcome all the errors.

edited May 23 '17 at 12:13

Community

1
1

answered Jan 16 '14 at 05:23

C Sharper

8,284
26
88
151

java.lang.ClassNotFoundException exception

4 Answers4