Grouper Users - Open Discussion List

["Sanjay Vivek" <>]

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 export.properties" as
shown below:

[root@pod
 api]# ant xml-export -Dcmd=GrouperSystem export.xml
export.properties
Buildfile: build.xml

xml-export:

ensure.cmd:

xml.export:
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
support
 referencing ids defined in non-executed targets.

BUILD FAILED
/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
project.classpath?

Cheers
Sanjay

>-----Original Message-----
>From: Tom Barton 
>[mailto:]
> 
>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 grouper.hibernate.properties 
>> files as shown below:
>> 
>> hibernate.dialect                     =
>> net.sf.hibernate.dialect.MySQLDialect
>> hibernate.connection.driver_class     = com.mysql.jdbc.Driver
>> hibernate.connection.url              =
>> jdbc:mysql://pod.ncl.ac.uk/registrygrouper
>> 
>> 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(DriverManager.java:545)
>>>>    at java.sql.DriverManager.getConnection(DriverManager.java:171)
>>> Have you set hibernate.connection.driver_class and 
>>> hibernate.connection.url in grouper.hibernate.properties to 
>correctly 
>>> reference your mysql jdbc driver?
>>>
>>> Tom
>>>
>