You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@metamodel.apache.org by "Kasper Sørensen (Jira)" <ji...@apache.org> on 2020/03/21 07:00:02 UTC
[jira] [Updated] (METAMODEL-1224) MetaModel-jdbc fails on newer
versions of PostgreSQL
[ https://issues.apache.org/jira/browse/METAMODEL-1224?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kasper Sørensen updated METAMODEL-1224:
---------------------------------------
Description:
PostgreSQL queries on newer versions (I'm using 12) of the database are failing with a cryptic message
{code}
org.apache.metamodel.jdbc.RolledBackUpdateException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "."
Position: 14
at org.apache.metamodel.jdbc.JdbcDataContext.executeUpdate(JdbcDataContext.java:923)
at org.apache.metamodel.jdbc.JdbcTestTemplates.simpleCreateInsertUpdateAndDrop(JdbcTestTemplates.java:580)
at org.apache.metamodel.jdbc.integrationtests.PostgresqlTest.testCreateInsertAndUpdate(PostgresqlTest.java:84)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at junit.framework.TestCase.runTest(TestCase.java:176)
at junit.framework.TestCase.runBare(TestCase.java:141)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:129)
at junit.framework.TestSuite.runTest(TestSuite.java:252)
at junit.framework.TestSuite.run(TestSuite.java:247)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:541)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:763)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:463)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:209)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "."
Position: 14
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:562)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
at org.apache.metamodel.jdbc.JdbcCreateTableBuilder.execute(JdbcCreateTableBuilder.java:61)
at org.apache.metamodel.create.CreateTable.run(CreateTable.java:65)
at org.apache.metamodel.create.CreateTableColumnBuilder.run(CreateTableColumnBuilder.java:39)
at org.apache.metamodel.jdbc.JdbcDataContext.executeUpdate(JdbcDataContext.java:915)
... 21 more
{code}
This bug reported on one of our downstream apps, DataCleaner: https://github.com/datacleaner/DataCleaner/issues/1849
was:
PostgreSQL queries on newer versions (I'm using 12) of the database are failing with a cryptic message
```
org.apache.metamodel.jdbc.RolledBackUpdateException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "."
Position: 14
at org.apache.metamodel.jdbc.JdbcDataContext.executeUpdate(JdbcDataContext.java:923)
at org.apache.metamodel.jdbc.JdbcTestTemplates.simpleCreateInsertUpdateAndDrop(JdbcTestTemplates.java:580)
at org.apache.metamodel.jdbc.integrationtests.PostgresqlTest.testCreateInsertAndUpdate(PostgresqlTest.java:84)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at junit.framework.TestCase.runTest(TestCase.java:176)
at junit.framework.TestCase.runBare(TestCase.java:141)
at junit.framework.TestResult$1.protect(TestResult.java:122)
at junit.framework.TestResult.runProtected(TestResult.java:142)
at junit.framework.TestResult.run(TestResult.java:125)
at junit.framework.TestCase.run(TestCase.java:129)
at junit.framework.TestSuite.runTest(TestSuite.java:252)
at junit.framework.TestSuite.run(TestSuite.java:247)
at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:541)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:763)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:463)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:209)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "."
Position: 14
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:562)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
at org.apache.metamodel.jdbc.JdbcCreateTableBuilder.execute(JdbcCreateTableBuilder.java:61)
at org.apache.metamodel.create.CreateTable.run(CreateTable.java:65)
at org.apache.metamodel.create.CreateTableColumnBuilder.run(CreateTableColumnBuilder.java:39)
at org.apache.metamodel.jdbc.JdbcDataContext.executeUpdate(JdbcDataContext.java:915)
... 21 more
```
This bug reported on one of our downstream apps, DataCleaner: https://github.com/datacleaner/DataCleaner/issues/1849
> MetaModel-jdbc fails on newer versions of PostgreSQL
> ----------------------------------------------------
>
> Key: METAMODEL-1224
> URL: https://issues.apache.org/jira/browse/METAMODEL-1224
> Project: Apache MetaModel
> Issue Type: Bug
> Reporter: Kasper Sørensen
> Assignee: Kasper Sørensen
> Priority: Major
>
> PostgreSQL queries on newer versions (I'm using 12) of the database are failing with a cryptic message
> {code}
> org.apache.metamodel.jdbc.RolledBackUpdateException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "."
> Position: 14
> at org.apache.metamodel.jdbc.JdbcDataContext.executeUpdate(JdbcDataContext.java:923)
> at org.apache.metamodel.jdbc.JdbcTestTemplates.simpleCreateInsertUpdateAndDrop(JdbcTestTemplates.java:580)
> at org.apache.metamodel.jdbc.integrationtests.PostgresqlTest.testCreateInsertAndUpdate(PostgresqlTest.java:84)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at junit.framework.TestCase.runTest(TestCase.java:176)
> at junit.framework.TestCase.runBare(TestCase.java:141)
> at junit.framework.TestResult$1.protect(TestResult.java:122)
> at junit.framework.TestResult.runProtected(TestResult.java:142)
> at junit.framework.TestResult.run(TestResult.java:125)
> at junit.framework.TestCase.run(TestCase.java:129)
> at junit.framework.TestSuite.runTest(TestSuite.java:252)
> at junit.framework.TestSuite.run(TestSuite.java:247)
> at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:86)
> at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:89)
> at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:41)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:541)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:763)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:463)
> at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:209)
> Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "."
> Position: 14
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:562)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:406)
> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
> at org.apache.metamodel.jdbc.JdbcCreateTableBuilder.execute(JdbcCreateTableBuilder.java:61)
> at org.apache.metamodel.create.CreateTable.run(CreateTable.java:65)
> at org.apache.metamodel.create.CreateTableColumnBuilder.run(CreateTableColumnBuilder.java:39)
> at org.apache.metamodel.jdbc.JdbcDataContext.executeUpdate(JdbcDataContext.java:915)
> ... 21 more
> {code}
> This bug reported on one of our downstream apps, DataCleaner: https://github.com/datacleaner/DataCleaner/issues/1849
--
This message was sent by Atlassian Jira
(v8.3.4#803005)