Hi,
I have a DSL Route that run a query in SqlServer 2008, but when i'm deploying my route, a error is generated...
Caused by: org.springframework.beans.PropertyBatchUpdateException; nested PropertyAccessExceptions (1) are:
PropertyAccessException 1: org.springframework.beans.MethodInvocationException: Property 'driverClassName' threw exception; nested exception is java.lang.IllegalStateException: Could not load JDBC driver class
I wrapped the sqlserver4.jar in a bundle (with the BND tool) and it's deployed with no errors.
10:14:45,615 | INFO | Timer-0 | FileMonitor | x.kernel.filemonitor.FileMonitor 374 | Deploying: C:\progress\fuse-esb-4.1.0.2\deploy\sqljdbc4.jar
10:14:45,775 | INFO | Timer-0 | FileMonitor | x.kernel.filemonitor.FileMonitor 550 | Started: sqljdbc4
I instaled the features: camel-jdbc and camel-sql.
This route works when I run it from the command line.
My route:
from("file:xxx").choice().when(xpath("/person/city = 'London'")).to("file:c:xxx").otherwise().setBody(constant("INSERT INTO MyTable values ('test1','test2')")).to("file:xxx").to("jdbc:dataSource");
My beans.xml
Any suggestions?
Hi,
I think you should import package
com.microsoft.sqlserver.jdbc.SQLServerDriver
in your maven-bundle-plugin configuration.
Freeman