Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0043137Openbravo ERPA. Platformpublic2020-02-06 18:222020-06-19 11:41
Reportershuehner 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR20Q3 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0043137: oracle jdbc driver needs to be updated to support Oracle 19c
DescriptionThe jdbc driver version in lib/runtime/ojdbc6.jar does now allow to connect to Oracle 19c but fails with:

     [java] 720 [main] ERROR org.openbravo.database.ConnectionProviderImpl - Error getting connection
     [java] java.sql.SQLException: ORA-28040: No matching authentication protocol

Quick check replacing that jdbc driver version with the ones shipped in 19C 19.3.0 oracle version solves that issue.

For quick test that jdbc jar can be found in oracle install at:
app/oracle/product/19.0.0/dbhome_1/jdbc/lib/ojdbc8.jar

Steps To ReproduceTry running i.e. create.database (or even trl.lib) command against oracle 19c database server.
Proposed SolutionUpdate jdbc driver to newer version while checking if it is still compatible with older releases supported by Openbravo (11.2 and 12.x)
Additional Information
TagsNo tags attached.
Relationships
blocks feature request 0043136 closed shuehner support Oracle 19c 
causes defect 0044726 closed platform jdbc connection to Oracle 11 sometimes fails 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-02-06 18:22shuehnerNew Issue
2020-02-06 18:22shuehnerAssigned To => platform
2020-02-06 18:22shuehnerOBNetwork customer => No
2020-02-06 18:22shuehnerModules => Core
2020-02-06 18:22shuehnerTriggers an Emergency Pack => No
2020-02-06 18:22shuehnerRelationship addedblocks 0043136
2020-05-27 07:59alostaleAssigned Toplatform => alostale
2020-05-27 08:15hgbotCheckin
2020-05-27 08:15hgbotNote Added: 0120320
2020-05-27 08:15hgbotStatusnew => resolved
2020-05-27 08:15hgbotResolutionopen => fixed
2020-05-27 08:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1c1ba90c4ba50e17f61de532c2f5d94d1ae18a78 [^]
2020-05-27 08:41alostaleReview Assigned To => caristu
2020-05-27 08:41alostaleNote Added: 0120323
2020-05-29 08:51caristuNote Added: 0120449
2020-05-29 08:51caristuStatusresolved => closed
2020-05-29 08:51caristuFixed in Version => 3.0PR20Q3
2020-06-19 11:41hgbotCheckin
2020-06-19 11:41hgbotNote Added: 0120923
2020-07-30 15:06shuehnerRelationship addedcauses 0044726

Notes
(0120320)
hgbot   
2020-05-27 08:15   
Repository: erp/devel/pi
Changeset: 1c1ba90c4ba50e17f61de532c2f5d94d1ae18a78
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Feb 11 12:03:32 2020 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/1c1ba90c4ba50e17f61de532c2f5d94d1ae18a78 [^]

fixed ISSUE-43137: updated Oracle jdbc to 19.3.0.0

Maven artifact:
    -groupId: com.oracle.ojdbc
    -artifactId: ojdbc8
    -version: 19.3.0.0

---
M build.xml
M legal/Licensing.txt
M legal/OTN_license.txt
A lib/runtime/ojdbc8-19.3.0.0.jar
R lib/runtime/ojdbc6.jar
---
(0120323)
alostale   
2020-05-27 08:41   
updated from 11.2.0.2.0 to 19.3.0.0
(0120449)
caristu   
2020-05-29 08:51   
Reviewed

MR: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/43 [^]
(0120923)
hgbot   
2020-06-19 11:41   
Repository: tools/automation/pi-mobile
Changeset: 4ce8dfed86f96817045d31e462d5cbc9eb4a3c27
Author: Cristian Berner <cristian.berner <at> openbravo.com>
Date: Wed Jun 17 10:17:33 2020 +0200
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/4ce8dfed86f96817045d31e462d5cbc9eb4a3c27 [^]

Relate to ISSUE-43137: Update ojdbc to support Oracle19

ojdbc6 has been updated to ojdbc8 and oracle-default.jar symlink now is
linked to this new library

---
M lib/runtime/oracle-default.jar
A lib/runtime/choosables/ojdbc8-19.3.0.0.jar
R lib/runtime/choosables/ojdbc6.jar
---