com.thortech.xl.gc.exception.DBException: A database error was encountered when retrieving data from a database.

Oracle Community | user10233157 | 4 years ago
  1. 0

    Database Application Tables Connector problem

    Oracle Community | 4 years ago | user10233157
    com.thortech.xl.gc.exception.DBException: A database error was encountered when retrieving data from a database.
  2. 0

    ERROR : column "this_.date" must appear in the GROUP BY clause or be used in an aggregate function

    Stack Overflow | 1 year ago | Chengappa
    org.postgresql.util.PSQLException: ERROR: column "this_.date" must appear in the GROUP BY clause or be used in an aggregate function Position: 296
  3. 0

    PostgreSQL 8.3 support

    GitHub | 3 years ago | flyway
    org.apache.maven.lifecycle.LifecycleExecutionException: Flyway Error: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select typname from pg_catalog.pg_type where typcategory in ('P', 'U') and typnamespace in (select oid from pg_catalog.pg_namespace where nspname = ?)]; nested exception is org.postgresql.util.PSQLException: ERROR: column "typcategory" does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Obscure error reporting

    GitHub | 3 years ago | omj
    org.postgresql.util.PSQLException: ERROR: relation "project" does not exist org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
  6. 0

    Non-admin users unable to connect to geoserver

    GitHub | 3 years ago | singhdonald
    org.postgresql.util.PSQLException: ERROR: column layers_layer.id does not exist Where: PL/pgSQL function "geonode_authorize_layer" line 13 at SQL statement
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: syntax error at or near "/" Position: 22

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    6 frames
  3. Commons DBCP
    DelegatingPreparedStatement.executeQuery
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    1 frame
  4. com.thortech.xl
    SchedulerBaseTask.execute
    1. com.thortech.xl.gc.impl.common.DBFacade.getRecord(Unknown Source)
    2. com.thortech.xl.gc.impl.common.DBFacade.getTargetRecord(Unknown Source)
    3. com.thortech.xl.gc.impl.recon.DBReconTransportProvider.getFirstPage(Unknown Source)
    4. com.thortech.xl.gc.runtime.GCScheduleTask.execute(GCScheduleTask.java:103)
    5. com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:384)
    5 frames
  5. postgresql.iam.scheduler
    TaskSupport.executeJob
    1. postgresql.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:145)
    1 frame
  6. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor1014.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  7. postgresql.iam.scheduler
    QuartzJob.execute
    1. postgresql.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:196)
    1 frame
  8. quartz
    SimpleThreadPool$WorkerThread.run
    1. org.quartz.core.JobRunShell.run(JobRunShell.java:202)
    2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
    2 frames