agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

[Pljava-dev] Problems with JDBC-UNICODE
4+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] Problems with JDBC-UNICODE
@ 2005-05-05 13:53  
  0 siblings, 2 replies; 4+ messages in thread

From:  @ 2005-05-05 13:53 UTC (permalink / raw)

An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050505/4b90af2d/attachment.html;



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* [Pljava-dev] Problems with JDBC-UNICODE
@ 2005-05-05 14:19  
  parent: 
  1 sibling, 0 replies; 4+ messages in thread

From:  @ 2005-05-05 14:19 UTC (permalink / raw)

Jordi Marqu?s wrote:

> when I use tsearch2 (in trigger) to insert "text" or "to varchar" in a 
> table one it appears to me the following error. 
>
> Exception: ERROR: Regex error in '[^?he$': brackets [] not balanced
>
> I am sure that it is related to the character code but I do not have 
> solution
>
> Thank you
>
> -- 
> Jordi Marqu?s Ferr? (jordi.marques at iigov.org)

You are aware that in order to pass a backslash you need to escape it 
(i.e. \\ or even \\\\ if you want to pass escaped backslash to the SQL 
parser).

Can you provide a sample of the statement that you pass to JDBC?

Regards,
Thomas Hallgren






^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* [Pljava-dev] Problems with JDBC-UNICODE
@ 2005-05-05 14:34  
  parent: 
  1 sibling, 1 reply; 4+ messages in thread

From:  @ 2005-05-05 14:34 UTC (permalink / raw)

An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050505/b68fd106/attachment.html;



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* [Pljava-dev] Re: Problems with JDBC-UNICODE
@ 2005-05-05 15:16  
  parent: 
  0 siblings, 0 replies; 4+ messages in thread

From:  @ 2005-05-05 15:16 UTC (permalink / raw)

Jordi Marqu?s wrote:
> My PreparedStatement is:
> 
> INSERT INTO FUENTE (FUE_IDINT, FUE_NOMBRE, FUE_CODIGO, FUE_TIPO) VALUES 
> (?, ?, ?, ?)
> 
> pstmt = conn.prepareStatement(query,
>                     ResultSet.TYPE_SCROLL_INSENSITIVE,
>                     ResultSet.CONCUR_READ_ONLY);
> pstmt.setInt(1, bean.getId());
> pstmt.setString(2, bean.getName());
> pstmt.setString(3, bean.getCode());
> pstmt.setString(4, bean.getType));
> 
> pstmt.executeUpdate();
> 
>             conn.commit();
> 
I don't think there's anything that PL/Java does that would cause this 
error. A statement like this is basically just passed on to the backend 
SPI layer. Strings are converted from what java uses (Unicode) to 
whatever is used in the backend by means of normal PostgreSQL conversion 
routines.

Can you execute your statement using the client JDBC driver?, I.e. not 
using PL/Java?

How do you obtain your java.sql.Connection?

Regards,
Thomas Hallgren





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

end of thread, other threads:[~2005-05-05 15:16 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-05 13:53 [Pljava-dev] Problems with JDBC-UNICODE 
2005-05-05 14:19 ` 
2005-05-05 14:34 ` 
2005-05-05 15:16   ` 

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox