subject api jdbc connector should give descriptive errors

The subject api gives substandard error messages when something is wrong. In the case below I believe the query doesnt have enough columns, but it is very vague. It should give the query in the error message (I just committed a fix for this, but we should test), and it should tell which column it is looking for but cant find...

One of the queries in the sources.xml file is not valid for your DB. Try copying the query to the DB and fill in a value where the ?'s are, and see if it works. Incidentally, I think we should tighten up the error handling in the JDBCSourceAdapter class... either for 1.3 or 1.4. I added some stuff in there to make it better, if anyone objects, let me know and I can remove... but there is more to do...

Thanks,
Chris

e.g. if the query is:

select
s.subjectid as id, s.name as name,
(select sa2.value from subjectattribute sa2 where name='name' and sa2.SUBJECTID = s.subjectid) as lfname,
(select sa3.value from subjectattribute sa3 where name='loginid' and sa3.SUBJECTID = s.subjectid) as loginid,
(select sa4.value from subjectattribute sa4 where name='description' and sa4.SUBJECTID = s.subjectid) as description from
subject s
where
s.subjectid = ?

run the query:

select
s.subjectid as id, s.name as name,
(select sa2.value from subjectattribute sa2 where name='name' and sa2.SUBJECTID = s.subjectid) as lfname,
(select sa3.value from subjectattribute sa3 where name='loginid' and sa3.SUBJECTID = s.subjectid) as loginid,
(select sa4.value from subjectattribute sa4 where name='description' and sa4.SUBJECTID = s.subjectid) as description from
subject s
where
s.subjectid = 'abc'

