[ https://issues.apache.org/jira/browse/CONNECTORS-148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12988899#comment-12988899 ]
Grant Ingersoll commented on CONNECTORS-148: -------------------------------------------- Is there a workaround at all for this? Can the user hand create the DB or run a separate script? > Creating database in PostgreSQL does not work > --------------------------------------------- > > Key: CONNECTORS-148 > URL: https://issues.apache.org/jira/browse/CONNECTORS-148 > Project: ManifoldCF > Issue Type: Bug > Components: Framework core > Affects Versions: ManifoldCF 0.1 > Reporter: Karl Wright > Assignee: Karl Wright > Priority: Blocker > Fix For: ManifoldCF 0.1 > > > When you try to create a PostgreSQL database, you get back the following > error: > Exception: Database exception: Exception doing query: ERROR: syntax error at > or near "$1" > org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database > exception: Exception doing query: ERROR: syntax error at or near "$1" > at > org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:461) > at > org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:505) > at > org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1131) > at > org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144) > at > org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:168) > at > org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.createUserAndDatabase(DBInterfacePostgreSQL.java:536) > at > org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:656) > at > org.apache.manifoldcf.jettyrunner.ManifoldCFJettyRunner.main(ManifoldCFJettyRunner.java:202) > Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near > "$1" > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:305) > at > org.apache.manifoldcf.core.database.Database.execute(Database.java:606) > at > org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:421) -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira