Re: Problems with semicolon trying to create a trigger function via jdbc - Mailing list pgsql-jdbc

From Collin Peters
Subject Re: Problems with semicolon trying to create a trigger function via jdbc
Date
Msg-id 7a8b7ba31003251545u69166ae0nde99317ec5bd6b3f@mail.gmail.com
Whole thread Raw
In response to Re: Problems with semicolon trying to create a trigger function via jdbc  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
On Thu, Mar 25, 2010 at 3:31 PM, Kris Jurka <books@ejurka.com> wrote:
>
>
> 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"));

Hmmm... good idea but the driver versions are the same


jar:file:/home/collin/.m2/repository/postgresql/postgresql/8.3-603.jdbc3/postgresql-8.3-603.jdbc3.jar!/org/postgresql/Driver.class

jar:file:/home/collin/Code/intouch/trunk2/java/intouch-webapp/target/intouch-webapp/WEB-INF/lib/postgresql-8.3-603.jdbc3.jar!/org/postgresql/Driver.class

>
> Kris Jurka
>
>

pgsql-jdbc by date:

Previous
From: Maciek Sakrejda
Date:
Subject: Re: Problems with semicolon trying to create a trigger function via jdbc
Next
From: "Albe Laurenz"
Date:
Subject: Re: Problems with semicolon trying to create a trigger function via jdbc