Hi Tony, Thanks for going through the details and confirming that it is OK. I did restart Tomcat after copying the mysql.jar to the tomcat lib directory. I wondered if the SQL Transformer had 'broken' or I had a bad install, so I reinstalled all the components yesterday, but to no effect.
I tried your suggestion, declaring the SQL namespace at the root tag, but again to no effect - this is the output: <?xml version="1.0" encoding="ISO-8859-1" ?> - <document xmlns:sql="http://apache.org/cocoon/sql/2.0";> - <sql:execute-query> <sql:use-connection>ward_connect</sql:use-connection> <sql:query>select admin_name from wards</sql:query> </sql:execute-query> </document> - which is also the input ;) I forgot to mention that I am working on win 2K - if that makes any difference. If this isn't a problem with cocoon, then could it be with the MySQL database? It is installed on Localhost:3306, but apart from start the MySQL server running, I don't do anything else. I assume that from the connection parameters in cocoon.xconf...... <datasources> <jdbc name="ward_connect"> <pool-controller min="5" max="10"/> <dburl>jdbc:mysql://localhost:3306/ward_data?autoReconnect=true</dburl> <user>administrator</user> <password>mypassword</password> </jdbc> </datasources> .....cocoon can find the database and connect to it? Although I read an instruction on http://www.candlelightsoftware.com/orion-cocoon.html way down the page under the bullet point "Initialize the database using mysql............" that appears to call mysql from inside cocoon? is it a requirement for MySQL to physically sit inside Tomcat/Cocoon on the directory? I thought that the mysql.jar would find and connect to MySql wherever it is, as long as the connection parameters are OK. I have played around with the access settings to the mysql database (setting access from all locations, from localhost only etc..), but again - no change. In any case, If there was a problem connecting to the database then surely cocoon would throw up a error message to that effect, but according to the access log, there are no problems! So i am still stumped, but have to get this sorted soon! deadlines are approaching fast! gulp.... If you think of anything else. I will be very grateful for your help, thanks, Guy ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Kensington & Chelsea PCT ********************************************************************** --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
