-
1. Re: Free database and JBoss with correct national encoding
davidjencks Oct 31, 2001 7:29 PM (in response to caba)How do you configure the encoding in Borland Appserver? Can you configure a standalone interclient connection with the desired character encoding, getting the connection from DriverManager?
-
2. Re: Free database and JBoss with correct national encoding
caba Nov 1, 2001 5:00 AM (in response to caba)Here is my AppServer configuration:
ejb-inprise.xml
<datasource-definitions>
<jndi-name>foo/DS</jndi-name> jdbc:interbase://localhost/C:\database\FOO.GDB
SYSDBA
masterkey
<driver-class-name>interbase.interclient.Driver</driver-class-name>
<jdbc-property>
<prop-name>charSet</prop-name>
<prop-value>Cp1250</prop-value>
</jdbc-property>
</datasource-definitions>
Standalone client:
I use JDBC Pilot (integrated in JBuilder5)
Here I have to use this settings:
URL: jdbc:interbase://localhost/C:\database\FOO.GDB
Driver: interbase.interclient.Driver
Username:
Use extended properties: YES
Extended properties: user=sysdba,password=masterkey,charSet=Cp1250
With this configuration everything goes fine.
IBConsole:
Here I during registering database set
Default Character Set: WIN1250
But IBConsole has one strange feature (or bug).
If I create database in IBConsole with this default character set, I can't immediately modify the data.
I have to unregister and register again the database.
Then it goes correctly. :-) -
3. Re: Free database and JBoss with correct national encoding
davidjencks Nov 1, 2001 11:38 PM (in response to caba)Did you try including in the XADataSourceLoader config for interbase
charSet=Cp1250;userName=SYSDBA;password=masterkey
?
Remove the userName and Password properties too... of all the ridiculous configuration methods.....grrrr...
I'm not sure if the userName and password are quite right for interclient, check the docs. This will (if the separate userName is missing) make the XADataSourceImpl use DriverManager.getConnection(url, properties) which should give you what you want. -
4. Re: Free database and JBoss with correct national encoding
caba Nov 2, 2001 2:42 PM (in response to caba)Thank you very much, David.
It's OK now.
I wrote comma, not semicolon !!! =:-O
It was my fault, because in JBuilder I have to separate properties by comma.
So. The right configuration is here.
foo/DS
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
charSet=Cp1250;user=SYSDBA;password=masterkey
jdbc:interbase://localhost/C:\database\foo.GDB
Thank you a lot one more time.
Have a nice weekend.