Openbravo Issue Tracking System - Java Client POS
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007550Java Client POS(No Category)public2009-02-13 13:152011-04-01 00:00
Reportermirurita 
Assigned Toadrianromero 
PrioritynormalSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version 
Target Version2.30Fixed in Version 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
OBNetwork customer
Support ticket
Regression introduced in release
Summary0007550: Kettle synchronization: boolean type problem in PostgreSQL
DescriptionIf you configure transformations to use PostgreSQL database and run the transformation it fails.

Information:
http://www.javaforge.com/proj/tracker/itemDetails.do?task_id=5718&navigation=true [^]

http://forums.pentaho.org/showthread.php?t=27330 [^]
Steps To ReproduceRun Openbravo ERP.

Edit kettle.properties file:
http://wiki.openbravo.com/wiki/OpenbravoPOS_Installation#Usage_2 [^]

db.URL = jdbc:postgresql://localhost:5432/openbravopos [^]
db.driver = org.postgresql.Driver
db.user = user
db.password = pass

Start spoon and run Customers.ktr transformation for example.



Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-13 13:15miruritaNew Issue
2009-02-13 16:07miruritaDescription Updated
2009-02-16 10:10adrianromeroSeverityminor => critical
2009-02-16 10:10adrianromeroStatusnew => scheduled
2009-02-16 10:10adrianromeroTarget Version => 2.30
2009-03-18 10:48adrianromeroAssigned To => mirurita
2009-03-25 17:58hgbotCheckin
2009-03-25 17:58hgbotNote Added: 0014965
2009-03-25 17:58hgbotStatusscheduled => resolved
2009-03-25 17:58hgbotResolutionopen => fixed
2009-03-25 18:00hgbotCheckin
2009-03-25 18:00hgbotNote Added: 0014966
2009-04-24 15:10hgbotCheckin
2009-04-24 15:10hgbotNote Added: 0015699
2011-03-31 11:15dalsasuaAssigned Tomirurita => adrianromero
2011-03-31 11:15dalsasuaNote Added: 0035399
2011-03-31 18:12adrianromeroStatusresolved => closed
2011-04-01 00:00anonymoussf_bug_id0 => 3265607
2012-11-07 09:40priyamCategory01 - General => (No Category)

Notes
(0014965)
hgbot   
2009-03-25 17:58   
Repository: openbravopos
Revision: 552
Author: mirurita
Date: 2009-03-25 17:58:29 +0100 (Wed, 25 Mar 2009)

Fixes issue 0007550: Kettle synchronization: boolean type problem in PostgreSQL

---
U trunk/src-pos/com/openbravo/pos/scripts/Derby-create.sql
U trunk/src-pos/com/openbravo/pos/scripts/Derby-upgrade-2.30beta.sql
U trunk/src-pos/com/openbravo/pos/scripts/HSQLDB-create.sql
U trunk/src-pos/com/openbravo/pos/scripts/HSQLDB-upgrade-2.00.sql
U trunk/src-pos/com/openbravo/pos/scripts/HSQLDB-upgrade-2.10.sql
U trunk/src-pos/com/openbravo/pos/scripts/HSQLDB-upgrade-2.20.sql
U trunk/src-pos/com/openbravo/pos/scripts/HSQLDB-upgrade-2.30beta.sql
U trunk/src-pos/com/openbravo/pos/scripts/MySQL-create.sql
U trunk/src-pos/com/openbravo/pos/scripts/MySQL-upgrade-2.00.sql
U trunk/src-pos/com/openbravo/pos/scripts/MySQL-upgrade-2.10.sql
U trunk/src-pos/com/openbravo/pos/scripts/MySQL-upgrade-2.20.sql
U trunk/src-pos/com/openbravo/pos/scripts/MySQL-upgrade-2.30beta.sql
U trunk/src-pos/com/openbravo/pos/scripts/Oracle-create.sql
U trunk/src-pos/com/openbravo/pos/scripts/Oracle-upgrade-2.00.sql
U trunk/src-pos/com/openbravo/pos/scripts/Oracle-upgrade-2.10.sql
U trunk/src-pos/com/openbravo/pos/scripts/Oracle-upgrade-2.20.sql
U trunk/src-pos/com/openbravo/pos/scripts/Oracle-upgrade-2.30beta.sql
U trunk/src-pos/com/openbravo/pos/scripts/PostgreSQL-create.sql
U trunk/src-pos/com/openbravo/pos/scripts/PostgreSQL-upgrade-2.00.sql
U trunk/src-pos/com/openbravo/pos/scripts/PostgreSQL-upgrade-2.10.sql
U trunk/src-pos/com/openbravo/pos/scripts/PostgreSQL-upgrade-2.20.sql
U trunk/src-pos/com/openbravo/pos/scripts/PostgreSQL-upgrade-2.30beta.sql
---

https://dev.openbravo.com/websvn/openbravopos/?rev=552&sc=1 [^]
(0014966)
hgbot   
2009-03-25 18:00   
Repository: openbravopos
Revision: 553
Author: mirurita
Date: 2009-03-25 18:00:30 +0100 (Wed, 25 Mar 2009)

Fixes issue 0007550: Kettle synchronization: boolean type problem in
PostgreSQL

---
U trunk/transformations/Customers.ktr
A trunk/transformations/Initialization.ktr
U trunk/transformations/PRODUCTS JOB.kjb
U trunk/transformations/Products.ktr
U trunk/transformations/RUN SYNCHRONIZATION.kjb
U trunk/transformations/Taxes.ktr
---

https://dev.openbravo.com/websvn/openbravopos/?rev=553&sc=1 [^]
(0015699)
hgbot   
2009-04-24 15:10   
Repository: openbravopos
Revision: 596
Author: mirurita
Date: 2009-04-24 15:10:27 +0200 (Fri, 24 Apr 2009)

Fixes issue 0007550: Kettle synchronization: boolean type problem in
PostgreSQL (Initialization)

---
U trunk/transformations/ALL SYNCHRONIZATION.kjb
---

https://dev.openbravo.com/websvn/openbravopos/?rev=596&sc=1 [^]
(0035399)
dalsasua   
2011-03-31 11:15   
Adrián,

Given that it's a critical issue, can you please check it works and close it?

Thanks.