Thread: bothering error

bothering error

From
bluejacksong
Date:
I download a small java program which use jdbc to connect to postgresql.But I meet a error like this:
java.lang.NoSuchMethodError: java/sql/Statement.getResultSetConcurrency()I
        at org.postgresql.jdbc2.Connection.getResultSet(Connection.java:216)
        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:121)
        at org.postgresql.Connection.ExecSQL(Connection.java:398)
        at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
        at HelloPostgresql.<init>(HelloPostgresql.java:30)
        at HelloPostgresql.main(HelloPostgresql.java:92)

The jdk I use is j2sdk1.4.0_01
The jdbc driver I use is pgjdbc2.jar which I downloaded from http://jdbc.postgresql.org/download.html.
What is the problem? give me some suggestion
thanks

jack

______________________________________

===================================================================
�������ѵ������� (http://mail.sina.com.cn)
���˷�����Ϣ�������г���һ�ߣ��ó���ʱ�ͳ��֣� (http://classad.sina.com.cn/2shou/)

Re: bothering error

From
Dave Cramer
Date:
It looks like you have a jdbc1 jar being picked up before the jdbc2 jar,
check your classpath.

Barry Lind has answered this a few times, search for his answers as
well.

Dave
On Mon, 2002-07-22 at 22:34, bluejacksong wrote:
> I download a small java program which use jdbc to connect to postgresql.But I meet a error like this:
> java.lang.NoSuchMethodError: java/sql/Statement.getResultSetConcurrency()I
>         at org.postgresql.jdbc2.Connection.getResultSet(Connection.java:216)
>         at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:121)
>         at org.postgresql.Connection.ExecSQL(Connection.java:398)
>         at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
>         at HelloPostgresql.<init>(HelloPostgresql.java:30)
>         at HelloPostgresql.main(HelloPostgresql.java:92)
>
> The jdk I use is j2sdk1.4.0_01
> The jdbc driver I use is pgjdbc2.jar which I downloaded from http://jdbc.postgresql.org/download.html.
> What is the problem? give me some suggestion
> thanks
>
> jack
>
> ______________________________________
>
> ===================================================================
> ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn)
> ÐÂÀË·ÖÀàÐÅÏ¢£º¶þÊÖÊг¡×ßÒ»×ߣ¬¸Ã³öÊÖʱ¾Í³öÊÖ£¡ (http://classad.sina.com.cn/2shou/)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>