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?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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?