From: thhal at mailblocks.com (Thomas Hallgren)
Date: Thu, 05 May 2005 17:16:36 +0200
Subject: [Pljava-dev] Re: Problems with JDBC-UNICODE
In-Reply-To: <33162.10.0.0.64.1115303659.squirrel@10.0.0.64>
References: <33093.10.0.0.64.1115301237.squirrel@10.0.0.64>
	<427A2B6C.2050203@mailblocks.com>
	<thhal-07sNVA2lwyic8R5HIsV0dsBMpJgbFqV@mailblocks.com>
	<33162.10.0.0.64.1115303659.squirrel@10.0.0.64>
	<427A38D4.8050808@mailblocks.com>
	<thhal-0VtFVAzFxyicASUpKVHWlT8Rg1rns7e@mailblocks.com>
Message-ID: <thhal-0VtFVAzNxyicigrz8orPlHPq6whHEME@mailblocks.com>

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