[news.eclipse.dtp] Re: Jdbc Derby connect URL failed with a double byte

[Stephan van Loendersloot <stephan@xxxxxxxxxxxx>]

Hi Cindy,

This is a known problem, see:

https://issues.apache.org/jira/browse/DERBY-728

The workaround is to use characters of the ISO-8859-1 set.

BTW, it is recommended to use the Derby database driver instead of the 
IBM driver.

Regards,

Stephan.

> Hi:
>
> When I use DTP connection profile to connect to a derby database with 
> UDB driver, and the database name or the path to the database has a 
> double byte language character, i.e. 
> URL:jdbc:derby:net://localhost:1527/"C:/è/mydatabase", I get the 
> exception:
> com.ibm.db2.jcc.b.SqlException: [jcc][10402][11146][3.50.152] Cannot 
> convert Unicode string to Ebcdic string. ERRORCODE=-4220, SQLSTATE=null
>
> Does anyone know how I can specify a database name with a double byte 
> language character?
>
> Thanks
>
> Cindy