Hi!
I get this error when Im trying to connect to a table in the same directory as the tinySQL.jar file:
Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:tinySQL
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.main(test.java:13)
Here is the code I'm using:
import java.sql.*;
public class test {
public static void main(String[] args) throws SQLException {
Connection conn = null;
try {
Class.forName("com.sqlmagic.tinysql.dbfFileDriver");
conn = DriverManager.getConnection("jdbc:tinySQL");
} catch (java.lang.ClassNotFoundException ex1) {
ex1.printStackTrace();
}
try {
Statement st = null;
ResultSet rs = null;
st = conn.createStatement();
rs = st.executeQuery("SELECT * FROM test");
while (rs.next()) {
int id = rs.getInt("id");
System.out.println(id);
}
rs.close();
} catch (SQLException ex2) {
ex2.printStackTrace();
}
}
}
I would really appreciate some help with this.
Thank you
