Grouper Developers Forum

[Chris Hyzer <>]

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 
> [mailto:]
> 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(JUnitTas
> 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(JUnitTas
> 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(DelegatingMethodAccesso
> 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(DefaultExecu
> 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(OraclePrep
> aredStatement.java:5360)
>         at
> oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStat
> ement.java:5352)
>         at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegatin
> gPreparedStatement.java:131)
>         at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegatin
> gPreparedStatement.java:131)
>         at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSqlResul
> ts(Unknown
> Source)
>         at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.search(Unkn
> own
> Source)
>         at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.findAll(Source
> sXmlResolver.java:143)
>         at
> edu.internet2.middleware.grouper.subj.CachingResolver.findAll(CachingRe
> solver.java:119)
>         at
> edu.internet2.middleware.grouper.Test_subj_CachingResolver.test_findAll
> _Query_cacheMiss(Unknown
> Source)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja
> va:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso
> 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(JUnitT
> estRunner.java:421)
>         at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUn
> itTestRunner.java:912)
>         at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnit
> 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(OraclePrep
> aredStatement.java:5360)
>         at
> oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStat
> ement.java:5352)
>         at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegatin
> gPreparedStatement.java:131)
>         at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegatin
> gPreparedStatement.java:131)
>         at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSqlResul
> ts(Unknown
> Source)
>         at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.search(Unkn
> own
> Source)
>         at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.findAll(Source
> sXmlResolver.java:143)
>         at
> edu.internet2.middleware.grouper.subj.CachingResolver.findAll(CachingRe
> solver.java:119)
>         at
> edu.internet2.middleware.grouper.Test_subj_CachingResolver.test_findAll
> _Query_cacheMiss(Unknown
> Source)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja
> va:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso
> 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(JUnitT
> estRunner.java:421)
>         at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUn
> itTestRunner.java:912)
>         at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnit
> 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(OraclePrep
> aredStatement.java:5360)
>         at
> oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStat
> ement.java:5352)
>         at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegatin
> gPreparedStatement.java:131)
>         at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegatin
> gPreparedStatement.java:131)
>         at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSqlResul
> ts(Unknown
> Source)
>         at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.search(Unkn
> own
> Source)
>         at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.findAll(Source
> sXmlResolver.java:143)
>         at
> edu.internet2.middleware.grouper.subj.CachingResolver.findAll(CachingRe
> solver.java:119)
>         at
> edu.internet2.middleware.grouper.Test_subj_CachingResolver.test_findAll
> _Query_cacheHit(Unknown
> Source)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja
> va:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso
> 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(JUnitT
> estRunner.java:421)
>         at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUn
> itTestRunner.java:912)
>         at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnit
> 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(OraclePrep
> aredStatement.java:5360)
>         at
> oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStat
> ement.java:5352)
>         at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegatin
> gPreparedStatement.java:131)
>         at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegatin
> gPreparedStatement.java:131)
>         at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSqlResul
> ts(Unknown
> Source)
>         at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.search(Unkn
> own
> Source)
>         at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.findAll(Source
> sXmlResolver.java:143)
>         at
> edu.internet2.middleware.grouper.subj.CachingResolver.findAll(CachingRe
> solver.java:119)
>         at
> edu.internet2.middleware.grouper.Test_subj_CachingResolver.test_findAll
> _Query_cacheHit(Unknown
> Source)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja
> va:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso
> 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(JUnitT
> estRunner.java:421)
>         at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUn
> itTestRunner.java:912)
>         at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnit
> 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(OraclePrep
> aredStatement.java:5360)
>         at
> oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStat
> ement.java:5352)
>         at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegatin
> gPreparedStatement.java:131)
>         at
> org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegatin
> gPreparedStatement.java:131)
>         at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSqlResul
> ts(Unknown
> Source)
>         at
> edu.internet2.middleware.subject.provider.JDBCSourceAdapter.search(Unkn
> own
> Source)
>         at
> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.findAll(Source
> sXmlResolver.java:143)
>         at
> edu.internet2.middleware.grouper.subj.CachingResolver.findAll(CachingRe
> solver.java:119)
>         at
> edu.internet2.middleware.grouper.Test_subj_CachingResolver.test_findAll
> _Query_cacheSize(Unknown
> Source)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja
> va:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso
> 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(JUnitT
> estRunner.java:421)
>         at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUn
> itTestRunner.java:912)
>         at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnit
> 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 
> > > [mailto:]
> > > Sent: Tuesday, May 06, 2008 4:53 PM
> > > To: 
> > > 
> > > 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
> >