<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<style type="text/css">
<!--
/*
The original subSilver Theme for phpBB version 2+
Created by subBlue design
http://www.subBlue.com
NOTE: These CSS definitions are stored within the main page body so that you can use the phpBB2
theme administration centre. When you have finalised your style you could cut the final CSS code
and place it in an external file, deleting this section to save bandwidth.
*/
/* General page style. The scroll bar colours only visible in IE5.5+ */
body {
background-color: #E5E5E5;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11;
color: #000000;
}
/* General font families for common tags */
font,th,td,p { font-family: Verdana, Arial, Helvetica, sans-serif }
p, td { font-size : 11; color : #000000; }
a:link,a:active,a:visited { color : #006699; }
a:hover { text-decoration: underline; color : #DD6900; }
hr { height: 0px; border: solid #D1D7DC 0px; border-top-width: 1px;}
h1,h2 { font-family: "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif; font-size : 22px; font-weight : bold; text-decoration : none; line-height : 120%; color : #000000;}
/* This is the border line & background colour round the entire page */
.bodyline { background-color: #FFFFFF; border: 1px #98AAB1 solid; }
/* General text */
.gen { font-size : 12px; }
.genmed { font-size : 11px; }
.gensmall { font-size : 10px; line-height: 12px}
.gen,.genmed,.gensmall { color : #000000; }
a.gen,a.genmed,a.gensmall { color: #006699; text-decoration: none; }
a.gen:hover,a.genmed:hover,a.gensmall:hover { color: #DD6900; text-decoration: underline; }
/* Forum title: Text and link to the forums used in: index.php */
.forumlink { font-weight: bold; font-size: 12px; color : #006699; }
a.forumlink { text-decoration: none; color : #006699; }
a.forumlink:hover{ text-decoration: underline; color : #DD6900; }
/* The content of the posts (body of text) */
.postbody { font-size : 12px; line-height: 18px}
a.postlink:link { text-decoration: none; color : #006699 }
a.postlink:visited { text-decoration: none; color : #5493B4; }
a.postlink:hover { text-decoration: underline; color : #DD6900}
/* Quote & Code blocks */
.code {
font-family: Courier, 'Courier New', sans-serif; font-size: 11px; color: #006600;
background-color: #FAFAFA; border: #D1D7DC; border-style: solid;
border-left-width: 1px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px
}
.quote {
font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #444444; line-height: 125%;
background-color: #FAFAFA; border: #D1D7DC; border-style: solid;
border-left-width: 1px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px
}
-->
</style>
</head>
<body>
<div class="postbody">Hello all, <br />
<br />
I currently try to set up a JBI file in order to use the storedQuery operation and I'm facing a problem when a message is send to my component.<br />
<br />
The message (in the fault) returned is: <br />
</span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>Code:</b></span></td> </tr> <tr> <td class="code">Failed to process the exchange : NullPointerException : null</td> </tr></table><span class="postbody"><br />
<br />
<br />
Here is my JBI file:<br />
</span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>Code:</b></span></td> </tr> <tr> <td class="code"><?xml version="1.0" encoding="UTF-8"?><br />
<!-- <br />
JBI descriptor for the PEtALS' "petals-bc-xquare" component (XQuare).<br />
Originally created for the version 2.0 of the component.<br />
--><br />
<jbi:jbi version="1.0" <br />
xmlns:interfaceNs="http://petals.ow2.org/components/xquare/version-2.0"<br />
xmlns:jbi="http://java.sun.com/xml/ns/jbi"<br />
xmlns:petalsCDK="http://petals.ow2.org/components/extensions/version-4.0"<br />
xmlns:serviceNs="http://prosodie.com"<br />
xmlns:xquare="http://petals.ow2.org/components/xquare/version-2.0"<br />
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><br />
<br />
<!-- Import a Service into PEtALS or Expose a PEtALS Service => use a BC. --><br />
<jbi:services binding-component="true"><br />
<br />
<!-- Import a Service into PEtALS => provides a Service. --><br />
<jbi:provides <br />
interface-name="interfaceNs:XQuare"<br />
service-name="serviceNs:SqlService"<br />
endpoint-name="SqlServiceEndpoint"><br />
<br />
<!-- CDK specific elements --><br />
<petalsCDK:wsdl>description.wsdl</petalsCDK:wsdl><br />
<br />
<!-- Component specific elements --> <br />
<xquare:url>jdbc:jtds:sqlserver://xxxx:1433/bbb</xquare:url><br />
<xquare:user>sa</xquare:user><br />
<xquare:password>xxx</xquare:password><br />
<xquare:driver>net.sourceforge.jtds.jdbc.Driver</xquare:driver><br />
<xquare:mapping>mapping.map</xquare:mapping><br />
<xquare:maxActive>8</xquare:maxActive><br />
<xquare:maxIdle>8</xquare:maxIdle><br />
<xquare:minIdle>0</xquare:minIdle><br />
<xquare:maxWait>-1</xquare:maxWait><br />
<xquare:timeBetweenEvictionRunsMillis>-1</xquare:timeBetweenEvictionRunsMillis><br />
<br />
<xquare:storedQueries><br />
<xquare:storedQuery id="0"><![CDATA[<br />
declare variable $serialNumber as xs:string external<br />
<result> {<br />
for $u in collection("_userData")/_userData[serialNumber = $serialNumber]<br />
return $u<br />
} </result>]]><br />
</xquare:storedQuery><br />
</xquare:storedQueries> <br />
</jbi:provides><br />
</jbi:services><br />
</jbi:jbi></td> </tr></table><span class="postbody"><br />
<br />
The input message:<br />
</span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>Code:</b></span></td> </tr> <tr> <td class="code"><storedQuery id="0"><br />
<param name="serialNumber">269</param><br />
</storedQuery></td> </tr></table><span class="postbody"><br />
<br />
The message in the petals console is:<br />
</span><table width="90%" cellspacing="1" cellpadding="3" border="0" align="center"><tr> <td><span class="genmed"><b>Code:</b></span></td> </tr> <tr> <td class="code">[Petals.Container.Components.petals-bc-xquare]-SEVERE 2009-08-26 18:14:23,752 null<br />
java.lang.NullPointerException<br />
at org.ow2.petals.component.framework.util.XMLUtil.getAttributeValue(XMLUtil.java:354)<br />
at org.ow2.petals.bc.xquare.provide.XQuareBCJBIListener.getStoredQuery(XQuareBCJBIListener.java:479)<br />
at org.ow2.petals.bc.xquare.provide.XQuareBCJBIListener.doStoredQuery(XQuareBCJBIListener.java:385)<br />
at org.ow2.petals.bc.xquare.provide.XQuareBCJBIListener.onJBIMessage(XQuareBCJBIListener.java:229)<br />
at org.ow2.petals.component.framework.listener.MessageExchangeProcessor.processInOutAsProvider(MessageExchangeProcessor.java:524)<br />
at org.ow2.petals.component.framework.listener.MessageExchangeProcessor.processAsProvider(MessageExchangeProcessor.java:421)<br />
at org.ow2.petals.component.framework.listener.MessageExchangeProcessor.process(MessageExchangeProcessor.java:308)<br />
at org.ow2.petals.component.framework.listener.MessageExchangeProcessor.run(MessageExchangeProcessor.java:145)<br />
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)<br />
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)<br />
at java.lang.Thread.run(Unknown Source)</td> </tr></table><span class="postbody"><br />
<br />
Could you tell me how to configure a storedQuery in a JBI XQuare component file and what is wrong in my case?<br />
<br />
Thank you.</div>
<br /><div class="gensmall"><br />
<br />
<br />
-------------------- m2f --------------------<br />
<br />
Read this forum topic online here:<br />
<a href="http://petals.ebmwebsourcing.com/forum/viewtopic.php?p=890#890" target="_blank">http://petals.ebmwebsourcing.com/forum/viewtopic.php?p=890#890</a><br />
<br />
-------------------- m2f --------------------</div>
</body>
</html>