Tom, I've tried this and it was runnig well. That's why I'm surprised. I think the problem comes perhaps from my Cocoon configuration, because my access.log file looks like this: DEBUG (2002-05-16) 09:15.48:230 [access] (Unknown-URI) Unknown-thread/CocoonServlet: getRealPath for /: C:\tomcat\webapps\essai\ DEBUG (2002-05-16) 09:15.48:230 [access] (Unknown-URI) Unknown-thread/CocoonServlet: URL for Root: file:/C:/tomcat/webapps/essai/ DEBUG (2002-05-16) 09:15.48:230 [access] (Unknown-URI) Unknown-thread/CocoonServlet: work-directory was not set - defaulting to C:\tomcat\work\localhost\essai\cocoon-files DEBUG (2002-05-16) 09:15.48:390 [access] (Unknown-URI) Unknown-thread/CocoonServlet: upload-directory was not set - defaulting to C:\tomcat\work\localhost\essai\cocoon-files\upload-dir DEBUG (2002-05-16) 09:15.48:390 [access] (Unknown-URI) Unknown-thread/CocoonServlet: cache-directory was not set - defaulting to C:\tomcat\work\localhost\essai\cocoon-files\cache-dir DEBUG (2002-05-16) 09:15.48:390 [access] (Unknown-URI) Unknown-thread/CocoonServlet: Using configuration file: /cocoon.xconf DEBUG (2002-05-16) 09:15.48:500 [access] (Unknown-URI) Unknown-thread/CocoonServlet: show-time was not set - defaulting to false DEBUG (2002-05-16) 09:15.48:500 [access] (Unknown-URI) Unknown-thread/CocoonServlet: parent-component-manager was not set - defaulting to null. DEBUG (2002-05-16) 09:15.48:500 [access] (Unknown-URI) Unknown-thread/CocoonServlet: Trying to load class: org.hsqldb.jdbcDriver DEBUG (2002-05-16) 09:15.48:560 [access] (Unknown-URI) Unknown-thread/CocoonServlet: Trying to load class: sun.jdbc.odbc.JdbcOdbcDriver INFO (2002-05-16) 09:15.48:670 [access] (Unknown-URI) Unknown-thread/CocoonServlet: Reloading from: jndi:/localhost/essai/cocoon.xconf
I work in the webapps\essai directory where I have configurated the cocoon.xconf and WEB-INF/web-xml files. After, I also call http://localhost:8080/essai/base.xsp Something wrong must happen herre. Perhaps I have to configure the main cocoon.xconf and web-xml files? Regards, Cyril. ----- Original Message ----- From: "Tom Klaasen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 9:02 AM Subject: Re: Cocoon 2 + Access > Cyril, > > May I add a suggestion? Perhaps you should first try to make a DB > connection from within a simple scratch program (so just in a main() > method of some scratch class). I have the impression that the main part > of the issues you're having, lies there. Once you have it in scratch > code, it will be fairly easy to copy&paste it into an XSP page. > > hth, > tomK > > > > Faulkner, Perry wrote: > > > Cyril, > > > > You probably should set up a datasource, using the ODBC data manager. > > That's what the logs part 'jdbc:odbc:logs' is referring to in your <dburl> tag. Use the data source manager to create a data source, 'logs' that > > refers to your access database 'C:....\JAVA\JDBC\logs.mdb'. > > > > When you execute, check the cocoon logs, > > TOMCAT\webapps\cocoon\web-inf\logs to see what problems are occuring, > > if any! Also enable tracing in the ODBC data source manager to see if > > your queries are being passed to ODBC. > > > > Perry > > > > -----Original Message----- > > *From:* cyril vidal [mailto:[EMAIL PROTECTED]] > > *Sent:* Thursday, 16 May 2002 9: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 <mailto:[EMAIL PROTECTED]> > > *To:* '[EMAIL PROTECTED]' > > <mailto:[EMAIL PROTECTED]%27> > > *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 > > <file://%5C%5C%27s> 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]>
