I am installing a credential management package for a computer grid. The package is called PURSe and it uses Java, Mysql and portlet classes to work. when I compile it for testing I get this Java-mysql error

------------------ error -------------------------------------------

bootstrap: [java] 2 [main] (DatabaseManager.java:187) ERROR org.globus.purse.registration.databaseAccess.DatabaseManager - Error executing stmt: insert into null (varchar(100) not null,, null) values ('requested','A request has been made.') [java] java.sql.SQLException: Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null (varchar(100) not null,, null) values ('requested','A request has been made' at line 1" [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2234) [java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1412) [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1494) [java] at com.mysql.jdbc.Connection.execSQL(Connection.java:1905) [java] at com.mysql.jdbc.Connection.execSQL(Connection.java:1847) [java] at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1280) [java] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:171) [java] at org.globus.purse.registration.databaseAccess.DatabaseManager.runUpdateQuery(DatabaseManager.java:184) [java] at org.globus.purse.registration.databaseAccess.StatusDataHandler.storeData(StatusDataHandler.java:49) [java] at org.globus.purse.registration.BootstrapDatabase.loadFromFile(BootstrapDatabase.java:133) [java] at org.globus.purse.registration.BootstrapDatabase.initializeStatus(BootstrapDatabase.java:76) [java] at org.globus.purse.registration.BootstrapDatabase.main(BootstrapDatabase.java:57) [java] Exception in thread "main" org.globus.purse.exceptions.DatabaseAccessException: Connection URL: jdbc:mysql://coit-grid03.uncc.edu/purseDatabase userName: purseuser Error updating database. Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null (varchar(100) not null,, null) values ('requested','A request has been made' at line 1" [Root error message: Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null (varchar(100) not null,, null) values ('requested','A request has been made' at line 1"]. Root exception is java.sql.SQLException: Syntax error or access violation message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null (varchar(100) not null,, null) values ('requested','A request has been made' at line 1" [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2234) [java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1412) [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1494) [java] at com.mysql.jdbc.Connection.execSQL(Connection.java:1905) [java] at com.mysql.jdbc.Connection.execSQL(Connection.java:1847) [java] at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1280) [java] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:171) [java] at org.globus.purse.registration.databaseAccess.DatabaseManager.runUpdateQuery(DatabaseManager.java:184) [java] at org.globus.purse.registration.databaseAccess.StatusDataHandler.storeData(StatusDataHandler.java:49) [java] at org.globus.purse.registration.BootstrapDatabase.loadFromFile(BootstrapDatabase.java:133) [java] at org.globus.purse.registration.BootstrapDatabase.initializeStatus(BootstrapDatabase.java:76) [java] at org.globus.purse.registration.BootstrapDatabase.main(BootstrapDatabase.java:57)

BUILD FAILED /home/tomcat/purse/build.xml:111: Java returned: 1

Total time: 2 seconds

------------------------------------------------------------------------

the package is supposed to work "out-of-the-box". What configuration mistake could I have done to get this error?

the mysql server I installed is the red hat rpm 5.0 version using Java 1.5 ant 1.6.5

Any help is appreaciated.