Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group