First, I see that you're using Oracle-XE. If you're on Windows, be advised that Oracle-XE is only supported on 32bit versions of Windows. I learned the hard way - strange erratic behavior, etc. I advise that if you have 64bit Windows, that you uninstall Oracle-XE and install the standard release:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html What is your deployment environment? Servlet container/webapp? Standalone? Generally it's a good idea to mention the Operating System type and version, Camel version, etc. I am developing our app on 64bit Windows-7 and standard Oracle release 11.2g works find in all deployment modes: standalone app, servlet container and application server. Since I'm using OpenJPA, I am using DBCP connection pooling for standalone and non-managed servlet container (e.g. Jetty) for JBoss, the pooling is managed by JBoss. You should also use the JDBC driver jar that comes with 11.2g: $ORACLE_HOME/jdbc/lib i.e. C:/oraclexe/app/oracle/product/11.2.0/server/jdbc/lib ojdbc6_g.jar or ojdbc6.jar Chris On Thu, May 16, 2013 at 6:42 AM, takidean <takide...@hotmail.fr> wrote: > should id add something here > > > > > <bean id="orsmon" > class="org.springframework.jdbc.datasource.DriverManagerDataSource"> > <property name="driverClassName" value="oracle.jdbc.OracleDriver"/> > <property name="url" value="jdbc:oracle:thin:@localhost:1521:xe"/> > <property name="username" value="smon"/> > <property name="password" value="smon"/> > </bean> > > i add the jar file to the classphath , it works fine for mysql but bugs for > oracle > > the error that i got > > Property 'driverClassName' threw exception; nested exception is > java.lang.IllegalStateException: Could not load JDBC driver class > [oracle.jdbc.OracleDriver] > > > > -- > View this message in context: > http://camel.465427.n5.nabble.com/what-s-wrong-with-oracle-configuration-tp5732673.html > Sent from the Camel - Users mailing list archive at Nabble.com.
