java.sql.SQLException: java.sql.SQLException: Unexpected token: ) in statement [select * from RATES where (1=1) And (ACCOUNT = 'RATE') And (PERIOD <= '') And (YEAR = )]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by AravindhK, 1 year ago
java.sql.SQLException: Unexpected token: ) in statement [select * from RATES where (1=1) And (ACCOUNT = 'RATE') And (PERIOD <= '') And (YEAR = )]
via Oracle Community by 1873566, 1 year ago
java.sql.SQLException: unexpected token: + required: ,
via Oracle Community by RubiBanerjee, 1 year ago
via Oracle Community by User499380-OC, 1 year ago
java.sql.SQLException: unexpected token: FOR
via Oracle Community by MikeTurner_SATX, 1 year ago
java.sql.SQLException: unexpected token: ||C6_FUND_CODE "Fund", : line: 17
via oracle.com by Unknown author, 2 years ago
java.sql.SQLException: unexpected token: ||C6_FUND_CODE "Fund", : line: 17
java.sql.SQLException: java.sql.SQLException: Unexpected token: ) in statement [select * from RATES where (1=1) And (ACCOUNT = 'RATE') And (PERIOD <= '') And (YEAR = )]
at com.sunopsis.dwg.codeinterpretor.j.a(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execScriptingOrders(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlI.treatTaskTrt(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(Unknown Source)
at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(Unknown Source)
at com.sunopsis.dwg.cmd.DwgCommandBase.execute(Unknown Source)
at com.sunopsis.dwg.cmd.DwgCmd.k(Unknown Source)
at com.sunopsis.dwg.cmd.f.F(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpScen.a(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpScen.localExecuteSync(Unknown Source)
at com.sunopsis.dwg.tools.StartScen.actionExecute(Unknown Source)
at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.treatTaskTrt(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(Unknown Source)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(Unknown Source)
at com.sunopsis.dwg.cmd.DwgCommandScenario.treatCommand(Unknown Source)
at com.sunopsis.dwg.cmd.DwgCommandBase.execute(Unknown Source)
at com.sunopsis.dwg.cmd.DwgCmd.k(Unknown Source)
at com.sunopsis.dwg.cmd.g.z(Unknown Source)
at com.sunopsis.dwg.cmd.DwgCmd.run(Unknown Source)
at java.lang.Thread.run(Thread.java:637)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.