#1151 Exception with certain column names

Snapshot
open
nobody
7
2015-02-24
2014-07-29
Felix Garbe
No

Using:
Database: Oracle 11g
Driver: ojdbc7 (also tested with ojdbc6)

If a table have certain column names. Like "DATE" (which is possible using SQL-Statements). I am getting an exception while showing the content of this table:

2014-07-29 14:55:45,322 [Thread-3] ERROR net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab  - 
java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:766)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1244)
    at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:420)
    at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ContentsTab.createDataSet(ContentsTab.java:339)
    at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab$1.run(BaseDataSetTab.java:128)
    at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Thread.java:744)

It can be reproduced with folling table definition:

create table BUG_TEST_A (
  "DATE" DATE
)

While following definition is working fine:

create table BUG_TEST_B (
  "NODATE" DATE
)

Discussion


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks