You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@manifoldcf.apache.org by "Karl Wright (JIRA)" <ji...@apache.org> on 2011/02/01 13:12:28 UTC

[jira] Resolved: (CONNECTORS-148) Creating database in PostgreSQL does not work

     [ https://issues.apache.org/jira/browse/CONNECTORS-148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Karl Wright resolved CONNECTORS-148.
------------------------------------

       Resolution: Fixed
    Fix Version/s:     (was: ManifoldCF 0.1)
                   ManifoldCF next

ManifoldCF 0.1 does not contain an adequate fix.


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