To replicate:

1) Login as an instructor or admin (someone with upper-level privileges)
2) Go to a site with the Resources tool added. Enter the Resources tool.
3) Click the Add button next to any folder and select Add Citation List from the drop-down menu.

The resulting page contains a stack trace which specifies the below sql error. Tested 05/22/09 on sakai-2.6.0rc03.

Also, after a look up of the table CITATION_COLLECTIONS in the database the table was not found (not created).


0000009f BasicSqlServi W org.apache.commons.logging.impl.Jdk14Logger warn Sql.dbRead: sql: select PROPERTY_VALUE from CITATION_COLLECTION where (COLLECTION_ID = ? and PROPERTY_NAME = ?) bc12450b-ab97-4615-b094-0
68c62571384 sakai:most_recent_update
                                 com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2INST1.CITATION_COLLECTION
        at com.ibm.db2.jcc.c.fg.e(fg.java:1596)
        at com.ibm.db2.jcc.c.fg.a(fg.java:1206)
        at com.ibm.db2.jcc.b.gb.g(gb.java:140)
        at com.ibm.db2.jcc.b.gb.a(gb.java:39)
        at com.ibm.db2.jcc.b.w.a(w.java:34)
        at com.ibm.db2.jcc.b.vb.g(vb.java:139)
        at com.ibm.db2.jcc.c.fg.n(fg.java:1177)
        at com.ibm.db2.jcc.c.gg.eb(gg.java:1862)
        at com.ibm.db2.jcc.c.gg.d(gg.java:2295)
        at com.ibm.db2.jcc.c.gg.V(gg.java:424)
        at com.ibm.db2.jcc.c.gg.executeQuery(gg.java:407)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
        at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:545)
        at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:464)