 | |
oracle instance_name vs. service_name
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: oracle instance_name vs. service_name -
11-19-2008
, 05:50 PM
|
J?ns M?rtin Schl?tt?r <KmoEfrUew... (AT) spammotel (DOT) com> wrote: If I use sqlplus to connect to a database, I do it like that: sqlplus user1/secr... (AT) ora1 (DOT) mydomain.com:1583/db.prd1 where db.prd1 is the service_name. That's using the EZCONNECT syntax, ok. If I do the connect through JDBC, the connection url is: jdbc  racle:thin:@ora1.mydomain.com:1583:db1SQLPLUS uses the service name, whereas JDBC uses the instance_name (resp. sid). How does this work? Is the oracle protocol so that either instance name or service name can be used? I am surprised that this URL works, as indeed it does. I cannot find this form under the supported Syntaxes inhttp://download-uk..oracle.com/docs/cd/B19306_01/java.102/b14355/urls.... According to the documentation, it should be jdbc racle:thin:@//ora1.mydomain.com:1583/db.prd1Yours, Laurenz Albe |
and scroll down a bit to "If you are using the Thin or OCI drivers,
note the following:"
Found in a google search of:
jdbc thin style syntax
which led to http://twit88.com/blog/2008/05/29/ne...g-jdbc-driver/
So, judging from googling, at least, it's just an older syntax.
jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/m...19simmons.html
#12
| |||
| |||
|
|
J?ns M?rtin Schl?tt?r <KmoEfrUew... (AT) spammotel (DOT) com> wrote: If I use sqlplus to connect to a database, I do it like that: sqlplus user1/secr... (AT) ora1 (DOT) mydomain.com:1583/db.prd1 where db.prd1 is the service_name. That's using the EZCONNECT syntax, ok. If I do the connect through JDBC, the connection url is: jdbc racle:thin:@ora1.mydomain.com:1583:db1SQLPLUS uses the service name, whereas JDBC uses the instance_name (resp. sid). How does this work? Is the oracle protocol so that either instance name or service name can be used? I am surprised that this URL works, as indeed it does. I cannot find this form under the supported Syntaxes inhttp://download-uk..oracle.com/docs/cd/B19306_01/java.102/b14355/urls.... According to the documentation, it should be jdbc racle:thin:@//ora1.mydomain.com:1583/db.prd1Yours, Laurenz Albe |
and scroll down a bit to "If you are using the Thin or OCI drivers,
note the following:"
Found in a google search of:
jdbc thin style syntax
which led to http://twit88.com/blog/2008/05/29/ne...g-jdbc-driver/
So, judging from googling, at least, it's just an older syntax.
jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/m...19simmons.html
#13
| |||
| |||
|
|
J?ns M?rtin Schl?tt?r <KmoEfrUew... (AT) spammotel (DOT) com> wrote: If I use sqlplus to connect to a database, I do it like that: sqlplus user1/secr... (AT) ora1 (DOT) mydomain.com:1583/db.prd1 where db.prd1 is the service_name. That's using the EZCONNECT syntax, ok. If I do the connect through JDBC, the connection url is: jdbc racle:thin:@ora1.mydomain.com:1583:db1SQLPLUS uses the service name, whereas JDBC uses the instance_name (resp. sid). How does this work? Is the oracle protocol so that either instance name or service name can be used? I am surprised that this URL works, as indeed it does. I cannot find this form under the supported Syntaxes inhttp://download-uk..oracle.com/docs/cd/B19306_01/java.102/b14355/urls.... According to the documentation, it should be jdbc racle:thin:@//ora1.mydomain.com:1583/db.prd1Yours, Laurenz Albe |
and scroll down a bit to "If you are using the Thin or OCI drivers,
note the following:"
Found in a google search of:
jdbc thin style syntax
which led to http://twit88.com/blog/2008/05/29/ne...g-jdbc-driver/
So, judging from googling, at least, it's just an older syntax.
jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/m...19simmons.html
#14
| |||
| |||
|
|
If I use sqlplus to connect to a database, I do it like that: sqlplus user1/secr... (AT) ora1 (DOT) mydomain.com:1583/db.prd1 where db.prd1 is the service_name. That's using the EZCONNECT syntax, ok. If I do the connect through JDBC, the connection url is: jdbc racle:thin:@ora1.mydomain.com:1583:db1SQLPLUS uses the service name, whereas JDBC uses the instance_name (resp. sid). How does this work? Is the oracle protocol so that either instance name or service name can be used? I am surprised that this URL works, as indeed it does. I cannot find this form under the supported Syntaxes inhttp://download-uk.oracle.com/docs/cd/B19306_01/java.102/b14355/urls.... According to the documentation, it should be jdbc racle:thin:@//ora1.mydomain.com:1583/db.prd1Yours, Laurenz Albe http://download-west.oracle.com/docs...s.htm#g1073263 and scroll down a bit to "If you are using the Thin or OCI drivers, note the following:" Found in a google search of: jdbc thin style syntax which led to http://twit88.com/blog/2008/05/29/ne...g-jdbc-driver/ So, judging from googling, at least, it's just an older syntax. |
Yet even in 10.1 they don't seem to have that syntax in
"Table 3-3 Supported Database Specifiers"
Thanks for the clarification,
Laurenz Albe
#15
| |||
| |||
|
|
If I use sqlplus to connect to a database, I do it like that: sqlplus user1/secr... (AT) ora1 (DOT) mydomain.com:1583/db.prd1 where db.prd1 is the service_name. That's using the EZCONNECT syntax, ok. If I do the connect through JDBC, the connection url is: jdbc racle:thin:@ora1.mydomain.com:1583:db1SQLPLUS uses the service name, whereas JDBC uses the instance_name (resp. sid). How does this work? Is the oracle protocol so that either instance name or service name can be used? I am surprised that this URL works, as indeed it does. I cannot find this form under the supported Syntaxes inhttp://download-uk.oracle.com/docs/cd/B19306_01/java.102/b14355/urls.... According to the documentation, it should be jdbc racle:thin:@//ora1.mydomain.com:1583/db.prd1Yours, Laurenz Albe http://download-west.oracle.com/docs...s.htm#g1073263 and scroll down a bit to "If you are using the Thin or OCI drivers, note the following:" Found in a google search of: jdbc thin style syntax which led to http://twit88.com/blog/2008/05/29/ne...g-jdbc-driver/ So, judging from googling, at least, it's just an older syntax. |
Yet even in 10.1 they don't seem to have that syntax in
"Table 3-3 Supported Database Specifiers"
Thanks for the clarification,
Laurenz Albe
#16
| |||
| |||
|
|
If I use sqlplus to connect to a database, I do it like that: sqlplus user1/secr... (AT) ora1 (DOT) mydomain.com:1583/db.prd1 where db.prd1 is the service_name. That's using the EZCONNECT syntax, ok. If I do the connect through JDBC, the connection url is: jdbc racle:thin:@ora1.mydomain.com:1583:db1SQLPLUS uses the service name, whereas JDBC uses the instance_name (resp. sid). How does this work? Is the oracle protocol so that either instance name or service name can be used? I am surprised that this URL works, as indeed it does. I cannot find this form under the supported Syntaxes inhttp://download-uk.oracle.com/docs/cd/B19306_01/java.102/b14355/urls.... According to the documentation, it should be jdbc racle:thin:@//ora1.mydomain.com:1583/db.prd1Yours, Laurenz Albe http://download-west.oracle.com/docs...s.htm#g1073263 and scroll down a bit to "If you are using the Thin or OCI drivers, note the following:" Found in a google search of: jdbc thin style syntax which led to http://twit88.com/blog/2008/05/29/ne...g-jdbc-driver/ So, judging from googling, at least, it's just an older syntax. |
Yet even in 10.1 they don't seem to have that syntax in
"Table 3-3 Supported Database Specifiers"
Thanks for the clarification,
Laurenz Albe
#17
| |||
| |||
|
|
If I use sqlplus to connect to a database, I do it like that: sqlplus user1/secr... (AT) ora1 (DOT) mydomain.com:1583/db.prd1 where db.prd1 is the service_name. That's using the EZCONNECT syntax, ok. If I do the connect through JDBC, the connection url is: jdbc racle:thin:@ora1.mydomain.com:1583:db1SQLPLUS uses the service name, whereas JDBC uses the instance_name (resp. sid). How does this work? Is the oracle protocol so that either instance name or service name can be used? I am surprised that this URL works, as indeed it does. I cannot find this form under the supported Syntaxes inhttp://download-uk.oracle.com/docs/cd/B19306_01/java.102/b14355/urls.... According to the documentation, it should be jdbc racle:thin:@//ora1.mydomain.com:1583/db.prd1Yours, Laurenz Albe http://download-west.oracle.com/docs...s.htm#g1073263 and scroll down a bit to "If you are using the Thin or OCI drivers, note the following:" Found in a google search of: jdbc thin style syntax which led to http://twit88.com/blog/2008/05/29/ne...g-jdbc-driver/ So, judging from googling, at least, it's just an older syntax. |
Yet even in 10.1 they don't seem to have that syntax in
"Table 3-3 Supported Database Specifiers"
Thanks for the clarification,
Laurenz Albe
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.