ode-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthieu Riou <matthieu.r...@gmail.com>
Subject Re: Oracle 9i issues
Date Wed, 08 Jul 2009 17:25:35 GMT
On Wed, Jul 8, 2009 at 7:54 AM, <adiaz.noriega@gmail.com> 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
>

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