Hi
I am getting the following error ;
java.sql.SQLException: Failed to insert a new record into table wo! For more information, please use SQLException.getNextException().
java.sql.SQLException: Failed to insert new record into table wo because of duplicate key or corrupted index file. For more information, please use SQLException.getNextException().
java.sql.SQLException: Failed to calculate index value for index expression ID
I am using the BDE 5.2.02 and dbase plus 2.163. The insertRow() work fine without an index (.mdx). The java code is as follows
Properties properties = new Properties();
properties.setProperty("versionNumber", "DB2K");
Class.forName("com.hxtt.sql.dbf.DBFDriver").newInstance();
String jdbcConnection = "jdbc:dbf:/D:/dms2000/data/dms";
Connection con = DriverManager.getConnection(jdbcConnection,properties);
int id = 0;
PreparedStatement stmt = con.prepareStatement(
"select * from wo", ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate("reindex all on WO" );
stmt.setString(1,"%");
ResultSet rs = stmt.executeQuery();
rs.next();
rs.moveToInsertRow();
rs.updateString("WO_NUM", "zzzz");
try{
rs.insertRow();
rs.moveToCurrentRow();
}catch(SQLException e) {
System.out.println(e.toString());
System.out.println(e.getNextException().toString());
System.out.println(e.getNextException().getNextException().toString());
}
|
v4.0.014 supports autoincrement type, int type, and timestamp type for dbase 7 and its mdx format. Please download it.
|