Обсуждение: 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