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