RE: [GUSDEV] WDK installation error

[Y. T. G. <yg...@pc...>]

Dear Henrigue,
WDK has been tested and used mostly with oracle databases so it is
possible that you are hitting a postgres specific WDK bug.
We will see if we can reproduce the behavior here and get back to you.
If would be helpful if you could let us know what version of WDK you are
using.=20

Have you run wdkCache command yet? If not can you run it to see if you
can successfully create the cache tables needed by WDK?

-Thomas

-----Original Message-----
From: gus...@li...
[mailto:gus...@li...] On Behalf Of Henrique
Juc
Sent: Tuesday, March 07, 2006 1:38 PM
To: Gusdev gusdev-gusdev
Subject: [GUSDEV] WDK installation error


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
but expression is of type character varying
        at org.postgresql.core.v3.QueryExe=20
cutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1256)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
175)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:392)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:330)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2S
tatement.java:282)
        at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delega
tingPreparedStatement.java:233)
        at
org.gusdb.wdk.model.implementation.SqlUtils.getResultSet(SqlUtils.java:5
1)
        at
org.gusdb.wdk.model.test.TestDBManager.main(TestDBManager.java:117)

The first part I understand as the tables were already there, but that
seems 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=20
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,=20
you create an opening in your heart for maliciousness to enter. Testing,

competing with, and criticizing others weaken and defeat you."=20

Morihei Ueshiba, O-Sensei (1883-1969)=20