client side charset conversion not working correctly
odbcpse
I am not too familar with charsetrs, and I see this in the output (as I
am
sure you did):
syb charset cp850 mapped to IANA charset name Cp850
Apparently jConnect is not liking this and I am not sure why.
I just tried a connection to ASE 12.5.1 (win2000) from a windows client
-
but I was using Nt as the client, with jdk 1.3.1 - I do have i18n.jar up
near the front of
the classpath - could you post your classpath and indicate what platform
your client is
running on, adn maybe ASE also?
pv
kbombard wrote:
>
> I hope someone may have a few suggestions on my problem.
> I am using jconnect 5.5, jdk 1.3.1, ASE 12.5.1 (with the
> default charset set to cp850 and a default install) and I
> get the following error below:
>
> (Thread[main,5,main]): java.sql.SQLException: JZ0IB: The
> server's default charset of cp850 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.
>
> I did include the jars it mentioned and it did not work. I
> do not want to upgrade JDK's b/c my co-workers use 1.3.1 and
> they can connect to my DB with the same program and it works
> fine. Something is screwed up in my env and I do not know
> what it is? I have double and triple checked my path and
> classpath. I have included a file showing the output using
> jconn2d.jar but it does not point me to anything. Hoping
> for some help. Thanks.
>
> ------------------------------------------------------------------------
> Name: out2.txt
> out2.txt Type: Plain Text (text/plain)
> Encoding: base64
kbombard
showing that cp850 does not map to Cp850. The rest of the
line (surrounding info is part of the string output).
I am using ASE 12.5.1 and connections worki well with any
sql client from my own machine to the DB on my machine. It
can not connect with the test program.
My classpath in the bat file to run the program is:
java -classpath
.\..\build\classes\;..\..\..\..\project\lib\easerver\jconn2.jar
;.;..\..\..\..\project\lib\apache\ojb\db-ojb-1.0.rc4.jar;..\..\..\..\project\lib\apache\log4j\log4j-1.2.8.jar
;..\..\..\..\project\lib\jamon\JAMon.jar;..\..\..\..\project\lib\apache\commons-dbcp.jar
;..\..\..\..\project\lib\apache\commons-pool.jar;..\..\..\..\project\lib\apache\xml-apis.jar
;..\..\..\..\project\lib\apache\xercesImpl.jar;..\..\..\..\project\lib\apache\struts\commons-beanutils.jar
;..\..\..\..\project\lib\apache\struts\commons-collections.jar
;..\..\..\..\project\lib\apache\struts\commons-logging.jar;..\..\..\..\project\lib\displaytag\commons-lang-2.0.jar
TestDefaultClassificationBO
The jconn2.jar is the same one from CVS everyone on my
project is using and it works good for them. They can run
the program from their laptop and connect to my DB, so that
points to my env. Just not sure what.
My path in the bat file is:
set PATH = ..\..\config\kbombardw2k\
> > -------------- Name: out2.txt
Dave Clegg
domestic version has a very limitted set of built-in character set
converters. You need the international version of the JVM if you want
cp850 support.
You can read all about it at
http://java.sun.com/j2se/1.3/docs/guide/intl/encoding.doc.html
dave
