Hi,
I get error NO PRIMARY KEY from prs.moveToInsertRow();
Postgres 7.4.2 on with /usr/share/pgsql/pg73b1jdbc3.jar
All packets from the same Suse Standard Enterprise Server 9 CD‘s.
Bellow full test.java source.
Best regards
import java.sql.*;
public class
testas
{
private static Connection pg;
public static void
main(String [] args)
{
try {
Class.forName("org.postgresql.Driver").newInstance();
}
catch (Exception e) {
}
try {
pg = DriverManager.getConnection("jdbc:postgresql://192.168.2.3/db","vidas","");
Statement st = pg.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
st.executeUpdate("CREATE TABLE public.testas (loid integer PRIMARY KEY) WITHOUT OIDS");
ResultSet prs = st.executeQuery("SELECT p.* FROM public.testas p");
//prs.next();
prs.moveToInsertRow();
//System.out.println(prs.getConcurrency());
}
catch (SQLException e) {
System.out.println("err: "+e);
e.printStackTrace();
}
}
}