-
1. Re: How to set vendor specific properties in Datasource in J
davidjencks Aug 6, 2002 11:01 PM (in response to tsangcn)This would be a very easy patch to the firebirdsql driver. You just need to add a get/set CharSet attribute to FBManagedConnectionFactory and do whatever is necessary to get the supplied value into an appropriate spot in the defaultCri. Setting the charset already works when getting the connections from FBDriver. If you have any problems, please ask on the firebird-java list, the developers who added charset support to the driver will see it and can help.
Since you are already trying using unicode in Firebird, you would be in an ideal spot to test such a patch. If you write it please submit it to the firebird-java list or the patch tracker at firebird, and it will get applied quickly. I'm a bit reluctant to write it myself since I'm not very familiar with the character set support in firebird and am not sure I could test it well. -
2. Re: How to set vendor specific properties in Datasource in J
rrokytskyy Aug 8, 2002 9:56 AM (in response to tsangcn)I already patched the driver. Property is called Encoding, not CharSet. This was done because InterClient driver accepts "charSet" property, but values are different from ones that are used in Firebird type 4 JDBC/JCA driver.
-
3. Re: How to set vendor specific properties in Datasource in J
tsangcn Aug 8, 2002 11:29 AM (in response to tsangcn)Thank you David.
I have download new patch from firebird CVS, then build a new firebirdsql.rar. Its OK now. The UNICODE characters come back to normal. They have add a new config-property to Firebird-service.xml to specify the encoding.
Add the following to the Firebird-service.xml for UNICODE support
<config-property>
<config-property-name>Encoding</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>UNICODE_FSS</config-property-value>
</config-property>
Also, with the new patch, the Database property can be specify with the old format as
localhost/3050:/home/databases/sample.gdb
or use the standard jdbc format as
//localhost//home/databases/sample.gdb
Thanks.
CN -
4. Re: How to set vendor specific properties in Datasource in J
tsangcn Aug 8, 2002 11:37 AM (in response to tsangcn)Thank you David.
I have download new patch from firebird CVS, then build a new firebirdsql.rar. Its OK now. The UNICODE characters come back to normal. They have add a new config-property to Firebird-service.xml to specify the encoding.
Add the following to the Firebird-service.xml for UNICODE support
<config-property>
<config-property-name>Encoding</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>UNICODE_FSS</config-property-value>
</config-property>
Also, with the new patch, the Database property can be specify with the old format as
localhost/3050:/home/databases/sample.gdb
or use the standard jdbc format as
//localhost//home/databases/sample.gdb
Thanks.
CN