QSqlDatabase::tables() get stuck

Yihua Liu

My program has successfully connected and opened an Oracle database (db.isOpen() == true) and I write

const QStringList tables = db.tables();

Then my program gets stuck at this line. If I paused it in a debugger, it was paused at

I also checked the tables of that Oracle database in PL/SQL Developer and it turned out that all tables of the database could be normally managed. Why my program could not retrieve the table names of the database?

jsulm

@Yihua-Liu It looks like it's waiting for something to come over network. Is your connection to the database stable?

jsulm

@Yihua-Liu Assembler code will not help.
You should install Qt debug symbols to get meaningful information where in Qt code it hangs.

Yihua Liu

Thanks for your advice

It seems that it gets stuck here

jsulm

@Yihua-Liu It looks like it's waiting for something to come over network. Is your connection to the database stable?

Yihua Liu

@jsulm I can query the database fast using PL/SQL Developer, so I think my network environment is not problematic. The database has less than 150 tables so I think it does not need much time to read their names.

Are there any differences between OCIStmtFetch and OCIStmtFetch2? I read that OCIStmtFetch is deprecated

jsulm

@Yihua-Liu said in QSqlDatabase::tables() get stuck:

Are there any differences between OCIStmtFetch and OCIStmtFetch2?

I don't know. At some point Qt will have to change this :-)
I'm out of ideas. Maybe somebody else can help.

Christian Ehrlicher

@jsulm said in QSqlDatabase::tables() get stuck:

At some point Qt will have to change this :-)

Use the latest version... 🙂
And no, no difference except support for stuff >2GB