fadi qutaishat wrote:
Hi all,
After having a lot of troubles in doing the configurations I have
managed to establish the connection from cocoon to MySQL db. I have used
the latest JDK version which is J2sdk1.4.2_07 and Cocoon version 2.1.6
and Tomcat version 4.0.6.
I have used a simple XML file that contains SQL statement to do the test
and it was like the following:
<document>
<sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
<sql:use-connection>newdb</sql:use-connection>
<sql:query>
select emp_id,emp_name from employee
</sql:query>
</sql:execute-query>
</document>
So my question is that after finishing the query do I have to close the
connection with MySQL db? If so, what would be the command, can I put it
in put it in the above XML file ?
no you do not have to do anything else.
your syntax is a bit wrong though. Have a look at:
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Usage+and+Examples
--
Leszek Gawron [EMAIL PROTECTED]
Project Manager MobileBox sp. z o.o.
+48 (61) 855 06 67 http://www.mobilebox.pl
mobile: +48 (501) 720 812 fax: +48 (61) 853 29 65
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
