[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - 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 at 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... 


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4173763#4173763

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4173763