# Specify a proportion of the available physical memory to use (ie. Ĭ:\Program Files\Aqua Data Studio 11.0 - 64bit>type datastudio.ini
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. Ĭ:\Program Files\Aqua Data Studio 11.0 - 64bit\lib\drivers>dirĭirectory of C:\Program Files\Aqua Data Studio 11.0 - 64bit\lib\driversĬ:\Program Files\Aqua Data Studio 11.0 - 64bit\lib\drivers> Below is a listing of the Aqua Data Studio library directory \lib\drivers\. 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. If you are using Oracle 8i then the ojdbc14.jar file will not exist but may be substituted by the classes12.jar or classes12.zip file.Ĭ:\oracle\product\10.2.0\db_1\jdbc\lib>dirĭirectory of C:\oracle\product\10.2.0\db_1\jdbc\lib 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. Below is a directory listing of the driver files in the \jdbc\lib\ directory. You may locate the JDBC drivers for your installed version of Oracle in the Oracle server or Oracle client installations. You may locate the latest Oracle JDBC drivers at the following location. There is no need to change or update the drivers on OSX. Note OSX Installations: OCI Connections are not supported on OSX. If you have the 8i/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 8i/9i JDBC driver, which has support for 8i/9i 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. Oracle JDBC/OCI drivers do not provide support between OCI libraries. In Java 5, the method was altered in order to support JSR-13:Decimal Arithmetic Enhancement standard.Oracle JDBC drivers provide compatibilty between different version of the Oracle server. Oracle driver, while binding the objects to SQL types, is calling BigDecimal.toString() method. In order to safe the precision in Java it is the common practice to use BigDecimals. The bug appeared with Oracle JDBC driver ( ojdbc14.jar) version 10.1.0.4 once we migrated the application to Java 5 from Java 1.4.
Recently we encountered a production bug where a client got some extra money on his/her account. I would like to share an issue with you regarding Oracle 10g JDBC driver and migration to Java 5.
0 kommentar(er)
