Discussion:
Sybase JDBC setup
(too old to reply)
Peter Wu
2004-05-25 20:07:58 UTC
Permalink
Hi,

I am trying to configure a Sybase JDBC connection pool using "com.sybase.jdbc2.jdbc.SybDriver"
(Sybase's Driver of Type 4 Versions: 5.x). I have both jConnect.jar and jconn2.jar
in the classpath.

The following is the error message from the admin console when I click on the
"Test Driver Configuration" during configuration.

//------------------------------------------------------------
JZ0IB: The server's default charset of roman8 does not map to an encoding that
is available in the client Java environment. Because jConnect will not be able
to do client-side conversion, the connection is unusable and is being closed.
Try using a later Java version, or try including your Java installation's i18n.jar
or charsets.jar file in the classpath.
//------------------------------------------------------------

Any idea why this is happening and how to solve it?

Thanks!

Peter
Joe Weinstein
2004-05-25 20:45:54 UTC
Permalink
Post by Peter Wu
Hi,
I am trying to configure a Sybase JDBC connection pool using "com.sybase.jdbc2.jdbc.SybDriver"
(Sybase's Driver of Type 4 Versions: 5.x). I have both jConnect.jar and jconn2.jar
in the classpath.
The following is the error message from the admin console when I click on the
"Test Driver Configuration" during configuration.
//------------------------------------------------------------
JZ0IB: The server's default charset of roman8 does not map to an encoding that
is available in the client Java environment. Because jConnect will not be able
to do client-side conversion, the connection is unusable and is being closed.
Try using a later Java version, or try including your Java installation's i18n.jar
or charsets.jar file in the classpath.
//------------------------------------------------------------
Any idea why this is happening and how to solve it?
Thanks!
Peter
Hi. You should probably do what the sybase driver is saying... I suggest:
1 - download Sybase's latest version of the driver and get it listed ahead of
the weblogic.jar file in the server's classpath.
2 - Include the Sybase driver's i18n.jar and/or charsets.jar also, also ahead
of the weblogic.jar.

Joe
Peter Wu
2004-05-26 05:17:22 UTC
Permalink
Hi, Joe,

I tried it, but got the same error message.

I did #1 as you advised, putting the latest driver classes jar file before the
weblogic.jar in the server classpath. For the #2 I used the charsets.jar from
JDK1.4 instead of that from Sybase driver. With these 8.1 console still shows
the same error message as before. Just wondering if there is and how you can get
charsets.jar from Sybase driver's?

Thanks!

Peter
Post by Peter Wu
Post by Peter Wu
Hi,
I am trying to configure a Sybase JDBC connection pool using "com.sybase.jdbc2.jdbc.SybDriver"
(Sybase's Driver of Type 4 Versions: 5.x). I have both jConnect.jar
and jconn2.jar
Post by Peter Wu
in the classpath.
The following is the error message from the admin console when I click
on the
Post by Peter Wu
"Test Driver Configuration" during configuration.
//------------------------------------------------------------
JZ0IB: The server's default charset of roman8 does not map to an encoding
that
Post by Peter Wu
is available in the client Java environment. Because jConnect will
not be able
Post by Peter Wu
to do client-side conversion, the connection is unusable and is being
closed.
Post by Peter Wu
Try using a later Java version, or try including your Java installation's
i18n.jar
Post by Peter Wu
or charsets.jar file in the classpath.
//------------------------------------------------------------
Any idea why this is happening and how to solve it?
Thanks!
Peter
1 - download Sybase's latest version of the driver and get it listed ahead of
the weblogic.jar file in the server's classpath.
2 - Include the Sybase driver's i18n.jar and/or charsets.jar also, also ahead
of the weblogic.jar.
Joe
Joe Weinstein
2004-05-26 16:14:19 UTC
Permalink
Post by Peter Wu
Hi, Joe,
I tried it, but got the same error message.
I did #1 as you advised, putting the latest driver classes jar file before the
weblogic.jar in the server classpath. For the #2 I used the charsets.jar from
JDK1.4 instead of that from Sybase driver. With these 8.1 console still shows
the same error message as before. Just wondering if there is and how you can get
charsets.jar from Sybase driver's?
Dunno... I would definitely suggest also pinging Sybase in their newsgroups about
how to fix that driver exception.
Joe
Post by Peter Wu
Thanks!
Peter
Post by Peter Wu
Post by Peter Wu
Hi,
I am trying to configure a Sybase JDBC connection pool using "com.sybase.jdbc2.jdbc.SybDriver"
(Sybase's Driver of Type 4 Versions: 5.x). I have both jConnect.jar
and jconn2.jar
Post by Peter Wu
in the classpath.
The following is the error message from the admin console when I click
on the
Post by Peter Wu
"Test Driver Configuration" during configuration.
//------------------------------------------------------------
JZ0IB: The server's default charset of roman8 does not map to an encoding
that
Post by Peter Wu
is available in the client Java environment. Because jConnect will
not be able
Post by Peter Wu
to do client-side conversion, the connection is unusable and is being
closed.
Post by Peter Wu
Try using a later Java version, or try including your Java installation's
i18n.jar
Post by Peter Wu
or charsets.jar file in the classpath.
//------------------------------------------------------------
Any idea why this is happening and how to solve it?
Thanks!
Peter
1 - download Sybase's latest version of the driver and get it listed ahead of
the weblogic.jar file in the server's classpath.
2 - Include the Sybase driver's i18n.jar and/or charsets.jar also, also ahead
of the weblogic.jar.
Joe
Loading...