Some drivers allows you to appende the properties as a ; og , seperated list
after the url.
So try set this in your url
url=whateverurl;CHARSET_CONVERTER_CLASS=com.sybase.jdbc2.utils.TruncationCon
verter,CHARSET=roman8
lookup the doc for the sybase driver to see the correct syntax...
/max
----- Original Message -----
From: "Gibbs, Tim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 16, 2002 6:33 PM
Subject: Additional JDBC Properties
I am back to trying to get OJB working with Sybase which is proving to be
rather annoying.
The problem that I am currently working on relates to passing additional
JDBC information to the newly created connection. For example when we
create a JDBC connection we do it as follows:
Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
conn = DriverManager.getConnection(connectionURL,props);
where props = java.util.Properties
which are:
USER=myDBUser
PASSWORD=myDBPassword
CHARSET_CONVERTER_CLASS=com.sybase.jdbc2.utils.TruncationConverter
CHARSET=roman8
Now pay special attention to the CHARSET_CONVERTER_CLASS and the CHARSET
properties. These two properties MUST be set for our version of java (1.4)
and Sybase or the connections throw an exception as follows:
java.sql.SQLException: JZ006: Caught IOException: java.io.IOException:
JZ0I6: An error occured converting UNICODE to the charset used by the
server. Error message: java.io.CharConversionException:
java.io.UnsupportedEncodingException: hp-roman8
Now, we know that to solve the exception in JDBC is to add the above
properties to the connection creation but there doesn't seem to be any way
to include "supplemental" properties to the JDBC connection handlers in OJB
because after reviewing the source code for: AbstractConnectionFactory we
find that the connection created using:
if (jcd.getUserName() == null)
{
retval = java.sql.DriverManager.getConnection(url);
}
else
{
retval = java.sql.DriverManager.getConnection(url,
jcd.getUserName(), jcd.getPassWord());
}
which seems to preclude the use of additional properties.
Can someone provide some guidance as to how I might fix this issue. Have I
missed something in the connection descriptor?
Thanks for any help!
Tim
--------------------------------------------
Tim Gibbs
RBC Capital Markets
Phone: (416) 842-4663
E-Mail: [EMAIL PROTECTED]
<font face="Times New Roman" size="3">
<p>-------------------------------------------------------------------------
-----</p>
<p> This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than an
intended recipient is unauthorized. If you received this e-mail in error,
please advise me (by return e-mail or otherwise) immediately.</p>
<p> Ce courriel est confidentiel et prot�g�. L'exp�diteur ne renonce pas aux
droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou
copie de ce message ou des renseignements qu'il contient par une personne
autre que le (les) destinataire(s) d�sign�(s) est interdite. Si vous recevez
ce courriel par erreur, veuillez m'en aviser imm�diatement, par retour de
courriel ou par un autre moyen.</p>
<p>====================================================</p>
</font>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
