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:

Java Code:
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 = [HTML][/HTML]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 :)