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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by AravindhK, 1 year ago
Unexpected token: ) in statement [select * from RATES where (1=1) And (ACCOUNT = 'RATE') And (PERIOD <= '') And (YEAR = )]
via oracle.com by Unknown author, 2 years ago
Unexpected token: ACCOUNT in statement [select   C1_ACCOUNT    ""Account]
via Oracle Community by 751552, 1 year ago
Column not found: ESSBASETEMPTABLE.MEMBERNAME in statement [select ESSBASETEMPTABLE.MemberName "Account",ESSBASETEMPTABLE.ParentName "Parent",ESSBASETEMPTABLE.Alias "Alias: Default",C4_PLANSTORAGE "Data Storage
via Oracle Community by 710783, 1 year ago
Unexpected token: TO_NUMBER in statement [select C1_POZYCJABUDZETOWACF "PozycjaBudzetowaCF",C2_OKRESCF "OkresCF",C3_BUDZETCF "BudzetCF",C4_SCENARIUSZCF "ScenariuszCF",C5_WALUTACF "WalutaCF",C7_BANKCF "BankCF", C8_WERSJA
via Oracle Community by user424872 - oracle, 1 year ago
Unexpected token: PARENTNAME in statement [select C1_PARENTNAME ""ParentName]
via Oracle Community by kirannch, 1 year ago
Unexpected end of command in statement [select C1_ACCOUNT "Account",C2_ENTITY "Entity",C3_PRODUCT "Product",C4_CHANNEL "Channel",C11_REPORTINGLEVEL "Reporting Level",C5_SCENARIO "Scenario",']
java.sql.SQLException: Unexpected token: ) in statement [select * from RATES where (1=1) And (ACCOUNT = 'RATE') And (PERIOD <= '') And (YEAR = )]
at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at org.python.core.PyReflectedFunction.__call__(PyReflectedFunction.java)
at org.python.core.PyMethod.__call__(PyMethod.java)
at org.python.core.PyObject.__call__(PyObject.java)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Write tip

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