ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From adiaz.nori...@gmail.com
Subject Oracle 9i issues
Date Wed, 08 Jul 2009 14:43:47 GMT
Hi all,

does ODE support Oracle 9i? I have configured with Oracle 10g but not with  
9i.

I have followed this tutorial  
http://bpelsoa.blogspot.com/2008/07/oracle-database-10g-with-apache-ode-12.html
and works great in 10 version


I got the following error while starting Ode with Oracle 9i:

WARN - GeronimoLog.warn(96) | Unable to determine database dialect
java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at  
oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlException(DBError.java:689)
at  
oracle.jdbc.OracleDatabaseMetaData.getDatabaseMajorVersion(OracleDatabaseMetaData.java:4442)
at  
org.apache.ode.scheduler.simple.JdbcDelegate.guessDialect(JdbcDelegate.java:293)
at org.apache.ode.scheduler.simple.JdbcDelegate.<init>(JdbcDelegate.java:78)
at org.apache.ode.axis2.ODEServer.createScheduler(ODEServer.java:458)
at org.apache.ode.axis2.ODEServer.initBpelServer(ODEServer.java:484)
at org.apache.ode.axis2.ODEServer.init(ODEServer.java:161)
at org.apache.ode.axis2.ODEServer.init(ODEServer.java:119)

This is my current configuration:

In tomcat/conf/server.xml in host element I have:

<Context path="/ode" docBase="ode" debug="5" reloadable="true"  
crossContext="true">
<Resource name="jdbc/oracle/ode"
auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30"  
maxWait="10000"
username="ode" password="ode" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:mySid"/>
</Context>

And in \ode\WEB-INF\conf\ode-axis2.properties
ode-axis2.db.mode=EXTERNAL
ode-axis2.db.ext.dataSource=java:comp/env/jdbc/oracle/ode

Again, the same configuration works with Oracle 10g, not with 9i.


thanks in advance

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message