Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] java.sql.SQLException when running Export/Import tool.

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] java.sql.SQLException when running Export/Import tool.

Chronological Thread 
  • From: "Sanjay Vivek" <>
  • To: "Tom Barton" <>
  • Cc: <>
  • Subject: RE: [grouper-users] java.sql.SQLException when running Export/Import tool.
  • Date: Mon, 13 Aug 2007 14:43:11 +0100

Hi there,

I solved the "java.sql.SQLException: No suitable driver" by configuring
the sources.xml file. It appears that I missed a line although it never
gave me an exception before. However, I'm getting a new error when I run
"ant xml-export -Dcmd=GrouperSystem export.xml" as
shown below:

api]# ant xml-export -Dcmd=GrouperSystem export.xml
Buildfile: build.xml



Warning: Reference project.classpath has not been set at runtime, but
was found during
build file parsing, attempting to resolve. Future versions of Ant may
referencing ids defined in non-executed targets.

/usr/local/sanjay/grouper-api-1.2.0/build.xml:729: The following error
occurred while executing this line:
/usr/local/sanjay/grouper-api-1.2.0/build.xml:704: Java returned: 1

And in grouper_event.log, I get the following msg:

2007-08-13 13:34:38,081: unable to export to xml: null

I'm running everything under root so permissions shouldn't be the
problem. Do I have to explictly reference anything in the


>-----Original Message-----
>From: Tom Barton
>Sent: 13 August 2007 13:54
>To: Sanjay Vivek
>Subject: Re: [grouper-users] java.sql.SQLException when
>running Export/Import tool.
>There are no additional files necessary to configure, nor have
>I seen this error before. Permissions or classpath problem??
>Sanjay Vivek wrote:
>> Hi Tom,
>> We have a working Grouper system in place and everything
>else appears
>> to work perfectly. I've configured the
>> files as shown below:
>> hibernate.dialect =
>> net.sf.hibernate.dialect.MySQLDialect
>> hibernate.connection.driver_class = com.mysql.jdbc.Driver
>> hibernate.connection.url =
>> jdbc:mysql://
>> For some reason, XmlExporter is unable to reference
>> mysql-connector-java-5.0.6-bin.jar in our Grouper_Install/lib. Are
>> there any other config files I should edit?
>> Regards
>> Sanjay
>>> -----Original Message-----
>>> From: Tom Barton
>>> [mailto:]
>>> Sent: 10 August 2007 19:32
>>> To: Sanjay Vivek
>>> Cc:
>>> Subject: Re: [grouper-users] java.sql.SQLException when running
>>> Export/Import tool.
>>> Sanjay Vivek wrote:
>>>> 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(
>>>> at java.sql.DriverManager.getConnection(
>>> Have you set hibernate.connection.driver_class and
>>> hibernate.connection.url in to
>>> reference your mysql jdbc driver?
>>> Tom

Archive powered by MHonArc 2.6.16.

Top of Page