• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Oracle jdbc connect error and patch version

Explorer ,
Nov 27, 2024 Nov 27, 2024

Copy link to clipboard

Copied

I was forced to upgrade from Coldfusion 2018 to Coldfusion 2021, update 16.  For our database connection we are using the Oracle wallet to use ssl authentication.  This was working fine in 2018.  Now with the upgrade it stopped working.  The error is this:
java.sql.SQLNonTransientConnectionException: [DataDirect][Oracle JDBC Driver]Error during renegotiation of SSL socket.

 

I found this article on the same error that occurred with a version of the datadirect drivers:

https://community.progress.com/s/article/Unable-to-get-JDBC-connection-to-SSL-enabled-multitenant-Or...

 

My question is, I know the version shipped with coldfusion 2021 is 6.0, but what is the patch/build version?  I want to compare it against what is in the progress datadirect article to see if that is the problem.  I already tried updating to CF update 17 for 2021, and that mucked up our other database connection as well, so I uninstalled it and went back to update 16.  

 

Thank You.

Views

191

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Nov 28, 2024 Nov 28, 2024

I have found a way to trick ColdFusion into revealing the full version of the Datadirect Oracle driver. 

<cfset baseExceptionsObject=createobject("java","macromedia.jdbc.oracle.base.BaseExceptions")>
<!---<cfdump var="#baseExceptionsObject#" label="macromedia.jdbc.oracle.base.BaseExceptions object"><br>--->

<!--- Deliberate fake call, causing an error. The error message should, we hope, reveal the version --->
<cfoutput>#baseExceptionsObject.bm(-1)#</cfoutput>


The result on ColdFusion 2023 Upd

...

Votes

Translate

Translate
Community Expert ,
Nov 27, 2024 Nov 27, 2024

Copy link to clipboard

Copied

Ugh. The file you're interested in is something like C:\ColdFusion2021\cfusion\lib\adobe_drivers.jar. (Actually, of course, it's somewhere within that jar, like macromedia/jdbc/oracle.properties or macromedia/jdbc/OracleDriver.class.) Unfortunately, this is a DataDirect driver as you know, and it doesn't contain the relevant version info in a MANIFEST.mf file - I think that's where it would have to go. I'm not entirely sure whether you can just download something from Progress to fix it. You could try in a test environment, but you'd still have to guess at the version you're using.

 

I recommend that you open a ticket at https://tracker.adobe.com/ asking (a) can Adobe fix this problem and if so when, (b) what version of the driver you're actually using, and (c) can you download something from Progress that will fix this problem. I'm pretty sure that the Adobe version is one or two versions behind the latest Progress version. I'm sorry I can't give you a more definitive answer. Maybe one of the other contributors can. Adobe might be able to provide a personal bugfix for you and maybe anyone else with the same problem.

 

Alternatively, you could try Oracle's own JDBC driver instead. I think it's free, but it'll come with its own problems I'm sure.

 

Dave Watts, Eidolon LLC

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 28, 2024 Nov 28, 2024

Copy link to clipboard

Copied

Hi @Yodeler ,

Someone once asked a related question: on how to fix an ArrayCopy Out Of Bounds Error. The question contains a clue.  You will see that the error message in that post contains lines such as

...
at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1051|:1102)
at macromedia.jdbc.oracle.base.BaseExceptions.a(|Oracle|6.0.0.1051|:976)
at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1051|:1128)
at macromedia.jdbc.oracle.base.BaseExceptions.b(|Oracle|6.0.0.1051|:796)
at macromedia.jdbc.oracle.OracleImplConnection.open(|Oracle|6.0.0.1051|:2602)
...

 

I'm guessing that 6.0.0.1051 refers to the version. So, take a look at your own error messages. Do you see a similar string?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 28, 2024 Nov 28, 2024

Copy link to clipboard

Copied

Oh, and please share your findings with the forum. 🙂

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 28, 2024 Nov 28, 2024

Copy link to clipboard

Copied

I have found a way to trick ColdFusion into revealing the full version of the Datadirect Oracle driver. 

<cfset baseExceptionsObject=createobject("java","macromedia.jdbc.oracle.base.BaseExceptions")>
<!---<cfdump var="#baseExceptionsObject#" label="macromedia.jdbc.oracle.base.BaseExceptions object"><br>--->

<!--- Deliberate fake call, causing an error. The error message should, we hope, reveal the version --->
<cfoutput>#baseExceptionsObject.bm(-1)#</cfoutput>


The result on ColdFusion 2023 Update 11:

BKBK_0-1732803010142.png

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Dec 02, 2024 Dec 02, 2024

Copy link to clipboard

Copied

I was able to get the version, but I had to add a cftry, cfcatch around the error to get the version message.  Thanks so much.

It turns out the version that is supplied in Coldfusion2021 is 1051.  The fixed version that I need per Progress/DataDirect is 1080.  So I'm thinking that this is likely the culprit.  I'll log a bug with Adobe, maybe they will provide a hotfix for me.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Dec 03, 2024 Dec 03, 2024

Copy link to clipboard

Copied

LATEST

Thanks for the update. Please let us know how things go.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation