Hi,
I am trying to configure oracle datasource for jboss
I have put oracle-ds.xml in the deploy directory, and classes111.zip in the deploy/default/lib directory . Also I have modified standardjbosscmp-jdbc.xml like
java:/OracleDS
<datasource-mapping>Oracle8</datasource-mapping>
and and standardjaws.xml like
java:/OracleDS
<type-mapping>Oracle8</type-mapping>
But when I get error in datasource.getConnection()
as follows
Could not create connection; - nested throwable: (java.sql.SQLException: Refused:ROR=(CODE=12505)(EMFI=4))))
what cud be the problem
Thanx in advance
Binny
1) Make sure you aren't using any dot notation in
the SID.
2) Verify the port number
3) Verify the SID name
4) Make sure you have the right driver version. IIRC, classes111.zip is for JDK 1.1.
Mike