Re: Problem with creating language by JDBC

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem with creating language by JDBC
Date: 2010-06-24 21:38:10
Message-ID: i00j7v$ani$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Ming Deng wrote on 24.06.2010 19:44:
> Hi there,
>
> I was trying to create language by execute() or executeUpdate(). But the
> call always fails with message as
>
> problem running SQL query: CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
> HANDLER plpgsql_call_handler
> .An I/O error occured while sending to the backend.
>
> Following is a snippet of the Java code I have, which works with
> creating database, executing other queries:
>

Did you try to use a regular statement, instead of a PreparedStatement?

Statement stmt = con.createStatement()
stmt.executeUpdate("CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler");

Thomas

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message MD 2010-06-25 03:10:38 Re: Problem with creating language by JDBC
Previous Message Ming Deng 2010-06-24 17:44:53 Problem with creating language by JDBC