----- Original Message ----- From: "cyril vidal" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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" <[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]>
