rounded brackets in prepared statement - Mailing list pgsql-jdbc

From Ladislav DANKO
Subject rounded brackets in prepared statement
Date
Msg-id 511A926E.4080106@enaktyment.cz
Whole thread Raw
Responses Re: rounded brackets in prepared statement  (dmp <danap@ttc-cmc.net>)
List pgsql-jdbc
Hi folks,

my setup: Java 1.6, JDBC PostgreSQL JDBC4 driver 9.1-903.

Why when I do:

PreparedStatement ps = myConnection.prepareStatement("SELECT a,b,c FROM mytable WHERE category ~ ?");
ps.setString(1, "my/super/category/a(bcdef");
result = ps.executeQuery();

I need to escape rounded bracket in setString in this way:
ps.setString(1, "super/category/a(bcdef".replaceAll("\\(", "\\\\(")));

I think it has somethink to do with regular expessions but ot know much more about it.

--
With kind regards,

Ladislav DANKO


pgsql-jdbc by date:

Previous
From: Bryan Varner
Date:
Subject: Re: PostgreSQL XAResource & GlassFish 3.1.2.2
Next
From: Bryan Varner
Date:
Subject: Re: PostgreSQL XAResource & GlassFish 3.1.2.2