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