Thread: bug in jdbc

Marek-

This appears to be a normal message from the driver reporting an error in
the submitted SQL statement. The "Something unusual" part of the message is
a bit misleading, but the rest of the message points pretty clearly to a
problem with the function pg_encoding_to_char. What happens if you try to
execute the same statement via psql?

-Nick


-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Marek Koniew
Sent: Thursday, May 23, 2002 7:56 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] bug in jdbc


i got the buggy driver from http://jdbc.postgresql.org/download/pgjdbc2.jar
jdbc7.0-1.2 driver working OK

there is exception :

 Something unusual has occured to cause the driver to fail. Please report
this exception: Exception: java.sql.SQLException: ERROR:  No such function
'pg_encoding_to_char' with the specified attributes

Stack Trace:

java.sql.SQLException: ERROR:  No such function 'pg_encoding_to_char' with
the specified attributes

        at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
        at org.postgresql.Connection.ExecSQL(Connection.java:398)
        at org.postgresql.Connection.ExecSQL(Connection.java:381)
        at org.postgresql.Connection.openConnection(Connection.java:314)
        at org.postgresql.Driver.connect(Driver.java:149)
        at java.sql.DriverManager.getConnection(DriverManager.java:517)
        at java.sql.DriverManager.getConnection(DriverManager.java:177)
        at board.userbase(board.java)
        at board.doPost(board.java)
        at board.doGet(board.java)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:271)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:311)
        at
org.apache.jserv.JServConnection.processRequest(JServConnection.java:317)
        at org.apache.jserv.JServConnection.run(JServConnection.java:188)
        at java.lang.Thread.run(Thread.java:484)
End of Stack Trace

I think this is a case of using the jdbc 1.1 driver in a 1.2
environment? There are similiar messages in the archive

Dave
On Thu, 2002-05-23 at 08:56, Marek Koniew wrote:
> i got the buggy driver from http://jdbc.postgresql.org/download/pgjdbc2.jar
> jdbc7.0-1.2 driver working OK
>
> there is exception :
>
>  Something unusual has occured to cause the driver to fail. Please report this exception: Exception:
java.sql.SQLException:ERROR:  No such function 'pg_encoding_to_char' with the specified attributes 
>
> Stack Trace:
>
> java.sql.SQLException: ERROR:  No such function 'pg_encoding_to_char' with the specified attributes
>
>         at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
>         at org.postgresql.Connection.ExecSQL(Connection.java:398)
>         at org.postgresql.Connection.ExecSQL(Connection.java:381)
>         at org.postgresql.Connection.openConnection(Connection.java:314)
>         at org.postgresql.Driver.connect(Driver.java:149)
>         at java.sql.DriverManager.getConnection(DriverManager.java:517)
>         at java.sql.DriverManager.getConnection(DriverManager.java:177)
>         at board.userbase(board.java)
>         at board.doPost(board.java)
>         at board.doGet(board.java)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:271)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:311)
>         at org.apache.jserv.JServConnection.processRequest(JServConnection.java:317)
>         at org.apache.jserv.JServConnection.run(JServConnection.java:188)
>         at java.lang.Thread.run(Thread.java:484)
> End of Stack Trace
>
>

> I think this is a case of using the jdbc 1.1 driver in a 1.2
> environment? There are similiar messages in the archive

This sounds better than my idea- Try Dave's solution before mine.

-Nick