How to connect to sql server using JTDS driver in Android

Question

I am new to android .. I want to connect sql server using JTDS driver. can someone tell me ..

thnx in advance ...

Answer 1

Getting "ClassNotFoundException" error when using JTDS on ANDROID for direct access to SQLSERVER?

After 3 hours, RND to find a solution for the same error above. I didn’t get an error in the code, I also have a library called “jtds-1.3.0” that correctly continues debugging the code, still getting the same error again and again.

{
 Class.forName("net.sourceforge.jtds.jdbc.Driver");

 Connection conn = DriverManager.getConnection(
 db_connect_string, db_userid, db_password);
}

I tried an alternative by changing the line

...... Class.forName("net.sourceforge.jtds.jdbc.Driver");

to

...... (new Driver()).getClass();

...... (new Driver())

, jtds-1.3.0, , jtds-1.2.5 ; .

, . ​​ -, .

Answer 2

, - jTDS . , :

http://www.java-tips.org/other-api-tips/jdbc/how-to-connect-microsoft-sql-server-using-jdbc-3.html

import java.sql.*;

public class testConnection
{
    public static void main(String[] args) 
    {
        DB db = new DB();
        db.dbConnect("jdbc:jtds:sqlserver://localhost:1433/tempdb","sa","");
    }
}

class DB
{
    public DB() {}

    public voidn dbConnect(String db_connect_string, String db_userid, String db_password)
    {
        try
        {
            Class.forName("net.sourceforge.jtds.jdbc.Driver");
            Connection conn = DriverManager.getConnection(
            db_connect_string, db_userid, db_password);
            System.out.println("connected");
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
};

EDIT:
ClassNotFoundException, . AndroidManifest.xml, , :

<manifest xmlns:android="http://schemas.android.com/apk/res/android"
      package="com.ezee.app"  
/*...*/
<activity android:name=".connect12" 

, your_project_folder/src/com/ezee/app/connect12 ( , )

Answer 3

, Android SQL Server, 10.0.2.2 "localhost" "127.0.0.1", Android .

SQL Server.

Answer 4

Exception in thread "main" java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
    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.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at com.test.objectref.GroupBy.main(GroupBy.java:12)

Jtds lib.