Grouper Users - Open Discussion List

["Sanjay Vivek" <>]

That worked like a charm. Thanks for the tip :)

Cheers.
Sanjay 

>-----Original Message-----
>From: Tom Barton 
>[mailto:]
> 
>Sent: 13 August 2007 15:05
>To: Sanjay Vivek
>Cc: 
>
>Subject: Re: [grouper-users] java.sql.SQLException when 
>running Export/Import tool.
>
>Hopefully this is just a matter of including quotes around the 
>value of 'cmd', as in
>
># ant xml-export -Dcmd="GrouperSystem export.xml export.properties"
>
>Tom
>
>Sanjay Vivek wrote:
>> 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
>>>>>
>