Re: [GUSDEV] WDK error

[<hen...@gm...>]

Hi Thomas,


I have the same file as you do.

 head $GUS_HOME/data/WDKToySite/Model/testTables/WDKTestEst
row_project_id number(10) not null,     est_id number(10) not null,  =20
 na_sequence_id number(10) not null,    clone_id number(10),  =20
library_id number(5) not null,  dbest_id_est number(12),     =20
accession varchar(20),  quality_start number(12) not null,  =20
quality_stop number(12), seq_length number(12)
10      9644241 20103105                9602    2398182 AI579851     =20
 1       0     0
10      9644243 20103107                9602    2398184 AI579853     =20
 1       0     0
10      9644244 20103108                9602    2398185 AI579854     =20
 1       0     0
10      9644248 20103112                9602    2398189 AI579858     =20
 1       0     0
10      9644249 20103113                9602    2398190 AI579859     =20
 1       0     0
10      9644251 20103115                9602    2398192 AI579861     =20
 1       0     0
10      9644261 20103125                9602    2398202 AI579871     =20
 1       0     0
10      9644273 20103137                9602    2398214 AI579883     =20
 1       0     0
10      9644283 20901075                9603    3264539 AW119237    =20
1       0     0

And I got the same error.

[juca1@kineto3 project_home]$ wdkTestDb -model toyModel -drop
Dropping existing table usertest.WDKTestEst
[juca1@kineto3 project_home]$ wdkTestDb -model toyModel -create

Loading table usertest.WDKTestEst 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.QueryExecutorImpl.receiveErrorResponse(Qu=
eryExecutorImpl.java:1471)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExe=
cutorImpl.java:1256)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorIm=
pl.java:175)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc=
2Statement.java:392)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abs=
tractJdbc2Statement.java:330)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(Abstra=
ctJdbc2Statement.java:282)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdat=
e(DelegatingPreparedStatement.java:233)
        at org.gusdb.wdk.model.implementation.SqlUtils.getResultSet(SqlUtil=
s.java:51)
        at org.gusdb.wdk.model.test.TestDBManager.main(TestDBManager.java:1=
17)

Thanks for the attention,

Henrique Cesar Lemos Juc=E1 - 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)