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

Oracle Community | user10233157 | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Database Application Tables Connector problem

    Oracle Community | 5 years ago | user10233157
    com.thortech.xl.gc.exception.DBException: A database error was encountered when retrieving data from a database.
  2. 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)
  3. 0

    PostgreSQL syntax error in param passed in a BeanPropertyRowMapper

    Stack Overflow | 2 years ago | SilvioC90
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "$3" Posizione: 3939
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 0

    PostgreSQL 8.3 support

    GitHub | 4 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
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