[jira] [Commented] (METAMODEL-1224) MetaModel-jdbc fails on newer versions of PostgreSQL

["Kasper Sørensen (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/METAMODEL-1224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17063798#comment-17063798 ] 

Kasper Sørensen commented on METAMODEL-1224:
--------------------------------------------

This seems important:
{code}
ERROR 08:04:19 JdbcUtils - Could not execute create table statement: CREATE TABLE .metamodel_test_simple (mykey INTEGER NOT NULL, name VARCHAR(20), PRIMARY KEY(mykey)): ERROR: syntax error at or near "."
{code}
Notice that the schema name seems to be missing (or blank).

> 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)