Return-Path: Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 63147 invoked from network); 22 Mar 2000 17:34:12 -0000 Received: from gateway.britbio.co.uk (193.128.108.161) by locus.apache.org with SMTP; 22 Mar 2000 17:34:12 -0000 Received: by gateway.britbio.co.uk; (8.8.8/1.3/10May95) id RAA24939; Wed, 22 Mar 2000 17:36:08 GMT From: Received: from somewhere by smtpxd Received: from somewhere by smtpxd Content-return: allowed Date: Wed, 22 Mar 2000 17:31:34 +0000 Subject: SQL processor: dburl syntax for oracle To: cocoon-users@xml.apache.org Message-id: <6540FCA49130D31184BB00508B303F135EE71B@MERCURY> MIME-version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-type: text/plain; charset="iso-8859-1" X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N I'm having difficulty getting the SQL processor to connect to oracle. The SQL processor is running (as judged by it stripping out the connectiondefs section of the xml). The query is not being run. Instead the query element is untouched. The error log contains java.sql.SQLException: Invalid Oracle URL specified: OracleDriver.connect at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156) at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:775) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:143) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(DriverManager.java:137) at org.apache.cocoon.processor.sql.ConnectionCreator.getConnection(ConnectionCr eator.java:88) at org.apache.cocoon.processor.sql.ConnectionDefs.getConnection(ConnectionDefs. java:179) at org.apache.cocoon.processor.sql.SQLProcessor.process(Compiled Code) at org.apache.cocoon.Engine.handle(Compiled Code) at org.apache.cocoon.Cocoon.service(Cocoon.java:145) at javax.servlet.http.HttpServlet.service(HttpServlet.java:588) at org.apache.jserv.JServConnection.processRequest(JServConnection.java:314) at org.apache.jserv.JServConnection.run(JServConnection.java:188) at java.lang.Thread.run(Thread.java:479) This looks to me as if the dburl is incorrect. I'm using oracle.jdbc.driver.OracleDriver jdbc:oracle:thin@XX.XX.XX.XX:1521:d2k XXXXXX YYYYYY which was worked out on the basis of a previous post http://xml-archive.webweaving.org/xml-archive-cocoon-users/1059.html I can connect to the oracle database directly from java using the same jdbc drivers, so there's nothing inherantly wrong. Can anyone spot anything wrong with this, or am I looking in the wrong place? Many thanks Tim --------------------------------------------- Tim Dudgeon dudgeon@britbio.co.uk