JDBC Connection object in Camel Processor

[contactreji]

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.