From: | MD <mingdeng2004(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Cc: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
Subject: | Re: Problem with creating language by JDBC |
Date: | 2010-06-25 03:10:38 |
Message-ID: | bbb0de80-cbd0-4b78-a47b-d6d7627c8f76@y4g2000yqy.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Jun 24, 5:38 pm, spam_eater(at)gmx(dot)net (Thomas Kellerer) wrote:
> 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
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-jdbc
I just tried with the regular statement, got the same failure.
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2010-06-25 06:40:12 | Re: Problem with creating language by JDBC |
Previous Message | Thomas Kellerer | 2010-06-24 21:38:10 | Re: Problem with creating language by JDBC |