From: <hen...@gm...> - 2006-03-07 18:38:25
|
Hi everyone, I'm trying to install WDK to use along with GUS, however I'm getting the following error. I'm using the files provided with the WDK package. The error is the following: [juca1@kineto3 config]$ wdkTestDb -model toyModel -create Table usertest.WDKTestEst already exists; no change made. To reload this table, first drop it and then create it again Loading table usertest.WDKTestTaxonName to database from file ERROR: column "row_project_id" is of type numeric but expression is of type character varying java.sql.SQLException: ERROR: column "row_project_id" is of type numeric bu= t expression is of type character varying at org.postgresql.core.v3.QueryExe cutorImpl.receiveErrorResponse( QueryExecutorImpl.java:1471) at org.postgresql.core.v3.QueryExecutorImpl.processResults( QueryExecutorImpl.java:1256) at org.postgresql.core.v3.QueryExecutorImpl.execute( QueryExecutorImpl.java:175) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute( AbstractJdbc2Statement.java:392) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags( AbstractJdbc2Statement.java:330) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate( AbstractJdbc2Statement.java:282) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdat= e (DelegatingPreparedStatement.java:233) at org.gusdb.wdk.model.implementation.SqlUtils.getResultSet( SqlUtils.java:51) at org.gusdb.wdk.model.test.TestDBManager.main(TestDBManager.java :117) The first part I understand as the tables were already there, but that seem= s not to be part of the problem, as I dropped the tables, but the problem persisted. What should I do? Any suggestions? Thanks in advance, Henrique Cesar Lemos Juc=E1 Bi=F3logo/Tecnologista - FAPERJ http://www.biowebdb.org http://www.bioinformatica.ufsc.br "As soon as you concern yourself with the "good" and "bad" of your fellows, you create an opening in your heart for maliciousness to enter. Testing, competing with, and criticizing others weaken and defeat you." Morihei Ueshiba, O-Sensei (1883-1969) |