Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Where do I find the OracleXMLSQL.jar

Posted on 2001-06-20
5
2,379 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
ID: 6214506
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
ID: 6215019
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
ID: 6217212
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
ID: 6217280
and I found the xsu12.jar also in $ORACLE_HOME/rdbms/jlib
0
 
LVL 2

Author Comment

by:banicki
ID: 6218294
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

856 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