Where do I find the OracleXMLSQL.jar

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
LVL 2
banickiAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

graf27Commented:
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
banickiAuthor Commented:
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
graf27Commented:
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
graf27Commented:
and I found the xsu12.jar also in $ORACLE_HOME/rdbms/jlib
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
banickiAuthor Commented:
You were right!
Thanks.  
We downloaded the 817 XDK from OTN, which included the XSU12, which includes OracleXMLQuery.class
Thanks Again.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.