Hi,
I am trying to create a connection with a custom JDBC connection string, but SQL*Developer throws the error message:
Status : Failure -Test failed: Required property 'hostname' is not set on the DatabaseProvider
my tests are:
<li> with connection via
Connection Type set to
TNS and a proper alias - it works fine
<li> with connection via
Connection Type set to
Advanced and exactly the same values from tns in the url:
jdbc:oracle:thin:@(DESCRIPTION=(enable=broken)(ADDRESS=(PROTOCOL=tcp)(HOST=172.24.32.113)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=RESTSVP_SITE1)))
- it fails with
Status : Failure -Test failed: Required property 'hostname' is not set on the DatabaseProvider
<li> with JDBC URL set to
jdbc:oracle:thin:@172.24.32.113:1521/RESTSVP_SITE1
- it works fine
As my
jdbc url is quite close to the example in [url http://docs.oracle.com/cd/E11882_01/java.112/e16548/apxtblsh.htm#CHDBBDDA]Using JDBC with Firewalls maybe someone can help me to fix it?
Martin
Edited by: berx on Oct 12, 2012 11:32 AM - fixed typos