ADempiere ERP Business Suite / Bugs / #2173 Oracle JDBC driver problema

#2173 Oracle JDBC driver problema

Milestone: Core

Status: open-remind

Owner: Teo Sarca

Labels: Technical (124)

Priority: 3

Updated: 2010-04-16

Created: 2009-10-12

Creator: Cristina Ghita

Private: No

Hi,

After I integrated the BF [ 2849122 ] PO.AfterSave is not rollback on error - add releaseSavepoint method, I couldn't anymore to post documents.
The problem is in method releaseSavepoint(Savepoint savepoint). Apparently , Oracle JDBC driver doesn't support releasing savepoints .

Regards,
Cristina Ghita, www.arhipac.ro

Discussion

Cristina Ghita - 2009-10-12

assigned_to: nobody --> teo_sarca
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Teo Sarca - 2009-10-12

status: open --> pending-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Teo Sarca - 2009-10-12

Revision: 10580
http://adempiere.svn.sourceforge.net/adempiere/?rev=10580&view=rev
Author: teo_sarca
Date: 2009-10-12 08:37:01 +0000 (Mon, 12 Oct 2009)

Log Message:
-----------
BF [ 2876927 ] Oracle JDBC driver problema
https://sourceforge.net/tracker/?func=detail&atid=879332&aid=2876927&group_id=176962

Note: As of Oracle Database 10g, releaseSavepoint and
oracleReleaseSavepoint are not supported. If you call either
of the methods, then SQLException is thrown with the message
"Unsupported feature".
-- 4-4 Oracle Database JDBC Developer's Guide and Reference

Modified Paths:
--------------
trunk/base/src/org/compiere/util/Trx.java

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Heng Sin - 2009-10-12

Hi Teo,

I think we should treat releaseSavepoint similar to the rollback of transaction where it is reasonably safe to ignore the sqlexception ( maybe just log as warning ).

WDYT ?

Regards,
Low

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Ruiz - 2009-10-12

Teo, I don't like this solution.

The last version of oracle jdbc is 11.2.0.1.0:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

I think a better solution will be to upgrade the jdbc jar to the latest - and ignore the sqlexception when unsupported (as Heng Sin adviced).

Regards,

Carlos Ruiz

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Ruiz - 2009-10-12

status: pending-fixed --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Teo Sarca - 2009-10-13

status: open-fixed --> open-remind
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Teo Sarca - 2009-10-13

Hi,

Ok, I will do this in next days.

Best regards,
Teo Sarca

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Teo Sarca - 2009-10-23

I uploaded the changed file. Please review.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Teo Sarca - 2009-10-23

Trx.java

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Ruiz - 2010-04-16

Warning - seems like Trx.java is dropping a public method (unused in Adempiere).

Pending tasks -> upgrade oracle jdbc driver
integrate Trx.java here (just the changes on releaseSavePoint)

Regards,

Carlos Ruiz

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Ruiz - 2010-04-16

priority: 5 --> 3

milestone: --> Core
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Carlos Ruiz - 2010-06-14

Committed revision 12536.

upgraded to Oracle Database 11g Release 2 (11.2.0.1.0) JDBC Drivers downloaded from
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_112010.html

ojdbc6.jar (2,111,220 bytes) - Classes for use with JDK 1.6. It contains the JDBC driver classes except classes for NLS support in Oracle Object and Collection types.
Link to SF Tracker: http://sourceforge.net/support/tracker.php?aid=2876927

We need to check if the provided Trx.java works better now.

Regards,

Carlos Ruiz

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Tony Snook - 2010-06-14

Merged Rev 12536 to /trunk with Revision: 12538
http://adempiere.svn.sourceforge.net/adempiere/?rev=12538&view=rev

Regards,
Tony

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.