Hello again! I've resolved my problem, nothing was wrong with the ode configuration, except that I was not using the correct Oracle driver for the correct Oracle version.
So in my case I was using Oracle 9 driver instead of Oracle 10 driver. So I've changed the driver and the hibernate settings and everything works OK for now. I still have errors but are of a different kind. I've changed the Hibernate Configuration with: hibernate.dialect=org.hibernate.dialect.Oracle10gDialect Victor Chirita wrote: > > Hello to everybody, > > This is my first post here and I'm asking for your help with the matter in > the title. > > I've been trying to configure Ode to use Hibernate as persistency layer in > Tomcat 6.0.18 with Oracle 9 as database for a few days now and no luck. > I'll be very grateful if someone can point me in the right direction with > this since I've not been able to find information on how to configure it. > I've read the messages on > http://www.nabble.com/Apache-Ode-User-f16255.html but with no luck finding > what I need. I want to know the necessary steps to make the configuration > run. > > > What I did: > deployed in Tomcat apache-ode-war-1.2 - OK (with derby database) > after test with derby which is ok, I tried to switch to Oracle (the > database that we currently use) > changed ode\WEB-INF\conf\ode-axis2.properties with the following entries: > > # ODE Configuration > # Database mode property specify whether to use embedded db or external. > ode-axis2.db.mode=EXTERNAL > # Previously created data source name. > ode-axis2.db.ext.dataSource=java:comp/env/jdbc/OdeDb > > ode-axis2.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl > org.hibernate.dialect.Dialect=org.hibernate.dialect.Oracle9Dialect > > ## Process dehydration > ## wait for 5 minutes instead of 20 minutes > ode-axis2.process.dehydration.maximum.age=300000 > > # allow not more than 500 processes to be in memory at once > ode-axis2.process.dehydration.maximum.count=500 > > is it ok to add to the same file the following: > # Hibernate Configuration > hibernate.hbm2ddl.auto=update > for hibernate? > > added the file context.xml in ode\META-INF\context.xml with the following > contents: > <Context path="/ode" docBase="ode" debug="5" reloadable="true" > crossContext="true"> > <Resource name="jdbc/OdeDb" auth="Container" > type="javax.sql.DataSource" maxActive="100" maxIdle="30" > maxWait="10000" > username="ode" password="bapro77" > driverClassName="oracle.jdbc.OracleDriver" > url="jdbc:oracle:thin:@192.168.0.5:1521:BAPRO"/> > </Context> > > added the folowing jars to tomcat\lib (as specified in the tomcat6 > configuration) > antlr-2.7.6.jar > asm-1.5.3.jar > cglib-2.1_3.jar > ehcache-1.2.3.jar > hibernate-3.2.5.ga-bundle.jar > ojdbc14.jar > > no jars added to web-inf/lib of deployed war file. > > The output of the console is: > ... ... ... > DEBUG - GeronimoLog.debug(66) | Loading properties > DEBUG - GeronimoLog.debug(66) | Initializing transaction manager > DEBUG - GeronimoLog.debug(66) | Initializing transaction manager using > org.apache.ode.il.EmbeddedGeronimoFactory > DEBUG - GeronimoLog.debug(66) | Creating data source. > DEBUG - GeronimoLog.debug(66) | Starting DAO. > INFO - GeronimoLog.info(79) | Using DAO Connection Factory class > org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl. > May 8, 2009 4:33:03 AM org.apache.coyote.http11.Http11AprProtocol start > INFO: Starting Coyote HTTP/1.1 on http-8080 > May 8, 2009 4:33:03 AM org.apache.coyote.ajp.AjpAprProtocol start > INFO: Starting Coyote AJP/1.3 on ajp-8009 > May 8, 2009 4:33:03 AM org.apache.catalina.startup.Catalina start > INFO: Server startup in 31540 ms > > NO ERRORS but the init of the BPEL Server does not occur. > > Please help me to resolve this problem since after 3 days it starts to > drive me crazy and i'm feeling i'm loosing my sense. Please advise if it > is easier to switch to OpenJPA and how to do that. > -- View this message in context: http://www.nabble.com/ApacheODE-1.2-%2B-Hibernate-%2B-Tomcat-6.0.18-on-Oracle-9-configuration-Problems-tp23442676p23592886.html Sent from the Apache Ode User mailing list archive at Nabble.com.
