Connect to SQL Server in Android

Question

I have already downloaded jtds and also jdbc and even put under my libs I have tried the com.microsoft.sqlserver.jdbc.SQLServerDriver and also net.sourceforge.jtds.jdbc.Driver still not working. I also added both in my dependencies in my build.gradle but still not working and I even gave permission to the Android manifest for it

Here is my build.gradle file for the dependencies:

dependencies {

    implementation 'androidx.appcompat:appcompat:1.6.1'
    implementation 'com.google.android.material:material:1.5.0'
    implementation 'androidx.constraintlayout:constraintlayout:2.1.4'
    testImplementation 'junit:junit:4.13.2'
    androidTestImplementation 'androidx.test.ext:junit:1.1.5'
    androidTestImplementation 'androidx.test.espresso:espresso-core:3.5.1'
    //implementation 'com.microsoft.sqlserver:mssql-jdbc:9.4.0.jre8'
    //implementation 'net.sourceforge.jtds:jtds:1.3.1'
    implementation files('libs/jtds-1.3.1.jar')
    implementation 'com.microsoft.sqlserver:mssql-jdbc:12.2.0.jre8'
}

Here is the AndroidManifest.xml:

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    package="com.example.canteenmeal">

    <uses-permission android:name="android.permission.NFC" />
    <uses-permission android:name="android.permission.INTERNET" />
    <uses-permission android:name="android.permission.ACCESS_NETWORK_STATE"/>
    <uses-feature android:name="android.hardware.nfc" />

    <application
        android:allowBackup="true"
        android:dataExtractionRules="@xml/data_extraction_rules"
        android:fullBackupContent="@xml/backup_rules"
        android:icon="@mipmap/ic_launcher"
        android:label="@string/app_name"
        android:roundIcon="@mipmap/ic_launcher_round"
        android:supportsRtl="true"
        android:theme="@style/Theme.CanteenMeal"
        tools:targetApi="31">

        <activity
            android:name=".MainActivity"
            android:theme="@style/Theme.AppCompat.Light.NoActionBar"
            android:exported="true">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />
                <category android:name="android.intent.category.LAUNCHER" />
                <action android:name="android.nfc.action.TECH_DISCOVERED" />
            </intent-filter>
        </activity>

        <activity
            android:name=".AdminActivity"
            android:exported="true">
            <!-- Define any necessary intent filters or other attributes for AdminActivity -->
        </activity>

        <activity
            android:name=".CanteenEmployeeActivity"
            android:exported="true">
            <!-- Define any necessary intent filters or other attributes for CanteenEmployeeActivity -->
        </activity>

        <!-- Other manifest entries -->

    </application>
</manifest>

This is my DatabaseHelper.java:

public class DatabaseHelper {

    private static final String DATABASE_URL = "jdbc:sqlserver://10.1.32.111:1433/PROD";
    private static final String DATABASE_USERNAME = "Sexy";
    private static final String DATABASE_PASSWORD = "sexy";

    // Login table constants
    private static final String TABLE_NAME = "users";
    private static final String COLUMN_USERNAME = "username";
    private static final String COLUMN_PASSWORD = "password";

    // Employee table constants
    private static final String TABLE_EMPLOYEE = "employee";
    private static final String COLUMN_EMPLOYEE_VISA = "visa";
    private static final String COLUMN_EMPLOYEE_NAME = "employeename";
    private static final String COLUMN_EMPLOYEE_BADGE_NUMBER = "badgenumber";

    // Report table constants
    private static final String TABLE_REPORT = "reports";
    private static final String COLUMN_REPORT_EMPLOYEE_VISA = "visa";
    private static final String COLUMN_REPORT_EMPLOYEE_NAME = "employeename";
    private static final String COLUMN_REPORT_EMPLOYEE_BADGE_NUMBER = "badgenumber";
    private static final String COLUMN_COLOUR = "Colour";
    private static final String COLUMN_DATE_TIME = "Date_Time";

    private Connection connection;
    private Context context;

    public DatabaseHelper(Context context) {
        this.context= context;

        try {
            // Load the SQL Server JDBC driver
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            // Connect to the database
            connection = DriverManager.getConnection(DATABASE_URL, DATABASE_USERNAME, DATABASE_PASSWORD);
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
    }

I am sure that it has something has to do with the getConnection where its not working can someone help me please

Here are the details of the SQL server

Answer 1

I have found the solution where I had to use strict mode in the databasehelper here is the updated code:

public DatabaseHelper(Context context) {
    this.context= context;
    StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
    StrictMode.setThreadPolicy(policy);

    try {
        // Load the SQL Server JDBC driver
        Class.forName("net.sourceforge.jtds.jdbc.Driver");
        // Connect to the database
        connection = DriverManager.getConnection(DATABASE_URL,DATABASE_USERNAME,DATABASE_PASSWORD);
    } catch (ClassNotFoundException | SQLException e) {
        e.printStackTrace();
    }
}