Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
JDBC Drivers - Oracle JDBC Drivers 9i
|
|
Oracle JDBC drivers provide compatibilty between different version of the Oracle server. Oracle JDBC/OCI drivers do not provide support between OCI libraries. The JDBC driver included with ADS supports native connections to Oracle 10g/9i/8i, but only OCI connections with the 10g client software. If you have the 9i OCI client drivers installed on your machine and you would like to use them with ADS then you will need to install the Oracle 9i JDBC driver, which has support for 9i OCI libraries.
Note OSX Installations: OCI Connections are not supported on OSX. There is no need to change or update the drivers on OSX.
You may locate the latest Oracle JDBC drivers at the following location ...
Vendor: Oracle
Driver URL: [Free Registration Required] http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
You may locate the JDBC drivers for your installed version of Oracle in the Oracle server or Oracle client installations. Below is a directory listing of the driver files in the [ORACLE_HOME]\jdbc\lib\ directory. The ojdbc14.jar file is the Oracle JDBC driver required by ADS and the nls_charser12.jar is the language pack for the JDBC driver.
C:\oracle92\ora92\jdbc\lib>dir
Volume in drive C is Local Disk
Volume Serial Number is 108C-AA92
Directory of C:\oracle92\ora92\jdbc\lib
02/04/2003 06:34p DIR .
02/04/2003 06:34p DIR ..
04/26/2002 12:47p 1,033,402 classes111.jar
04/26/2002 12:47p 1,043,528 classes111.zip
04/26/2002 12:47p 1,371,600 classes111_g.jar
04/26/2002 12:47p 1,381,728 classes111_g.zip
04/26/2002 12:47p 1,196,109 classes12.jar
04/26/2002 12:47p 1,207,068 classes12.zip
04/26/2002 12:47p 1,201,552 classes12dms.jar
04/26/2002 12:47p 1,438,406 classes12dms_g.jar
04/26/2002 12:47p 1,432,813 classes12_g.jar
04/26/2002 12:47p 1,443,734 classes12_g.zip
04/26/2002 12:47p 1,781,005 nls_charset11.jar
04/26/2002 12:47p 1,810,518 nls_charset11.zip
04/26/2002 12:47p 1,781,898 nls_charset12.jar
04/26/2002 12:47p 1,811,415 nls_charset12.zip
04/26/2002 12:47p 36,640 ocrs12.jar
04/26/2002 12:47p 36,664 ocrs12.zip
04/26/2002 12:47p 1,174,976 ojdbc14.jar
04/26/2002 12:47p 1,383,922 ojdbc14_g.jar
18 File(s) 22,566,978 bytes
2 Dir(s) 35,225,325,568 bytes free
C:\oracle92\ora92\jdbc\lib>
To update the ADS JDBC drivers you need to overwrite the ADS oracle.jar file with ojdbc14.jar or classes12.zip/.jar, and overwrite the nlscharset12.jar with nls_charset12.jar. Below is a listing of the Aqua Data Studio library directory [ADS_HOME]\lib\drivers\ ...
C:\Program Files\Aqua Data Studio 11.0 - 64bit\lib\drivers>dir
Volume in drive C has no label.
Volume Serial Number is 40F4-2392
Directory of C:\Program Files\Aqua Data Studio 11.0 - 64bit\lib\drivers
04/09/2012 04:07 PM <DIR> .
04/09/2012 04:07 PM <DIR> ..
04/08/2012 04:03 PM 1,146,367 db2java.jar
12/07/2008 01:08 PM 3,059,973 db2jcc.jar
12/07/2008 01:08 PM 2,068 db2jcc_license_cisuz.jar
12/07/2008 01:08 PM 1,015 db2jcc_license_cu.jar
04/08/2012 04:03 PM 2,446,767 derby.jar
04/08/2012 04:03 PM 514,328 derbyclient.jar
04/08/2012 04:03 PM 229,921 derbynet.jar
04/08/2012 04:03 PM 812,386 ifxjdbc.jar
04/08/2012 04:03 PM 562,289 jconnect60.jar
04/08/2012 04:03 PM 4,485,843 jt400.jar
04/08/2012 04:03 PM 320,846 jtds-src.jar
04/08/2012 04:03 PM 324,727 jtds.jar
04/08/2012 04:03 PM 651,205 mysql-src.jar
04/08/2012 04:03 PM 745,416 mysql.jar
04/08/2012 04:03 PM 445,188 ncluster.jar
04/08/2012 04:03 PM 1,646,178 nlscharset12.jar
08/23/2010 11:07 AM 339,634 nzjdbc.jar
04/08/2012 04:03 PM 1,555,682 oracle.jar
04/08/2012 04:03 PM 346,944 paraccel-jdbc.jar
04/08/2012 04:03 PM 475,580 postgresql.jar
06/20/2008 01:41 PM 1,711 tdgssconfig.jar
05/08/2009 09:12 AM 855,053 terajdbc4.jar
04/08/2012 04:03 PM 286,773 util400.jar
04/08/2012 04:03 PM 139,148 xdb.jar
04/08/2012 04:03 PM 839,982 xmlparserv2.jar
25 File(s) 22,235,024 bytes
2 Dir(s) 113,013,755,904 bytes free
C:\Program Files\Aqua Data Studio 11.0 - 64bit\lib\drivers>
The Java class path for the drivers are already configured for ADS in the datastudio.ini for launching ADS with datastudio.exe and in datastudio.bat/.sh and datastudio-bundled.bat/.sh for launching ADS from the command line. The contents of the file are as follows ...
C:\Program Files\Aqua Data Studio 11.0 - 64bit>type datastudio.ini working.directory=. # JVM Properties vm.location=.\jre\bin\server\jvm.dll # Specify a proportion of the available physical memory to use (ie. relates to - Xmx arg). For example, vm.heapsize.max.percent=75. Note that this will use the m aximum memory possible. #vm.heapsize.max.percent= #Specify a proportion of the available physical memory to use as the minimum sta rting heap size (ie. relates to -Xms arg). #vm.heapsize.min.percent= #Specify a preferred amount (in MB) for the heap size (ie. relates to -Xmx arg). If this amount is not available it will use the maximum amount possible given t he physical memory available. #vm.heapsize.preferred= #Specifies that only one instance of the product should run at any given time #single.instance=window single.instance=dde dde.enabled=true dde.class=com.common.windows.noobfus.WinDDE dde.server.name=datastudio vmarg.1=-Dsun.swing.enableImprovedDragGesture vmarg.2=-Xmx512M vmarg.3=-XX:MaxPermSize=128m classpath.1=.\lib\*.jar classpath.2=.\lib\antlr\*.jar classpath.3=.\lib\apache\*.jar classpath.4=.\lib\apple\*.jar classpath.5=.\lib\aquafold\*.jar classpath.6=.\lib\aspose\*.jar classpath.7=.\lib\dnsjava\*.jar classpath.8=.\lib\drivers\*.jar classpath.9=.\lib\icepdf\*.jar classpath.10=.\lib\infragistics\*.jar classpath.11=.\lib\itext\*.jar classpath.12=.\lib\java\*.jar classpath.13=.\lib\jgoodies\*.jar classpath.14=.\lib\jgraph\*.jar classpath.15=.\lib\jide\*.jar classpath.16=.\lib\jinterop\*.jar classpath.17=.\lib\jna\*.jar classpath.18=.\lib\jogl\*.jar classpath.19=.\lib\perforce\*.jar classpath.20=.\lib\quartz\*.jar classpath.21=.\lib\snmp4j\*.jar classpath.22=.\lib\ssh2\*.jar classpath.23=.\lib\stndeditor\*.jar classpath.24=.\lib\svnkit\*.jar main.class=com.aquafold.datastudio.DataStudio C:\Program Files\Aqua Data Studio 11.0 - 64bit> C:\Program Files\Aqua Data Studio 11.0 - 64bit>type datastudio.bat ECHO OFF SET ADS_PATH= SET ADS_PATH=%ADS_PATH%;.\lib\ads.jar SET ADS_PATH=%ADS_PATH%;.\lib\aqua-lib.jar SET ADS_PATH=%ADS_PATH%;.\lib\antlr\stringtemplate.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-commons-net.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-jsch.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-launcher.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-nodeps.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-batik.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-fop.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-log4j.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-contrib.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-ooxml.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-ooxml-schemas.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-scratchpad.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-serializer.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-xalan.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-beanutils.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-codec.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-collections.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-compress.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-configuration.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-dbcp.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-dbutils.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-email.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-httpclient.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-io.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-lang.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-logging.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-logging-adapters.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-logging-api.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-math.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-net.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-net-ftp.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-primitives.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-transaction.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-validator.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-vfs.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-xmlgraphics.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\dom4j.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\hadoop-core.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\jakarta-oro.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\jcraft-jsch.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\tidy.jar SET ADS_PATH=%ADS_PATH%;.\lib\apple\aqua2.jar SET ADS_PATH=%ADS_PATH%;.\lib\aquafold\geo.jar SET ADS_PATH=%ADS_PATH%;.\lib\aspose\aspc.jar SET ADS_PATH=%ADS_PATH%;.\lib\aspose\jsr173-api.jar SET ADS_PATH=%ADS_PATH%;.\lib\aspose\stax2-api.jar SET ADS_PATH=%ADS_PATH%;.\lib\aspose\woodstox-core-asl.jar SET ADS_PATH=%ADS_PATH%;.\lib\dnsjava\dnsjava.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2java.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2jcc.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2jcc_license_cisuz.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2jcc_license_cu.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\derby.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\derbyclient.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\derbynet.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\ifxjdbc.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jconnect55.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jconnect60.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jt400.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jtds.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\mysql.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\ncluster.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\nlscharset12.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\nzjdbc.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\oracle.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\paraccel-jdbc.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\postgresql.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\tdgssconfig.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\terajdbc4.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\util400.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\xdb.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\xmlparserv2.jar SET ADS_PATH=%ADS_PATH%;.\lib\icepdf\icepdf-core.jar SET ADS_PATH=%ADS_PATH%;.\lib\icepdf\icepdf-viewer.jar SET ADS_PATH=%ADS_PATH%;.\lib\infragistics\infragistics.jar SET ADS_PATH=%ADS_PATH%;.\lib\itext\itext.jar SET ADS_PATH=%ADS_PATH%;.\lib\java\activation.jar SET ADS_PATH=%ADS_PATH%;.\lib\java\mail.jar SET ADS_PATH=%ADS_PATH%;.\lib\java\servlet-api.jar SET ADS_PATH=%ADS_PATH%;.\lib\java\tools.jar SET ADS_PATH=%ADS_PATH%;.\lib\jgoodies\looks.jar SET ADS_PATH=%ADS_PATH%;.\lib\jgraph\jgraph.jar SET ADS_PATH=%ADS_PATH%;.\lib\jgraph\jgraphlayout.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-action.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-beaninfo.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-common.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-components.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-dialogs.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-dock.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-grids.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-pivot.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-shortcut.jar SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-properties.jar SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\jcifs.jar SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\j-interop.jar SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\j-interopdeps.jar SET ADS_PATH=%ADS_PATH%;.\lib\jna\jna.jar SET ADS_PATH=%ADS_PATH%;.\lib\jna\platform.jar SET ADS_PATH=%ADS_PATH%;.\lib\jogl\jogl.jar SET ADS_PATH=%ADS_PATH%;.\lib\jogl\gluegen-rt.jar SET ADS_PATH=%ADS_PATH%;.\lib\perforce\p4java.jar SET ADS_PATH=%ADS_PATH%;.\lib\quartz\quartz.jar SET ADS_PATH=%ADS_PATH%;.\lib\snmp4j\snmp4j.jar SET ADS_PATH=%ADS_PATH%;.\lib\ssh2\ssh2.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.core.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.htmlcss.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.java.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.javascript.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.terminal.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.xml.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-htmlcss.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-java.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-javascript.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-core.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-xml.jar SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\svnkit-cli.jar SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\svnkit-javahl.jar SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\svnkit.jar ECHO ON java -Xmx512M -XX:MaxPermSize=192m -cp "%ADS_PATH%" com.aquafold.datastudio.Data Studio C:\Program Files\Aqua Data Studio 11.0 - 64bit>
|
|
|
|
|
|
|
|
|
|