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: Tom Barton <>
  • To: Sanjay Vivek <>
  • Cc:
  • Subject: Re: [grouper-users] java.sql.SQLException when running Export/Import tool.
  • Date: Mon, 13 Aug 2007 09:04:53 -0500

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




Archive powered by MHonArc 2.6.16.

Top of Page