JDBC problem, please help
I used the following program to add data to a MS access database table whick has only only simple text fields, F1,F2,F3. But it run out the below error message. Does anybody experiensed this problem?
//***********************
import java.sql.*;
import java.io.*;
public class DBTest
{
public static void main(String[] args)
{
Connection cnn;
Statement stmt;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cnn=DriverManager.getConnection("jdbc:odbc:DB");
System.out.println("Connection Openned:"+cnn.toString());
stmt=cnn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery("select F1,F2,F3 from test");
rs.moveToInsertRow();
rs.updateString("F1","Field one");
rs.insertRow();
rs.close();
stmt.close();
cnn.close();
}
catch(ClassNotFoundException cnfe)
{
System.out.println(cnfe.getMessage());
}
catch(SQLException e)
{
System.out.println(e.getMessage());
}
}
}
//***********************
Connection Openned:sun.jdbc.odbc.JdbcOdbcConnection@3fbdb0
Exception in thread "main" java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcBoundCol.setRowValues(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.updateChar(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.updateString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.updateString(Unknown Source)
at DBTest.main(DBTest.java:19)
