[Users] SQL

nch underscore_dot at yahoo.com
Wed Mar 16 10:59:38 CET 2011 

Hi, all.

I deployed petals-bc-sql and petals-sl-mysql-5.1.10 into Petals ESB 3.0.5
I developed an SQL service unit to provide into Petals through the corresponding PetalsStudio 1.0 wizard. I configured it to access a MySQL database.
After creating this SU, I exported it into a zipped service asembly and tried to deploy it. Petals activates de SU but fails to start it. Apparently it is not being able to load com.mysql.jdbc.Driver.
I found MySQL connector jar file into petals-sl-mysql-5.1.10 and into Petals ESB lib directory, so I can't figure out why it can't load it.

Any suggestions on how to solve this issue?
Regards


FINEST 2010-06-02 18:49:24,534 [Petals.Container.Components.petals-bc-sql]
    Create a dataSource with parameters :
FINEST 2010-06-02 18:49:24,534 [Petals.Container.Components.petals-bc-sql]
    url           :jdbc:mysql://localhost:3306/test
driver        :com.mysql.jdbc.Driver
user          :root
password      :root
maxActive     :8
maxIdle       :8
minIdle       :0
maxWait       :-1
timeBEviction :-1
INFO 2010-06-02 18:49:24,534 [Petals.Container.Components.petals-bc-sql]
    DataSource for {http://petals.ow2.org/components/sql/version-1}mysql-mysqlEndpoint created
INFO 2010-06-02 18:49:24,534 [Petals.Container.Components.petals-bc-sql]
    Service Unit 'su-SQL-mysql-provide' deployed
FINEST 2010-06-02 18:49:24,534 [Petals.JBI-Messaging.RouterServiceImpl]
    -START-RouterServiceImpl.modifiedSALifeCycle()
FINEST 2010-06-02 18:49:24,550 [Petals.JBI-Messaging.RouterServiceImpl]
    -END-RouterServiceImpl.modifiedSALifeCycle()
INFO 2010-06-02 18:49:24,628 [Petals.JBI-Management.DeploymentServiceImpl]
    DeploymentServiceImpl.deploy() Service Assembly 'sa-SQL-mysql-provide' deployed
FINEST 2010-06-02 18:49:24,628 [Petals.JBI-Management.DeploymentServiceImpl]
    -END-DeploymentServiceImpl.deploy()
FINEST 2010-06-02 18:49:24,628 [Petals.JBI-Management.DeploymentServiceImpl]
    -START-DeploymentServiceImpl.start()
FINEST 2010-06-02 18:49:24,628 [Petals.Container.ServiceAssemblyLifeCycle.sa-SQL-mysql-provide]
    -START-LifeCycleAbstract.start()
INFO 2010-06-02 18:49:24,628 [Petals.Container.Components.petals-bc-sql]
    Init Service Unit 'su-SQL-mysql-provide'
INFO 2010-06-02 18:49:24,628 [Petals.Container.Components.petals-bc-sql]
    Start Service Unit 'su-SQL-mysql-provide'
SEVERE 2010-06-02 18:49:24,628 [Petals.Container.ServiceAssemblyLifeCycle.sa-SQL-mysql-provide]
    Failed to start the Service Unit 'su-SQL-mysql-provide'
javax.jbi.management.DeploymentException: Failed to start the Service Unit 'su-SQL-mysql-provide'
	at org.ow2.petals.component.framework.su.AbstractServiceUnitManager.start(AbstractServiceUnitManager.java:617)
	at org.ow2.petals.container.lifecycle.ServiceUnitLifeCycle.start(ServiceUnitLifeCycle.java:161)
	at org.ow2.petals.container.lifecycle.ServiceAssemblyLifeCycle.doStart(ServiceAssemblyLifeCycle.java:166)
	at org.ow2.petals.container.lifecycle.LifeCycleAbstract.start(LifeCycleAbstract.java:185)
	at org.ow2.petals.jbi.management.deployment.DeploymentServiceImpl.start(DeploymentServiceImpl.java:533)
	at org.objectweb.fractal.julia.generated.C7949fad8_0.start(INTERCEPTOR[DeploymentServiceMBean])
	at org.objectweb.fractal.julia.generated.C7566203_0.start(INTERFACE[DeploymentServiceMBean])
	at org.ow2.petals.jbi.management.autoload.AutoLoaderServiceImpl.performDeploySA(AutoLoaderServiceImpl.java:450)
	at org.ow2.petals.jbi.management.autoload.AutoLoaderServiceImpl.install(AutoLoaderServiceImpl.java:169)
	at org.ow2.petals.jbi.management.autoload.InstallDirectoryScanner.run(InstallDirectoryScanner.java:81)
	at java.util.TimerThread.mainLoop(Timer.java:512)
	at java.util.TimerThread.run(Timer.java:462)
Caused by: org.ow2.petals.component.framework.api.exception.PEtALSCDKException: Can not reach the target database
	at org.ow2.petals.bc.sql.su.SUManager.doStart(SUManager.java:154)
	at org.ow2.petals.component.framework.su.AbstractServiceUnitManager.start(AbstractServiceUnitManager.java:615)
	... 11 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at org.ow2.petals.bc.sql.su.SUManager.doStart(SUManager.java:150)
	... 12 more
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
	at org.ow2.petals.system.classloader.ComponentClassLoader.loadClass(ComponentClassLoader.java:129)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:169)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130)
	... 14 more
