mysql jdbc connection setup issue

[longsha1223]

Hi All ,

I have put a bean about mysql connection in my camleContext.xml  :

<bean id="databaseConnection" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

  <property name="driverClassName" value="com.mysql.jdbc.Driver" />

  <property name="url" value="jdbc:mysql://localhost:3306/employees" />

  <property name="username" value="root" />

  <property name="password" value="abc123@" />

  </bean>

when i run the xml with no test , i got some error message :

[ERROR] *************************************

[ERROR] Error occurred while running main from: org.apache.camel.spring.Main

[ERROR]

java.lang.reflect.InvocationTargetException

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:606)

  at org.apache.camel.maven.RunMojo$1.run(RunMojo.java:487)

  at java.lang.Thread.run(Thread.java:744)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'databaseConnection' defined in file [/home/neo/jbdevstudio/workspace/camel-amq/target/classes/META-INF/spring/camelListner.xml]: Error setting property values; nested exception is 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 [com.mysql.jdbc.Driver]

  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1453)

  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)

  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)

  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)

  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:296)

  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)

  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:293)

  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)

  at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:628)

  at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932)

  at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)

  at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)

  at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93)

  at org.apache.camel.spring.Main.createDefaultApplicationContext(Main.java:186)

  at org.apache.camel.spring.Main.doStart(Main.java:140)

  at org.apache.camel.support.ServiceSupport.start(ServiceSupport.java:61)

  at org.apache.camel.main.MainSupport.run(MainSupport.java:148)

  at org.apache.camel.main.MainSupport.run(MainSupport.java:352)

  at org.apache.camel.spring.Main.main(Main.java:73)

  ... 6 more

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 [com.mysql.jdbc.Driver]

  at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:101)

  at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:57)

  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1450)

  ... 24 more

[ERROR] *************************************

How can I resolve this exception ?

Thanks ,

Best regards.

[davsclaus]

Hi

I suggest to take a look at the Camel SQL example

http://camel.apache.org/sql-example.html

And check its source code

camel/examples/camel-example-sql at master · apache/camel · GitHub

How the Camel application is packaged as an OSGi bundle and how to install the JDBC driver using the osgi:install commands from the Karaf shell.

[ffang]

Hi,

I believe this is caused by that the spring-jdbc bundle not Import-Package of mysql driver, so that the Class.forName(jdbc.driver.classname) way to load the jdbc driver doesn't work in OSGi container, I've written a blog[1] about the details and also the solutions there.

[1]http://freemanfang.blogspot.com/2012/03/how-to-use-jdbc-driver-in-osgi.html

Freeman

[longsha1223]

Hi , I have resolve the library loading issue ,

but when i connect to mysql instance through jdbc , I always get the exception :

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

I have do some actions as below but no usable :

use mysql;
select host,user,password from mysql.user;
update mysql.user set password = PASSWORD('123456') where password = '';

GRANT ALL PRIVILEGES ON employees.* TO 'root'@'%';

GRANT ALL PRIVILEGES ON employees.* TO 'root'@'127.0.0.1';

GRANT ALL PRIVILEGES ON employees.* TO 'root'@'localhost';
flush privileges;

How can I resolve the 'access denied for root@localhost' issue ?

thanks ,

Best regards.

[davsclaus]

I am not sure how to do that, as that would be a MySQL problem.

I think you have better luck asking on MySQL user forums / documentation how to setup user privileges.

You can also try to login to the mysql database from a sql shell, and see if the username / password works.