Re: java.sql.SQLException: No data found

[Derek Hohls <dh...@csir.co.za>]

Chris
 
If you have a "normal" XML page at the start of your pipeline,
instead of XSP, do you have the same problem:
 
<map:match pattern=""> 
<map:generate src="index.xml"/> 
 
where "index.xml" is a static file.
 
Derek
 
PS I assume you have also done the configuration for the
sun.jdbc.odbc.JdbcOdbcDriver file?

>>> GalaxyDriver@gmx.de 2005/10/04 09:33 AM >>>
Hi,

maybe you can help me??

I get the following error-message:

********************************************************************

Could not read resource
file:/C:/Tomcat_5_0/webapps/cocoon/sql_transformer17/index.xml 

org.apache.cocoon.ProcessingException: Could not read resource
file:/C:/Tomcat_5_0/webapps/cocoon/sql_transformer17/index.xml:
java.sql.SQLException: No data found 

cause: java.sql.SQLException: No data found 

********************************************************************


I want to connect my MS Access 2003-Database by using Cocoon 2.1.7.

So I entered the following settings in cocoon.xconf:

********************************************************************

*.

<jdbc name="access-myDb"> 
<pool-controller max="10" min="10"/> 
<auto-commit>true</auto-commit> 
<driver>sun.jdbc.odbc.JdbcOdbcDriver</driver> 
<dburl>jdbc:odbc:myDb</dburl> 
<user></user> 
<password></password> 
</jdbc> 

*.

********************************************************************

The ODBC-Connection jdbc:odbc:myDb has also been created.

The sitemap.xmap has the follwing content:

********************************************************************

<?xml version="1.0" encoding="ISO-8859-1"?> 
<map:sitemap xmlns:map="http://apache.org/cocoon/sitemap/1.0"> 

<map:pipelines> 

<map:pipeline> 

<!-- Die Funktion main() aufrufen --> 
<map:match pattern=""> 
<map:generate type="serverpages" src="index.xsp"/> 
<map:transform type="sql"> 
<map:parameter name="use-connection" value="access-myDb"/> 
</map:transform> 
<map:serialize type="xml"/> 
</map:match> 

</map:pipeline> 

</map:pipelines> 
</map:sitemap> 

********************************************************************

And the content of the index.xsp:

********************************************************************

*

<content> 
<sql:execute-query name="users" xmlns:sql="http://apache.org/cocoon/SQL/2.0"
> 

<sql:query> 
SELECT * FROM test 
</sql:query> 

</sql:execute-query> 
</content> 

*

********************************************************************

Do you know what I have to change*??

Bye
Chris

-- 
5 GB Mailbox, 50 FreeSMS http://www.gmx.net/de/go/promail 
+++ GMX - die erste Adresse für Mail, Message, More +++

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org 
For additional commands, e-mail: users-help@cocoon.apache.org 




-- 
This message is subject to the CSIR's copyright, terms and conditions and
e-mail legal notice. Views expressed herein do not necessarily represent the
views of the CSIR.
 
CSIR E-mail Legal Notice
http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html 
 
CSIR Copyright, Terms and Conditions
http://mail.csir.co.za/CSIR_Copyright.html 
 
For electronic copies of the CSIR Copyright, Terms and Conditions and the CSIR
Legal Notice send a blank message with REQUEST LEGAL in the subject line to
HelpDesk@csir.co.za.


This message has been scanned for viruses and dangerous content by MailScanner, 
and is believed to be clean.  MailScanner thanks Transtec Computers for their support.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org