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.(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
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"/>
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
