Menu
▾
▴
gusdev-gusdev
|
From: <hen...@gm...> - 2005-10-27 17:17:25
|
Hi.
Thanks for the attention again =3D)
I got this error while trying to create a toyModel (I guess this is
the last version):
$ 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)
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)
|
|
From: Y. T. G. <yon...@pc...> - 2005-10-28 03:12:04
|
Which version of WDK did you use? I strongly recommend installing stable versions of WDK from download site= =20 (or tagged/branched versions, not trunk, from svn)=20 WDK 1.6 and 1.7 has been tested against postgres (which looks like is what= =20 you are trying to use), with the command you are running executed=20 successfully. The same tests was not repeated in WDK 1.8 but there were no= =20 code changes relevant to postgres. -Thomas On Thu, 27 Oct 2005, [ISO-8859-1] Henrique Juc=E1 wrote: > Hi. > > Thanks for the attention again =3D) > > I got this error while trying to create a toyModel (I guess this is > the last version): > > $ 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(Q= ueryExecutorImpl.java:1471) > at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryEx= ecutorImpl.java:1256) > at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorI= mpl.java:175) > at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdb= c2Statement.java:392) > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Ab= stractJdbc2Statement.java:330) > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(Abstr= actJdbc2Statement.java:282) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpda= te(DelegatingPreparedStatement.java:233) > at org.gusdb.wdk.model.implementation.SqlUtils.getResultSet(SqlUti= ls.java:51) > at org.gusdb.wdk.model.test.TestDBManager.main(TestDBManager.java:= 117) > > > > > Henrique Cesar Lemos Juc=E1 - http://www.bioinformatica.ufsc.br > > "As soon as you concern yourself with the "good" and "bad" of your fellow= s, > 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) > > > ------------------------------------------------------- > This SF.Net email is sponsored by the JBoss Inc. > Get Certified Today * Register for a JBoss Training Course > Free Certification Exam for All Training Attendees Through End of 2005 > Visit http://www.jboss.com/services/certification for more information > _______________________________________________ > Gusdev-gusdev mailing list > Gus...@li... > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > |
|
From: <hen...@gm...> - 2005-11-03 19:37:14
|
Thanks fo the help.
I did as you instructed, and downloaded WDK-stable from the homepage.
Everything went well till the same step.
$ 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(AbstractJdbc2S=
tatement.java:282)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate=
(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)
Did I forget anything?
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)
|
|
From: Y. T. G. <yg...@pc...> - 2005-11-03 20:33:42
|
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 |
|
From: <hen...@gm...> - 2005-11-08 11:44:39
|
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)
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X