Thread: [Squirrel-sql-users] Squirrel Error
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: RaoG <web...@gm...> - 2008-08-13 18:27:55
|
I am new to Squirrel. I installed 1.2beta6 version. I am trying to access the tables. The system getting stuck frequently whenever I clicked on a tab particularly ROWCOUNT. How can I see the SQL statement for the table I am viewing. Thanks Rao -- View this message in context: http://www.nabble.com/Squirrel-Error-tp18968610p18968610.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
From: Matthew D. <mda...@ja...> - 2008-08-15 19:33:03
|
Rao, The simple answer would be that your sample select statement contains incorrect syntax. What is the SQL? When you write "I installed 1.2beta6 version," I'm not exactly sure which version this is. The current release from a couple of months ago is 2.6.6. Regards, Matt Jaspersoft -----Original Message----- From: squ...@li... [mailto:squ...@li...] On Behalf Of RaoG Sent: Wednesday, 13 August, 2008 11:34 To: squ...@li... Subject: [Squirrel-sql-users] Squirrel Error I am new to Squirrel. I installed 1.2beta6 version. I am trying to access the tables. The system getting stuck frequently whenever I clicked on a tab particularly ROWCOUNT. How can I see the SQL statement for the table I am viewing. If I write a sample select statement, it is returning the following error. Error: java.sql.SQLException: Unable to parse query text: Incorrect syntax near "FROM", found "v1". On line 1, column 21. [parser-2904201] com.compositesw.common.CompositeRuntimeException: Unable to parse query text: Incorrect syntax near "FROM", found "v1". On line 1, column 21. [parser-2904201] at com.compositesw.server.qe.QESqlRequest.execute(QESqlRequest.java:146) at com.compositesw.server.request.HookSqlRequest.execute(HookSqlRequest.java: 64) at com.compositesw.server.dbchannel.CsExec.exec(CsExec.java:72) at com.compositesw.server.dbchannel.CsExec.exec(CsExec.java:45) at com.compositesw.server.dbchannel.ServerCommand.exec(ServerCommand.java:374 ) at com.compositesw.server.dbchannel.ServerCommand.dispatchCommand(ServerComma nd.java:143) at com.compositesw.server.dbchannel.ServerCommand.run(ServerCommand.java:66) at com.compositesw.common.thread.ThreadPool$WorkerThread.run(ThreadPool.java: 266) Caused by: com.compositesw.server.qe.QueryEngineException: Unable to parse query text: Incorrect syntax near "FROM", found "v1". On line 1, column 21. [parser-2904201] at com.compositesw.server.qe.QueryEngine.execute(QueryEngine.java:85) at com.compositesw.server.qe.QESqlRequest.execute(QESqlRequest.java:111) ... 7 more Caused by: com.compositesw.cdms.services.parser.ParserException: Unable to parse query text: Incorrect syntax near "FROM", found "v1". On line 1, column 21. [parser-2904201] at com.compositesw.cdms.services.parser.ParserImpl.parseSql(ParserImpl.java:1 47) at com.compositesw.cdms.services.parser.ParserImpl.parseSql(ParserImpl.java:9 5) at com.compositesw.server.qe.QueryEngine.parse(QueryEngine.java:788) at com.compositesw.server.qe.QueryEngine.execute(QueryEngine.java:70) ... 8 more Caused by: line 1:21: Incorrect syntax near "FROM", found "v1" at com.compositesw.cdms.services.parser.SqlParser.createException(SqlParser.j ava:77) at com.compositesw.cdms.services.parser.SqlParser.createException(SqlParser.j ava:52) at com.compositesw.cdms.services.parser.SqlParser.from_clause(SqlParser.java: 4358) at com.compositesw.cdms.services.parser.SqlParser.table_expression(SqlParser. java:2588) at com.compositesw.cdms.services.parser.SqlParser.query_specification(SqlPars er.java:2385) at com.compositesw.cdms.services.parser.SqlParser.simple_table(SqlParser.java :2068) at com.compositesw.cdms.services.parser.SqlParser.non_join_query_primary(SqlP arser.java:2032) at com.compositesw.cdms.services.parser.SqlParser.non_join_query_term(SqlPars er.java:1886) at com.compositesw.cdms.services.parser.SqlParser.non_join_query_expression(S qlParser.java:1385) at com.compositesw.cdms.services.parser.SqlParser.query_expression(SqlParser. java:1042) at com.compositesw.cdms.services.parser.SqlParser.direct_select_statement_mul tiple_rows(SqlParser.java:723) at com.compositesw.cdms.services.parser.SqlParser.direct_sql_data_statement(S qlParser.java:681) at com.compositesw.cdms.services.parser.SqlParser.directly_executable_stateme nt(SqlParser.java:230) at com.compositesw.cdms.services.parser.SqlParser.start_rule(SqlParser.java:1 72) at com.compositesw.cdms.services.parser.ParserImpl.parseSql(ParserImpl.java:1 34) ... 11 more Please send me your suggestions Thanks Rao -- View this message in context: http://www.nabble.com/Squirrel-Error-tp18968610p18968610.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
From: Robert M. <rob...@gm...> - 2008-08-15 21:10:26
|
On Wed, Aug 13, 2008 at 2:27 PM, RaoG <web...@gm...> wrote: > > I am new to Squirrel. I installed 1.2beta6 version. I am trying to access > the > tables. The system getting stuck frequently whenever I clicked on a tab > particularly ROWCOUNT. How can I see the SQL statement for the table I am > viewing. The row count tab is populated by the query: select count(*) from <table> Rob |