#1243 building output very slow in squirrel 3.7

[goodsonfr]

Hi,
I use Squirrel 3.7 with informatica JDBC driver to query a Centera database. My issue is that building output is very slow and I need to cancel because after several hours I don't have the result. By checking the database, the query is done on it and the process is blocked by squirrel for display the output. The number of line in the result is not very high.
Could you help me for the issue ?
Thanks, regards
Edouard

[goodsonfr]

Squirrel log of my issue:
2016-03-25 15:19:32,317 [Thread-8] ERROR net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet - Failed to get table info from ResultSetMetaData.
java.sql.SQLException: Table "ADM"."PUBLIC"."COLUMNS" not found in system catalog.
at com.informatica.fas.jdbc.QueryValues.call(QueryValues.java:456)
at com.informatica.fas.jdbc.QueryValues.command(QueryValues.java:1824)
at com.informatica.fas.jdbc.QueryValues.catalog(QueryValues.java:1811)
at com.informatica.fas.jdbc.FASStatement.execute(FASStatement.java:670)
at com.informatica.fas.jdbc.FASStatement.execute(FASStatement.java:468)
at com.informatica.fas.jdbc.FASStatement.executeQuery(FASStatement.java:709)
at com.informatica.fas.jdbc.FASStatement.executeCatalog(FASStatement.java:773)
at com.informatica.fas.jdbc.FASResultSetMetaData.getTableName(FASResultSetMetaData.java:226)
at net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.createResultSetMetaDataTable(ResultSetDataSet.java:447)
at net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.createColumnDefinitions(ResultSetDataSet.java:421)
at net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet._setResultSet(ResultSetDataSet.java:184)
at net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setSqlExecutionTabResultSet(ResultSetDataSet.java:127)
at net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecutionHandler.sqlResultSetAvailable(SQLExecutionHandler.java:423)
at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processResultSet(SQLExecuterTask.java:549)
at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:414)
at net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:212)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:736)

[sfst]

"My issue is that building output is very slow and I need to cancel because after several hours I don't have the result."

Do you mean that after several hours you still don't have the COMPLETE result? If you cancel the command in the "building output phase" all rows received so far are shown in the result tab.

"The number of line in the result is not very high."

Can you please give a ballpark number what is "not very high" for you? e.g. 100's, 1000's?

If feature request #468 would help you with your issue, please upvote it :-)