From: "Kevin B" <kbass1@nc-rr.com>
Newsgroups: comp.databases.oracle.misc,comp.lang.java.databases,comp.lang.java.programmer
Subject: SQL Embedded in XML (XML/Java/Oracle integration)
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <wj846.67562$sr6.11866552@typhoon.southeast.rr.com>
Date: Mon, 01 Jan 2001 23:23:08 GMT
NNTP-Posting-Host: 24.25.11.203
X-Complaints-To: abuse@rr.com
X-Trace: typhoon.southeast.rr.com 978391388 24.25.11.203 (Mon, 01 Jan 2001 18:23:08 EST)
NNTP-Posting-Date: Mon, 01 Jan 2001 18:23:08 EST
Organization: Road Runner - NC


I am attempting to integrate XML and Java but have encountered connection
problems.  I am receiving an error message of:

 java.sql.SQLException: The Network Adapter could not establish the
connection.

I can connect to the database using SQL*PLUS but cannot connect through XML.
I am using Personal Oracle 8i on Windows 98 and the database is up and
running. What am I doing wrong??


My XML code is as follows:

 <?xml version="1.0"?>
 <sqlx>
   <inputSpec>
     <param name=":salary" default="40000"/>
   </inputSpec>
   <execute url="jdbc:oracle:thin:@localhost:1521:ORCL"
            driver="oracle.jdbc.driver.OracleDriver"
            user="scott"
            password="tiger"
            sql="select lastname,salary from employee where salary >=
:salary
 order by salary"/>
</sqlx>


Thanks, Kevin