java.sql.SQLException

Table not found in statement [SELECT DISTINCT plan_name FROM "CROP_PLANS"]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web12282

  • via Google Groups by lookie, 11 months ago
    Table not found in statement [SELECT DISTINCT plan_name FROM "CROP_PLANS"]
  • Table not found: S0002 Table not found: MAGAZINEX in statement [SELECT DISTINCT MAGAZINEX.JDOCLASSX FROM MAGAZINEX]
  • via Oracle Community by 570040, 1 year ago
    Table not found: C$_mfileds2ds in statement [select DISTINCT CITY_ID CITY_ID, CITY CITY, POPULATION POPULATION, REGION_ID REGION_ID from "C$_mfileds2ds" where (1=1)]
  • Stack trace

    • java.sql.SQLException: Table not found in statement [SELECT DISTINCT plan_name FROM "CROP_PLANS"] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source) at CPS.Core.DB.HSQLQuerier.getDistinctValuesForColumn(HSQLQuerier.java:235) at CPS.Core.DB.HSQLDB.getListOfCropPlans(HSQLDB.java:134) at CPS.Core.CropPlans.PlanManager.updateListOfPlans(PlanManager.java:111) at CPS.Core.CropPlans.PlanManager.setDataModel(PlanManager.java:78) at CPS.Core.CropPlans.CropPlanList.setDataSource(CropPlanList.java:83) at CPS.UI.Modules.CPSMasterDetailModule.setDataSource(CPSMasterDetailModule.java:100) at CPS.CropPlanning.<init>(CropPlanning.java:70) at CPS.CropPlanning.main(CropPlanning.java:38)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    11 more bugmates