We would like to change the back-end database for a SOA application, but in data-sources.xml I don't see any database information. I searched and found a connections.xml file under <SOA_home>\applications\<appname>\<appname>\WEB-INF\classes, which is the only place specified database connections. The developer who developed this application has left and I am a OAS admin and has limited knowledge with Jdeveloper. I would like to know
1. if it is possible to convert the database connection to SOA level using data-sources.xml and connect to the new database?
2. If 1 is not possible, and I have to do it in Jdeveloper, generally what steps should I take? I have the source code and a new installation of Jdeveoper.
We are using SOA 10.1.3.5 on Windows server 2008.
And here is the information regarding our application in connections.xml:
<connection>
<JDBC_PORT>2322</JDBC_PORT>
<ConnectionType>JDBC</ConnectionType>
<HOSTNAME>host.mycompany.com</HOSTNAME>
<DeployPassword>true</DeployPassword>
<user>user1</user>
<ConnectionName>appname</ConnectionName>
<ServiceName>dbname</ServiceName>
<PWD>
<![xxxxxxxxxxxxxxxx]]>
</PWD>
<JdbcDriver>oracle.jdbc.OracleDriver</JdbcDriver>
<ORACLE_JDBC_TYPE>thin</ORACLE_JDBC_TYPE>
</connection>
Thanks a lot.
Hailie