Grouper Users - Open Discussion List

[Keith Hazelton <>]

I get the same JDBC errors with both the 
.../contrib/load/csv2group/csv2group.java program as well as the command 
line tool .../contrib/load/groupmgr/groupmgr.java when I attempt the 
first example in the groupmgr READMS file, It is supposed to add a 
top-level naming stem called "test."

The GROUPER_FIELD table is there.  A run of ..../grouper-0.5/ant db 
executing the query "select * from GROUPER_FIELD" yields the following:

GROUPFIELD       READPRIV WRITEPRIV ISLIST
---------------- -------- --------- ------
admins           ADMIN    ADMIN     TRUE  
creators         STEM     STEM      TRUE  
description      READ     ADMIN     FALSE 
displayExtension VIEW     ADMIN     FALSE 
displayName      VIEW               FALSE 
elig-affils      UPDATE   UPDATE    TRUE  
excludes         UPDATE   UPDATE    TRUE  
extension        VIEW     ADMIN     FALSE 
includes         UPDATE   UPDATE    TRUE  
members          READ     UPDATE    TRUE  
name             VIEW               FALSE 
optins           UPDATE   UPDATE    TRUE  
optouts          UPDATE   UPDATE    TRUE  
readers          ADMIN    ADMIN     TRUE  
stem             VIEW     ADMIN     FALSE 
stemmers         STEM     STEM      TRUE  
updaters         ADMIN    ADMIN     TRUE  
viewers          ADMIN    ADMIN     TRUE  

18 row(s) in 1 ms

Hints welcome.     --Keith


______________

Excerpt from terminal session:

keith$ java groupmgr -a -n -s Grouper.NSROOT - e test

2004-12-28 10:22:53,746  WARN JDBCExceptionReporter: SQL Error: -22, 
SQLState: S0002
2004-12-28 10:22:53,746  WARN JDBCExceptionReporter: SQL Error: -22, 
SQLState: S0002
2004-12-28 10:22:53,751 ERROR JDBCExceptionReporter: Table not found: 
GROUPER_FIELD in statement [select grouperfie0_.groupField as 
groupField, grouperfie0_.readPriv as readPriv, grouperfie0_.writePriv as 
writePriv, grouperfie0_.isList as isList from grouper_field grouperfie0_]
2004-12-28 10:22:53,751 ERROR JDBCExceptionReporter: Table not found: 
GROUPER_FIELD in statement [select grouperfie0_.groupField as 
groupField, grouperfie0_.readPriv as readPriv, grouperfie0_.writePriv as 
writePriv, grouperfie0_.isList as isList from grouper_field grouperfie0_]
2004-12-28 10:22:53,755  WARN JDBCExceptionReporter: SQL Error: -22, 
SQLState: S0002
2004-12-28 10:22:53,755  WARN JDBCExceptionReporter: SQL Error: -22, 
SQLState: S0002
2004-12-28 10:22:53,758 ERROR JDBCExceptionReporter: Table not found: 
GROUPER_FIELD in statement [select grouperfie0_.groupField as 
groupField, grouperfie0_.readPriv as readPriv, grouperfie0_.writePriv as 
writePriv, grouperfie0_.isList as isList from grouper_field grouperfie0_]
2004-12-28 10:22:53,758 ERROR JDBCExceptionReporter: Table not found: 
GROUPER_FIELD in statement [select grouperfie0_.groupField as 
groupField, grouperfie0_.readPriv as readPriv, grouperfie0_.writePriv as 
writePriv, grouperfie0_.isList as isList from grouper_field grouperfie0_]
net.sf.hibernate.exception.SQLGrammarException: Could not execute query

--
________________________________________________________
Keith Hazelton                  Senior IT Architect, UW-Madison
(608) 262-0771                  Division of Info. Technology
(608) 877-0977 (home)           1210 W. Dayton St., rm. 2164
http://arch.doit.wisc.edu/keith      Madison, WI  53706