JGUni - 2007-04-04


I was trying to use JWNL with DB2 as database backend. When I try to use the DictionaryToDatabase util, I get a strange DB2 error, complaining about invalid tokens. Of course I checked create.sql and modified to use DB2 types. When I issue the statements directly via the DB2 command line, the work okay.

This is the command line I used
C:\javalibs\Wordnet>java -cp jwnl.jar;utilities.jar;commons-logging.jar;db2jcc.jar;db2jcc_license_cu.jar net.didion.jwnl.utilities.DictionaryToDatabase JWNLProperties.xml create_db2.sql com.ibm.db2.jcc.DB2Driver jdbc:db2:Wordnet db2user <mypassword>

This is the DB2 error
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: ;;r(255), pos char(1));END-OF-STATEMENT

I wanted to check the code of the utility to see if there was some problem, but I could not find the code in the -src.zip and in the CVS.

Has anyone successfully used DB2 as backend? Can the code for the DictionaryToDatabase utility be made available?