Hi
I’m migrating from Servoy 4.1.4 to Servoy 5.2.7
I have about 3000 warning + errors
But there are many error about database inconsistency.
I use PostgreSQL 9.0.
All the number columns have length 17,17 but in pgAdmin the length there isn’t. The column is double precision.
Why servoy read the length 17,17? ( in servoy 4 the length was 8 correctly ).
The same issue with media column ( in postgre are bytea type ).
An example of number column error is:
‘locale_bridgedata->clr_fatture_storico->importo_lordo_euro’ column difference. (NUMBER(id:8), length: 17, allowNull: true) in DB ↔ (NUMBER(id:8), length: 8, allowNull: true) in DB information file. The DB information on this column differs from the actual column in the DB.
If I create a number column from servoy 5 the column is created correctly in postgre. But if I exit and restart servoy, the column have length 17,17.
I tried to force the length column to 8 in servoy but is the same.
If I create a number column from pgAdmin, in servoy I see the column with length 17,17.
In attachment you can see how columns appears in servoy!!
[attachment=0]table column issue.JPG[/attachment]
I tried to set the last jdbc driver downloaded from http://jdbc.postgresql.org/download.html ( jdbc 4 ) but nothing.
I hope someone can help me!
Thanks in advance.
Bye
Roberto
