[Users] "Cannot load JDBC driver class" when using bc-sql

[Dungnghe]

Hi all,
I have a problem when trying to test bc-sql with HSQLDB, i receive a Fault when try to send IN message like that:


Code:
FAULT : <?xml version="1.0" encoding="UTF-8" standalone="no"?><soapenv:Fault xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><faultcode>soapenv:Server</faultcode><faultstring><![CDATA[org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.hsqldb.jdbcDriver']]></faultstring><faultactor>http://petals.ow2.org/exception</faultactor><detail><stackTrace><![CDATA[org.ow2.petals.component.framework.api.exception.SOAP11FaultServerException: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.hsqldb.jdbcDriver'

	at org.ow2.petals.component.framework.process.MessageExchangeProcessor.processInOutAsProvider(MessageExchangeProcessor.java:657)

	at org.ow2.petals.component.framework.process.MessageExchangeProcessor.processAsProvider(MessageExchangeProcessor.java:382)

	at org.ow2.petals.component.framework.process.MessageExchangeProcessor.process(MessageExchangeProcessor.java:242)

	at org.ow2.petals.component.framework.process.MessageExchangeProcessor.run(MessageExchangeProcessor.java:176)

	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

	at java.lang.Thread.run(Unknown Source)

]]></stackTrace></detail></soapenv:Fault>



My IN message:

Code:
<sql xmlns="http://petals.ow2.org/components/sql/version-1">
  <sql show-metadata="true">SELECT index FROM topic WHERE name='AA'</sql>
</sql>



my Su content:

Code:
 service-unit.zip
   + META-INF
       - jbi.xml
       - SQLInterfaces.wsdl
       - SQLServices.wsdl
       + repository
           - repository.properties
           - repository.scripts



and my Jbi.xml

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!-- 
	JBI descriptor for the PEtALS' "petals-bc-sql" component (SQL).
	Originally created for the version 1.0 of the component.
 -->
<jbi:jbi version="1.0" 
	xmlns:interfaceNs="http://petals.ow2.org/components/sql/version-1"
	xmlns:jbi="http://java.sun.com/xml/ns/jbi"
	xmlns:petalsCDK="http://petals.ow2.org/components/extensions/version-5"
	xmlns:serviceNs="http://petals.ow2.org/integration"
	xmlns:sql="http://petals.ow2.org/components/sql/version-1"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	
	<!-- Import a Service into PEtALS or Expose a PEtALS Service => use a BC. -->
	<jbi:services binding-component="true">
	
		<!-- Import a Service into PEtALS => provides a Service. -->
		<jbi:provides 		
			interface-name="interfaceNs:SQL"
			service-name="serviceNs:HSQLTest"
			endpoint-name="HSQLTestEndpoint">
	
			<!-- CDK specific elements -->
			<petalsCDK:wsdl>SQLService.wsdl</petalsCDK:wsdl>
			<petalsCDK:message-properties>
				<petalsCDK:message-property message="in" name="metadata">true</petalsCDK:message-property>
			</petalsCDK:message-properties>
		
			<!-- Component specific elements -->	
			<sql:url>jdbc:hsqldb:file:/repository</sql:url>
			<sql:user>sa</sql:user>
			<sql:password></sql:password>
			<sql:streamingMode>false</sql:streamingMode>
			<sql:maxActive>8</sql:maxActive>
			<sql:maxIdle>8</sql:maxIdle>
			<sql:minIdle>0</sql:minIdle>
			<sql:maxWait>-1</sql:maxWait>
			<sql:timeBetweenEvictionRunsMillis>-1</sql:timeBetweenEvictionRunsMillis>			
		</jbi:provides>
	</jbi:services>
</jbi:jbi>



i have deployed already Shared librares SL-JDBC-HSQL but not work.
can anyone give me some advice?




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

Unsuscribe/Suscribe Petals forum notificationWBR:>
Read this forum topic online here:
http://petals.ebmwebsourcing.com/forum/viewtopic.php?p=30303#30303

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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://forum-list.petalslink.org/pipermail/users/attachments/20110316/5da945f1/attachment.htm>