On Wed, Jul 8, 2009 at 7:54 AM, <[email protected]> wrote: > Hi all, > > does ODE support Oracle 9i? I have configured with Oracle 10g but not with > 9i. >
Try to set the dialect explicitly, in ode-axis2.properties add the following: hibernate.dialect=org.hibernate.dialect.Oracle9Dialect It should help. Matthieu > > 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 >
