I get strange errors in logs. When I paste SQL into editor and this sql
contains objects names, squirrel hangs for some time or forever. For
example I hava database "A_D_K7_VT_DB02_FINANCE" and view (not table)
"T02005_INVC_HDR" inside of it. I can write select * from, but when I paste
some SQL with this view name then in log I get info that database '*
A_D_DB02_FINANCE*' which is true because database '*A_D_K7_VT_DB02_FINANCE'
*exists. Why the names are different? It crushes squirrel almost every
time. Can you help?
some info
JDBC Driver CLASSNAME
com.teradata.jdbc.TeraDriver
getDriverName
com.teradata.jdbc.TeraDriver
getDatabaseProductVersion
Teradata Database 12.00.03.18
getIdentifierQuoteString
"
getDriverVersion
14.00.00.14
DRIVER FILES: terajdbc4.jar 860 650 bytes, tdgssconfig.jar 2 405 bytes.
LOG:
2012-10-04 17:30:32,410 [AWT-EventQueue-1] ERROR
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoColumnCache
- Failed to load columns for table T02005_INVC_HDR
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC
14.00.00.14] [Error 3802] [SQLState 42S02] Database 'A_D_DB02_FINANCE' does
not exist.
at
com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:307)
at
com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:102)
at
com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:302)
at
com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:183)
at
com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:121)
at
com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:112)
at
com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:373)
at
com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:315)
at
com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecuteQuery(TDStatement.java:303)
at com.teradata.jdbc.jdbc_4.TDStatement.executeQuery(TDStatement.java:1067)
at
com.teradata.jdbc.TeraDatabaseMetaData$ObtainViewColumnMetaData.executeHelpColumn(TeraDatabaseMetaData.java:3439)
at
com.teradata.jdbc.TeraDatabaseMetaData$ObtainViewColumnMetaData.processRows(TeraDatabaseMetaData.java:3287)
at
com.teradata.jdbc.jdbc_4.TDResultSet.setFetchedRowsPostProcessor(TDResultSet.java:379)
at
com.teradata.jdbc.TeraDatabaseMetaData.getColumns(TeraDatabaseMetaData.java:3242)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1741)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getColumnInfo(SQLDatabaseMetaData.java:1830)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.accessDbToLoadColumns(SchemaInfo.java:1297)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadColumns(SchemaInfo.java:1272)
at
net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.isTableExt(SchemaInfo.java:760)
at
net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.RSyntaxHighlightTokenMatcher.isTable(RSyntaxHighlightTokenMatcher.java:119)
at
net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.RSyntaxHighlightTokenMatcherProxy.isTable(RSyntaxHighlightTokenMatcherProxy.java:31)
at
net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMarker.addToken(SquirrelTokenMarker.java:49)
at
org.fife.ui.rsyntaxtextarea.TokenMakerBase.addToken(TokenMakerBase.java:104)
at
net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.addToken(SquirrelTokenMakerBase.java:313)
at
net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.addToken(SquirrelTokenMakerBase.java:298)
at
net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.addToken(SquirrelTokenMakerBase.java:287)
at
net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.yylex(SquirrelTokenMakerBase.java:683)
at
net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.getTokenList(SquirrelTokenMakerBase.java:370)
at
org.fife.ui.rsyntaxtextarea.TokenMakerBase.getLastTokenTypeOnLine(TokenMakerBase.java:171)
at
net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.SquirrelTokenMakerBase.getLastTokenTypeOnLine(SquirrelTokenMakerBase.java:72)
at
org.fife.ui.rsyntaxtextarea.RSyntaxDocument.fireInsertUpdate(RSyntaxDocument.java:167)
at javax.swing.text.AbstractDocument.handleInsertString(Unknown Source)
at javax.swing.text.AbstractDocument.insertString(Unknown Source)
at javax.swing.text.PlainDocument.insertString(Unknown Source)
at
net.sourceforge.squirrel_sql.plugins.syntax.rsyntax.RSyntaxSQLEntryPanel.appendText(RSyntaxSQLEntryPanel.java:222)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.appendSQL(SQLPanel.java:663)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.copySelectedItemToEntryArea(SQLPanel.java:672)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel.access$1600(SQLPanel.java:89)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.SQLPanel$CopyLastButton$1.actionPerformed(SQLPanel.java:1122)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown
Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
|
