The XSP uri you are using is old. The new URI is
http://apache.org/xsp
Try
<xsp:page
language="java"
xmlns:xsp="http://apache.org/xsp";
xmlns:esql="http://apache.org/cocoon/SQL/v2";
Marco
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 04, 2001 7:51 PM
Subject: mySQL, jdbc and ESQL
> Hi,
> I'm trying to setup a pooled connection for mySQL.
>
> My packets: JDK 1.3.1, Tomcat 4 beta5, Cocoon 2 beta1, mySQL 3.23.38,
> mm.mysql 2.0.6.1 on Linux Red Hat 6.2.
>
> I've created a db named "test" with user "fku"
> and table "utenti".
> Then I've added these lines to cocoon.xconf
> ------
> <datasources>
> <jdbc name="personnel">
> <pool-controller min="5" max="10"/>
> <dburl>jdbc:mysql://localhost/test</dburl>
> <user>fku</user>
> <password></password>
> </jdbc>
> </datasources>
> ------
>
> And these to WEB-INF/web.xml
> ------
> <init-param>
> <param-name>load-class</param-name>
> <param-value>
> org.gjt.mm.mysql.Driver
> </param-value>
> </init-param>
> ------
>
> I've put mm.mysql-2.0.6.1.jar in TOMCAT_HOME/lib and CLASSPATH contains
the
> path to mm.mysql's dir /opt/mm.mysql-2.0.6.1.
>
> This is my XML code:
> ------
> <xsp:page
> laguage="java"
> xmlns:xsp="http://www.apache.org/1999/XSP/Core";
> xmlns:esql="http://apache.org/cocoon/SQL/v2";
> >
> ...
> <esql:connection>
> <esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
> <esql:dburl>jdbc:mysql://localhost/test</esql:dburl>
> <esql:username>fku</esql:username>
> <esql:password></esql:password>
> <esql:execute-query>
> <esql:query>select * from prova</esql:query>
>
> <esql:results>
> <ROWSET>
> <esql:row-results>
> <ROW>
> <esql:get-columns/>
> </ROW>
> </esql:row-results>
> </ROWSET>
> </esql:results>
>
> </esql:execute-query>
> </esql:connection>
> ------
>
> Please, see the mySQL's localhost.log:
> ------
> /opt/mysql/libexec/mysqld, Version: 3.23.38-log, started with:
> Tcp port: 3306 Unix socket: /tmp/mysql.sock
> Time Id Command Argument
> 010703 15:35:08 1 Connect fku@localhost as anonymous on
> 1 Init DB test
> 010703 15:35:16 1 Query SHOW VARIABLES
> 010703 15:35:42 2 Connect fku@localhost as anonymous on
> 2 Init DB test
> 2 Query SHOW VARIABLES
> 3 Connect fku@localhost as anonymous on
> 3 Init DB test
> 3 Query SHOW VARIABLES
> 010703 15:35:43 4 Connect fku@localhost as anonymous on
> 4 Init DB test
> 4 Query SHOW VARIABLES
> 010703 15:35:44 5 Connect fku@localhost as anonymous on
> 5 Init DB test
> 5 Query SHOW VARIABLES
> ------
>
> And, finally, cocoon.log:
> ------
> ...
> 2001-07-03 15:28:52 DEBUG 1539 [cocoon ] (HttpProcessor[8080][4]):
Trying
> to load class: org.gjt.mm.mysql.Driver
> ...
> 2001-07-03 15:35:42 DEBUG 41112 [cocoon ] (Thread-7): JdbcConnection
object created
>
> 2001-07-03 15:35:42 DEBUG 41155 [cocoon ] (Thread-7): JdbcConnection
object created
>
> 2001-07-03 15:35:43 DEBUG 41206 [cocoon ] (Thread-7): JdbcConnection
object created
>
> 2001-07-03 15:35:44 DEBUG 41311 [cocoon ] (Thread-7): JdbcConnection
object created
>
> 2001-07-03 15:35:45 DEBUG 41396 [cocoon ] (Thread-7): JdbcConnection
object created
> ...
> ------
>
> But I receive ESQL code in final HTML directly, without any query
> execution, so my HTML document contains these lines:
> ------
> org.gjt.mm.mysql.Driver jdbc:mysql://localhost/test fku
> select * from prova
> ------
>
> It seems that the pooled connection is established, but ESQL code
> isn't recognized by C2.
>
> I've missed anything?
> Any idea?
>
> Thanks in Advance
> Regards, ciao
> Francesco
>
>
> Francesco Casalena
> L.U.G. "Il Pinguino"
> ----------------------------------------------
> Virgilio Mail - Il tuo indirizzo E-mail gratis
> http://mail.virgilio.it
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
