I would like to thank all who have responded to my inquiry. Here is some additional information.
Connection is defined in cocoon.xconf as jdbc:oracle:thin:@servername:1521:oracleserviceID I checked with our DBA and the server hosting cocoon successfully connected to the server hosting Oracle via Sqlplus. Windows ODBC uses the Oracle service ID when creating DSN's, so we know the network communication is functioning properly through that. In PHP ADODB, I use the DSN to connect to the Oracle database and it works. No timeouts. Could it be related to the location of the jdbc? I've tried with classes12.jar in Cocoon web-inf/lib folder, in Tomcat Common/lib folder and in the classpath. To recall, my original inquiry was that we want to query a table in Oracle and display the results in a html table. It has been decided to go with PHP and ADODB. We can get this done in a relatively quick manner. Time permitting, we will take another look at doing this through Cocoon via SQL Transformer or ESQL. This is my first Cocoon set back. Otherwise, Cocoon has been great for our organization. Keep up the good work. 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 12:05 PM To: [EMAIL PROTECTED] Subject: Re: Cocoon and Oracle Il giorno 09/ago/04, alle 18:49, Schultz, Gary - COMM ha scritto: > Is there a simple way I can check to make sure the Cocoon - Oracle > connection is working? How is your connection defined in cocoon.xconf? Your JDBC URL should be something like: jdbc:oracle:thin:@<hostname>:<port>:<sid> If it is, try to do a "telnet <hostname> <port>" and see if you can connect. You shouldn't actually see anything but "Connected to <hostname>" and then telnet should quit when you press Enter. If you have the Oracle client installed, try to see if you can connect with Sqlplus. The fact that the connection times out without giving any error makes me think you have some problems with your network setup. Ugo -- Ugo Cei - http://beblogging.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
