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

jboss 7.1.1 Oracle 9i

podonnell Mar 27, 2012 6:12 AM

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

podonnell Mar 28, 2012 3:44 AM (in response to podonnell)

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:"
Actions