>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
>
Thank you Marco, but I continue to receive
ESQL code directly in HTML file.
I'm very stuck!
Another idea?
Regards, ciao
Francesco
>
>----- 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>
>> ------
>>
>> ------
>> <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: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 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?
>>
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]>