FINEST 2010-06-02 18:49:24,628 [Petals.JBI-Messaging.RouterServiceImpl]
    -START-RouterServiceImpl.modifiedSALifeCycle()
FINEST 2010-06-02 18:49:24,628 [Petals.JBI-Messaging.RouterServiceImpl]
    -END-RouterServiceImpl.modifiedSALifeCycle()
SEVERE 2010-06-02 18:49:24,643 [Petals.JBI-Management.DeploymentServiceImpl]
    Unable to start the service assembly 'sa-SQL-mysql-provide'
javax.jbi.JBIException: An exception occured while starting the Service Assembly 'sa-SQL-mysql-provide' : Failed to start the Service Unit 'su-SQL-mysql-provide'
	at org.ow2.petals.container.lifecycle.LifeCycleAbstract.start(LifeCycleAbstract.java:196)
	at org.ow2.petals.jbi.management.deployment.DeploymentServiceImpl.start(DeploymentServiceImpl.java:533)
	at org.objectweb.fractal.julia.generated.C7949fad8_0.start(INTERCEPTOR[DeploymentServiceMBean])
	at org.objectweb.fractal.julia.generated.C7566203_0.start(INTERFACE[DeploymentServiceMBean])
	at org.ow2.petals.jbi.management.autoload.AutoLoaderServiceImpl.performDeploySA(AutoLoaderServiceImpl.java:450)
	at org.ow2.petals.jbi.management.autoload.AutoLoaderServiceImpl.install(AutoLoaderServiceImpl.java:169)
	at org.ow2.petals.jbi.management.autoload.InstallDirectoryScanner.run(InstallDirectoryScanner.java:81)
	at java.util.TimerThread.mainLoop(Timer.java:512)
	at java.util.TimerThread.run(Timer.java:462)
SEVERE 2010-06-02 18:49:24,643 [Petals.AutoLoaderServiceImpl]
    Error during the deployment of a service assembly: 
java.lang.Exception: An exception occured while starting the Service Assembly 'sa-SQL-mysql-provide' : Failed to start the Service Unit 'su-SQL-mysql-provide'
	at org.ow2.petals.jbi.management.deployment.DeploymentServiceImpl.start(DeploymentServiceImpl.java:544)
	at org.objectweb.fractal.julia.generated.C7949fad8_0.start(INTERCEPTOR[DeploymentServiceMBean])
	at org.objectweb.fractal.julia.generated.C7566203_0.start(INTERFACE[DeploymentServiceMBean])
	at org.ow2.petals.jbi.management.autoload.AutoLoaderServiceImpl.performDeploySA(AutoLoaderServiceImpl.java:450)
	at org.ow2.petals.jbi.management.autoload.AutoLoaderServiceImpl.install(AutoLoaderServiceImpl.java:169)
	at org.ow2.petals.jbi.management.autoload.InstallDirectoryScanner.run(InstallDirectoryScanner.java:81)
	at java.util.TimerThread.mainLoop(Timer.java:512)
	at java.util.TimerThread.run(Timer.java:462)
FINEST 2010-06-02 18:49:24,643 [Petals.AutoLoaderServiceImpl]
    -END-AutoLoaderServiceImpl.install()




-------------------- m2f --------------------

Subscribe/Unsubscribe emails notifications.

Response to this email will be posted on the Petals forum.
Please delete the existing text before responding :)

Read the topic online:
http://forum.petalslink.com/viewtopic.php?p=31067#31067

-------------------- m2f --------------------

More information about the Users mailing list