Documentation 8.0 Aqua Data Studio
8.0 Supported RDBMS
Servers 1. Installation1.1 Minimum Requirements 1.2 Installing Aqua Data Studio in Windows OS 1.3 Installing Aqua Data Studio in Linux OS 1.4 Installing Aqua Data Studio in Mac OS 1.5 Launcher & Memory Configuration 1.6 Interface Language, Fonts & Character sets 1.7 Charts and OpenGL/JOGL Configuration 1.8 Application Logs & Support Information 1.9 Configuration & Connection files 2.
Registering a Database Server2.1 Oracle 2.2 Oracle OCI 2.3 DB2 iSeries 2.4 DB2 LUW 2.5 DB2 zOS 2.6 MS SQL Server 2.7 Sybase ASE 2.8 Sybase Anywhere 2.9 Sybase IQ 2.10 Informix 2.11 Teradata 2.12 Aster nCluster 2.13 MySQL 2.14 PostgreSQL 2.15 Apache Derby 2.16 Generic JDBC 2.17 Generic ODBC 3. JDBC
Driver Configuration3.1 Oracle 8i JDBC Drivers 3.2 Oracle 9i JDBC Drivers 3.3 Oracle 10g JDBC Drivers 3.4 Oracle 11g JDBC Drivers 3.5 DB2 iSeries JDBC Drivers 3.6 DB2 z/OS JDBC Drivers 3.7 DB2 LUW 7.2 JDBC Drivers 3.8 DB2 LUW 8.1 and DB2 UDB 8.2 3.9 DB2 LUW 9.0 and DB2 UDB 9.5 3.10 SQL Server JDBC Drivers 3.11 Sybase ASE JDBC Drivers 3.12 Sybase Anywhere JDBC Drivers 3.13 Sybase IQ JDBC Drivers 3.14 Informix JDBC Drivers 3.15 Teradata JDBC Drivers 3.16 Aster nCluster Drivers 3.17 PostgreSQL JDBC Drivers 3.18 MySQL JDBC Drivers 3.19 Apache Derby JDBC Drivers 3.20 SQLite JDBC Drivers 3.21 Firebird JDBC Drivers 4.
Workspace and Docking Framework4.1 Menus and Toolbar 4.2 Shortcuts Toolbar 4.3 Schema Browser 4.4 Scripts Browser 4.5 Details View 5.
Query Analyzer - SQL Tool in ADS5.1 Invoking the Query Analyzer (CTRL+Q) 5.2 Using the Query Analyzer 5.3 Query Analyzer and its Environment 5.4 Server Side Comments 5.5 Parameterized Scripts 5.6 Displaying Results of Queries 5.7 Saving Query Results 5.8 Tips and Tricks 5.9. SQL
Automation5.9.1 Insert, Update, Select 5.9.2 Introduce Columns and Value Stubs 5.9.3 Morph to Delimited List 5.9.4 Formatting Statements 5.9.5 Auto Completion 5.9.6 Aqua Commands 5.10. Charting Grids and Pivot Grids5.10.1 Working with Grids and Pivot Grids 5.10.2 Working with Enhanced Charts 5.10.3 Scripting Charts 5.10.4 Chart Options 5.10.5 Function Series 5.11. Visual
Explain Plan5.11.1 Using Explain Diagrams 5.11.2 Sample Query Tuning Demo 6. SQL
History (CTRL+ ALT+H) 7. Query
Builder Tool in ADS7.1 Building Queries 7.2 Workspace Reference 8. GUI
Tools for Database Objects8.1 Creating Databases 8.2 Creating Tables 8.3 Creating Constraints 8.4 Creating Indexes 8.5 Creating Views & Triggers 8.6 Creating Aliases & Synonyms 8.7 Creating Storage Objects 8.8 Multi Scripting Objects 9. Tools and
Features9.1 How to Import Data using ADS 9.2 How to Export Data using ADS 9.3 Generate SQL Scripts using ADS 9.4 Table Data Editor 9.5 Server Script Generator 9.6 Using Object Search in ADS 9.7 Comparing two Database Schemas 9.8 Using the Visual Explain White Board 9.9 Using the Execution Monitor 9.10 Generating ER Diagrams 10. Procedure, Function & Package
Editor 11. SQL Debugger11.1.1 Oracle Debugger 11.1.2 DB2 Debugger 11.1.3 MS SQL Debugger 11.1.4 Sybase Debugger 12. ER Modeler in
ADS12.1 Notation and Normalization 12.2 Creating Tables 12.3 Creating Indexes 12.4 Creating Constraints 12.5 Creating Relationships & Subcategories 12.6 Adding Notes and Regions 12.7 Saving and Exporting an ER Model 12.8 Forward Engineering 12.9 Reverse Engineering 12.10 ER Modeler Demo 12.11 Converting ER Models DB to DB 13. Version
Control in ADS13.1 Using a Subversion Repository 13.2 Using a CVS Repository 13.3 File Search in Version Control 14.
Database Administrator Tools 14.1 ORACLE DBA
Tools14.1.1 Server Statistics 14.1.2 Rollback Manager 14.1.3 Log Manager 14.1.4 Session Manager 14.1.5 Instance Manager 14.1.6 Storage Manager 14.1.7 Security Manager 14.1.8 SGA Manager 14.2 SQL SERVER
DBA Tools14.2.1 Instance Manager 14.2.2 Session Manager 14.2.3 Security Manager 14.2.4 Storage Manager 14.2.5 SQL Agent Manager 14.3 SYBASE DBA
Tools14.3.1 Instance Manager 14.3.2 Session Manager 14.3.3 Security Manager 14.3.4 Storage Manager 14.4 MySQL DBA
Tools14.4.1 Instance Manager 14.4.2 Session Manager 14.4.3 Storage Manager 14.4.4 Security Manager 14.5 DB2 for
LUW DBA Tools14.5.1 Instance Manager 14.5.2 Session Manager 14.5.3 Storage Manager 14.5.4 Security Manager 15. Compare
Tools in ADS15.1 File Compare 15.2 Results Compare 15.3 Directory Compare 15.4 Tab Compare 15.5 Schema Compare 15.6 Copy History Compare 16. Editors
& Viewers 17. Aqua
Data Studio OPTIONS17.1 General Options 17.2 Editor Options 17.3 Compare and Results Options 17.4 Query Analyzer Options 17.5 Scripts and Results Options 17.6 Visual Explain Options 17.7 Formatter Options 17.8 Permissions and Registration Options 17.9 Key Mapping Options and Key Assist Tool 17.10 Command line |
3.18 MySQL JDBC DriversJDBC Drivers - MySQL JDBC Drivers
The MySQL JDBC (v3.1.10) drivers included with ADS work across
all versions of MySQL from 3.x to 4.1. MySQL server releases are
very frequent, and may sometimes require updating the JDBC
driver. Driver Location (Windows/Linux): Driver Location (OSX):
C:\Program Files (x86)\Aqua Data Studio 8.0 - 32bit\lib\drivers>dir
Volume in drive C has no label.
Volume Serial Number is 40F4-2392
Directory of C:\Program Files (x86)\Aqua Data Studio 8.0 - 32bit\lib\drivers
06/11/2009 09:47 AM .
06/11/2009 09:47 AM ..
06/10/2009 12:48 PM 1,146,367 db2java.jar
06/10/2009 12:48 PM 3,059,973 db2jcc.jar
12/07/2008 01:08 PM 2,068 db2jcc_license_cisuz.jar
06/10/2009 12:48 PM 1,015 db2jcc_license_cu.jar
06/10/2009 12:48 PM 2,446,767 derby.jar
06/10/2009 12:48 PM 514,328 derbyclient.jar
06/10/2009 12:48 PM 229,921 derbynet.jar
06/11/2009 09:46 AM 788,919 drivers-extended.zip
06/10/2009 12:48 PM 685,631 ifxjdbc.jar
06/10/2009 12:48 PM 529,560 jconnect60.jar
06/10/2009 12:48 PM 4,301,866 jt400.jar
06/10/2009 12:48 PM 568,827 jtds-src.jar
06/10/2009 12:48 PM 298,518 jtds.jar
06/10/2009 12:48 PM 655,034 mysql-src.jar
06/10/2009 12:48 PM 676,693 mysql.jar
06/10/2009 12:48 PM 444,919 ncluster.jar
06/10/2009 12:48 PM 1,646,178 nlscharset12.jar
06/10/2009 12:48 PM 1,555,682 oracle.jar
06/10/2009 12:48 PM 415,542 postgresql.jar
03/04/2009 11:57 AM 1,711 tdgssconfig.jar
03/04/2009 11:57 AM 848,943 terajdbc4.jar
06/10/2009 12:48 PM 286,771 util400.jar
06/10/2009 12:48 PM 139,148 xdb.jar
06/10/2009 12:48 PM 839,982 xmlparserv2.jar
24 File(s) 22,084,363 bytes
2 Dir(s) 261,242,703,872 bytes free
C:\Program Files (x86)\Aqua Data Studio 8.0 - 32bit\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 (x86)\Aqua Data Studio 8.0 - 32bit>type datastudio.ini working.directory=. # JVM Properties vm.location=.\jre\bin\client\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 vmarg.1=-Dsun.swing.enableImprovedDragGesture vmarg.2=-Xmx256M 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\aspose\*.jar classpath.6=.\lib\dnsjava\*.jar classpath.7=.\lib\drivers\*.jar classpath.8=.\lib\infragistics\*.jar classpath.9=.\lib\itext\*.jar classpath.10=.\lib\java\*.jar classpath.11=.\lib\jgoodies\*.jar classpath.12=.\lib\jgraph\*.jar classpath.13=.\lib\jide\*.jar classpath.14=.\lib\jinterop\*.jar classpath.15=.\lib\jna\*.jar classpath.16=.\lib\jogl\*.jar classpath.17=.\lib\quartz\*.jar classpath.18=.\lib\snmp4j\*.jar classpath.19=.\lib\ssh2\*.jar classpath.20=.\lib\stndeditor\*.jar classpath.21=.\lib\svnkit\*.jar main.class=com.aquafold.datastudio.DataStudio C:\Program Files (x86)\Aqua Data Studio 8.0 - 32bit>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-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-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-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-xmlgraphics.jar SET ADS_PATH=%ADS_PATH%;.\lib\apple\aqua2.jar SET ADS_PATH=%ADS_PATH%;.\lib\aspose\aspc.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_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\nlscharset12.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\oracle.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\postgresql.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\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\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\jogl\jogl.jar SET ADS_PATH=%ADS_PATH%;.\lib\jogl\gluegen-rt.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.xml.jar SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\org-openide-explorer.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 -Xmx256M -XX:MaxPermSize=128m -cp "%ADS_PATH%" com.aquafold.datastudio.Data Studio
|