You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "Edwards, Crista E" <cr...@pnc.com.INVALID> on 2020/01/27 17:14:55 UTC
Tomcat 9.0 - JDBC URL Help
What is the proper syntax for the URL portion of my JDBC connection when using 2 databases? We are on Tomcat 9.0, connecting to an Oracle database. We have 2 database instances, one active & one inactive, but the JDBC connection must contain both & connect to the active instance. Below is an example of the URL we were using when on Websphere servers.
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(source_route=off)(load_balance=off)(failover=on)(address=(protocol=tcp)(host=ldb123.prod.exint.net)(port=1500))(address=(protocol=tcp)(host=ldb234.prod.exint.net)(port=1500)))(connect_data=(service_name=abc0405p_rwsvc.prod.exint.net)))
Thank you,
Crista Edwards
The contents of this email are the property of PNC. If it was not addressed to you, you have no legal right to read it. If you think you received it in error, please notify the sender. Do not forward or copy without permission of the sender. This message may be considered a commercial electronic message under Canadian law or this message may contain an advertisement of a product or service and thus may constitute a commercial electronic mail message under US law. You may unsubscribe at any time from receiving commercial electronic messages from PNC at http://pages.e.pnc.com/globalunsub/
PNC, 249 Fifth Avenue, Pittsburgh, PA 15222; pnc.com
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Tomcat 9.0 - JDBC URL Help
Posted by Luis Rodríguez Fernández <uo...@gmail.com>.
Hello Crista,
I do think that you can have more chances of get an answer for this in the
Oracle Community [1]
Anyway this is how our tns entries [2] looks like for our Oracle Databases:
TNS_ENTRY_1_PROD=(
DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP) (HOST=my.host.name.1) (PORT=XXXXX) )
(ADDRESS=
(PROTOCOL=TCP) (HOST=my.host.name.1) (PORT=XXXXX) )
(LOAD_BALANCE=off)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=my.service.name)
(FAILOVER_MODE=
(TYPE=SELECT)
(METHOD=BASIC)
)
)
)
Hope it helps,
Luis
[1]
https://community.oracle.com/community/groundbreakers/database/general_questions
[2]
https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/glossary.html#GUID-8836AF91-6176-4133-BD13-348AF90181CE
El lun., 27 ene. 2020 a las 18:15, Edwards, Crista E
(<cr...@pnc.com.invalid>) escribió:
> What is the proper syntax for the URL portion of my JDBC connection when
> using 2 databases? We are on Tomcat 9.0, connecting to an Oracle database.
> We have 2 database instances, one active & one inactive, but the JDBC
> connection must contain both & connect to the active instance. Below is an
> example of the URL we were using when on Websphere servers.
>
> jdbc:oracle:thin:@
> (DESCRIPTION=(ADDRESS_LIST=(source_route=off)(load_balance=off)(failover=on)(address=(protocol=tcp)(host=
> ldb123.prod.exint.net)(port=1500))(address=(protocol=tcp)(host=
> ldb234.prod.exint.net)(port=1500)))(connect_data=(service_name=
> abc0405p_rwsvc.prod.exint.net)))
>
> Thank you,
> Crista Edwards
>
>
>
> The contents of this email are the property of PNC. If it was not
> addressed to you, you have no legal right to read it. If you think you
> received it in error, please notify the sender. Do not forward or copy
> without permission of the sender. This message may be considered a
> commercial electronic message under Canadian law or this message may
> contain an advertisement of a product or service and thus may constitute a
> commercial electronic mail message under US law. You may unsubscribe at any
> time from receiving commercial electronic messages from PNC at
> http://pages.e.pnc.com/globalunsub/
> PNC, 249 Fifth Avenue, Pittsburgh, PA 15222; pnc.com
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
--
"Ever tried. Ever failed. No matter. Try Again. Fail again. Fail better."
- Samuel Beckett