Hi
I'm trying the hxtt JDBC driver for MS access database.
I have my java code in a Linux machine, and I read/write data in a database on winxp machine.
I downloaded the jar (Evaluation trial) and I can do select queries but when I try to do insert, I get this error:
java.sql.SQLException: java.lang.NullPointerException
at com.hxtt.sql.access.aw.dc(Unknown Source)
at com.hxtt.sql.access.bc.a(Unknown Source)
at com.hxtt.sql.x.a(Unknown Source)
at com.hxtt.sql.b6.for(Unknown Source)
at com.hxtt.sql.b0.int(Unknown Source)
at com.hxtt.sql.dn.a(Unknown Source)
at com.hxtt.sql.bs.a(Unknown Source)
at com.hxtt.sql.aj.a(Unknown Source)
at com.hxtt.sql.aj.a(Unknown Source)
at com.hxtt.sql.aj.a(Unknown Source)
at com.hxtt.sql.aj.executeUpdate(Unknown Source)
at hxtt.test(hxtt.java:37)
at hxtt.main(hxtt.java:10)
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.bs.a(Unknown Source)
at com.hxtt.sql.aj.a(Unknown Source)
at com.hxtt.sql.aj.a(Unknown Source)
at com.hxtt.sql.aj.a(Unknown Source)
at com.hxtt.sql.aj.executeUpdate(Unknown Source)
at hxtt.test(hxtt.java:37)
at hxtt.main(hxtt.java:10)
What is the problem?
my java code is:
...
Class.forName("com.hxtt.sql.access.AccessDriver");
Connection con = DriverManager.getConnection( "jdbc:access:smb://user:pwd@ip_winxp/dir1/db1.mdb" ,"","");
Statement s = con.createStatement();
s.execute("select name from table_A");
ResultSet rs = s.getResultSet();
while(rs.next()){
// ALL IS OK
System.out.printlnprint(rs.getString(1));
}
//EXCEPTION!
s.executeUpdate("insert into table_A (name) values ('Andrea')"));
....
thanks
Andrea
|
>I have my java code in a Linux machine, and I read/write data in a database
> on winxp machine.
If there is a MS Access application do concurrent data modification, you need lockType=ACCESS connection property.
//EXCEPTION!
>s.executeUpdate("insert into table_A (name) values ('Andrea')"));
Sorry. A new feature resulted that bug. We will upload the fix version in 2 hours.
|
many thanks for the info about the connection property..and for the fix!
I will try the fix version and I will inform you about the result
Andrea
|
|
Now you can download the latest fix version.
|
it works!
many thanks
Andrea
|
Main
webmaster@hxtt.com