> ----Original Message----
> From: Thomas M Goerger tmg@umn.edu
> Sent: Wednesday, May 07, 2008 12:39 PM
> To: Chris Hyzer
> Subject: RE: [grouper-users] Errors switching to Oracle backend
>
> I was using version 1.2.1, but just tried installing 1.3RC2, and am
> getting the same errors with it also. I'm using Oracle 10g, using the
> driver downloaded from Oracle's JDBC site ojdbc14.jar.
>
> The database does seem to get created correctly in the schemaexport
> and db-init steps, so I'm not sure why it's failing in the test step.
> I'll paste some errors below.
>
> test.log:
>
> /home/tmg/grouper/grouper/build.xml:651: Test
> edu.internet2.middleware.grouper.SuiteDefault failed
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.actOnTestResult
> (
> JUnitTask.java:1712)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTa
> s
> k.java:820)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.executeOrQueue(
> J
> UnitTask.java:1657)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTask.execute(JUnitTa
> s
> k.java:764)
> at
> org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
> at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
> o
> rImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at
> org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:
> 105)
> at org.apache.tools.ant.Task.perform(Task.java:348)
> at org.apache.tools.ant.Target.execute(Target.java:357)
> at org.apache.tools.ant.Target.performTasks(Target.java:385)
> at
> org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
> at
> org.apache.tools.ant.Project.executeTarget(Project.java:1298)
> at
> org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExec
> u
> tor.java:41)
> at
> org.apache.tools.ant.Project.executeTargets(Project.java:1181)
> at org.apache.tools.ant.Main.runBuild(Main.java:698)
> at org.apache.tools.ant.Main.startAnt(Main.java:199)
> at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
> at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
> [junit] Running edu.internet2.middleware.grouper.SuiteDefault
> [junit] System property grouper.allow.db.changes is true which
> allows db changes to user 'grouper' and url 'jdbc
> :oracle:thin:@192.168.77.225:1521:grouper'
> [junit] log4j:WARN No appenders could be found for logger
> (org.hibernate.cfg.SettingsFactory).
> [junit] log4j:WARN Please initialize the log4j system properly.
> [junit] Tests run: 165, Failures: 0, Errors: 1, Time elapsed:
> 83.467
> sec
>
> BUILD FAILED
>
> ------------------------------------------------
> grouper_error.log
> -------------------------------------------
>
> 2008-05-07 11:24:55,620: Instantiating new Digester.
> 2008-05-07 11:24:55,620: Instantiating new Digester.
> 2008-05-07 11:24:55,692: Parsing config input stream:
> java.io.BufferedInputStream@1301ed8
> 2008-05-07 11:24:55,692: Parsing config input stream:
> java.io.BufferedInputStream@1301ed8
> 2008-05-07 11:24:56,260: Loading source: g:gsa
> 2008-05-07 11:24:56,260: Loading source: g:gsa
> 2008-05-07 11:24:56,281: Loading search: searchSubject
> 2008-05-07 11:24:56,281: Loading search: searchSubject
> 2008-05-07 11:24:56,283: Loading search: searchSubjectByIdentifier
> 2008-05-07 11:24:56,283: Loading search: searchSubjectByIdentifier
> 2008-05-07 11:24:56,285: Loading search: search
> 2008-05-07 11:24:56,285: Loading search: search
> 2008-05-07 11:24:56,288: Loading source: ldapjndi
> 2008-05-07 11:24:56,288: Loading source: ldapjndi
> 2008-05-07 11:24:56,288: Creating Directory Context
> 2008-05-07 11:24:56,288: Creating Directory Context
> 2008-05-07 11:24:56,353: Success in connecting to LDAP
> 2008-05-07 11:24:56,353: Success in connecting to LDAP
> 2008-05-07 11:24:56,388: Loading search: searchSubject
> 2008-05-07 11:24:56,388: Loading search: searchSubject
> 2008-05-07 11:24:56,390: Loading search: searchSubjectByIdentifier
> 2008-05-07 11:24:56,390: Loading search: searchSubjectByIdentifier
> 2008-05-07 11:24:56,392: Loading search: search
> 2008-05-07 11:24:56,392: Loading search: search
> 2008-05-07 11:24:56,392: Loading source: oracle
> 2008-05-07 11:24:56,392: Loading source: oracle
> 2008-05-07 11:24:56,408: Loading JDBC driver:
> oracle.jdbc.driver.OracleDriver
> 2008-05-07 11:24:56,408: Loading JDBC driver:
> oracle.jdbc.driver.OracleDriver
> 2008-05-07 11:24:56,408: JDBC driver loaded.
> 2008-05-07 11:24:56,408: JDBC driver loaded.
> 2008-05-07 11:24:56,423: Initializing connection factory.
> 2008-05-07 11:24:56,423: Initializing connection factory.
> 2008-05-07 11:24:56,426: Connection factory initialized.
> 2008-05-07 11:24:56,426: Connection factory initialized.
> 2008-05-07 11:24:56,444: Data Source initialized.
> 2008-05-07 11:24:56,444: Data Source initialized.
> 2008-05-07 11:24:56,479: Loading source: g:isa
> 2008-05-07 11:24:56,479: Loading source: g:isa
> 2008-05-07 11:25:49,764: Instantiating new Digester.
> 2008-05-07 11:25:49,764: Instantiating new Digester.
> 2008-05-07 11:25:49,833: Parsing config input stream:
> java.io.BufferedInputStream@1301ed8
> 2008-05-07 11:25:49,833: Parsing config input stream:
> java.io.BufferedInputStream@1301ed8
> 2008-05-07 11:25:50,417: Loading source: g:gsa
> 2008-05-07 11:25:50,417: Loading source: g:gsa
> 2008-05-07 11:25:50,438: Loading search: searchSubject
> 2008-05-07 11:25:50,438: Loading search: searchSubject
> 2008-05-07 11:25:50,440: Loading search: searchSubjectByIdentifier
> 2008-05-07 11:25:50,440: Loading search: searchSubjectByIdentifier
> 2008-05-07 11:25:50,443: Loading search: search
> 2008-05-07 11:25:50,443: Loading search: search
> 2008-05-07 11:25:50,445: Loading source: ldapjndi
> 2008-05-07 11:25:50,445: Loading source: ldapjndi
> 2008-05-07 11:25:50,445: Creating Directory Context
> 2008-05-07 11:25:50,445: Creating Directory Context
> 2008-05-07 11:25:50,557: Success in connecting to LDAP
> 2008-05-07 11:25:50,557: Success in connecting to LDAP
> 2008-05-07 11:25:50,593: Loading search: searchSubject
> 2008-05-07 11:25:50,593: Loading search: searchSubject
> 2008-05-07 11:25:50,595: Loading search: searchSubjectByIdentifier
> 2008-05-07 11:25:50,595: Loading search: searchSubjectByIdentifier
> 2008-05-07 11:25:50,597: Loading search: search
> 2008-05-07 11:25:50,597: Loading search: search
> 2008-05-07 11:25:50,597: Loading source: oracle
> 2008-05-07 11:25:50,597: Loading source: oracle
> 2008-05-07 11:25:50,613: Loading JDBC driver:
> oracle.jdbc.driver.OracleDriver
> 2008-05-07 11:25:50,613: Loading JDBC driver:
> oracle.jdbc.driver.OracleDriver
> 2008-05-07 11:25:50,613: JDBC driver loaded.
> 2008-05-07 11:25:50,613: JDBC driver loaded.
> 2008-05-07 11:25:50,629: Initializing connection factory.
> 2008-05-07 11:25:50,629: Initializing connection factory.
> 2008-05-07 11:25:50,631: Connection factory initialized.
> 2008-05-07 11:25:50,631: Connection factory initialized.
> 2008-05-07 11:25:50,661: Data Source initialized.
> 2008-05-07 11:25:50,661: Data Source initialized.
> 2008-05-07 11:25:50,790: Loading source: g:isa
> 2008-05-07 11:25:50,790: Loading source: g:isa
> 2008-05-07 11:26:09,665: Instantiating new Digester.
> 2008-05-07 11:26:09,665: Instantiating new Digester.
> 2008-05-07 11:26:09,715: Parsing config input stream:
> java.io.BufferedInputStream@268cc6
> 2008-05-07 11:26:09,715: Parsing config input stream:
> java.io.BufferedInputStream@268cc6
> 2008-05-07 11:26:09,738: Loading source: g:gsa
> 2008-05-07 11:26:09,738: Loading source: g:gsa
> 2008-05-07 11:26:09,754: Loading search: searchSubject
> 2008-05-07 11:26:09,754: Loading search: searchSubject
> 2008-05-07 11:26:09,757: Loading search: searchSubjectByIdentifier
> 2008-05-07 11:26:09,757: Loading search: searchSubjectByIdentifier
> 2008-05-07 11:26:09,758: Loading search: search
> 2008-05-07 11:26:09,758: Loading search: search
> 2008-05-07 11:26:09,759: Loading source: ldapjndi
> 2008-05-07 11:26:09,759: Loading source: ldapjndi
> 2008-05-07 11:26:09,760: Creating Directory Context
> 2008-05-07 11:26:09,760: Creating Directory Context
> 2008-05-07 11:26:09,831: Success in connecting to LDAP
> 2008-05-07 11:26:09,831: Success in connecting to LDAP
> 2008-05-07 11:26:09,993: Loading search: searchSubject
> 2008-05-07 11:26:09,993: Loading search: searchSubject
> 2008-05-07 11:26:09,994: Loading search: searchSubjectByIdentifier
> 2008-05-07 11:26:09,994: Loading search: searchSubjectByIdentifier
> 2008-05-07 11:26:09,996: Loading search: search
> 2008-05-07 11:26:09,996: Loading search: search
> 2008-05-07 11:26:09,996: Loading source: oracle
> 2008-05-07 11:26:09,996: Loading source: oracle
> 2008-05-07 11:26:09,997: Loading JDBC driver:
> oracle.jdbc.driver.OracleDriver
> 2008-05-07 11:26:09,997: Loading JDBC driver:
> oracle.jdbc.driver.OracleDriver
> 2008-05-07 11:26:09,997: JDBC driver loaded.
> 2008-05-07 11:26:09,997: JDBC driver loaded.
> 2008-05-07 11:26:10,013: Initializing connection factory.
> 2008-05-07 11:26:10,013: Initializing connection factory.
> 2008-05-07 11:26:10,015: Connection factory initialized.
> 2008-05-07 11:26:10,015: Connection factory initialized.
> 2008-05-07 11:26:10,030: Data Source initialized.
> 2008-05-07 11:26:10,030: Data Source initialized.
> 2008-05-07 11:26:10,031: Loading source: g:isa
> 2008-05-07 11:26:10,031: Loading source: g:isa
> 2008-05-07 11:26:13,170: Loading source: g:isa
> 2008-05-07 11:26:13,170: Loading source: g:isa
> 2008-05-07 11:26:14,356: Loading source: g:isa
> 2008-05-07 11:26:14,356: Loading source: g:isa
> 2008-05-07 11:26:15,776: Loading source: g:isa
> 2008-05-07 11:26:15,776: Loading source: g:isa
> 2008-05-07 11:26:17,081: Loading source: g:isa
> 2008-05-07 11:26:17,081: Loading source: g:isa
> 2008-05-07 11:26:20,683: Loading source: g:isa
> 2008-05-07 11:26:20,683: Loading source: g:isa
> 2008-05-07 11:26:21,780: Loading source: g:isa
> 2008-05-07 11:26:21,780: Loading source: g:isa
> 2008-05-07 11:26:27,627: Loading source: g:isa
> 2008-05-07 11:26:27,627: Loading source: g:isa
> 2008-05-07 11:26:28,311: Loading source: g:isa
> 2008-05-07 11:26:28,311: Loading source: g:isa
> 2008-05-07 11:26:29,214: Loading source: g:isa
> 2008-05-07 11:26:29,214: Loading source: g:isa
> 2008-05-07 11:26:30,256: Loading source: g:isa
> 2008-05-07 11:26:30,256: Loading source: g:isa
> 2008-05-07 11:26:31,466: Loading source: g:isa
> 2008-05-07 11:26:31,466: Loading source: g:isa
> 2008-05-07 11:26:32,620: Loading source: g:isa
> 2008-05-07 11:26:32,620: Loading source: g:isa
> 2008-05-07 11:26:33,862: Loading source: g:isa
> 2008-05-07 11:26:33,862: Loading source: g:isa
> 2008-05-07 11:26:34,852: Loading source: g:isa
> 2008-05-07 11:26:34,852: Loading source: g:isa
> 2008-05-07 11:26:35,926: Loading source: g:isa
> 2008-05-07 11:26:35,926: Loading source: g:isa
> 2008-05-07 11:26:37,309: Loading source: g:isa
> 2008-05-07 11:26:37,309: Loading source: g:isa
> 2008-05-07 11:26:38,319: Loading source: g:isa
> 2008-05-07 11:26:38,319: Loading source: g:isa
> 2008-05-07 11:26:39,412: Loading source: g:isa
> 2008-05-07 11:26:39,412: Loading source: g:isa
> 2008-05-07 11:26:40,856: Loading source: g:isa
> 2008-05-07 11:26:40,856: Loading source: g:isa
> 2008-05-07 11:26:42,206: Loading source: g:isa
> 2008-05-07 11:26:42,206: Loading source: g:isa
> 2008-05-07 11:26:43,319: Loading source: g:isa
> 2008-05-07 11:26:43,319: Loading source: g:isa
> 2008-05-07 11:26:44,381: Loading source: g:isa
> 2008-05-07 11:26:44,381: Loading source: g:isa
> 2008-05-07 11:26:45,381: Loading source: g:isa
> 2008-05-07 11:26:45,381: Loading source: g:isa
> 2008-05-07 11:26:46,425: Loading source: g:isa
> 2008-05-07 11:26:46,425: Loading source: g:isa
> 2008-05-07 11:26:47,442: Loading source: g:isa
> 2008-05-07 11:26:47,442: Loading source: g:isa
> 2008-05-07 11:26:49,112: Loading source: g:isa
> 2008-05-07 11:26:49,112: Loading source: g:isa
> 2008-05-07 11:26:50,125: Loading source: g:isa
> 2008-05-07 11:26:50,125: Loading source: g:isa
> 2008-05-07 11:26:51,122: Loading source: g:isa
> 2008-05-07 11:26:51,122: Loading source: g:isa
> 2008-05-07 11:26:52,063: Loading source: g:isa
> 2008-05-07 11:26:52,063: Loading source: g:isa
> 2008-05-07 11:26:53,393: Loading source: g:isa
> 2008-05-07 11:26:53,393: Loading source: g:isa
> 2008-05-07 11:26:54,377: Loading source: g:isa
> 2008-05-07 11:26:54,377: Loading source: g:isa
> 2008-05-07 11:26:55,430: Loading source: g:isa
> 2008-05-07 11:26:55,430: Loading source: g:isa
> 2008-05-07 11:26:56,404: Loading source: g:isa
> 2008-05-07 11:26:56,404: Loading source: g:isa
> 2008-05-07 11:26:57,338: Loading source: g:isa
> 2008-05-07 11:26:57,338: Loading source: g:isa
> 2008-05-07 11:26:58,271: Loading source: g:isa
> 2008-05-07 11:26:58,271: Loading source: g:isa
> 2008-05-07 11:26:59,277: Loading source: g:isa
> 2008-05-07 11:26:59,277: Loading source: g:isa
> 2008-05-07 11:27:00,244: Loading source: g:isa
> 2008-05-07 11:27:00,244: Loading source: g:isa
> 2008-05-07 11:27:01,426: Loading source: g:isa
> 2008-05-07 11:27:01,426: Loading source: g:isa
> 2008-05-07 11:27:02,628: Loading source: g:isa
> 2008-05-07 11:27:02,628: Loading source: g:isa
> 2008-05-07 11:27:03,965: Loading source: g:isa
> 2008-05-07 11:27:03,965: Loading source: g:isa
> 2008-05-07 11:27:05,242: Loading source: g:isa
> 2008-05-07 11:27:05,242: Loading source: g:isa
> 2008-05-07 11:27:06,410: Loading source: g:isa
> 2008-05-07 11:27:06,410: Loading source: g:isa
> 2008-05-07 11:27:07,645: Loading source: g:isa
> 2008-05-07 11:27:07,645: Loading source: g:isa
> 2008-05-07 11:27:08,663: Loading source: g:isa
> 2008-05-07 11:27:08,663: Loading source: g:isa
> 2008-05-07 11:27:09,707: Loading source: g:isa
> 2008-05-07 11:27:09,707: Loading source: g:isa
> 2008-05-07 11:27:10,724: Loading source: g:isa
> 2008-05-07 11:27:10,724: Loading source: g:isa
> 2008-05-07 11:27:11,657: Loading source: g:isa
> 2008-05-07 11:27:11,657: Loading source: g:isa
> 2008-05-07 11:27:12,573: Loading source: g:isa
> 2008-05-07 11:27:12,573: Loading source: g:isa
> 2008-05-07 11:27:13,476: Loading source: g:isa
> 2008-05-07 11:27:13,476: Loading source: g:isa
> 2008-05-07 11:27:14,458: Loading source: g:isa
> 2008-05-07 11:27:14,458: Loading source: g:isa
> 2008-05-07 11:27:15,421: Loading source: g:isa
> 2008-05-07 11:27:15,421: Loading source: g:isa
> 2008-05-07 11:27:16,651: Loading source: g:isa
> 2008-05-07 11:27:16,651: Loading source: g:isa
> 2008-05-07 11:27:17,637: Loading source: g:isa
> 2008-05-07 11:27:17,637: Loading source: g:isa
> 2008-05-07 11:27:18,545: Loading source: g:isa
> 2008-05-07 11:27:18,545: Loading source: g:isa
> 2008-05-07 11:27:19,460: Loading source: g:isa
> 2008-05-07 11:27:19,460: Loading source: g:isa
> 2008-05-07 11:27:20,417: Loading source: g:isa
> 2008-05-07 11:27:20,417: Loading source: g:isa
> 2008-05-07 11:27:21,409: Loading source: g:isa
> 2008-05-07 11:27:21,409: Loading source: g:isa
> 2008-05-07 11:27:22,444: Loading source: g:isa
> 2008-05-07 11:27:22,444: Loading source: g:isa
> 2008-05-07 11:27:23,376: Loading source: g:isa
> 2008-05-07 11:27:23,376: Loading source: g:isa
> 2008-05-07 11:27:24,348: Loading source: g:isa
> 2008-05-07 11:27:24,348: Loading source: g:isa
> 2008-05-07 11:27:27,362: Loading source: g:isa
> 2008-05-07 11:27:27,362: Loading source: g:isa
> 2008-05-07 11:27:27,440: Loading source: g:isa
> 2008-05-07 11:27:27,440: Loading source: g:isa
> 2008-05-07 11:27:27,459: searchType: searchSubject filter:
> (&(cn=subject
> does not exist)(objectclass=person)) base:
> 2008-05-07 11:27:27,459: searchType: searchSubject filter:
> (&(cn=subject
> does not exist)(objectclass=person)) base:
> 2008-05-07 11:27:27,727: Loading source: g:isa
> 2008-05-07 11:27:27,727: Loading source: g:isa
> 2008-05-07 11:27:27,739: searchType: searchSubject filter:
> (&(cn=GrouperAll)(objectclass=person)) base: ou=People,o=
> 2008-05-07 11:27:27,739: searchType: searchSubject filter:
> (&(cn=GrouperAll)(objectclass=person)) base: ou=People,o=
> 2008-05-07 11:27:27,822: Loading source: g:isa
> 2008-05-07 11:27:27,822: Loading source: g:isa
> 2008-05-07 11:27:27,908: Loading source: g:isa
> 2008-05-07 11:27:27,908: Loading source: g:isa
> 2008-05-07 11:27:27,921: searchType: searchSubject filter:
> (&(cn=GrouperAll)(objectclass=person)) base: ou=People,o=
> 2008-05-07 11:27:27,921: searchType: searchSubject filter:
> (&(cn=GrouperAll)(objectclass=person)) base: ou=People,o=
> 2008-05-07 11:27:28,011: Loading source: g:isa
> 2008-05-07 11:27:28,011: Loading source: g:isa
> 2008-05-07 11:27:28,139: searchType: search filter: (cn=subject does
> not
> exist) base: ou=People,o=University of Minn
> 2008-05-07 11:27:28,139: searchType: search filter: (cn=subject does
> not
> exist) base: ou=People,o=University of Minn
> 2008-05-07 11:27:28,168: SQLException occurred: Invalid column index
> java.sql.SQLException: Invalid column index
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 1
> 12)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 1
> 46)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 2
> 08)
> at
> oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePre
> p
> aredStatement.java:5360)
> at
> oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedSta
> t
> ement.java:5352)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegati
> n
> gPreparedStatement.java:131)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegati
> n
> gPreparedStatement.java:131)
> at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSqlResu
> l
> ts(Unknown
> Source)
> at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.search(Unk
> n
> own
> Source)
> at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.findAll(Sourc
> e
> sXmlResolver.java:143)
> at
> edu.internet2.middleware.grouper.subj.CachingResolver.findAll(CachingR
> e
> solver.java:119)
> at
> edu.internet2.middleware.grouper.Test_subj_CachingResolver.test_findAl
> l
> _Query_cacheMiss(Unknown
> Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
> a
> va:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
> o
> rImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at junit.framework.TestCase.runTest(TestCase.java:164)
> at junit.framework.TestCase.runBare(TestCase.java:130)
> at junit.framework.TestResult$1.protect(TestResult.java:110)
> at junit.framework.TestResult.runProtected(TestResult.java:128)
> at junit.framework.TestResult.run(TestResult.java:113)
> at junit.framework.TestCase.run(TestCase.java:120)
> at junit.framework.TestSuite.runTest(TestSuite.java:228)
> at junit.framework.TestSuite.run(TestSuite.java:223)
> at junit.framework.TestSuite.runTest(TestSuite.java:228)
> at junit.framework.TestSuite.run(TestSuite.java:223)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnit
> T
> estRunner.java:421)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JU
> n
> itTestRunner.java:912)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUni
> t
> TestRunner.java:766)
> 2008-05-07 11:27:28,168: SQLException occurred: Invalid column index
> java.sql.SQLException: Invalid column index
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 1
> 12)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 1
> 46)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 2
> 08)
> at
> oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePre
> p
> aredStatement.java:5360)
> at
> oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedSta
> t
> ement.java:5352)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegati
> n
> gPreparedStatement.java:131)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegati
> n
> gPreparedStatement.java:131)
> at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSqlResu
> l
> ts(Unknown
> Source)
> at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.search(Unk
> n
> own
> Source)
> at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.findAll(Sourc
> e
> sXmlResolver.java:143)
> at
> edu.internet2.middleware.grouper.subj.CachingResolver.findAll(CachingR
> e
> solver.java:119)
> at
> edu.internet2.middleware.grouper.Test_subj_CachingResolver.test_findAl
> l
> _Query_cacheMiss(Unknown
> Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
> a
> va:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
> o
> rImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at junit.framework.TestCase.runTest(TestCase.java:164)
> at junit.framework.TestCase.runBare(TestCase.java:130)
> at junit.framework.TestResult$1.protect(TestResult.java:110)
> at junit.framework.TestResult.runProtected(TestResult.java:128)
> at junit.framework.TestResult.run(TestResult.java:113)
> at junit.framework.TestCase.run(TestCase.java:120)
> at junit.framework.TestSuite.runTest(TestSuite.java:228)
> at junit.framework.TestSuite.run(TestSuite.java:223)
> at junit.framework.TestSuite.runTest(TestSuite.java:228)
> at junit.framework.TestSuite.run(TestSuite.java:223)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnit
> T
> estRunner.java:421)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JU
> n
> itTestRunner.java:912)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUni
> t
> TestRunner.java:766)
> 2008-05-07 11:27:28,266: Loading source: g:isa
> 2008-05-07 11:27:28,266: Loading source: g:isa
> 2008-05-07 11:27:28,283: searchType: search filter: (cn=GrouperAll)
> base:
> ou=People,o=University of Minnesota,c=US s
> 2008-05-07 11:27:28,283: searchType: search filter: (cn=GrouperAll)
> base:
> ou=People,o=University of Minnesota,c=US s
> 2008-05-07 11:27:28,288: SQLException occurred: Invalid column index
> java.sql.SQLException: Invalid column index
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 1
> 12)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 1
> 46)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 2
> 08)
> at
> oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePre
> p
> aredStatement.java:5360)
> at
> oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedSta
> t
> ement.java:5352)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegati
> n
> gPreparedStatement.java:131)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegati
> n
> gPreparedStatement.java:131)
> at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSqlResu
> l
> ts(Unknown
> Source)
> at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.search(Unk
> n
> own
> Source)
> at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.findAll(Sourc
> e
> sXmlResolver.java:143)
> at
> edu.internet2.middleware.grouper.subj.CachingResolver.findAll(CachingR
> e
> solver.java:119)
> at
> edu.internet2.middleware.grouper.Test_subj_CachingResolver.test_findAl
> l
> _Query_cacheHit(Unknown
> Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
> a
> va:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
> o
> rImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at junit.framework.TestCase.runTest(TestCase.java:164)
> at junit.framework.TestCase.runBare(TestCase.java:130)
> at junit.framework.TestResult$1.protect(TestResult.java:110)
> at junit.framework.TestResult.runProtected(TestResult.java:128)
> at junit.framework.TestResult.run(TestResult.java:113)
> at junit.framework.TestCase.run(TestCase.java:120)
> at junit.framework.TestSuite.runTest(TestSuite.java:228)
> at junit.framework.TestSuite.run(TestSuite.java:223)
> at junit.framework.TestSuite.runTest(TestSuite.java:228)
> at junit.framework.TestSuite.run(TestSuite.java:223)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnit
> T
> estRunner.java:421)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JU
> n
> itTestRunner.java:912)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUni
> t
> TestRunner.java:766)
> 2008-05-07 11:27:28,288: SQLException occurred: Invalid column index
> java.sql.SQLException: Invalid column index
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 1
> 12)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 1
> 46)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 2
> 08)
> at
> oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePre
> p
> aredStatement.java:5360)
> at
> oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedSta
> t
> ement.java:5352)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegati
> n
> gPreparedStatement.java:131)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegati
> n
> gPreparedStatement.java:131)
> at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSqlResu
> l
> ts(Unknown
> Source)
> at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.search(Unk
> n
> own
> Source)
> at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.findAll(Sourc
> e
> sXmlResolver.java:143)
> at
> edu.internet2.middleware.grouper.subj.CachingResolver.findAll(CachingR
> e
> solver.java:119)
> at
> edu.internet2.middleware.grouper.Test_subj_CachingResolver.test_findAl
> l
> _Query_cacheHit(Unknown
> Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
> a
> va:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
> o
> rImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at junit.framework.TestCase.runTest(TestCase.java:164)
> at junit.framework.TestCase.runBare(TestCase.java:130)
> at junit.framework.TestResult$1.protect(TestResult.java:110)
> at junit.framework.TestResult.runProtected(TestResult.java:128)
> at junit.framework.TestResult.run(TestResult.java:113)
> at junit.framework.TestCase.run(TestCase.java:120)
> at junit.framework.TestSuite.runTest(TestSuite.java:228)
> at junit.framework.TestSuite.run(TestSuite.java:223)
> at junit.framework.TestSuite.runTest(TestSuite.java:228)
> at junit.framework.TestSuite.run(TestSuite.java:223)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnit
> T
> estRunner.java:421)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JU
> n
> itTestRunner.java:912)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUni
> t
> TestRunner.java:766)
> 2008-05-07 11:27:28,366: Loading source: g:isa
> 2008-05-07 11:27:28,366: Loading source: g:isa
> 2008-05-07 11:27:28,450: Loading source: g:isa
> 2008-05-07 11:27:28,450: Loading source: g:isa
> 2008-05-07 11:27:28,466: searchType: search filter: (cn=GrouperAll)
> base:
> ou=People,o=University of Minnesota,c=US s
> 2008-05-07 11:27:28,466: searchType: search filter: (cn=GrouperAll)
> base:
> ou=People,o=University of Minnesota,c=US s
> 2008-05-07 11:27:28,472: SQLException occurred: Invalid column index
> java.sql.SQLException: Invalid column index
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 1
> 12)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 1
> 46)
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:
> 2
> 08)
> at
> oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePre
> p
> aredStatement.java:5360)
> at
> oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedSta
> t
> ement.java:5352)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegati
> n
> gPreparedStatement.java:131)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegati
> n
> gPreparedStatement.java:131)
> at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSqlResu
> l
> ts(Unknown
> Source)
> at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.search(Unk
> n
> own
> Source)
> at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.findAll(Sourc
> e
> sXmlResolver.java:143)
> at
> edu.internet2.middleware.grouper.subj.CachingResolver.findAll(CachingR
> e
> solver.java:119)
> at
> edu.internet2.middleware.grouper.Test_subj_CachingResolver.test_findAl
> l
> _Query_cacheSize(Unknown
> Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j
> a
> va:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
> o
> rImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:585)
> at junit.framework.TestCase.runTest(TestCase.java:164)
> at junit.framework.TestCase.runBare(TestCase.java:130)
> at junit.framework.TestResult$1.protect(TestResult.java:110)
> at junit.framework.TestResult.runProtected(TestResult.java:128)
> at junit.framework.TestResult.run(TestResult.java:113)
> at junit.framework.TestCase.run(TestCase.java:120)
> at junit.framework.TestSuite.runTest(TestSuite.java:228)
> at junit.framework.TestSuite.run(TestSuite.java:223)
> at junit.framework.TestSuite.runTest(TestSuite.java:228)
> at junit.framework.TestSuite.run(TestSuite.java:223)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnit
> T
> estRunner.java:421)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JU
> n
> itTestRunner.java:912)
> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUni
> t
> TestRunner.java:766)
> 2008-05-07 11:27:28,472: SQLException occurred: Invalid column index
>
>
> thanks,
>
> Tom Goerger
>
>
> On Tue, 6 May 2008, Chris Hyzer wrote:
>
> > Oracle is common with grouper, so something weird is going on.
> >
> > Can you give more info?
> >
> > 1. What version of grouper
> > 2. Can you copy and paste more output/logs 3. What version of oracle
> > (10g)?
> > 4. Did you put an oracle driver jar in the lib dir or are you using
> one that was there already? (ojdbc14.jar)
> >
> > "ant test" should recreate the db, so it should be created correctly
> at that point... but I agree with you that error seems to point to
> the db and the java are mismatched somehow
> >
> > Finally, if you can get latest grouper from HEAD from cvs, that
> > might
> be better for you, if not, then the latest v1.3 releace candidate (2)
> might be best.
> >
> > Chris
> >
> >
> > > ----Original Message----
> > > From: Thomas M Goerger tmg@umn.edu
> > > Sent: Tuesday, May 06, 2008 4:53 PM
> > > To: grouper-users@internet2.edu
> > > Subject: [grouper-users] Errors switching to Oracle backend
> > >
> > > Hi,
> > >
> > > I'm trying to get Oracle hooked up as the backend database for
> Grouper,
> > > and am running into an error. When I run ant test, even with the
> > > -
> D
> > > "haltonerror=no" flag, I'm getting just one error. This error is:
> > >
> > > BUILD FAILED
> > > /home/tmg/grouper/grouper/build.xml:620: Test
> > > edu.internet2.middleware.grouper.SuiteDefault failed
> > >
> > > In the grouper_error log, I'm getting an SQL error of
> > > 2008-05-06 15:13:39,676: SQLException occurred: Invalid column
> index
> > > java.sql.SQLException: Invalid column index
> > >
> > > Could it be that the database was created incorrectly, or
> > > something along those lines? I didn't create the database, so I'm
> > > not certain if
> it
> > > needs
> > > to be created a certain way, or something like that.
> > >
> > > Thanks,
> > >
> > > Tom Goerger
> > > University of Minnesota
> > > Internet Services
> >