Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2458

Wrong "name-in-source" property value for imported tables in Source model (JDBC importer, Sybase 15 Database)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • 9.2
    • 9.0.1, 10.0
    • None
    • None
    • Hide

      Use JDBC importer and import a source model from Sybase database.
      In my case, every table has "name-in-source" property like "bqt2"."<table-name>", but it should be "bqt2"."dbo"."<table-name>". As result every query ends with an exception: "Error: bqt2.SmallA not found. Specify owner.objectname..."

      I have tried this using JTDS driver and all tables had correct "name-in-source". But this driver in neither tested nor supported for teiid.

      Show
      Use JDBC importer and import a source model from Sybase database. In my case, every table has "name-in-source" property like "bqt2"."<table-name>", but it should be "bqt2"."dbo"."<table-name>". As result every query ends with an exception: "Error: bqt2.SmallA not found. Specify owner.objectname..." I have tried this using JTDS driver and all tables had correct "name-in-source". But this driver in neither tested nor supported for teiid.

      I am trying to import a Source model from Sybase database. But imported tables have wrong "name-in-source" property values.

        1. sybase_bqt2_datatools_tree.png
          sybase_bqt2_datatools_tree.png
          21 kB
        2. pic3.png
          pic3.png
          137 kB
        3. pic2.png
          pic2.png
          76 kB
        4. pic1.png
          pic1.png
          71 kB
        5. parts_sql_schema_tree.png
          parts_sql_schema_tree.png
          9 kB
        6. parts_sql_include_catalog_in_name.png
          parts_sql_include_catalog_in_name.png
          14 kB
        7. parts_sql_catalog_in_name_in_source.png
          parts_sql_catalog_in_name_in_source.png
          28 kB

              asmigala@redhat.com Andrej Smigala
              jdurani Juraj Duráni (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: