I use Oracle in UNIX environment. I know the information of dbhost, port and service-name. However I can't use the form of "jdbc racle:thin:@dbhost ort:sid" because I don't have a "sid". Can you tell me how to connect DB in such a situation? By the way, could there anyone tell me where to find the format of dbURl passed to DriverManager.getConnection(dbURL) as I saw different DB use different dbURL format. Thanks a lot. Rgds, Ma Di
ram menon
Greenhorn
Joined: Oct 24, 2000
Posts: 5
posted
0
Every Oracle installation will have an SID. By default it is ORCL. But you can change this during installation. You can use the OCI driver if you do not know the SID. jdbcracleci8:@<database> where <database> is either an entry in tnsnames.ora or a SQL*net name-value pair. Hope this helps, Ram
Ma Di
Greenhorn
Joined: Nov 28, 2000
Posts: 6
posted
0
Thanks a lot. Ram. Rgds, Ma Di
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
racle:thin:@dbhost 
ort:sid" 
racle