Grouper Developers Forum

[Thomas M Goerger <>]

I did make this change, and also tried to modify the question marks in my
queries that also seemed to be throwing 'invalid character' errors.  Still
am getting the Invalid column index error though, despite these changes.

Have any other ideas of what could be the culprit?  Or does anyone have a
working sample sources file that's hitting an Oracle DB that I could look
at?

Thanks,

Tom Goerger
University of Minnesota
Internet Services


On Thu, 8 May 2008, Chris Hyzer wrote:

> Ok, this is a little more complicated than invalid query.  The query must 
> have the same  number of ?'s as the numParameters setting in sources.xml, 
> you have 1 question mark and 2 as the setting.  Set it to 1, and you should 
> be all set.
>
> I have two problems with the subject api error handling.
>
> 1. It logs and swallows exceptions (here is an example in the current 
> grouper subject api):
>
>         } catch (SQLException ex) {
>             log.debug("SQLException occurred: " + ex.getMessage(), ex);
>         }
>
> 2. It doesn't give enough information.  It should tell you which source, 
> which query, which column index (in this case), etc, and give you a hint as 
> to what to do to fix it.  That would save everyone a lot of time.  I 
> changed the JDBCSourceAdapter (didn't commit), to give this error message:
>
> 2008-05-08 13:03:18,365 ERROR JDBCSourceAdapter: Error setting param: 2 in 
> source: qsuob, in query: select
> subject.subjectid as id, subject.name as name,{snip};, Invalid column 
> index, maybe not enough question marks (bind variables) are in query, or 
> the param 'numParameters' in sources.xml for that query is incorrect
>
> Which is very descriptive, and if it doesn't help the person using it, the 
> list will instantly know the  problem.
>
> If the subject sources are setup correctly then my changes wont help much, 
> but if not, they will be valuable.  Not sure what version of grouper we 
> want these in...  let me know.
>
> Thanks,
> Chris
>
>
> > -----Original Message-----
> > From: Thomas M Goerger 
> > [mailto:]
> > Sent: Thursday, May 08, 2008 10:13 AM
> > To: Chris Hyzer
> > Subject: RE: [grouper-users] Errors switching to Oracle backend
> >
> > Hi,
> >
> > The query looks OK.  I don't know SQL well at all, so I had one of our
> > SQL
> > gurus look it over, and it all checked out for him with Oracle.  I was
> > thinking the same, that it might be a problem with sources.xml.  I just
> > basically adapted the HSQLDB source to use Oracle, so I'm not sure if
> > that's causing the problem, in that one of the parameters is set
> > incorrectly.  In any case, below is my sources.xml.  Thanks for the
> > consideration!
> >
> > Tom Goerger
> > University of Minnesota
> > Internet Services
> >
> > <?xml version="1.0" encoding="utf-8"?>
> >
> > <!--
> > Grouper's subject resolver configuration
> > $Id: sources.xml,v 1.8 2007/08/30 15:52:22 blair Exp $
> > -->
> >
> > <sources>
> >
> >   <!-- Group Subject Resolver -->
> >   <!--
> >     NOTE: It is recommended that you **not** change the default
> >           values for this source adapter.
> >   -->
> >   <source
> > adapterClass="edu.internet2.middleware.grouper.GrouperSourceAdapter">
> >     <id>g:gsa</id>
> >     <name>Grouper: Group Source Adapter</name>
> >     <type>group</type>
> >   </source>
> >   <!-- Group Subject Resolver -->
> >
> >
> >   <source
> > adapterClass="edu.internet2.middleware.subject.provider.JNDISourceAdapt
> > er">
> >     <id>ldapjndi</id>
> >     <name>LDAP JNDI Source Adapter</name>
> >     <type>person</type>
> >     <init-param>
> >       <param-name>INITIAL_CONTEXT_FACTORY</param-name>
> >       <param-value>com.sun.jndi.ldap.LdapCtxFactory</param-value>
> >     </init-param>
> >     <init-param>
> >       <param-name>PROVIDER_URL</param-name>
> >       <param-value>ldap://lde-d.tc.umn.edu:389</param-value>
> >     </init-param>
> >     <init-param>
> >       <param-name>POOL_CONNECTIONS</param-name>
> >       <param-value>true</param-value>
> >     </init-param>
> >     <init-param>
> >       <param-name>SECURITY_AUTHENTICATION</param-name>
> >       <param-value>simple</param-value>
> >     </init-param>
> >     <init-param>
> >       <param-name>SECURITY_PRINCIPAL</param-name>
> >       <param-value>cn=Grouper Testing,ou=Application
> > Services,o=University
> > of Minnesota,c=US</param-value>>
> >     </init-param>
> >     <init-param>
> >       <param-name>SECURITY_CREDENTIALS</param-name>
> >       <param-value>not here</param-value>
> >     </init-param>
> >     <init-param>
> >       <param-name>SubjectID_AttributeType</param-name>
> >       <param-value>cn</param-value>
> >     </init-param>
> >     <init-param>
> >       <param-name>Name_AttributeType</param-name>
> >       <param-value>cn</param-value>
> >     </init-param>
> >     <init-param>
> >       <param-name>Description_AttributeType</param-name>
> >       <param-value>cn</param-value>
> >     </init-param>
> >
> >     <!-- Scope Values can be: OBJECT_SCOPE, ONELEVEL_SCOPE,
> > SUBTREE_SCOPE
> > -->
> >     <search>
> >       <searchType>searchSubject</searchType>
> >         <param>
> >           <param-name>filter</param-name>
> >           <param-value>
> >             (&amp;(cn=%TERM%)(objectclass=person))
> >           </param-value>
> >         </param>
> >         <param>
> >           <param-name>scope</param-name>
> >           <param-value>SUBTREE_SCOPE</param-value>
> >         </param>
> >         <param>
> >           <param-name>base</param-name>
> >           <param-value>
> >             ou=People,o=University of Minnesota,c=US
> >           </param-value>
> >         </param>
> >       </search>
> >
> >       <!-- this search and the one above return the basic set of
> > attributes: umnEmplID, cn, description -->
> >       <search>
> >         <searchType>searchSubjectByIdentifier</searchType>
> >         <param>
> >           <param-name>filter</param-name>
> >           <param-value>
> >             (&amp;(cn=%TERM%)(objectclass=person))
> >           </param-value>
> >         </param>
> >         <param>
> >           <param-name>scope</param-name>
> >           <param-value>SUBTREE_SCOPE</param-value>
> >         </param>
> >         <param>
> >           <param-name>base</param-name>
> >           <param-value>
> >             ou=People,o=University of Minnesota,c=US
> >           </param-value>
> >         </param>
> >       </search>
> >
> >       <!-- return additional attributes for this search, to help humans
> > recognize subjects -->
> >       <search>
> >         <searchType>search</searchType>
> >         <param>
> >           <param-name>filter</param-name>
> >           <param-value>
> >           (cn=%TERM%)
> > <!--
> > (&amp;(|(userid=%TERM%)(cn=%TERM%)(umnOfficialName=*%TERM%*))(objectcla
> > ss=person))
> > -->
> >           </param-value>
> >         </param>
> >         <param>
> >           <param-name>scope</param-name>
> >           <param-value>SUBTREE_SCOPE</param-value>
> >         </param>
> >         <param>
> >           <param-name>base</param-name>
> >           <param-value>
> >             ou=People,o=University of Minnesota,c=US
> >           </param-value>
> >         </param>
> >       </search>
> >       <attribute>sn</attribute>
> >       <attribute>uid</attribute>
> >       <attribute>givenName</attribute>
> >       <attribute>ou</attribute>
> >       <attribute>cn</attribute>
> >   </source>
> >
> >   <source
> > adapterClass="edu.internet2.middleware.subject.provider.JDBCSourceAdapt
> > er">
> >     <id>oracle</id>
> >     <name>Oracle JDBC Source Adapter</name>
> >     <type>person</type>
> >     <init-param>
> >       <param-name>maxActive</param-name>
> >       <param-value>4</param-value>
> >     </init-param>
> >     <init-param>
> >       <param-name>maxIdle</param-name>
> >       <param-value>2</param-value>
> >     </init-param>
> >     <init-param>
> >       <param-name>maxWait</param-name>
> >       <param-value>5</param-value>
> >     </init-param>
> >
> >     <init-param>
> >       <param-name>dbDriver</param-name>
> >       <param-value>oracle.jdbc.driver.OracleDriver</param-value>
> >     </init-param>
> >     <init-param>
> >       <param-name>dbUrl</param-name>
> >
> > <param-value>jdbc:oracle:thin:@edb1.tc.umn.edu:1521:grouper</param-
> > value>
> >     </init-param>
> >
> >     <init-param>
> >       <param-name>dbUser</param-name>
> >       <param-value>grouper</param-value>
> >     </init-param>
> >     <init-param>
> >       <param-name>dbPwd</param-name>
> >       <param-value>not here</param-value>
> >     </init-param>
> >
> >      <init-param>
> >       <param-name>SubjectID_AttributeType</param-name>
> >       <param-value>subjectId</param-value>
> >     </init-param>
> >     <init-param>
> >       <param-name>Name_AttributeType</param-name>
> >       <param-value>name</param-value>
> >     </init-param>
> >     <init-param>
> >       <param-name>Description_AttributeType</param-name>
> >       <param-value>name</param-value>
> >     </init-param>
> >
> >     <search>
> >       <searchType>searchSubject</searchType>
> >       <param>
> >         <param-name>numParameters</param-name>
> >         <param-value>1</param-value>
> >       </param>
> >       <param>
> >         <param-name>sql</param-name>
> >         <param-value>select * from Subject where
> > (subjectId=?)</param-value>
> >        </param>
> >     </search>
> >     <search>
> >       <searchType>searchSubjectByIdentifier</searchType>
> >       <param>
> >         <param-name>numParameters</param-name>
> >         <param-value>1</param-value>
> >       </param>
> >       <param>
> >         <param-name>sql</param-name>
> >         <param-value>select * from Subject where (name=?)</param-value>
> >       </param>
> >     </search>
> >     <search>
> >       <searchType>search</searchType>
> >         <param>
> >           <param-name>numParameters</param-name>
> >           <param-value>2</param-value>
> >         </param>
> >         <param>
> >           <param-name>sql</param-name>
> > #          <param-value>
> > #            select * from Subject where
> > #                  (subjectId  like '%?%')
> > #              or  (name       like '%?%')
> > #          </param-value>
> >           <param-value>
> >             select
> >             subject.subjectid as id, subject.name as name,
> >             lfnamet.lfname as lfname, loginidt.loginid as loginid,
> >             desct.description as description
> >             from
> >             subject
> >             left join (select subjectid, value as lfname from
> > subjectattribute
> >             where name='name') lfnamet
> >             on subject.subjectid=lfnamet.subjectid
> >             left join (select subjectid, value as loginid from
> > subjectattribute
> >             where name='loginid') loginidt
> >             on subject.subjectid=loginidt.subjectid
> >             left join (select subjectid, value as description from
> > subjectattribute
> >             where name='description') desct
> >             on subject.subjectid=desct.subjectid
> >             where
> >             loginidt.loginid = ?;
> >           </param-value>
> >       </param>
> >     </search>
> >
> >   </source>
> > </sources>
> >
> >
> > On Thu, 8 May 2008, Chris Hyzer wrote:
> >
> > > Actually, maybe the query is ok, but it doesn't have enough columns.
> > If you want to take out your passwords and send me your sources.xml I
> > can confirm.  Or, let me know how it goes.
> > >
> > > Thanks!
> > > Chris
> > >
> > > > -----Original Message-----
> > > > From: Chris Hyzer
> > > > Sent: Wednesday, May 07, 2008 2:26 PM
> > > > To: 'Thomas M Goerger'; Grouper Dev
> > > > Subject: RE: [grouper-users] Errors switching to Oracle backend
> > > >
> > > > 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
> > > > > >
> > >
>