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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > Sent: 16 May 2002 00:20 > To: [EMAIL PROTECTED] > 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: '[EMAIL PROTECTED]' > 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:[EMAIL PROTECTED]] > Sent: Thursday, 16 May 2002 8:18 > To: [EMAIL PROTECTED] > 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: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > --------------------------------------------------------------------- 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]>
