Hi!
After upgrading my jdbc driver (MySQL MaxDB, 7.6.0 Build
030-000-005-567) one of my automated tests fails. Server is running
7.6.00 BUILD 027-121-124-939 on Linux.
The test consists passing each character (byte actually, 0..255) to the
DB and see if it can be stored, loaded and queried. Most DBs have
problems with various characters but this one is new:
The byte 164 (decimal, CURRENCY SIGN) triggers an exception with a query
like this:
SELECT DISTINCT oid FROM foo WHERE bar = '¤'
com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4025]: Error
at
com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:72)
at
com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:946)
at
com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:584)
at
com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:454)
at
com.sap.dbtech.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:812)
at
com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:860)
at
com.sap.dbtech.jdbc.StatementSapDB.execute(StatementSapDB.java:263)
at
com.sap.dbtech.jdbc.StatementSapDB.executeQuery(StatementSapDB.java:417)
The description for the error -4025 tells me to look for a table called
DOMAIN.CHARSET which does not exist (anymore?)
unsurprisingly the connection parameter "unicode" does not change this
behaviour.
reviewing old mailing list entries i guess this occurs finally because
my application is running latin9 somewhere in between. i might be using
a latin9 character which cannot be mapped in latin1 which results in
this error.
hm. i just found out about it, because the exception is new with this
jdbc driver version (it worked with MySQL MaxDB, 7.6.0 Build
016-000-004-753). i believe it didnt handle that byte correctly for me,
but at least it wasnt throwing this exception.
so, is this a bug or intended?
Raimund
--
Die Lösung für effizientes Kundenbeziehungsmanagement.
Jetzt informieren: http://www.universal-messenger.de
Pinuts media+science GmbH http://www.pinuts.de
Dipl.-Inform. Raimund Jacob [EMAIL PROTECTED]
Krausenstr. 9-10 voice : +49 30 59 00 90 322
10117 Berlin fax : +49 30 59 00 90 390
Germany
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
