Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0001955Openbravo ERPA. Platformpublic2007-09-13 12:222008-06-12 09:43
Reporterjpabloae 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0001955: svn: user check fails if bbdd.user is in lowercase
DescriptionIn subversion r1014, the ant install.source task does not raise a warning about the existence of the bbdd.user if the ${bbdd.user} value is in lowercase because the username in Oracle is in uppercase.

Steps to reproduce:

1. Use the following user (in lowercase) in database/build.xml:
<property name="bbdd.user" value="tad"/>
2. Check the database username is in uppercase:
select count(*) from dba_users where username='TAD';
3. Run ant install.source
4. It doesn't show and stop with the warning.

If bbdd.user is TAD in uppercase, then it works fine.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0005544)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1793821 [^]
(0002114)
jpabloae   
2008-02-25 19:33   
(edited on: 2008-06-12 09:21)
Logged In: YES
user_id=1603191
Originator: YES

Maybe this user check should be in "clean.database.${bbdd.dbms}" and not in "${bbdd.rdbms}.structure".

A possible solution when bbdd.dbms=ORACLE:

< SELECT COUNT(*) INTO v_count FROM DBA_USERS WHERE USERNAME = '${bbdd.user}';
> SELECT COUNT(*) INTO v_count FROM DBA_USERS WHERE USERNAME = upper('${bbdd.user}');
(0002115)
marvintm   
2008-05-28 17:43   
(edited on: 2008-06-12 09:21)
Logged In: YES
user_id=1952914
Originator: NO

In recent versions of Openbravo the database is deleted before being created when you do a create.database. This means that the check mentioned is obsolete (it will never raise a warning, as the database will never exist, as it has just been deleted). Therefore, this bug is now a non issue.