Connect to a SQL Database

by AntoniMG » Wed, 08 Jul 2009 01:02:43 GMT


Sponsored Links
 Hi,

Im triying to connect to a SQL Database with Android, this is my code:

package com.example.conversor;
import java.sql.*;

import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;

[...]

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (Exception e) {
e.printStackTrace();
}


try {
DBConnSQL = DriverManager.getConnection("jdbc:sqlserver://zeus:
1433;DatabaseName=dsnew;","sa","sapass");
} catch (Exception e)
{
e.printStackTrace();
}

And this is what i get:

07-07 11:16:27.450: ERROR/jdwp(1597): Failed sending reply to
debugger: Broken pipe
07-07 11:16:29.832: ERROR/dalvikvm(1605): Could not find class
'javax.sql.XAConnection', referenced from method
com.microsoft.sqlserver.jdbc.SQLServerConnection.close
07-07 11:16:29.931: ERROR/AndroidRuntime(1605): Uncaught handler:
thread main exiting due to uncaught exception
07-07 11:16:29.983: ERROR/AndroidRuntime(1605): java.lang.VerifyError:
com.microsoft.sqlserver.jdbc.SQLServerConnection
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
java.sql.DriverManager.getConnection(DriverManager.java:192)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
java.sql.DriverManager.getConnection(DriverManager.java:228)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
com.example.conversor.ConversorAct.onCreate(ConversorAct.java:39)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:
1123)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
android.app.ActivityThread.performLaunchActivity(ActivityThread.java:
2231)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:
2284)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
android.app.ActivityThread.access$1800(ActivityThread.java:112)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
android.app.ActivityThread$H.handleMessage(ActivityThread.java:1692)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
android.os.Handler.dispatchMessage(Handler.java:99)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
android.os.Looper.loop(Looper.java:123)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
android.app.ActivityThread.main(ActivityThread.java:3948)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
java.lang.reflect.Method.invokeNative(Native Method)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
java.lang.reflect.Method.invoke(Method.java:521)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run
(ZygoteInit.java:782)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:540)
07-07 11:16:29.983: ERROR/AndroidRuntime(1605):     at
dalvik.system.NativeStart.main(Native Method)



SQL Server is correctly installaed and configured, and receiving
Querys from other app.

Thanks.




--~--~---------~--~----~------------~-------~--~----~



Connect to a SQL Database

by Charlie Collins » Wed, 08 Jul 2009 04:06:08 GMT


 n general you don't want to do that - connect directly to your SQL
server from Android. If your Android device is on the same subnet,
and you configure host resolution and port access, you *might* be able
to do that, I have never really thought to try, but it's certainly not
the normal path.

Normally, you will want a server side API, like REST or such, that you
can call from Android using HTTP or something. That way your device
can connect to your server side API and it doesn't need to know
anything about it being a SQLServer (the abstraction is at a different
level), and it will work regardless of whether or not you are on the
same subnet. Have a look at a REST implementation for your favorite
server side language (Jersey for Java, whatever for .net, etc) and
create a simple server side for your Android app to connect to, and
try that.

On Jul 7, 7:18am, AntoniMG <tonio...@gmail.com> wrote:
--~--~---------~--~----~------------~-------~--~----~


Sponsored Links


Other Threads

1. developing input hardware device for Android

Hi,
I'm a total newbie to developing for Android and I could be in over my
head for this but I'm a fast learner with programming languages so I
thought I'd give it a shot.   As for the hardware part, that'll be
more difficult.

I'm a big fan of the NESOID app for Android and every time I play I
keep thinking of how it would be great to develop a controller for the
android so you get better gameplay than using the keyboard.  (plus I
feel like I'm going to wear out those specific keys on the keyboard
that I keep repeatedly using to play)

So my question is,  how would I go about this?  What kind of hardware
should i get?  I assume this controller would plug into the USB.  In
my mind it seems simple enough.  Each button of the controller would
correspond the pressing a letter on the keyboard.  So this controller
would work on multiple games that use the keyboard,  like Doom for
Android, Kidd GBC, Alien {*filter*} Bath, etc..

Right now I have this as the common control settings.
Up = 1,  Down = A, Left = Q , Right = W
B = O, A = P, Select = Del, Start = Return

So basically the input into my G1 from the controller would mimic
pressing these letters.  Maybe with an App you would also able to
changes these settings.

since I don't know if I can upload pictures to these forums, here's a
crappy ascii drawing of what the controller would look like.

               --------------------------------
               |                                     |
               |                                     |
-----------               G1                    --------------
|               |                                    |               |
|    U        |                                    |   X   Y     |
|  L   R     -------------------------------   B   A      |     --->
slides open this way so the USB can be plugged in.
|    D                    select  start                       |
----------------------------------------------------------

thanks!


--~--~---------~--~----~------------~-------~--~----~

2. filled database doesn't appear in listview

Hello,

I have done several tutorials and tried to read everything carefully,
but I still can't fix my problem.
I have a simple database that works. I can read from the database
successfully by printing some rows to the catlog:


Cursor NumbersCursor = db.getNumbers();
startManagingCursor(NumbersCursor);

Log.d("ColCount ",new Integer(NumbersCursor.getColumnCount()).toString
());
Log.d("Columns  ", arrayToString(NumbersCursor.getColumnNames(),","));
while(NumbersCursor.moveToNext()) {
        Log.d("---------------","---------------");
        Log.d("CursorPosition ",new Integer(NumbersCursor.getPosition
()).toString());
        Log.d("title",NumbersCursor.getString(1));
        Log.d("number",NumbersCursor.getString(2));
        Log.d("---------------","---------------");
}
NumbersCursor.moveToPosition(-1);





Now since this works I want to show the data also on the device:

String[] from = new String[]{"title"};
int[] to = new int[]{android.R.id.text1};

ListAdapter adapter =
                    new SimpleCursorAdapter(
                                this,
                                android.R.layout.simple_list_item_1,
                                NumbersCursor,
                                from,
                                to);

setListAdapter(adapter);




But I always receive the "no data" screen on the device.
Does anyone know what I did wrong ?


--~--~---------~--~----~------------~-------~--~----~

3. Post Only Twitter client -- POT alpha release.

4. TextView Link to Android Settings

5. Anyone know how to build the gsptest?

6. How to write .jpg/.png file to gallery in Android

7. What should I do if I change the framework code in Android?