Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Connection - url

843854May 13 2003 — edited May 21 2003
Help!
My java application has database connection with oracle using Oracle thin driver. Currently this is my url which is in my properties file and the connectionBean accesses this properties file to connect.

url = jdbc:odbc:oracle:thin:@160:150:122:21:1521:alwf;
160:15:122:21 is the ip address of the database server. alwf is the SID; This works well but the database group changes the ip address every once in a while and they do not let the developers know; I am sure there is a way to connect it to the server without the ip address. Please help if you know a way.
Thanks
Sue

Comments

Frank Kulash
Answer
Hi,

Here's one way: 
WHERE   COLUMNA NOT LIKE '%ABC' 
AND 	(   COLUMNA NOT LIKE 'ABC%' 
	OR  COLUMNA  =	     'ABCD'
	)
AND 	COLUMNA NOT LIKE '%XYZ' 
AND 	COLUMNA NOT LIKE 'XYZ%'
Marked as Answer by SeshuGiri · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 18 2003
Added on May 13 2003
#java-database-connectivity-jdbc
13 comments
632 views