Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0000382Openbravo ERPY. DBSourceManagerpublic2008-05-20 16:162009-03-18 11:02
marvintm 
marvintm 
highmajoralways
closedfixed 
5
 
 
Core
No
0000382: Export.database doesn't work in PostgreSQL (Invalid property name 'CODE_REVISION')
When you try to export structure or data in PostgreSQL in the Trunk, it gives an error:

export.database:

export.database.structure:
[exportdatabase] Reading tables...
[exportdatabase] Reading views...
[exportdatabase] Reading sequences...
[exportdatabase] Reading triggers...
[exportdatabase] Reading functions...
[exportdatabase] Sorting foreign keys and checks...
[exportdatabase] Starting function and trigger standardization.

BUILD FAILED
/home/openbravo/workspaceBuena/openbravo/build.xml:298: The following error occurred while executing this line:
/home/openbravo/workspaceBuena/openbravo/src-db/database/build.xml:355: java.lang.IllegalArgumentException: Invalid property name 'CODE_REVISION'

The problem is that in PostgreSQL, properties have to be searched in beans in lower case, and DBSourceManager currently searches the property CODE_REVISION in upper case.
Just do

ant export.database

in a working copy of the trunk, with Openbravo.properties pointing to a PostgreSQL database.
dbsm_migrate
Issue History
2008-05-20 16:16marvintmNew Issue
2008-05-20 16:16marvintmAssigned To => marvintm
2008-05-20 16:17marvintmStatusnew => scheduled
2008-05-20 16:17marvintmNote Added: 0000259
2008-05-21 12:11marvintmStatusscheduled => resolved
2008-05-21 12:11marvintmResolutionopen => fixed
2008-05-21 12:11marvintmNote Added: 0000285
2008-11-26 14:10psarobeStatusresolved => closed
2008-12-18 12:38jpabloaeSticky IssueNo => Yes
2008-12-18 12:39jpabloaeSticky IssueYes => No
2008-12-18 12:39jpabloaeTag Attached: dbsm_migrate
2008-12-18 12:41jpabloaeProject@4@ => Openbravo ERP
2008-12-18 12:41jpabloaeCategory => Y. DBSourceManager
2009-03-18 11:02anonymoussf_bug_id0 => 2691308

Notes
(0000259)
marvintm   
2008-05-20 16:17   
It only happens in the trunk (in 2.3x and in 2.4x the security mechanism for DBSourceManager wasn't yet implemented).
(0000285)
marvintm   
2008-05-21 12:11   
Now export.database will work again in PostgreSQL.