0 Replies Latest reply on Sep 2, 2008 11:30 AM by vaerssv

    secure jdbc connection

    vaerssv

      Hello,

      I'm trying to configure a secure connection to the oracle db we are using.

      we configured a tcps listener on the oracle db, but i don't know how to configure in my oracle-ds.xml...

      for the moment i have this config:

      <xa-datasource>
      <jndi-name>MyDb_JDBC_TX_DATASOURCE</jndi-name>
      <track-connection-by-tx/>
      <isSameRM-override-value>false</isSameRM-override-value>
      <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
      <xa-datasource-property name="URL">jdbc:oracle:thin:@MyServer:1521:MyDb</xa-datasource-property>
      <xa-datasource-property name="User">MyDb_OWNER</xa-datasource-property>
      <xa-datasource-property name="Password">xxxx</xa-datasource-property>

      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

      <no-tx-separate-pools/>


      <type-mapping>Oracle9i</type-mapping>

      <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
      <max-pool-size>50</max-pool-size>
      </xa-datasource>

      this is working fine with normal jdbc connection.

      i tried this config with tcps on the db:

      <xa-datasource>
      <jndi-name>MyDb_JDBC_TX_DATASOURCE</jndi-name>
      <track-connection-by-tx/>
      <isSameRM-override-value>false</isSameRM-override-value>
      <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>

      <xa-datasource-property name="URL">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=MyServer)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=MyDb)))</xa-datasource-property>
      <xa-datasource-property name="User">MyDb_OWNER</xa-datasource-property>
      <xa-datasource-property name="Password">xxxx</xa-datasource-property>

      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

      <no-tx-separate-pools/>


      <type-mapping>Oracle9i</type-mapping>

      <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
      <max-pool-size>50</max-pool-size>
      </xa-datasource>


      but in the log i have the following error:


      INFO 2008-09-02 17:20:18,250 [sib.Logger] () { STDOUT } - [LOG] 2008-09-02, 17:20:18.247 PM CEST [Server:MyApp] [WsId:0]
      Thread[main,5,jboss]
      Class : (StartupLogger)
      ErrorNo : 523101
      ErrorCode : 2
      ExtErrorCode : 2
      Level : Bad Error
      AddInfo : Unsupported Database. Please call support.
      Description : RuntimeException occurred
      PCEDBException@eb49a5(StClass: 0; StCode: 0; ErrorCode: 3; Ext.ErrorCode: 1; Message: {0}
      null)



      does this mean that my oracle-ds config is bad or is it the db that do not respond as expected ?

      many thanks for your help...