Solved

Where do I find the OracleXMLSQL.jar

Posted on 2001-06-20
5
2,316 Views
Last Modified: 2007-11-27
Where can I find the OracleXMLSQL.jar
I've installed 8.1.7 on a server and installed the Developer's Tools option.
I searched the directories for it, but only found OracleXSQL.jar...

Any Ideas?

Terry
0
Comment
Question by:banicki
  • 3
  • 2
5 Comments
 
LVL 3

Expert Comment

by:graf27
Comment Utility
The file is named "oraclexsql.jar" (lowercase). You must find it in $ORACLE_HOME/lib and/or $ORACLE_HOME/xdk/lib. Also you can download the utilities complete (XSU) from the otn:

http://otn.oracle.com/tech/xml/xdk_java/
0
 
LVL 2

Author Comment

by:banicki
Comment Utility
no, I have oraclexsql.jar, I'm looking for oracxmlsql.jar
see the execption below, then see the contents of oraclexmlsql.jar from metalink...
humm....  
maybe the real question is where do i find a jar containing
oracle/xml/sql/query/OracleXMLQuery



C:\Java>testxsql

C:\Java>jre -cp c:\j2sdkee1.3\lib\system\oraclexsql.jar;c:\j2sdkee1.3\lib\system
\classes12.zip;c:\j2sdkee1.3\lib\system\xmlparserv2.jar;c:\j2sdkee1.3\lib\system
 oracle.xml.xsql.XSQLCommandLine TestXML.xsql xml-stylesheet=none
Exception in thread "main" java.lang.NoClassDefFoundError: oracle/xml/sql/query/
OracleXMLQuery
        at oracle.xml.xsql.actions.XSQLQueryHandler.handleAction(Compiled Code)
        at oracle.xml.xsql.XSQLDocHandler.getDocument(Compiled Code)
        at oracle.xml.xsql.XSQLPageProcessor.process(Compiled Code)
        at oracle.xml.xsql.XSQLCommandLine.main(XSQLCommandLine.java:43)


Zip file: <JDeveloper home>\lib\oraclexmlsql.jar

  Length   Size  Ratio    Date     Time   Name
  ------   ----- -----    ----     ----   ----
    3224    3224   0%  09/02/1999  23:18  META-INF/MANIFEST.MF
   25859   25859   0%  09/02/1999  23:17  oracle/xml/sql/core/OracleXMLConvert.class
    1991    1991   0%  09/02/1999  23:17  oracle/xml/sql/core/OracleXMLTimer.class
    1328    1328   0%  09/02/1999  23:17  oracle/xml/sql/core/OracleXMLTime.class
    1506    1506   0%  09/02/1999  23:17  oracle/xml/sql/dataset/OracleXMLDataSet.class
   10196   10196   0%  09/02/1999  23:17  oracle/xml/sql/dataset/OracleXMLDataSetExtJdbc.class
    5219    5219   0%  09/02/1999  23:17  oracle/xml/sql/query/OracleXMLQuery.class
    1561    1561   0%  09/02/1999  23:17  oracle/xml/sql/docgen/OracleXMLDocGen.class
    3471    3471   0%  09/02/1999  23:17  oracle/xml/sql/docgen/OracleXMLDocGenString.class
    3769    3769   0%  09/02/1999  23:17  oracle/xml/sql/docgen/OracleXMLDocGenDOM.class
     936     936   0%  09/02/1999  23:17  oracle/xml/sql/name/OracleColumnName.class
    1156    1156   0%  09/02/1999  23:17  oracle/xml/sql/name/OracleCursorName.class
    1164    1164   0%  09/02/1999  23:17  oracle/xml/sql/name/OracleADTName.class
     845     845   0%  09/02/1999  23:17  oracle/xml/sql/name/OracleCollectionName.class
     528     528   0%  09/02/1999  23:17  oracle/xml/sql/name/OracleScalarName.class
    2302    2302   0%  09/02/1999  23:17  oracle/xml/sql/OracleXMLSQLException.class
   12815   12815   0%  09/02/1999  23:17  oracle/xml/sql/dml/OracleXMLSave.class
     645     645   0%  09/02/1999  23:17  oracle/xml/sql/OracleXMLSQLNoRowsException.class
   18298   18298   0%  09/02/1999  23:18  OracleXML.class
    5621    5621   0%  09/02/1999  23:18  OracleXMLStore.class
       0       0   0%  09/02/1999  23:18  VERSION_
 ------- -------  ---                     -------
  102434  102434   0%                          21
0
 
LVL 3

Expert Comment

by:graf27
Comment Utility
I found the class oracle.xml.sql.query.XMLQuery in a file named "xsu12.jar". It is part of the "Oracle XML Developer's Kit for Java". You can download the current version from

http://technet.oracle.com/software/tech/xml/xdk_java/htdocs/files/xdk_java_8_1_7_1A.zip


If you use JDeveloper, the file is also in the $JDEVHOME/lib. xsu12.jar is for JDK 1.2, xsu11.jar is for JDK 1.1 (I think):
0
 
LVL 3

Accepted Solution

by:
graf27 earned 25 total points
Comment Utility
and I found the xsu12.jar also in $ORACLE_HOME/rdbms/jlib
0
 
LVL 2

Author Comment

by:banicki
Comment Utility
You were right!
Thanks.  
We downloaded the 817 XDK from OTN, which included the XSU12, which includes OracleXMLQuery.class
Thanks Again.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now