[ https://issues.apache.org/jira/browse/CONNECTORS-115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Wright resolved CONNECTORS-115. ------------------------------------ Resolution: Fixed Fix Version/s: LCF Release 0.5 Assignee: Karl Wright I found the fix that corresponds to this report. ------------------------------------------------------------------------ r1006085 | kwright | 2010-10-08 20:43:45 -0400 (Fri, 08 Oct 2010) | 1 line Fix problem with postgreSQL implementation which causes second run of DBCreate to fail. > Restarting the example fails when db present > -------------------------------------------- > > Key: CONNECTORS-115 > URL: https://issues.apache.org/jira/browse/CONNECTORS-115 > Project: ManifoldCF > Issue Type: Bug > Environment: Windows XP, Example running with PostgreSQL instead of > embedded derby. Use defaults for dbname, user, and password. > Reporter: Farzad > Assignee: Karl Wright > Fix For: LCF Release 0.5 > > > When you restart the example you get the following: > C:\Program Files\Apache\apache-acf\example>java -jar start.jar > Configuration file successfully read > org.apache.manifoldcf.core.interfaces.ManifoldCFException: Database > exception: Exception doing query: ERROR: database "d > bname" already exists > at > org.apache.manifoldcf.core.database.Database.executeViaThread(Database.java:421) > at > org.apache.manifoldcf.core.database.Database.executeUncachedQuery(Database.java:465) > at > org.apache.manifoldcf.core.database.Database$QueryCacheExecutor.create(Database.java:1072) > at > org.apache.manifoldcf.core.cachemanager.CacheManager.findObjectsAndExecute(CacheManager.java:144) > at > org.apache.manifoldcf.core.database.Database.executeQuery(Database.java:167) > at > org.apache.manifoldcf.core.database.DBInterfacePostgreSQL.createUserAndDatabase(DBInterfacePostgreSQL.java:50 > 8) > at > org.apache.manifoldcf.core.system.ManifoldCF.createSystemDatabase(ManifoldCF.java:638) > at > org.apache.manifoldcf.jettyrunner.ManifoldCFJettyRunner.main(ManifoldCFJettyRunner.java:202) > Caused by: org.postgresql.util.PSQLException: ERROR: database "dbname" > already exists > 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:337) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:329) > at > org.apache.manifoldcf.core.database.Database.execute(Database.java:526) > at > org.apache.manifoldcf.core.database.Database$ExecuteQueryThread.run(Database.java:381) > C:\Program Files\Apache\apache-acf\example> > The only way to get it started is dropping the table it created the first > time, in this case "dbname". -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.