I am however able to connect to SQL Server DB using the given DB name, user name and password via SQL Server Management Studio client and can run select and insert queries directly.
For SQL Server driver name, I used the reference from https://access.redhat.com/site/documentation/en-US/Fuse_ESB_Enterprise/7.1/html/EIP_Transaction_Guide/files/TxnManagers-Samples-JDBC.html site to get the value. It says driver name should be com.microsoft.jdbc.sqlserver.SQLServerDriver but sqljdbc4 jar does not contain this class and rather the class name is com.microsoft.sqlserver.jdbc.SQLServerDriver. That was one difference. If there are ways to get more debug information to fix this issue? Thanks Shiv -- View this message in context: http://camel.465427.n5.nabble.com/java-lang-NullPointerException-in-Camel-JDBC-component-for-Select-statement-tp5750783p5750788.html Sent from the Camel - Users mailing list archive at Nabble.com.
