Maybe this will help. This is the connection string we use for JSP.
jdbc:oracle:thin:@oracle1dp.gavilon.com:1535:oracle11p
username is: roUser
password: xxxxx
Using this, I get the connection string:
Host: oracle1dp.gavilon.com:1535; SID=oracle11p; Direct=true; User ID=roUser; Password=xxxxx;
Get connection failed. Object doesn't exist. If I leave off the port number, I get connection failed, no listener.