Re: Problems with semicolon trying to create a trigger function via 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
>
>