JDBC connection in Android

Question

Is there anyone who tried JDBC connection in android because in Android 2.3 JDBC is supported.

I have to connect with Mysql without web service.

I have made application but it gives me error

public class MysqlConnect extends Activity{
@Override
public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);
setContentView(R.layout.main);
System.out.println("MySQL Connect Example.");
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";
String dbName = "jdbctutorial";
String driver = "com.mysql.jdbc.Driver";
String userName = "root"; 
String password = "root";
try {
  Class.forName(driver).newInstance();
  conn = DriverManager.getConnection(url+dbName,userName,password);
  System.out.println("Connected to the database");
  conn.close();
  System.out.println("Disconnected from database");
} catch (Exception e) {
  e.printStackTrace();
}
}
}

i am getting error in getConnection. error is like java.lang.VerifyError : com.mysql.jdbc.MysqlIO

Thanks in advance.

can you post the stack trace for this ?$ – njzk2 Apr 25 '12 at 14:05 — njzk2, Apr 25 '12 at 14:05
read my answer ant you shall be free of all the pain. – Behnam Apr 28 '14 at 12:12 — Behnam, Apr 28 '14 at 12:12

score 4 · Answer 1 · answered Jul 05 '11 at 05:25

4

I have successfully connected to MySQL, Oracle and SQL Server directly from an Android device using JDBC and the regular type 4 drivers used for desktop Java applications for the respective databases.

Just search for a desktop JDBC sample. The same code works without any modifications on Android. Make sure you add the .jar file of the driver to the project in Eclipse. The compiler will automatically convert the .jar driver into Dalvik compatible package.

answered Jul 05 '11 at 05:25

Monstieur

7,992
10
51
77

3

hi, can you please explain in brief. coz so many people trying to do this, but not get successful result. if possible please edit your answer with some code snapshot, which jars required to build etc... – milind Sep 22 '11 at 13:14
2

http://pastebin.com/K42jvLJu Just add the respective Type 4 driver such as ojdbc14.jar to the project as an external JAR. – Monstieur Dec 06 '11 at 10:47
I still have the same VerifyError. Using ADT v22 and android platform 19. I included ojdbc14 (tried both with and without jtds.jar). 3 days of pain now... any help @Kurian – Dino Velić Nov 28 '13 at 13:34

score 3 · Answer 2 · edited May 23 '17 at 12:15

3

The VerifyError probably happens because of wrong class file signature.

Check here:

JDBC was included in previous releases as well - the key issue is to include the proper driver class for your database and make sure it can work with the Android runtime.

edited May 23 '17 at 12:15

Community

1
1

answered Dec 15 '10 at 07:38

Sebastian Roth

11,344
14
61
110

Hi, Thanks for your reply. I have already added mysql-connector-java in my application. Is there any example which is successfully connect with mysql through jdbc ? – djk Dec 15 '10 at 09:51
Have you run this jar file thrugh the "dx" program? – Sebastian Roth Dec 15 '10 at 09:54
1

dx is not required. When you add an external jar it's done automatically. – Monstieur Dec 06 '11 at 10:31

score 1 · Answer 3 · answered Sep 17 '13 at 07:20

I had the same issue, two things solved my problem:

You must remember to put your JDBC connection code in an AsyncTask, other wise you will BURN BURN BURN!
Do NOT mistake "INTERNET" permission for the "uses INTERNET" permission. You need the latter to perform JDBC.

If none of above solved your problem, check the logcat line starting with "caused by:" in your warning lines. Googling that line gets you close to finding a solution.

score 0 · Answer 4 · answered Jul 04 '13 at 08:33

0

I had a similar problem, try to run connection code from a new thread not main and change the localhost server address.

answered Jul 04 '13 at 08:33

plewand

156
1
9

score 0 · Answer 5 · answered Jun 23 '18 at 08:23

I've got the same error.

Just adding this line to your gradle dependency resolves the error.

compile group: 'mysql', name: 'mysql-connector-java', version: '5.1.44'

And you can change the version according to your need.

After adding this, gradle sync will be taking care of everything, you just have to connect to DB in the same way as you do in simple java jdbc program. I've developed my app using the android studio.

JDBC connection in Android

5 Answers5

Linked