notepad as backend database
hello gentle man,
i used notepad as back end data base,i created csvdsn for that.
type 1 jdbc driiver.
the code i written is
<code>
import java.sql.*;
import java.io.*;
import sun.jdbc.odbc.*;
class NotePadBackEnd {
public static void main(String args[]){
int i=0;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:csvdsn" ,"","");
String vsql="insert into csvdsn values(?,?)";
PreparedStatement pstmt=con.prepareStatement(vsql);
pstmt.setInt(1,01);
pstmt.setString(2,"first");
i=pstmt.executeUpdate();
}catch(Exception e){e.printStackTrace();}
if(i==1)
System.out.println("Record inserted");
else
System.out.println("Record is not inserted");
}
}
</code>
the error i am getting is
microsoft jetty database driver not loaded.
for loading driverclass i used rt.jar file,eventhough automatically comes in jre, i copied and set classpath for that. but error is not solved.
what might be the reason?could plz explain me , how to solve this problem?