grouper-dev - RE: [grouper-users] Errors switching to Oracle backend

Subject: Grouper Developers Forum

List archive

RE: [grouper-users] Errors switching to Oracle backend

From: Chris Hyzer <>
To: Thomas M Goerger <>
Cc: "" <>
Subject: RE: [grouper-users] Errors switching to Oracle backend
Date: Thu, 8 May 2008 16:05:16 -0400
Accept-language: en-US
Acceptlanguage: en-US

If you changed the numParameters back to 1 to match the number of question
marks, and it didn't take, then maybe it is a build problem. Are you
changing it in the servlet container directory, or the source directory?
Change the password in the file and you should see a different error (just to
make sure the builds are working).

The invalid char is the semicolon at the end of the query I think. Sorry,
forgot to mention that. You shouldn't have a semicolon in the sources.xml
file. If you are using the default table structures that grouper created
(with the subject and subjectattribute tables), then this sources.xml is
valid (change the user/pass/db url/driver at the top section of the jdbc
part) (this is the one with the quickstart)

http://viewvc.internet2.edu/viewvc.py/grouper-qs-builder/sources.xml?root=I2MI&view=markup

The top part is the jdbc part... you can merge that with what you have now.
If it doesn't work, let me know.

Thanks,
Chris
> -----Original Message-----
> From: Thomas M Goerger
> [mailto:]
> Sent: Thursday, May 08, 2008 4:01 PM
> To: Chris Hyzer
> Cc:
>
> Subject: RE: [grouper-users] Errors switching to Oracle backend
>
> 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"?>
> > >
> > > 
> > >
> > > <sources>
> > >
> > > 
> > > 
> > > <source
> > >
> adapterClass="edu.internet2.middleware.grouper.GrouperSourceAdapter">
> > > <id>g:gsa</id>
> > > <name>Grouper: Group Source Adapter</name>
> > > <type>group</type>
> > > </source>
> > > 
> > >
> > >
> > > <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>
> > >
> > > 
> > > <search>
> > > <searchType>searchSubject</searchType>
> > > <param>
> > > <param-name>filter</param-name>
> > > <param-value>
> > > (&(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>
> > >
> > > 
> > > <search>
> > > <searchType>searchSubjectByIdentifier</searchType>
> > > <param>
> > > <param-name>filter</param-name>
> > > <param-value>
> > > (&(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>
> > >
> > > 
> > > <search>
> > > <searchType>search</searchType>
> > > <param>
> > > <param-name>filter</param-name>
> > > <param-value>
> > > (cn=%TERM%)
> > > 
> > > </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
> > > > > > >
> > > >
> >

RE: [grouper-users] Errors switching to Oracle backend, Chris Hyzer, 05/07/2008
- <Possible follow-up(s)>
- RE: [grouper-users] Errors switching to Oracle backend, Chris Hyzer, 05/08/2008
  - RE: [grouper-users] Errors switching to Oracle backend, Thomas M Goerger, 05/08/2008
    - RE: [grouper-users] Errors switching to Oracle backend, Chris Hyzer, 05/08/2008

List archive

RE: [grouper-users] Errors switching to Oracle backend