Menu

#90 method getRowCount don't use schema

v2.1
closed-fixed
None
5
2008-08-06
2005-06-03
No

Although I informed the schema's name in the
constructor of DatabaseConnection, when I use
getRowCount this not appear before the tableName.

i wrote this litle code in
getRowCount(String tableName, String whereClause)
of the AbstractDatabaseConnection class:

...
sqlBuffer.append("select count(*) from ");

//add schema before tableName
if ((getSchema() != null) && !getSchema().equals("")) {
sqlBuffer.append(getSchema() + ".");
}

sqlBuffer.append(tableName);
...

this solved my problem
thanks

Discussion

  • matthias g

    matthias g - 2008-08-06

    Logged In: YES
    user_id=1803108
    Originator: NO

    I committed the fix in rev. 774/trunk for the upcoming 2.3.0 release.

    Thanks a lot,
    mat

     
  • matthias g

    matthias g - 2008-08-06
    • assigned_to: rlogiacco --> gommma
    • status: open --> closed-fixed
     

Log in to post a comment.