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
|
