Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Jdbc Derby connect URL failed with a double byte language character
Jdbc Derby connect URL failed with a double byte language character [message #48570] Fri, 08 August 2008 10:31 Go to next message
Eclipse User
Originally posted by: jinx.us.ibm.com

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
Re: Jdbc Derby connect URL failed with a double byte language character [message #48779 is a reply to message #48570] Mon, 11 August 2008 15:22 Go to previous messageGo to next message
Stephan van Loendersloot is currently offline Stephan van Loendersloot
Messages: 7
Registered: July 2009
Junior Member
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
Re: Jdbc Derby connect URL failed with a double byte language character [message #49058 is a reply to message #48779] Wed, 20 August 2008 13:37 Go to previous message
Eclipse User
Originally posted by: brianf.sybase.com

Thanks Stephan for responding to Cindy's question!
--Fitz

"Stephan van Loendersloot" <stephan@republika.nl> wrote in message
news:g7q3i0$qk0$1@build.eclipse.org...
> 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
Re: Jdbc Derby connect URL failed with a double byte language character [message #592643 is a reply to message #48570] Mon, 11 August 2008 15:22 Go to previous message
Stephan van Loendersloot is currently offline Stephan van Loendersloot
Messages: 7
Registered: July 2009
Junior Member
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
Re: Jdbc Derby connect URL failed with a double byte language character [message #592764 is a reply to message #48779] Wed, 20 August 2008 13:37 Go to previous message
Brian Fitzpatrick is currently offline Brian Fitzpatrick
Messages: 495
Registered: July 2009
Senior Member
Thanks Stephan for responding to Cindy's question!
--Fitz

"Stephan van Loendersloot" <stephan@republika.nl> wrote in message
news:g7q3i0$qk0$1@build.eclipse.org...
> 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
Previous Topic:Useability
Next Topic:Is this the question about dtp?(jee-ganymede)
Goto Forum:
  


Current Time: Thu Jul 24 19:02:00 EDT 2014

Powered by FUDForum. Page generated in 0.01612 seconds