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 82048 invoked from network); 23 Jun 2000 19:13:26 -0000 Received: from mailserver-ng.cs.umbc.edu (130.85.100.230) by locus.apache.org with SMTP; 23 Jun 2000 19:13:26 -0000 Received: from sunserver1.cs.umbc.edu (actaeon.cs.umbc.edu [130.85.99.51]) by mailserver-ng.cs.umbc.edu (8.9.3/8.9.3) with ESMTP id PAA27970; Fri, 23 Jun 2000 15:13:25 -0400 (EDT) Received: from localhost (ryu@localhost) by sunserver1.cs.umbc.edu (8.9.3/8.9.3) with SMTP id PAA15616; Fri, 23 Jun 2000 15:13:25 -0400 (EDT) X-Authentication-Warning: sunserver1.cs.umbc.edu: ryu owned process doing -bs Date: Fri, 23 Jun 2000 15:13:25 -0400 (EDT) From: rong To: SaiRam Mattancheril cc: rong , cocoon-users@xml.apache.org Subject: Re: SQL tag setup for Oracle In-Reply-To: <3953AD10.288B17DC@ecdev.fedex.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N On Fri, 23 Jun 2000, SaiRam Mattancheril wrote: > > I think your ORACLE_SID should be alright -- in anycase Login to the unix box > and type the command "echo $ORACLE_SID" and it should respond with GL. > > I assume that in your Java/JDBC/Oracle application (which you say works ) you > are using the same driver and not oci8 or someother "non-thin" oracle driver. > What is the error you are getting? In my JAVA/JDBC/ORACLE application, i used the same driver(oracle815.jar), which is JDBC thin driver for Oracle8.1.5. I use the same for cocoon application. The error of my sql.xml cocoon application is: I got a blank screen, but that's ok since i don't apply a xslt on this page. However, when i look at the source, i saw the following: **** oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@oracle.gl.umbc.edu:1521:GL ryu ryu select * from shop **** Instead, i should see something like: ****
1
A 3.45
1
B 3.99
2
A 10.99 ... ***** This means SQL processor doesn't query into Oracle database. > > can try to help if i can get more specific information on the following > 1) Cocoon's response to your SQL-XML -- r u getting a blank screen, are > you getting a "printStackTrace" What is "printStackTrace"? >2) The classpath used by your working > Java Application and the classpath used by TomCat/Cocoon I believe they share the same classpath, i use "echo $CLASSPATH" to check this. >3) The names and versions of the Oracle JDBC drivers you are using. JDBC thin driver for Oracle8.1.5, oracle815.jar