We run Oracle 8i. I renamed classes12.zip to classes12.jar.
Checked with the DBA and added the correct servername and SID. I'm trying to get this to work by running tests based on both the SQL Transformer and ESQL samples, and documentation for SQL Transformer and ESQL. When I run a test based on the SQL Transformer I get the following error: Failed to obtain connection. Made 5 attempts with 5000ms interval or it simply runs and runs and runs with no result When I run a test based on ESQL I get nothing. The browser simply runs and runs and runs with no result. Is there a simple way I can check to make sure the Cocoon - Oracle connection is working? This is very frustrating. To those that have stumbled through this, is it worth learning? Should I stick to PHP? I was able to learn to work with Oracle and PHP in a relatively short period of time using the database abstraction classes provided in ADODB for PHP. Gary T. Schultz Web Technical Administrator / GIS Coordinator Wisconsin Department of Commerce 6th Floor P.O. Box 7970 Madison, WI 1-608-266-1283 -----Original Message----- From: Ugo Cei [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 9:13 AM To: [EMAIL PROTECTED] Subject: Re: Cocoon and Oracle Schultz, Gary - COMM wrote: > Section 1.5 Comments from the readers, there is a comment at the bottom that > mentions the need for a jar file instead of classes12.zip. What would be the > name for this jar file? Can I simply expand the zip and use it's contents to > create the jar, or do I need to build the jar from other resources? Simply rename classes12.zip to classes12.jar. If you're using Oracle 9 or later, you should use the "ojdbc14.jar" file that you can download from Oracle instead. > We are running Windows 2000 server. We use system DSN's configured via the > ODBC Data Source Administrator. Am I correct in assuming that the SID > identified in the wiki at section 1.3 Setting cocoon.xconf, is the DSN set > in the ODBC administrator? Not at all. The SID is the Oracle instance identifier and should be known by your DBA (if it's not been changed on install, it should be "ORCL"). The Oracle driver is a type 4 JDBC driver and does not use ODBC. Ugo --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
