Recently while i was trying to configure Sun One Application Server with Oracle 10i
i found out that the traditional method of jdbc url pattern [jdbc:oracle:thin@myhost:port:service]
not working .
Then after spending some time in searching the net, i found that in 10i the jdbc url pattern has changed to "jdbc:oracle:thin:username/password@//myhost:1521/orcl".
NOTE:
Difference Between Service & SID:
Oracle SID is the unique name that uniquely identifies an instance/database.
Service name is the TNS alias for a database and this Service name is recorded in Tnsnames.ora file on your clients and it can be the same as SID (the default) or may be different.
posted by Nagz @ 11:08 PM
0 Comments:
Post a Comment
<< Home