Re: Problems with semicolon trying to create a trigger function via jdbc

From: Kris Jurka <books(at)ejurka(dot)com>
To: Collin Peters <cpeters(at)intouchtechnology(dot)com>
Cc: Maciek Sakrejda <msakrejda(at)truviso(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problems with semicolon trying to create a trigger function via jdbc
Date: 2010-03-25 22:31:20
Message-ID: alpine.BSO.2.00.1003251827080.330@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 25 Mar 2010, Collin Peters wrote:

> I wasn't able to get the DriverManager.getConnection() approach to
> work (still worked in the unit test, but not the running webapp), but
> reverting to the old 'non-dollar' quoting approach worked.
>

I'd bet you have two different driver versions deployed to your webapp and
you're getting an old version which doesn't understand dollar quotes.

Try
System.out.println(Class.forName("org.postgresql.Driver").getResource("/org/postgresql/Driver.class"));

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Collin Peters 2010-03-25 22:45:19 Re: Problems with semicolon trying to create a trigger function via jdbc
Previous Message Maciek Sakrejda 2010-03-25 22:30:21 Re: Problems with semicolon trying to create a trigger function via jdbc