File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes problem in insering data in msaccess thru jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "problem in insering data in msaccess thru jdbc" Watch "problem in insering data in msaccess thru jdbc" New topic
Author

problem in insering data in msaccess thru jdbc

sukhesh raturi
Greenhorn

Joined: Jun 05, 2001
Posts: 1
friends when i use to insert data in database using execute update there is no problem ,but when i used prepared statement
to insert the same data in ms access its not working.Its funny that the programme is running on sql server without any problem
here is the code,please sort it out
few lines of code....

try
{
Connection con1=DriverManager.getConnection("jdbc dbc:sraturi");
PreparedStatement pst=con1.prepareStatement("INSERT INTO sr values(?,?,?)");
System.out.println("before update");
pst.setString(1,args[0]);
pst.setInt(2,Integer.parseInt(args[1]));
pst.setInt(3,Integer.parseInt(args[2]));

System.out.print("ok");
int r =pst.executeUpdate();
System.out.print("update completed" + r );

}
catch (Exception e)
{
System.out.println(" ");
}
}
}
thanx in advance
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem in insering data in msaccess thru jdbc