0003698: Oracle specific code fails on Postgresql - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0003698

Openbravo ERP

01. General setup

public

2008-05-06 01:58

2008-06-12 09:44

Reporter

cromero

Assigned To

cromero

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

2.35MP4

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0003698: Oracle specific code fails on Postgresql

Description

Related to bug:
0002941

Hi,

browse this file:
openbravo/src/org/openbravo/erpCommon/ad_forms/InitialClientSetup.java

inside you'll see several refernces to
" strError = strError.substring( strError.lastIndexOf("@ORA-")
,strError.length());
"

But "@ORA-" is specific Oracle code that'll lead to errors such as out of
range exception (-1 passed to lastIndexOf ) if used with Postgresql under
certain circumstances. We got the error while importing the Frechn chart of
account on postgresql, we add to comment out those lines to make it pass.

Anyway, I don't really know what the current code breaks wand what would be
the best fix, but what I know is that this code is currently unsafe for
Postgresql.

Best regards,

RaphaÃ«l Valyi
http://www.smile.fr [^]

Steps To Reproduce

Proposed Solution

Additional Information