RE: [GUSDEV] WDK installation error

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

We just ran wdkTestDb here against a postgres database without a
problem.

Please check your $GUS_HOME/data/WDKToySite/Model/testTables/WDKTestEst
The first line of that file should specify datatypes for each column,
first of which should say "row_project_id number(10) not null".
The first column of all lines that follow should be numeric (10 to be
specific).

If there is no unexpected problem there, then make sure you start your
WDK installation with clean (no old code)
and dedicated (no code from other projects, especially GUS)
$PROJECT_HOME and $GUS_HOME

-Thomas

> -----Original Message-----
> From: gus...@li...=20
> [mailto:gus...@li...] On Behalf=20
> Of Y. Thomas Gan
> Sent: Wednesday, March 08, 2006 10:29 AM
> To: 'Henrique Juc?; 'Gusdev gusdev-gusdev'
> Subject: RE: [GUSDEV] WDK installation error
>=20
>=20
> Dear Henrigue,
> WDK has been tested and used mostly with oracle databases so=20
> it is possible that you are hitting a postgres specific WDK=20
> bug. We will see if we can reproduce the behavior here and=20
> get back to you. If would be helpful if you could let us know=20
> what version of WDK you are using.=20
>=20
> Have you run wdkCache command yet? If not can you run it to=20
> see if you can successfully create the cache tables needed by WDK?
>=20
> -Thomas
>=20
> -----Original Message-----
> From: gus...@li...
> [mailto:gus...@li...] On Behalf=20
> Of Henrique Juc
> Sent: Tuesday, March 07, 2006 1:38 PM
> To: Gusdev gusdev-gusdev
> Subject: [GUSDEV] WDK installation error
>=20
>=20
> Hi everyone,
>=20
> I'm trying to install WDK to use along with GUS, however I'm=20
> getting the following error. I'm using the files provided=20
> with the WDK package. The error is the following:
>=20
> [juca1@kineto3 config]$ wdkTestDb -model toyModel -create
> Table usertest.WDKTestEst already exists; no change made.  To=20
> reload this table, first drop it and then create it again=20
> Loading table usertest.WDKTestTaxonName to database from file
>=20
> ERROR: column "row_project_id" is of type numeric but=20
> expression is of type character varying
> java.sql.SQLException: ERROR: column "row_project_id" is of=20
> type numeric but expression is of type character varying
>         at org.postgresql.core.v3.QueryExe=20
> cutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
>         at=20
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryE
> xecutorImp
> l.java:1256)
>         at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutor
> Impl.java:
> 175)
>         at=20
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJd
> bc2Stateme
> nt.java:392)
>         at=20
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(A
> bstractJdb
> c2Statement.java:330)
>         at=20
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(Abst
> ractJdbc2S
> tatement.java:282)
>         at=20
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpd
> ate(Delega
> tingPreparedStatement.java:233)
>         at=20
> org.gusdb.wdk.model.implementation.SqlUtils.getResultSet(SqlUt
> ils.java:5
> 1)
>         at
> org.gusdb.wdk.model.test.TestDBManager.main(TestDBManager.java:117)
>=20
> The first part I understand as the tables were already there,=20
> but that seems not to be part of the problem, as I dropped=20
> the tables, but the problem persisted. What should I do? Any=20
> suggestions?
>=20
> Thanks in advance,
>=20
>=20
> Henrique Cesar Lemos Juc=E1=20
> Bi=F3logo/Tecnologista - FAPERJ
>=20
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



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting
language that extends applications into web and mobile media. Attend the
live webcast and join the prime developer group breaking into this new
coding territory!
http://sel.as-us.falkag.net/sel?cmd_____________________________________
__________
Gusdev-gusdev mailing list
Gus...@li...
https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev