Solved

Where do I find the OracleXMLSQL.jar

Posted on 2001-06-20
5
2,429 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
[X]
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
  • 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

691 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