AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  problem with JBoss and interclient -> Cannot transliterate .          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message incasmin Guest Posted: Fri Jun 23, 2006 8:35 pm    Post subject: problem with JBoss and interclient -> Cannot transliterate . Hello, I have a problem with JBoss 4.0.3sp1 running on Linux and talking to Interbase 7.5 via interclient driver. When JBoss is started on Windows everything works perfectly well. But when JBoss is started on Linux there are times while updating rows when an error appears: java.sql.SQLException: [interclient][interbase]arithmetic exception, numeric overflow, or string truncation [interclient][interbase]Cannot transliterate character between character sets at interbase.interclient.Statement.remote_EXECUTE_UPDATE_STATEMENT(Unknown Source) at interbase.interclient.PreparedStatement.remote_EXECUTE_PREPARED_UPDATE_STATEMENT(Unknown Source) at interbase.interclient.PreparedStatement.executeUpdate(Unknown Source) at interbase.interclient.PreparedStatement.executeUpdate(Unknown Source) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:227) Database is each time the same and set to use UNICODE_FSS My interbase-ds.xml stored in $JBOSS_HOEM/server/default/deploy looks like: //---------------------------------------------------------------------------------------------------------------------------------------------------- ... <connection-url>jdbc:interbase://<path_to gdb_file></connection-url> <!-- The driver class --> <driver-class>interbase.interclient.Driver</driver-class> <!-- The login and password --> <user-name><correct_user></user-name> <password><correct_password></password> <charset>UTF8</charset> <config-property name="charSet" type="java.lang.String" value="UTF8" /> <!--example of how to specify class that determines if exception means connection should be destroyed--> <!--exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.DummyExceptionSorter</exception-sorter-class-name--> <!-- this will be run before a managed connection is removed from the pool for use by a client--> <!--<check-valid-connection-sql>select * from something</check-valid-connection-sql> --> <!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use --> <min-pool-size>1</min-pool-size> <!-- The maximum connections in a pool/sub-pool --> <max-pool-size>2</max-pool-size> <!-- The time before an unused connection is destroyed --> <!-- NOTE: This is the check period. It will be destroyed somewhere between 1x and 2x this timeout after last use --> <!-- TEMPORARY FIX! - Disable idle connection removal, HSQLDB has a problem with not reaping threads on closed connections --> <idle-timeout-minutes>0</idle-timeout-minutes> //---------------------------------------------------------------------------------------------------------------------------------------------------------------- Already have tried diffferent setting for charSet - nothing helped. The strange thing is that sometimes exactly the same method with exactly the same data invoked, of cource exeactly the same way - so sometimes it works and sometimes it doesn't. It was checked about 40 times till now. I was checking maybe JBoss passes different representations of the same String to prepared statement - it is not the case. |In 99% it is not a problem of not valid character set set - there are cases when everything works ok and after a minute, the problem appears again. It seems that cases when problematic functionality works well occur just after, and some time after server restart. Later the methods that worked well just after restart start to throw "Cannot transliterate ".... ecexption. I suspect that maybe some Connections (the initial ones ) are created in a different way then the rest. Probably because of the misconfiguration of database access form JBoss to Interbase - interclient does not catch the "UTF8" encoding ( tried already with "UTF-8" and "UNICODE-FSS" ). But I am not sure it it is that way. The strange thing is that on WIndows machines everytyhing is always ok. Maybe "default encoding of interclient matches default encoding under Windows ? ... Anybody knows solution to this problem ?? Regards, Incasmin Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.