Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 63838 invoked by uid 500); 17 May 2002 00:46:18 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 63827 invoked from network); 17 May 2002 00:46:18 -0000 Message-ID: <001401c1fcab$468960a0$d1b30950@cyrilus> From: "cyril vidal" To: References: <3CE35975.6060704@pandora.be> Subject: Re: Cocoon 2 + Access Date: Thu, 16 May 2002 09:28:28 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 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" To: 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 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:cyr.vidal@wanadoo.fr] > > *Sent:* Thursday, 16 May 2002 9: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:odbc:logs (with odbc, we don't need to write > > the complete url, right??) > > > > > > > > > > > > > > > > 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 > > > > > > > xmlns:xsp="http://apache.org/xsp"> > > xmlns:esql="http://apache.org/cocoon/SQL/v2"> > > > > > > > > pool > > > > > > > > > > > > > > > > > > To my great surprise, when I execute this file, I obtain: > > > > > > > > > > > > pool > > > > > > > > > > > > I think, it's not normal...I should not see the connection > > element... I think I have to change the line > > jdbc:odbc:logs 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. > > > > > > > xmlns:xsp="http://apache.org/xsp"> > > > > > > java.sql* > > > > > > > > > > > > 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'"); > > > > > > Nous proposons une r�duction de 25%, > > restreinte � la p�riode de Septembre 20001 � OCtobre > > 20001 > > > > > > resultat.getString (1) > > resultat.getString > > (2) > > resultat.getString > > (3) > > resultat.getString > > (4) > > resultat.getString (5) > > > > > > > > > > > > > --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. To unsubscribe, e-mail: For additional commands, e-mail: