9 Replies Latest reply on Jul 13, 2011 11:29 AM by Simon Martinelli

    JBoss 7 and OracleDriver

    Simon Martinelli Novice

      Hi,

       

      I installed ojdbc6.jar as module.

      This seams to work as I can see:

      Deploying JDBC-compliant driver class oracle.jdbc.OracleDriver (version 11.2)

       

      The I created a datasource in standalone.xml

       

      <datasource jndi-name="java:jboss/jdbc/shop" pool-name="ShopDS" enabled="true" use-java-context="true">

        <connection-url>jdbc:oracle:thin:localhost:1521:xe</connection-url>

        <driver>ojdbc6</driver>

        <pool></pool>

        <security>

          <user-name>shop</user-name>

          <password>shop</password>

        </security>

        <validation></validation>

        <timeout></timeout>

        <statement></statement>

      </datasource>   

       

      This seams to work as well and then Hibernate tries to access the data source.

      Then something strange happens. I get a Oracle Exception:

       

      ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

       

      There seams to happen something strange when creating the connection.

       

      Does anybody have JBoss 7 with Oracle Driver up and running?

       

      Thanks for you help.

      Simon