cocoon-users mailing list archives

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

----- Original Message -----
From: "cyril vidal" <cyr.vidal@wanadoo.fr>
To: <cocoon-users@xml.apache.org>; <c.watson@zen.co.uk>
Sent: Thursday, May 16, 2002 5:17 PM
Subject: Re: Cocoon 2 + Access:it runs now well!!!


> 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