CODEWITHSUNDEEP
javaoracle-databasejdbc
sagar
sagar

Reputation: 1

jdbc programming through oracle

what is the service name of oracle10g xe database

Upvotes: 0

Views: 852

Answers (3)

Andreas Dolk
Andreas Dolk

Reputation: 114767

Service name is ambigious. But as you asked about jdbc I guess you need advice on the service name that is used on the jdbc url.

Here is a good article with a link to oracle sources.

Basically it says that the format is

jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename

and myservicename can be found in TNSNAMES.ORA.

Upvotes: 0

Jörn Horstmann
Jörn Horstmann

Reputation: 34014

The jdbc url for a locally installed xe databse would look like this: jdbc:oracle:thin:@127.0.0.1:1521:XE, note that XE is the SID, a service name does not seem to be needed for jdbc.

Upvotes: 1

Venkat
Venkat

Reputation: 2634

It varies ragarding the network. In our local system it'll be 'localhost'

Upvotes: 1

Related Questions