Grouper Users - Open Discussion List

["Sanjay Vivek" <>]

Hi everyone,

I'm getting the following error when I run XmlExporter as an ant task in
grouper/build.xml:

java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(DriverManager.java:545)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(
DriverManagerConnectionFactory.java:48)
        at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableCon
nectionFactory.java:290)
        at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjec
tPool.java:840)
        at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSourc
e.java:95)
        at
edu.internet2.middleware.subject.provider.JDBCSourceAdapter.uniqueSearch
(Unknown Source)
        at
edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSubjectBy
Identifier(Unknown Source)
        at
edu.internet2.middleware.grouper.SubjectFinder._findByIdentifier(Subject
Finder.java:521)
        at
edu.internet2.middleware.grouper.SubjectFinder.findByIdentifier(SubjectF
inder.java:243)
        at
edu.internet2.middleware.grouper.XmlExporter.main(XmlExporter.java:218)
2007-08-10 14:06:02,585: SQLException occurred: No suitable driver
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(DriverManager.java:545)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(
DriverManagerConnectionFactory.java:48)
        at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableCon
nectionFactory.java:290)
        at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjec
tPool.java:840)
        at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSourc
e.java:95)
        at
edu.internet2.middleware.subject.provider.JDBCSourceAdapter.uniqueSearch
(Unknown Source)
        at
edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSubjectBy
Identifier(Unknown Source)
        at
edu.internet2.middleware.grouper.SubjectFinder._findByIdentifier(Subject
Finder.java:521)
        at
edu.internet2.middleware.grouper.SubjectFinder.findByIdentifier(SubjectF
inder.java:243)
        at
edu.internet2.middleware.grouper.XmlExporter.main(XmlExporter.java:218)


I'm guessing this is because Grouper implicitly only supports Oracle and
Postgres. We are using mysql as we're more familiar with mysql. How do I
go about configuring Grouper to support mysql? Any sort of help would be
appreciated.

Regards
--------------
Sanjay Vivek
Web Team
ISS
University of Newcastle Upon Tyne