I have been using Firebird database with UTF8 encoding. In normal JDBC coding, I need to the code the following in order to get a connection object
Properties props = new Properties();
String url = "jdbc:interbase://localhost//home/databases/sample.gdb";
Connection conn = DriverManager.getConnection(url, props);
In JBoss 2.4.4, I can define a connection pool with the following in jboss.jcml
<!-- sysdba -->
<!-- masterkey -->
Then, it is OK. I can read and write charcters to Firebird in UTF8.
But when I upgraded to JBoss 2.4.6, the UTF8 is displayed as garbage. To my findings, it seems that JBoss 2.4.6 must have the JDBCUser and Password attributes in jboss.jcml. But when I uncomment the two attributes, it seems that the charSet=UTF8 specify in the Properties attribute is not functioning.
Why JBoss behave differently with the same jboss.jcml in JBoss 2.4.4 and JBoss 2.4.6? Is this a BUG in JBoss 2.4.6 or I have to make some changes in jboss.jcml in JBoss 2.4.6? If I have to made changes, which changes should I made?
Then, I have try to upgrade to JBoss 3.0 using FirebirdSQL. I follows the instruction to do configuration. But I can only succeed in doing single byte characters. Those UTF8 characters stored in Firebird is displayed as garbage using the sample application when I used for JBoss 2.4.4.
So, how to configure a firebird connection pool in JBoss 3.0 in order to support UTF8?
Thanks a lot for help