From: | Collin Peters <cpeters(at)intouchtechnology(dot)com> |
---|---|
To: | Kris Jurka <books(at)ejurka(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:45:19 |
Message-ID: | 7a8b7ba31003251545u69166ae0nde99317ec5bd6b3f@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Thu, Mar 25, 2010 at 3:31 PM, Kris Jurka <books(at)ejurka(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2010-03-26 08:26:06 | Re: Problems with semicolon trying to create a trigger function via jdbc |
Previous Message | Kris Jurka | 2010-03-25 22:31:20 | Re: Problems with semicolon trying to create a trigger function via jdbc |