Android sql database connection

Question

I try to connect from eclipse emulator android to an sql server using this code:

String driver = "net.sourceforge.jtds.jdbc.Driver";
Class.forName(driver).newInstance();
String connString = "jdbc:jtds:sqlserver://83.212.240.15:1521/hua;encrypt=fasle;user=xxxxxx;password=xxx;instance=SQLEXPRESS;";
String username = "xxxxx";
String password = "xxxxx";
conn = DriverManager.getConnection(connString,username,password);
Statement stmt = conn.createStatement();
ResultSet reset = stmt.executeQuery("insert into picture values('hi');");
conn.close();

but i have the following error

Service com.android.exchange.ExchangeService has leaked ServiceConnection com.android.emailcommon.service.ServiceProxy$ProxyConnection@40cebcd0 that was originally bound here
android.app.ServiceConnectionLeaked: Service com.android.exchange.ExchangeService has leaked ServiceConnection com.android.emailcommon.service.ServiceProxy$ProxyConnection@40d64ec0 that was originally bound here
at android.app.LoadedApk$ServiceDispatcher.(LoadedApk.java:969)

I have put the permission for internet and i also i have put the jtds-1.3.0.jar in lib folder.Any ideas?

Thanks in adnvanced

Please copy and paste the logcat. The image is not readable on my end. — Code-Apprentice, Jun 16 '13 at 17:59
possible duplicate of [Various android logcat errors](http://stackoverflow.com/questions/13765122/various-android-logcat-errors) — Code-Apprentice, Jun 16 '13 at 18:18
I doubt it's the reason for your error, but `encrypt=fasle` does not look right. — Joachim Isaksson, Jun 16 '13 at 18:21
Just a blind dumb guess without seeing any source, but did you unbind your email service connection in onstop? — Joachim Isaksson, Jun 16 '13 at 18:29

score 0 · Answer 1 · answered Jul 31 '13 at 04:32

0

You get that error because you are using stmt.executeQuery.

stmt.executeQuery expects something in return (that means a result from a SELECT), but you are inserting data, not querying, so you should use stmt.executeUpdate instead

answered Jul 31 '13 at 04:32

Olivier López Ch

61
1
5

Android sql database connection

1 Answers1