cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "cyril vidal" <cyr.vi...@wanadoo.fr>
Subject Re: Cocoon 2 + Access:it runs now well!!!
Date Thu, 16 May 2002 15:17:24 GMT
Hy Christopher!

Thanks for your help!!! The > was indeed the origin of my problem...
Without code errors, Cocoon2 and Access, it runs well!!
Thanks again for your help,
Regards,
Cyril.
----- Original Message -----
From: "Christopher Watson" <c.watson@zen.co.uk>
To: <cocoon-users@xml.apache.org>
Sent: Thursday, May 16, 2002 11:05 AM
Subject: RE: Cocoon 2 + Access


> Cyril,
>
> If you MUST use access (I do while testing !) ...
>
> looking at your example ...
>
> <xsp:page language="java"
>           xmlns:xsp="http://apache.org/xsp">
>           xmlns:esql="http://apache.org/cocoon/SQL/v2">
>
> you've got an extra > after the xmlns:xsp="http://apache.org/xsp"
> it should be
>
> <xsp:page
>   language="java"
>           xmlns:xsp="http://apache.org/xsp"
>           xmlns:esql="http://apache.org/cocoon/SQL/v2">
>
> ===
> Don't expect to see much until you do something like the following.
> I wouldn't know how to use column numbers with esql; I always use names
>
> <?xml version="1.0" encoding="iso-8859-1"?>
> <xsp:page
>   language="java"
>           xmlns:xsp="http://apache.org/xsp"
>           xmlns:esql="http://apache.org/cocoon/SQL/v2">
>
> <doc>
>    <esql:connection>
>      <esql:pool>pool</esql:pool>
>
>      <esql:execute-query>
>       <esql:query>
>       select userid, sessionid, visitdate, referrer, page from visit
>       </esql:query>
>
>       <esql:results>
>        <esql:row-results>
>
>         <row>
> <userid><esql:get-string column = "userid"/></userid>
> <sessionid><esql:get-string column = "sessionid"/></sessionid>
> <visitdate><esql:get-string column = "visitdate"/></visitdate>
> <referrer><esql:get-string column = "referrer"/></referrer>
> <page><esql:get-string column = "page"/></page>
>         </row>
>
>        </esql:row-results>
>       </esql:results>
>
>      </esql:execute-query>
>
>    </esql:connection>
> </doc>
> </xsp:page>
>
> BUT I agree with others, you're probably safer using MySQL. It's free too!
> There's even an ODBC driver for it, so you could set an ODNC datasource
and
> look at it through access.
>
> -----Original Message-----
> From: cyril vidal [mailto:cyr.vidal@wanadoo.fr]
> Sent: 16 May 2002 00:20
> To: cocoon-users@xml.apache.org
> Subject: Re: Cocoon 2 + Access
>
>
> Hi Perry,
>
> I've tried with // instead  of / ,it isn't better...
> Anyway, I've configurated with esql and pool.
> the cocoon.xconf looks like this:
> <jdbc name="pool">
> <pool-controller min="5" max="10"/>
> <dburl>jdbc:odbc:logs</dburl>  (with odbc, we don't need to write the
> complete url, right??)
> <user></user>
> <password></password>
> </jdbc>
> and I didn't forget to load the driver in web.xml...
>
> My file base1.xsp is this one, as simple as possible, just to test the
> connection
> <?xml version="1.0" encoding="iso-8859-1"?>
> <xsp:page language="java"
>           xmlns:xsp="http://apache.org/xsp">
>           xmlns:esql="http://apache.org/cocoon/SQL/v2">
> <doc>
>    <esql:connection>
>      <esql:pool>pool</esql:pool>
>    </esql:connection>
> </doc>
>
> </xsp:page>
>
> To my great surprise, when I execute this file, I obtain:
> <doc xmlns:xsp="http://apache.org/xsp">
>
> <connection>
>
> <pool>pool</pool>
>
> </connection>
> </doc>
> I think, it's not normal...I should not see the connection element...  I
> think I have to change the line <dburl>jdbc:odbc:logs</dburl> but I don't
> know really how to do...
> regards,
> Cyril.
>
> ----- Original Message -----
> From: Faulkner, Perry
> To: 'cocoon-users@xml.apache.org'
> Sent: Thursday, May 16, 2002 12:47 AM
> Subject: RE: Cocoon 2 + Access
>
>
> Hi Cyril,
>
> In theory it should work, as it's just some Java code, similar to that
> produced by ESQL. The disadvantage, is that you don't have any error
> checking or logging to fall back on when situations like this occur, and
> ESQL would provide that.
>
> Anyway, the only obvious thing that I can see, is to put \\'s in your
> connection string, e.g:
>
> ("jdbc:odbc:localhost:8080/c:\\Mes_documents\\JAVA\\JDBC\\logs");
>
> Also turn on ODBC tracing and see if any other information is logged, to
> help you resolve the problem.
>
> Perry
>
> -----Original Message-----
> From: cyril vidal [mailto:cyr.vidal@wanadoo.fr]
> Sent: Thursday, 16 May 2002 8:18
> To: cocoon-users@xml.apache.org
> Subject: Cocoon 2 + Access
>
>
> Hy!
>
> I would like to know  if it is an obligation to use ESQL and the
connection
> pool provided by Cocoon2 to connect to a database.
> By example, isn't it possible just to write the following code, by which a
> simply connection should be executed with the 'logs' database?
> I've tried it and it doesn't work but I don't know if there's an error on
> the code or if anyway, it could never run.
> Some of you can help me, please?
> Thanks in advance,
> Cyril.
>
> <?xml version="1.0" encoding="iso-8859-1"?>
> <xsp:page language="java"
>           xmlns:xsp="http://apache.org/xsp">
>
> <xsp:structure>
> <xsp:include>java.sql*</xsp:include>
> </xsp:structure>
>
> <Promotion auteur="Jules">
>
> <xsp:logic>
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> Connection conn =
>
DriverManager.getConnection("jdbc:odbc:localhost:8080/c:\Mes_documents\JAVA\
> JDBC\logs");
> Statement stmt = conn.createStatement();
> ResultSet resultat = stmt.executeQuery("select * from visit where
> userid='cyril'");
> </xsp:logic>
>
> <Description>Nous proposons une réduction de 25%, restreinte à la période
de
> Septembre 20001 à OCtobre 20001</Description>
>
> <row>
> <userid><xsp:expr>resultat.getString (1)</xsp:expr></userid>
> <sessionid><xsp:expr>resultat.getString (2)</xsp:expr></sessionid>
> <visitdate><xsp:expr>resultat.getString (3)</xsp:expr></visitdate>
> <referrer><xsp:expr>resultat.getString (4)</xsp:expr></referrer>
> <page><xsp:expr>resultat.getString (5)</xsp:expr></page>
> </row>
>
> </Promotion>
> </xsp:page>
>
>
> ---------------------------------------------------------------------
> 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>
>



---------------------------------------------------------------------
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