1 Reply Latest reply on Mar 28, 2012 3:44 AM by paul odonnell

    jboss 7.1.1 Oracle 9i

    paul odonnell Newbie

      Hi,

      using ojdbc6.jar for my oracle driver on jboss 7.1.1 server. The server starts but later in the hibernate code when I try to

      do execute a querry to my 9i oracle database I get the following errores

       

      12:11:25,703 WARN [org.hibernate.util.JDBCExceptionReporter] (http-localhost-127.0.0.1-8080-2) SQL Error: 17412, SQLState: 99999

      12:11:25,703 ERROR [org.hibernate.util.JDBCExceptionReporter] (http-localhost-127.0.0.1-8080-2) Longitud de tipo mayor que el máximo permitido

      12:11:25,703 INFO [stdout] (http-localhost-127.0.0.1-8080-2)

      : could not execute query

       

      Does jboss 7 work with oracle 9i

       

      Thanks

        • 1. Re: jboss 7.1.1 Oracle 9i
          paul odonnell Newbie

          To answer my own question

          Does jboss 7 work with oracle 9i? Of course it does!!

           

          It's dealt with in this thread

          https://community.jboss.org/thread/169104?start=15&tstart=0

           

          Reference ojdbc14.jar in the module.xml in the

          ..\jboss-as-7.1.1.Final\modules\com\oracle\main directory

           

          then tweek your standalone.xml. the secret is to put in this line

           

            <driver-class>oracle.jdbc.OracleDriver</driver-class>

           

          here

           

          <driver name="oracleDriver" module="com.oracle.ojdbc14">

               <driver-class>oracle.jdbc.OracleDriver</driver-class>

               <xa-datasource-class>

                    oracle.jdbc.xa.client.OracleXADataSource

               </xa-datasource-class>

          </driver>

           

          thanks to Stefano Maestri for this explaination

          "ojdb14.jar isn't a jdbc4 compliant drive, so we can't desume from META-INF

          the dirver class and you have to specify it in standalone.xml this way:"