jsp and xquery exception help

, ,
1

I am passing a query into Tamino through a jsp page and can not get rid of a exception. The xquery works fine when I try it in the Tamino Xquery tool.

It is querying a collection called Graphics which has two instances in there:

<?xml version="1.0" encoding="utf-8"?>
<graphic id="X4220EB00020000P00.L010003" xmlns:ino="http://namespaces.softwareag.com/tamino/response2">
	<system id="42" title="Example system">
		<subsystem id="24" title="example subsystem">
			<task id="J-15HA---4829940482" title="901-266-551-101 PROOF LOAD TEST SPONSON FUEL CELLS SLING ASSEMBLY TASK REQUIREMENTS">
				<useableon>
					<uoc>17492</uoc>
					<uoc>175433</uoc>
				</useableon>
				<step num="1">
					<useableon>
						<uoc>17492</uoc>
					</useableon>
				</step>
				<step num="2">
					<useableon>
						<uoc>17492</uoc>
					</useableon>
				</step>
			</task>
		</subsystem>
	</system>
	<descriptivename>Example Descriptive Name</descriptivename>
	<versions>
		<datetime date="2005-10-23" time="T17:40:14" uri="http://phl-file-01/graphics/X4220EB00010000P00.L010003.cgm"/>
		<datetime date="2005-11-23" time="T17:40:14" uri="http://phl-file-01/graphics/X4220EB00010000P00.L010003.cgm"/>
		<datetime date="2005-10-23" time="T17:40:14" uri="http://phl-file-01/graphics/X4220EB00010000P00.L010003.cgm"/>
	</versions>
	<hotspots>
		<hotspot>X4220EB00010000P00.L010003</hotspot>
	</hotspots>
	<type>PUB</type>
	<format>CGM</format>
</graphic>
<?xml version="1.0" encoding="utf-8"?>
<graphic id="X4220EB00010000P00.L010003" xmlns:ino="http://namespaces.softwareag.com/tamino/response2">
	<system id="15" title="Example system">
		<subsystem id="HA" title="example subsystem">
			<task id="J-15HA---4829940482" title="901-266-551-101 PROOF LOAD TEST SPONSON FUEL CELLS SLING ASSEMBLY TASK REQUIREMENTS">
				<useableon>
					<uoc>16492</uoc>
					<uoc>165433</uoc>
				</useableon>
				<step num="1">
					<useableon>
						<uoc>16492</uoc>
					</useableon>
				</step>
				<step num="2">
					<useableon>
						<uoc>16492</uoc>
					</useableon>
				</step>
			</task>
		</subsystem>
	</system>
	<descriptivename>Example Descriptive Name</descriptivename>
	<versions>
		<datetime date="2005-10-23" time="T17:40:14" uri="http://phl-file-01/graphics/X4220EB00010000P00.L010003.cgm"/>
		<datetime date="2005-11-23" time="T17:40:14" uri="http://phl-file-01/graphics/X4220EB00010000P00.L010003.cgm"/>
		<datetime date="2005-10-23" time="T17:40:14" uri="http://phl-file-01/graphics/X4220EB00010000P00.L010003.cgm"/>
	</versions>
	<hotspots/>
	<type>PUB</type>
	<format>JPEG</format>
</graphic>

this is the code I am calling the xquery with:

String DATABASE_URI = "http://---.---.---.---/tamino/CDDE";

TConnection connection = TConnectionFactory.getInstance().newConnection( DATABASE_URI );
TXMLObjectAccessor xmlObjectAccessor = connection.newXMLObjectAccessor(TAccessLocation.newInstance( "Graphics" ),TDOMObjectModel.getInstance() );
StringBuffer queryBuffer = new StringBuffer();

queryBuffer.append("for $x in input()/graphic");
queryBuffer.append("return <option value={data($x/system/@id)}>{data($x/system/@id)}</option>");

TXQuery query  = TXQuery.newInstance( queryBuffer.toString() );

try {
	TResponse myResponse = xmlObjectAccessor.xquery( query);
	TXMLObject xmlObject = myResponse.getFirstXMLObject();
	out.println("<?xml version=\"1.0\"?>");
	xmlObject.writeTo(out);
}
catch (TXQueryException queryException) {
   response.setContentType("text/html");
if ( queryException.hasAccessFailureException() )
	  out.println( "<H3>" + queryException.getAccessFailureException() + "</H3>");
   else
	  out.println( "<H3>" + queryException.getRootCause().getMessage() + "</H3>" );
}
connection.close();

anybody have any ideas? This is my first time really trying java, xml, xquery, tamino all at once.

2

Hi

Please make sure that your query is formatted with spaces wherever necessary. As i look into your query, there is no space between “input()/graphic” and “return…” which also results in the reported exception.

Hope this helps in solving you problem.

Let us know if you need more information.

Thanks & Regards,
Srinu