RE: CMS 6.1 - Notes Example - Location ofPostgres-create.sql

Hi, i'm trying to have the binder example working, and i got the same
problem of location of the postgres-create.sql file.
So i search the mailing, I downloaded the archive of the example and
replace the files in my binder project.
Now when i run ccm load --interactive ccm-core binder i got the
following error :
========================================
CHECK: The database type is recognized
CHECK: The ccm-core package is configured.
CHECK: The JDBC URL parameter is set.
CHECK: The database is accepting connections
CHECK: JAAS is available
WARNING: Multiple implementations of the same API found
 
The CCM runtime classpath contains two or more implementations of the
same API.  Only one, from the first location listed below, will be
used.
 
    /usr/java/j2sdk1.4.2_04/jre/lib/rt.jar
    /usr/share/ccm-tools/lib/security/jaas.jar
CHECK: JCE is available
WARNING: Multiple implementations of the same API found
 
The CCM runtime classpath contains two or more implementations of the
same API.  Only one, from the first location listed below, will be
used.
 
    /usr/java/j2sdk1.4.2_04/jre/lib/jce.jar
    /usr/share/ccm-tools/lib/security/jce.jar
2004-06-15 00:16:48,961 [ main] INFO  packaging.Loader - Loading schema
for binder
com.arsdigita.util.UncheckedWrapperException: alter table binders add
    constraint binders_binder_id_f_1nxap foreign key (binder_id)
      references applications(application_id) (root cause:
org.postgresql.util.PSQLException: ERROR: relation "applications" does
not exist
)
        at com.arsdigita.installer.SQLLoader.execute(SQLLoader.java:174)
        at
com.arsdigita.installer.SQLLoader.access$000(SQLLoader.java:35)
        at
com.arsdigita.installer.SQLLoader$2.onStatement(SQLLoader.java:101)
        at
com.arsdigita.installer.StatementParser.statement(StatementParser.java:131)
        at
com.arsdigita.installer.StatementParser.parse(StatementParser.java:68)
        at com.arsdigita.installer.SQLLoader.load(SQLLoader.java:111)
        at com.arsdigita.installer.SQLLoader.include(SQLLoader.java:160)
        at
com.arsdigita.installer.SQLLoader.access$100(SQLLoader.java:35)
        at
com.arsdigita.installer.SQLLoader$2.onInclude(SQLLoader.java:107)
        at
com.arsdigita.installer.StatementParser.statement(StatementParser.java:87)
        at
com.arsdigita.installer.StatementParser.parse(StatementParser.java:68)
        at com.arsdigita.installer.SQLLoader.load(SQLLoader.java:111)
        at com.arsdigita.installer.SQLLoader.load(SQLLoader.java:74)
        at
com.arsdigita.loader.PackageLoader.load(PackageLoader.java:113)
        at com.arsdigita.packaging.Loader.loadSchema(Loader.java:105)
        at com.arsdigita.packaging.Load.run(Load.java:334)
        at com.arsdigita.packaging.MasterTool.main(MasterTool.java:90)
Root cause:
org.postgresql.util.PSQLException: ERROR: relation "applications" does
not exist
 
        at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
        at
org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:156)
        at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101)
        at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:298)
        at com.arsdigita.installer.SQLLoader.execute(SQLLoader.java:169)
        at
com.arsdigita.installer.SQLLoader.access$000(SQLLoader.java:35)
        at
com.arsdigita.installer.SQLLoader$2.onStatement(SQLLoader.java:101)
        at
com.arsdigita.installer.StatementParser.statement(StatementParser.java:131)
        at
com.arsdigita.installer.StatementParser.parse(StatementParser.java:68)
        at com.arsdigita.installer.SQLLoader.load(SQLLoader.java:111)
        at com.arsdigita.installer.SQLLoader.include(SQLLoader.java:160)
        at
com.arsdigita.installer.SQLLoader.access$100(SQLLoader.java:35)
        at
com.arsdigita.installer.SQLLoader$2.onInclude(SQLLoader.java:107)
        at
com.arsdigita.installer.StatementParser.statement(StatementParser.java:87)
        at
com.arsdigita.installer.StatementParser.parse(StatementParser.java:68)
        at com.arsdigita.installer.SQLLoader.load(SQLLoader.java:111)
        at com.arsdigita.installer.SQLLoader.load(SQLLoader.java:74)
        at
com.arsdigita.loader.PackageLoader.load(PackageLoader.java:113)
        at com.arsdigita.packaging.Loader.loadSchema(Loader.java:105)
        at com.arsdigita.packaging.Load.run(Load.java:334)
        at com.arsdigita.packaging.MasterTool.main(MasterTool.java:90)

========================================

I tried to drop / recreate the database i'm using for the binder
example, but it didn't change anything.
When i replace the file with the one Denis has provided, i have done a
ccm-configure, and a ant deploy.All seems fine.

I'm running a waf 6.1 nightly from the 16 may, and i'm using postgres
7.4 (i had to change the jdbc jar).
Should i downgrade to 7.3?



Thanks in advance for your help

David




-- 
Redhat-ccm-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/redhat-ccm-list
Archives: https://www.redhat.com/pipermail/redhat-ccm-list/