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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
