1 Reply Latest reply on Feb 20, 2004 12:36 AM by mikefinn

    Data Source problem

    binnyms

      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. Re: Data Source problem
          mikefinn

          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