2009-11-04 10:36:49 UTC
Hi all,
The full error msg is 'com.servingxml.util.system.DefaultLogger error SEVERE: Error in element sx:sqlConnectionPool. Creation of JDBC Connection Pool failed. No suitable driver found for jdbc:oracle:thin:@kl-lx-oracle4:1521:kl41'.
The resource script is shown below:
<?xml version="1.0"?>
<sx:resources xmlns:sx="http://www.servingxml.com/core">
<sx:service id="employees">
<sx:serialize>
<sx:content ref="employees"/>
</sx:serialize>
</sx:service>
<sx:recordContent id="employees">
<sx:sqlReader>
<sx:sqlConnectionPool ref="jdbcPool"/>
<sx:parameter name="jobList">
<sx:toString value="{$job}" separator=",">
<sx:quoteSymbol character="'" escapeCharacter="'"/>
</sx:toString>
</sx:parameter>
<sx:sqlQuery recordType = "employee">
SELECT EMPNO, ENAME AS NAME, JOB FROM EMP WHERE JOB = '{$job}'
</sx:sqlQuery>
</sx:sqlReader>
<sx:recordMapping ref="employeesToXml"/>
</sx:recordContent>
<sx:recordMapping id="employeesToXml">
<employees>
<sx:groupBy fields="JOB">
<sx:elementMap element="{JOB}">
<sx:onRecord>
<employee>
<sx:fieldAttributeMap field="EMPNO" attribute="employee-no"/>
<sx:fieldElementMap field="NAME" element="name"/>
</employee>
</sx:onRecord>
</sx:elementMap>
</sx:groupBy>
</employees>
</sx:recordMapping>
<sx:sqlConnectionPool id="jdbcPool"
driver="oracle.jdbc.driver.OracleDriver"
databaseUrl="jdbc:oracle:thin:@kl-lx-oracle4:1521:kl41"
user="{$user}"
password="{$password}"
minConnections="2"
testStatement="SELECT * FROM DUAL"/>
</sx:resources>
I am very new to this tool. I hope anyone can help me on this. Thks in advance. :)
