Connect to Oracle by ServiceName

296 views
Skip to first unread message

Tim Bugler

unread,
Mar 20, 2017, 1:16:14 PM3/20/17
to Lucee
Hoping someone can point me in the right direction;

Recently a provider changed the connection parameters for Oracle and they no longer use SID; they connect by ServiceName. 

1. How can I omit the SID in a JDBC connection string? If I leave out the SID Lucee throws and invalid format of the connection string; if I add it the server returns does not know of SID given by connector.
2. Same issue if I try to connect via an Oracle connections (as opposed to a jdbc driver)

Any ideas?

T.

Zac Spitzer

unread,
Mar 20, 2017, 8:33:49 PM3/20/17
to lu...@googlegroups.com
by provider you mean a third party db, or do you run the oracle server?

in regards to 2, you're saying sqlplus and tnsping also are failing?

it's been a while since i worked with oracle, but the first thing i'd be doing
is looking at the listener.ora file on the database server

btw which version of lucee?




--
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/f8c323d0-cc09-456c-ac20-6b6603e90a76%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Zac Spitzer
+61 405 847 168

Zac Spitzer

unread,
Mar 20, 2017, 8:49:17 PM3/20/17
to lu...@googlegroups.com

Tim Bugler

unread,
Mar 21, 2017, 8:30:09 AM3/21/17
to lu...@googlegroups.com
Lucee 5

It's a 3rd party provider, so I don't have access to Oracle, just the connection. They have disabled SID for security reasons and only allow connections via ServiceName. The issue isn't on the Oracle side, but how Lucee expects the JDBC connection string to be formatted. I can't omit the SID; Lucee doesn't like that. Attempting to use ODBC isn't an option as it again attempts to connect via SID.

Just wondering if anyone has a work around or driver for JDBC.

T.

On Mon, Mar 20, 2017 at 10:20 PM Zac Spitzer <zac.s...@gmail.com> wrote:
by provider you mean a third party db, or do you run the oracle server?

in regards to 2, you're saying sqlplus and tnsping also are failing?

it's been a while since i worked with oracle, but the first thing i'd be doing
is looking at the listener.ora file on the database server

btw which version of lucee?



On Tue, Mar 21, 2017 at 4:16 AM, Tim Bugler <tjbu...@gmail.com> wrote:
Hoping someone can point me in the right direction;

Recently a provider changed the connection parameters for Oracle and they no longer use SID; they connect by ServiceName. 

1. How can I omit the SID in a JDBC connection string? If I leave out the SID Lucee throws and invalid format of the connection string; if I add it the server returns does not know of SID given by connector.
2. Same issue if I try to connect via an Oracle connections (as opposed to a jdbc driver)

Any ideas?

T.

--
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.

To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/f8c323d0-cc09-456c-ac20-6b6603e90a76%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Zac Spitzer
+61 405 847 168

--
You received this message because you are subscribed to a topic in the Google Groups "Lucee" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/lucee/HlkCsvDmZZw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to lucee+un...@googlegroups.com.

To post to this group, send email to lu...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.
--
Tim Bugler
Web Guy / Volleyball Coach / Generally Busy Guy

Tim Bugler

unread,
Mar 21, 2017, 8:51:57 AM3/21/17
to lu...@googlegroups.com
Modifying the Oracle.cfc files doesn't appear to have any effect; pretty sure the OracleDriver is expecting an SID (regardless of how you format the dsn string).

So I guess its not so much Lucee as it is the oracle.jdbc.driver.OracleDriver?

T.

On Mon, Mar 20, 2017 at 9:19 PM Zac Spitzer <zac.s...@gmail.com> wrote:
On Tue, Mar 21, 2017 at 11:33 AM, Zac Spitzer <zac.s...@gmail.com> wrote:
by provider you mean a third party db, or do you run the oracle server?

in regards to 2, you're saying sqlplus and tnsping also are failing?

it's been a while since i worked with oracle, but the first thing i'd be doing
is looking at the listener.ora file on the database server

btw which version of lucee?



On Tue, Mar 21, 2017 at 4:16 AM, Tim Bugler <tjbu...@gmail.com> wrote:
Hoping someone can point me in the right direction;

Recently a provider changed the connection parameters for Oracle and they no longer use SID; they connect by ServiceName. 

1. How can I omit the SID in a JDBC connection string? If I leave out the SID Lucee throws and invalid format of the connection string; if I add it the server returns does not know of SID given by connector.
2. Same issue if I try to connect via an Oracle connections (as opposed to a jdbc driver)

Any ideas?

T.

--
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.

To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/f8c323d0-cc09-456c-ac20-6b6603e90a76%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Zac Spitzer
+61 405 847 168




--
Zac Spitzer
+61 405 847 168

--
You received this message because you are subscribed to a topic in the Google Groups "Lucee" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/lucee/HlkCsvDmZZw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.
--
Message has been deleted

Tim Bugler

unread,
Mar 21, 2017, 9:08:33 AM3/21/17
to lu...@googlegroups.com
Ignore that - updated wrong Lucee install. Modifying Oracle.cfc worked.

Thanks,

T.

Zac Spitzer

unread,
Mar 21, 2017, 7:21:19 PM3/21/17
to lu...@googlegroups.com
Great, can you submit a pull request https://github.com/lucee/Lucee/pulls ?

To unsubscribe from this group and stop receiving emails from it, send an email to lucee+unsubscribe@googlegroups.com.

To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/f8c323d0-cc09-456c-ac20-6b6603e90a76%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Zac Spitzer
+61 405 847 168




--
Zac Spitzer
+61 405 847 168

--
You received this message because you are subscribed to a topic in the Google Groups "Lucee" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/lucee/HlkCsvDmZZw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to lucee+unsubscribe@googlegroups.com.
--
Tim Bugler
Web Guy / Volleyball Coach / Generally Busy Guy
--
Tim Bugler
Web Guy / Volleyball Coach / Generally Busy Guy

--
**Ann: the mailing list is being migrated to the Lucee Dev forum at https://dev.lucee.org**
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAAOoH-PJdNAWdEYHfF1BOb-yx4%3Deo3D7rX33KArq_qprL8FBUA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages