what's wrong with oracle configuration

[takidean <ta...@hotmail.fr>]

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.

Re: what's wrong with oracle configuration

[Chris Wolf <cw...@gmail.com>]

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 <ta...@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.