android app unable to connect to the hsqldb server
- by Chinta
I am trying to connect my android app to the hsql db server.
Server runs on computer-1.
I can connect to the db server from local machine through java as well as Db-visualizer.
I can connect to the db server from another computer(computer-2) using Db-visualizer with comouter-1 ip address.
Now trying to connect from my app in Nexus 7 the same way I was connecting from computer-2. I am getting "No Suitable Driver" error. Below is the log.
11-02 12:01:41.235: W/System.err(9803): connection string <jdbc:hsqldb:hsql://192.168.2.6:9001/qBank>
11-02 12:01:41.235: W/System.err(9803): user id string <SA>
11-02 12:01:41.235: W/System.err(9803): password string <>
11-02 12:01:41.235: W/System.err(9803): ERROR: failed to get connection.
11-02 12:01:41.235: W/System.err(9803): java.sql.SQLException: No suitable driver
11-02 12:01:41.235: W/System.err(9803): at java.sql.DriverManager.getConnection(DriverManager.java:186)
11-02 12:01:41.235: W/System.err(9803): at java.sql.DriverManager.getConnection(DriverManager.java:213)
11-02 12:01:41.235: W/System.err(9803): at com.scan.util.GatherData.getConnection(GatherData.java:135)