Skip to Content.
Sympa Menu

grouper-users - Pt. 2: JDBC errors running csv2group

Subject: Grouper Users - Open Discussion List

List archive

Pt. 2: JDBC errors running csv2group


Chronological Thread 
  • From: Keith Hazelton <>
  • To:
  • Subject: Pt. 2: JDBC errors running csv2group
  • Date: Tue, 28 Dec 2004 10:38:18 -0600

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





Archive powered by MHonArc 2.6.16.

Top of Page