

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production Use sqlplus.exe and connect to the D]$ sqlplus Release 11.1.0.7.0 - Production on Wed Mar 14 11:10:17 2012Ĭopyright (c) 1982, 2008, Oracle. I downloaded and extracted the following zips file The following steps demonstrate how to use it with simple connection.ġ.

Use the tool at your own discretion.First, download the instant client you which to use from.

oracle-jdbc-tester is a 3rd party tool with no link to CA Technologies. jdbc-tester-1.0.jar RELAUTO password123 INFO Main - arg 0 = RELAUTOĢ3:59:48.248 INFO Main - arg 1 = password123Ģ3:59:48.248 INFO Main - arg 2 = INFO Main - ****** Starting JDBC Connection test *******Ģ3:59:59.293 INFO Main - Running SQL query: Ģ3:59:59.321 INFO Main - Result of sql Query: Ģ3:59:59.321 INFO Main - JDBC connection test successful!ĭISCLAIMER: This KB article is for information purpose only. jdbctester]$ /opt/releaseautomation/scripts/jdbctester/jdk1.7.0_181/bin/java -jar. jdbc-tester-1.0.jar RELAUTO password123 INFO Main - arg 0 = RELAUTOĢ3:53:00.828 INFO Main - arg 1 = password123Ģ3:53:00.828 INFO Main - arg 2 = INFO Main - ****** Starting JDBC Connection test *******Ģ3:53:09.157 ERROR Main - Exception occurred connecting to database: IO Error: The Network Adapter could not establish the connection jdbctester]$ /opt/releaseautomation/jre/bin/java -jar. Syntax: java -jar target/jdbc-tester-1.0.jar 1 (Failed JDBC connection) Grant execute permissions to jdbc-tester-1.0.jar using ' chmod +x j dbc-tester-1.0.jar'Ĥ. Execute the JAR file using the schema name, password and JDBC connection details: Copy it to the folder where Java is installed.ģ. The oracle-jdbc-tester is a handy tool that can be used to test JDBC connection to an Oracle Server.Ģ.
