rounded brackets in prepared statement

From: Ladislav DANKO <ladislav(dot)danko(at)enaktyment(dot)cz>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: rounded brackets in prepared statement
Date: 2013-02-12 19:05:18
Message-ID: 511A926E.4080106@enaktyment.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bryan Varner 2013-02-13 02:28:54 Re: PostgreSQL XAResource & GlassFish 3.1.2.2
Previous Message Bryan Varner 2013-02-12 18:53:57 Re: PostgreSQL XAResource & GlassFish 3.1.2.2