java.sql.SQLException: No data found

[Ga...@gmx.de]

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