You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ode.apache.org by ad...@gmail.com on 2009/07/08 16:43:47 UTC

Oracle 9i issues

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

Re: Oracle 9i issues

Posted by Matthieu Riou <ma...@gmail.com>.
On Wed, Jul 8, 2009 at 7:54 AM, <ad...@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
>

Fwd: Oracle 9i issues

Posted by ad...@gmail.com.
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