Create/Configure a connection pool in Spring and inject this into your
Processor, which you should also create/configure in Spring.
Best,
Christian
Am 25.02.2014 07:48 schrieb "contactreji" <contactr...@gmail.com>:
> Hi
>
> I am trying to do a database operation inside a Processor class.
>
> I have a code
>
> *private static Connection createConnection() {
> Connection conn=null;
>
> try {
> Class.forName("com.mysql.jdbc.Driver");
>
> // Get a connection
>
> } catch (Exception except) {
> LOGGER.info("Error Loading Driver Class");
> except.printStackTrace();
> }
> try {
> conn =
> DriverManager.getConnection(dbURL,"root","");
> } catch (SQLException e) {
> LOGGER.info("Error initializing the connection
> object from Driver
> Manager");
> // TODO Auto-generated catch block
> e.printStackTrace();
> }
> return conn;
> }*
>
>
> I get following log
>
> *12:12:23,609 | INFO | sumer[EAMBuffer] | DBActions
> | 271 - com.outotec.asset-down-time - 1.0.0 | Error Loading Driver Class
> 12:12:23,675 | INFO | sumer[EAMBuffer] | DBActions
> |
> 271 - com.outotec.asset-down-time - 1.0.0 | Error initializing the
> connection object from Driver Manager*
>
> This happens only when the project is deployed to Jboss Fuse. The same
> works
> fine when I run the program in Maven standalone using camel:run maven goal.
>
>
> *Is there any specific way in camel projects to obtain a connection object
> using spring configuration/java dsl to use the object in my java
> processor.*
> According to my requirement, I don't want to do it via camel SQL component.
>
> Please suggest
>
> Regards
> Reji Mathews
>
>
>
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/JDBC-Connection-object-in-Camel-Processor-tp5747896.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>
