cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <francesco.casal...@virgilio.it>
Subject again mySQL, jdbc and ESQL
Date Thu, 05 Jul 2001 17:14:14 GMT
>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: <francesco.casalena@virgilio.it>
>To: <cocoon-users@xml.apache.org>
>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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message