Solved

Where do I find the OracleXMLSQL.jar

Posted on 2001-06-20
5
2,403 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
clob to char in oracle 3 96
SQL2016 to ORACLE11G linked-server 6 49
Database Design Dilemma 6 66
UTL_FILE invalid file operation 5 45
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
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.
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

726 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