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