Обсуждение: problem with postgres jdbc driver and Java 1.4.2 sdk

Hi everybody,


Since I've upgraded to Java 1.4.2 on my Mac OSX box, I am having
extremely strange  problem with jdbc drivers.


I am simply trying to update a resultset via update* methods, and I
get the following exception :


<fixed><color><param>FFFF,0000,0000</param><x-tad-bigger>This method
is not yet implemented.</x-tad-bigger></color><x-tad-bigger>

</x-tad-bigger><color><param>FFFF,0000,0000</param><x-tad-bigger>    at
org.postgresql.Driver.notImplemented(Unknown Source)</x-tad-bigger></color><x-tad-bigger>

</x-tad-bigger><color><param>FFFF,0000,0000</param><x-tad-bigger>    at
org.postgresql.jdbc2.UpdateableResultSet.updateInt(Unknown Source)</x-tad-bigger></color><x-tad-bigger>

</x-tad-bigger><color><param>FFFF,0000,0000</param><x-tad-bigger>    at
org.postgresql.jdbc2.ResultSet.updateInt(Unknown Source)</x-tad-bigger></color><x-tad-bigger>

</x-tad-bigger><color><param>FFFF,0000,0000</param><x-tad-bigger>    at
testPg.<<init>(testPg.java:41)</x-tad-bigger></color><x-tad-bigger>

</x-tad-bigger><color><param>FFFF,0000,0000</param><x-tad-bigger>    at
testPg.main(testPg.java:51)


</x-tad-bigger></color></fixed>Here is a sample code that is getting
me into troubles:


<fixed><x-tad-bigger>
</x-tad-bigger><color><param>7F7F,0000,5555</param><x-tad-bigger>try</x-tad-bigger></color><x-tad-bigger>{ 

        stmt = conn.createStatement(

                ResultSet.TYPE_SCROLL_SENSITIVE,

                ResultSet.CONCUR_UPDATABLE);

        rs =
stmt.executeQuery(</x-tad-bigger><color><param>2A2A,0000,FFFF</param><x-tad-bigger>"select
* from contacts where id = 1"</x-tad-bigger></color><x-tad-bigger>);




rs.updateInt(</x-tad-bigger><color><param>2A2A,0000,FFFF</param><x-tad-bigger>"languageId"</x-tad-bigger></color><x-tad-bigger>,2);

        rs.updateRow();



        }

        </x-tad-bigger><color><param>7F7F,0000,5555</param><x-tad-bigger>catch</x-tad-bigger></color><x-tad-bigger>
(SQLException e) {

            e.printStackTrace();

        }



</x-tad-bigger></fixed>Is there any know issue with jdk 1.4.2 on Mac
OSX ?


Thank you very much for your help,


Olivier Crameri<fixed><x-tad-bigger>

</x-tad-bigger></fixed>
Hi everybody,

Since I've upgraded to Java 1.4.2 on my Mac OSX box, I am having
extremely strange  problem with jdbc drivers.

I am simply trying to update a resultset via update* methods, and I get
the following exception :

This method is not yet implemented.
    at org.postgresql.Driver.notImplemented(Unknown Source)
    at org.postgresql.jdbc2.UpdateableResultSet.updateInt(Unknown Source)
    at org.postgresql.jdbc2.ResultSet.updateInt(Unknown Source)
    at testPg.<init>(testPg.java:41)
    at testPg.main(testPg.java:51)

Here is a sample code that is getting me into troubles:

    try {
        stmt = conn.createStatement(
                ResultSet.TYPE_SCROLL_SENSITIVE,
                ResultSet.CONCUR_UPDATABLE);
        rs = stmt.executeQuery("select * from contacts where id = 1");

        rs.updateInt("languageId",2);
        rs.updateRow();

        }
        catch (SQLException e) {
            e.printStackTrace();
        }

Is there any know issue with jdk 1.4.2 on Mac OSX ?

Thank you very much for your help,

Olivier Crameri

Olivier Crameri wrote:
> Hi everybody,
>
> Since I've upgraded to Java 1.4.2 on my Mac OSX box, I am having
> extremely strange problem with jdbc drivers.
>
> I am simply trying to update a resultset via update* methods, and I get
> the following exception :
>
> This method is not yet implemented.
> at org.postgresql.Driver.notImplemented(Unknown Source)
> at org.postgresql.jdbc2.UpdateableResultSet.updateInt(Unknown Source)
> at org.postgresql.jdbc2.ResultSet.updateInt(Unknown Source)
> at testPg.<init>(testPg.java:41)
> at testPg.main(testPg.java:51)

This originates from a very old JDBC driver; jdbc2.UpdateableResultSet
and jdbc2.ResultSet were removed on 25 Jul 2002 according to cvsweb.
Try a more recent driver from http://jdbc.postgresql.org (or build your
own from CVS).

If the only thing you've changed is the JDK, check for old versions of
the driver in unexpected places -- perhaps the upgrade changed the
effective classpath being used.

-O

On Fri, 5 Mar 2004, Olivier Crameri wrote:

> Hi everybody,
>
> Since I've upgraded to Java 1.4.2 on my Mac OSX box, I am having
> extremely strange  problem with jdbc drivers.
>
> I am simply trying to update a resultset via update* methods, and I get
> the following exception :
>
> This method is not yet implemented.
>     at org.postgresql.Driver.notImplemented(Unknown Source)
>     at org.postgresql.jdbc2.UpdateableResultSet.updateInt(Unknown Source)
>     at org.postgresql.jdbc2.ResultSet.updateInt(Unknown Source)
>     at testPg.<init>(testPg.java:41)
>     at testPg.main(testPg.java:51)
>

The stacktrace shows a driver that is at least as old as 7.2.  Try
downloading a newer version from http://jdbc.postgresql.org/download.html

Kris Jurka