Android java connecting to SQL server 2005

[natuyk]

Hello to all of you. Im new in this current trend using java and my project was run in eclipse hellios.
I want to connect to sql server 2005. I just make a blank project in eclipse and copy the sample codes here in this forum. when i run it in emulator, the emulator pops up message that Sorry the application AnPOS ( process com.example.anupos) has stopped unexpectedly. Please try again..
here is the code i copy and paste it in mainactivity.java. I already consider the tcpip enable using its port number..I also put in environment variable CLASSPATH and the value is the location of sqljdbc.jar.. I also include in external jar this sqljdbc.jar in the project.

package com.example.anupos;

import java.sql.*;

public class MainActivity  {


  
    public static void main(String[] args) {
        
        // Create a variable for the connection string.
        String connectionUrl = "jdbc:sqlserver://localhost:1057;" +
            "databaseName=PH9011;integratedSecurity=true;";
 
        // Declare the JDBC objects.
        Connection con = null;
        Statement stmt = null;
        ResultSet rs = null;
         
            try {
                // Establish the connection.
                Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
                    con = DriverManager.getConnection(connectionUrl);
             
                    // Create and execute an SQL statement that returns some data.
                    String SQL = "SELECT * FROM CASHIER";
                    stmt = con.createStatement();
                    rs = stmt.executeQuery(SQL);
             
                    // Iterate through the data in the result set and display it.
                    while (rs.next()) {
                        System.out.println(rs.getString(4) + " " + rs.getString(6));
                    }
            }
         
        // Handle any errors that may have occurred.
        catch (Exception e) {
            e.printStackTrace();
        }
 
        finally {
            if (rs != null) try { rs.close(); } catch(Exception e) {}
                if (stmt != null) try { stmt.close(); } catch(Exception e) {}
                if (con != null) try { con.close(); } catch(Exception e) {}
        }
    }
    
    
}

Thank you so much

[viren2727in]

It is not advisable to create MSSQL connection from android, its better to create web service in server and use out put of web service in android.

[natuyk]

Is not advisable to create MSSQL connection from android, its better to create web service in server and use out put of web service in android.

but my manager dont want me to create a web page accessing sql server..He was an android apps like what he saw on registroid.com

[DarrylBurke]

A web service isn't a web page.

db

[natuyk]

A web service isn't a web page.

db

ah..ok i will research on this matter..thank you very much

[natuyk]

A web service isn't a web page.

db

Sir can you give me some hint. i very new with this thing..im only know visual .net. Thank you

[viren2727in]

There is two types of web services available. 1. SOAP (Not Suitable for Mobile Application) 2. REST (also known as RESTfull)

for mobile u have to use REST web services which returns data in text,JSON or XML format.