Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-5298

SQL OCI QSqlDatabase.tables() does not work

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • P3: Somewhat important
    • 4.6.1
    • 4.5.2, 4.5.3
    • SQL Support
    • None
    • 1b4ff1bab4ccc4bdc403b84920314f76fbca02c5

    Description

      I installed Oracle 11g under windows, setup all connections and then create a table (user system, password my choice).
      I can access these table with sql pro, can add data and selects, but using QSqlDatabase::tables() does not have this table in the Stringlist.
      Using a tool dbvisualizer shows that table correctly under SYSTEM TABLES.
      I got about 1500 entries in the list, using the parameter QSql::AllTables in .tables() brings about 4500 entries, but not my table.

      QSqlDatabase db = QSqlDatabase::addDatabase("QOCI");
      dp.open("system", "mypassword");
      QSqlQuery query("CREATE TABLE mytable (NAME VARCHAR(20))");
      table is created
      QSqlQuery query1("INSERT into mytable....")
      Select shows data

      QStringList List = db.tables() (or db.tables(QSql::AllTables))
      mytable is not found....

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            bilking Bill King
            peterbienert@azegmbh.de Peter Bienert
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes