RE: [GUSDEV] WDK error

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

Hi Henrique,
1) Try wdkTestDb -model toyModel -drop before create
2) look your data file.=20
Below is what I have:
head $GUS_HOME/data/WDKToySite/Model/testTables/WDKTestEst
row_project_id number(10) not null,     est_id number(10) not null,
na_sequence_id number(10) not null,     clone_id number(10),library_id
number(5) not null,  dbest_id_est number(12),        accession
varchar(20),  quality_start number(12) not null,      quality_stop
number(12),    seq_length number(12)
10      9644241 20103105                9602    2398182 AI579851
1       0       0
10      9644243 20103107                9602    2398184 AI579853
1       0       0
10      9644244 20103108                9602    2398185 AI579854
1       0       0
10      9644248 20103112                9602    2398189 AI579858
1       0       0
10      9644249 20103113                9602    2398190 AI579859
1       0       0
10      9644251 20103115                9602    2398192 AI579861
1       0       0
10      9644261 20103125                9602    2398202 AI579871
1       0       0
10      9644273 20103137                9602    2398214 AI579883
1       0       0
10      9644283 20901075                9603    3264539 AW119237
1       0       0

-Thomas

> -----Original Message-----
> From: gus...@li...=20
> [mailto:gus...@li...] On Behalf=20
> Of Henrique Juc
> Sent: Thursday, November 03, 2005 2:31 PM
> To: Gusdev gusdev-gusdev
> Cc: Y. Thomas Gan
> Subject: Re: [GUSDEV] WDK error
>=20
>=20
> Thanks fo the help.
>=20
> I did as you instructed, and downloaded WDK-stable from the=20
> homepage. Everything went well till the same step.
>=20
>=20
>  $ wdkTestDb -model toyModel -create
>=20
> Loading table usertest.WDKTestEst 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=20
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
> QueryExecutorImpl.java:1471)
>         at=20
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryE
> xecutorImpl.java:1256)
>         at=20
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutor
> Impl.java:175)
>         at=20
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJd
> bc2Statement.java:392)
>         at=20
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(A
> bstractJdbc2Statement.java:330)
> at=20
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(Abst
> ractJdbc2Statement.java:282)
>        at=20
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpd
> ate(DelegatingPreparedStatement.java:233)
>         at=20
> org.gusdb.wdk.model.implementation.SqlUtils.getResultSet(SqlUt
> ils.java:51)
>         at=20
> org.gusdb.wdk.model.test.TestDBManager.main(TestDBManager.java:117)
>=20
> Did I forget anything?
>=20
>=20
>  Henrique Cesar Lemos Juc=E1 - http://www.bioinformatica.ufsc.br
>=20
> "As soon as you concern yourself with the "good" and "bad" of=20
> your fellows, you create an opening in your heart for=20
> maliciousness to enter. Testing, competing with, and=20
> criticizing others weaken and defeat you."
>=20
> Morihei Ueshiba, O-Sensei (1883-1969)
>=20
>=20
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App=20
> Server. Download it for free - -and be entered to win a 42"=20
> plasma tv or your very own Sony(tm)PSP.  Click here to play:=20
> http://sourceforge.net/geronimo.php
>=20
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>=20