Does anyone have a sample datasource file for connecting UA to an Oracle
database? I am not a dba and cannot find any examples. Here is what I
have so far, but I don't know what to put for
<valid-connection-checker-class-name> or <type-mapping>


<?xml version="1.0" encoding="UTF-8"?>

<datasources>
<local-tx-datasource>
<jndi-name>IDMUADataSource</jndi-name>

<connection-url>jdbcracle:thin:@sid.mydomain.com:1521/servicename.world</connection-url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<security-domain>EncryptDBPassword</security-domain>
<!-- Valid connection checker class -->
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.Postgr eSQLValidConnectionChecker</valid-connection-checker-class-name>

<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml
(optional) -->
<metadata>
<type-mapping>PostgreSQL 8.0</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>

-Thanks!

Mike K


--
mkijewsk
------------------------------------------------------------------------
mkijewsk's Profile: https://forums.netiq.com/member.php?userid=2181
View this thread: https://forums.netiq.com/showthread.php?t=48264