Redhat7.2+postgresql7.2+jdk1.3.1
다음과같은에러발생
------------------------------------------------------------------
java.lang.NoSuchMethodError: java/sql/Statement.getResultSetConcurrency()I
at org.postgresql.jdbc2.Connection.getResultSet(source file unknown:line
unknown, pc 0x82ee836)
at org.postgresql.core.QueryExecutor.execute(source file unknown:line un
known, pc 0x82e69b9)
at org.postgresql.Connection.ExecSQL(source file unknown:line unknown, p
c 0x82ce604)
at org.postgresql.jdbc2.Statement.execute(source file unknown:line unkno
wn, pc 0x83258aa)
at org.postgresql.jdbc2.Statement.executeUpdate(source file unknown:line
unknown, pc 0x8325622)
at BoardTest.main(BoardTest.java:36)
--------------------------------------------------------------------
source
-------------------------------------------------------------------
try
{
Class.forName("org.postgresql.Driver");
java.sql.Connection conn=java.sql.DriverManager.getConnection
("jdbc:postgresql://127.0.0.1/testdb","postgres","");
java.sql.Statement stmt=conn.createStatement();
stmt.executeUpdate("insert into boardidx,title,name,pswd,email,ref) "+
"values(nextval('board_idx'),'title','name','pswd','email',currval('board_idx'));");
stmt.close();
conn.close();
}
catch (Exception e)
{
System.out.println("Error"+e.getMessage());
}
---------------------------------------------------------------
이상한에러가발생합니다. JDBC Driver를 잘못만들었나..
그리고 postgreSQL 깔때 이전버전 깔려있는건 모두 지운담 설치해야합니까? 전 그냥 깔았거덩요.. 그것때문인지 아뭏든 도와주십시요...
|