1 Reply Latest reply on Oct 30, 2002 6:32 AM by noir

    Interbase and UTF (final Battle) Jboss3.0.X

    roomy

      It seems to be NOT possible to set Character Encoding for Datasources in jboss 3.0.0 (in gerneral).
      I think most DB-Vendors expect a special Property when opening a DB-Connection.
      For Interbase this is charSet (i.e. given as UNICODE_FSS).
      I took a look in the JBoss Code
      org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory
      and i didnt find ANY support for Encoding. (hope this is the right place).
      wouldnt it be possible to add a more general way to specifiy Parameters for a JDBC Connect than to add fully static Properties in the ...service.xml File ?
      Right now you can only give URL, Username/password transaction, Driver
      This could look like this
      <config-property name="UserProperty" type="java.lang.String">charSet$UNICODE_FSS</config-property>
      So the user could add the necessary Properties on his own.
      charSet$UNICODE_FSS could mean add connection property charSet with Value UNICODE_FSS (you will find better separators than $)

      the java code would require a corresponding Property UserProperty which processes such user properties.

      Hm I hope you got an idea what i am talking about ?

      Volker

        • 1. Re: Interbase and UTF (final Battle) Jboss3.0.X
          noir

          Strange. There is such support in Jboss 2.x, where an arbitrary attributes could be sent to driver like this:


          DefaultDS
          org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
          jdbc:interbase://localhost/D:/firebird/devel/data.gdb
          user=SYSDBA;password=masterkey";charSet=UTF8



          I do not belive they really removed it in Jboss3. Try to look more.