Using Database-backed dictionary with DB2

Help
JGUni
2007-04-04
2013-04-29
  • JGUni
    JGUni
    2007-04-04

    Hi,

    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?