DdlUtils
  1. DdlUtils
  2. DDLUTILS-265

Oracle tablename with a '_' doesn't work correctly

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Core - Oracle
    • Labels:
      None

      Description

      I tested it on the head.

      I have a excisting database with tablenames like "pln_test" or "pln_helloworld"
      If i try to read this database to a model, the fields are not resolved for tables without a "_" it works

      In the class JdbcModelreader i changed the following
      //columnData = metaData.getColumns(metaData.escapeForSearch(tableName), getDefaultColumnPattern());
      columnData = metaData.getColumns(tableName, getDefaultColumnPattern());

      Because the data is retrieved by the jdbc metadata escaping is not needed

      And now it works.

        Activity

        Henk Laracker created issue -
        Henk Laracker made changes -
        Field Original Value New Value
        Description I tested it on the head.

        I have a excisting database with tablenames like "pln_test" or "pln_helloworld"
        If i try to read this database to a model, the fields are not resolved for tables without a "_" it works
        I tested it on the head.

        I have a excisting database with tablenames like "pln_test" or "pln_helloworld"
        If i try to read this database to a model, the fields are not resolved for tables without a "_" it works

        In the class JdbcModelreader i changed the following
                    //columnData = metaData.getColumns(metaData.escapeForSearch(tableName), getDefaultColumnPattern());
                    columnData = metaData.getColumns(tableName, getDefaultColumnPattern());

        Because the data is retrieved by the jdbc metadata escaping is not needed

        And now it works.
        Hide
        Jason Kaufmann added a comment -

        This fix broke me - using SQL Server 2000 on WinXP. Tables I have named with an underscore in them are no longer found.

        Show
        Jason Kaufmann added a comment - This fix broke me - using SQL Server 2000 on WinXP. Tables I have named with an underscore in them are no longer found.
        Hide
        Kevin Scott Carr added a comment -

        I am seeing this in MySql as well. I went into DatabaseMetaDataWrapper and removed _ from the searchStringPattern. It worked for my MySQL db, but I am sure it will fail for the SQL Server DB. Is there a way to set searchStringPattern on a db by db basis?

        Show
        Kevin Scott Carr added a comment - I am seeing this in MySql as well. I went into DatabaseMetaDataWrapper and removed _ from the searchStringPattern. It worked for my MySQL db, but I am sure it will fail for the SQL Server DB. Is there a way to set searchStringPattern on a db by db basis?

          People

          • Assignee:
            Thomas Dudziak
            Reporter:
            Henk Laracker
          • Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Development