I'm trying to Make a connection android studio to the database in SQL server 2014 , But this error appears :
java.sql.SQLException: Invalid object name 'tablename'
I use the :jtds 1.3.1
and :sqljdbc4-2.0
I connect a local network .
-
Do you literally mean "from Android studio", or from an Android app? If an app, it is not recommended to connect to a SQL database from a mobile appOneCricketeer– OneCricketeer2019-02-04 17:59:31 +00:00Commented Feb 4, 2019 at 17:59
-
i,m new programming android , i use Android studio for building android app , when i run app , The error appears ,I do not know the problemmohammd qandeel– mohammd qandeel2019-02-04 18:05:23 +00:00Commented Feb 4, 2019 at 18:05
-
Okay. My point still stands. Do not use SQL Server drivers within your Android app. Use a webservice. Expose a REST API to your database over your network -- stackoverflow.com/questions/15853367/…OneCricketeer– OneCricketeer2019-02-04 19:15:50 +00:00Commented Feb 4, 2019 at 19:15
Add a comment
|
1 Answer
The SQL statement is failing because you are not using the correct connection URL format for jTDS so you are not actually connecting to the database specified by the String variable serverDb.
You are trying to use a connection URL parameter named database that jTDS does not recognize:
String serverDb = "myDb";
String connUrl = "jdbc:jtds:sqlserver://localhost:49242;database=" + serverDb;
try (Connection conn = DriverManager.getConnection(connUrl, myUid, myPwd)) {
System.out.println(conn.getCatalog()); // prints: master
} catch (Exception e) {
e.printStackTrace(System.err);
}
Instead, you should be using the server:port/database format described in the documentation
String serverDb = "myDb";
String connUrl = "jdbc:jtds:sqlserver://localhost:49242/" + serverDb;
try (Connection conn = DriverManager.getConnection(connUrl, myUid, myPwd)) {
System.out.println(conn.getCatalog()); // prints: myDb
} catch (Exception e) {
e.printStackTrace(System.err);
}
