Thread: Methode is not yet implemented.
Hello! If I send a SELECT query to PostgreSQL from a JDBC connection of my programm about a lokal network I get this message: "This methode is not yet implemented." The SELECT query is very simple: SELECT * FROM <table>; I use S.u.S.E. 7.2. The driver and the PostgreSQL files are from this distribution. I can't believe that there is a "stable" driver that can't query simple SELECT... Hope somebody knows something and can help me, Joerg Sommer
On Wed, Jul 11, 2001 at 08:43:51PM +0100, Jörg Sommer wrote:
> Hello!
>
> If I send a SELECT query to PostgreSQL from a JDBC connection of my
> programm about a lokal network I get this message:
> "This methode is not yet implemented."
>
> The SELECT query is very simple: SELECT * FROM <table>;
>
> I use S.u.S.E. 7.2. The driver and the PostgreSQL files are from this
> distribution.
>
> I can't believe that there is a "stable" driver that can't query simple
> SELECT...
We can't believe it either.
Send a java code segment. You're probably doing something wrong. It should
be something like...
...
java.sql.Statement stmt = con.createStatement();
java.sql.ResultSet rs = stmt.executeQuery("SELECT * from <table>");
...
Where con is an open connection to your database.
Also, try grabbing a driver from: http://jdbc.fastcrypt.com/
Cheers,
Tom.
--
Thomas O'Dowd. - Nooping - http://nooper.com
tom@nooper.com - Testing - http://nooper.co.jp/labs
Dave Cramer schrieb:
> Joerg,
>
> Have you received a satisfactory answer to this problem yet?
>
> Dave
>
Hi Dave and the rest :)
I do many tests in the moment an I think I made a mistake (i'm not sure).
Perhaps, I misunderstand a error message. I tested the SELECT query once
more and the simple one works. (And much faster as with the
ODBC-JDBC-Bridge). But a SELECT query with a bit more complicated structure,
e.g. with and WHERE or ORDER do NOT work ("not yet implemented). I test this
in the moment because I don't want to wast your time once more (sorry for
that if so) if I make a mistake.
If the normal driver do not work I will test the one from fastcrypt and
another one I found on blackdown...
If I can not resolve my problem I will contact you once more...
Thank you very much for your interest
Jörg Sommer
Joerg,
I think there is some confusion here. Many people are using the driver
quite successfully. Me included. Can you send me the code that doesn't
work?
Dave
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Jörg Sommer
Sent: July 18, 2001 3:18 PM
To: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Methode is not yet implemented.
Dave Cramer schrieb:
> Joerg,
>
> Have you received a satisfactory answer to this problem yet?
>
> Dave
>
Hi Dave and the rest :)
I do many tests in the moment an I think I made a mistake (i'm not
sure). Perhaps, I misunderstand a error message. I tested the SELECT
query once more and the simple one works. (And much faster as with the
ODBC-JDBC-Bridge). But a SELECT query with a bit more complicated
structure, e.g. with and WHERE or ORDER do NOT work ("not yet
implemented). I test this in the moment because I don't want to wast
your time once more (sorry for that if so) if I make a mistake.
If the normal driver do not work I will test the one from fastcrypt and
another one I found on blackdown...
If I can not resolve my problem I will contact you once more...
Thank you very much for your interest
Jörg Sommer
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly