Postgres Error While Importing SysBase Image Data

Classic Servoy
1

Hi to All,
while importing Sysbase Image data table in Postgres the following error message appears:

The server version of the column ‘clientiid’ of table ‘clienti’ in server ‘trinitasbeatissima’ has a unique constraint while in the import version it has a primary key constraint.
The server version of the column ‘clientiid’ of table ‘clienti’ in server ‘trinitasbeatissima’ allows NULL values while the import version does not.
The server version of the column ‘immagine’ of table ‘articoli’ in server ‘trinitasbeatissima’ has length -1 while in the import version the column has length 2147483647.
The server version of the column ‘descr_lunga’ of table ‘articoli’ in server ‘trinitasbeatissima’ has length -1 while in the import version the column has length 2147483647.
The server version of the column ‘immagine2’ of table ‘articoli’ in server ‘trinitasbeatissima’ has length -1 while in the import version the column has length 2147483647.
The server version of the column ‘note’ of table ‘fatture’ in server ‘trinitasbeatissima’ has length -1 while in the import version the column has length 2147483647.
The server version of the column ‘righefattureid’ of table ‘righefatture’ in server ‘trinitasbeatissima’ has a unique constraint while in the import version it has a primary key constraint.
The server version of the column ‘righefattureid’ of table ‘righefatture’ in server ‘trinitasbeatissima’ allows NULL values while the import version does not.
The server version of the column ‘san_tommaso’ of table ‘immagini_testata’ in server ‘trinitasbeatissima’ has length -1 while in the import version the column has length 2147483647.
The server version of the column ‘ss_giovanni_paolo_ii’ of table ‘immagini_testata’ in server ‘trinitasbeatissima’ has length -1 while in the import version the column has length 2147483647.
The server version of the column ‘immagine’ of table ‘immagini_testata’ in server ‘trinitasbeatissima’ has length -1 while in the import version the column has length 2147483647.
The server version of the column ‘san_domenico’ of table ‘immagini_testata’ in server ‘trinitasbeatissima’ has length -1 while in the import version the column has length 2147483647.
The server version of the column ‘san_giuseppe’ of table ‘immagini_testata’ in server ‘trinitasbeatissima’ has length -1 while in the import version the column has length 2147483647.
The server version of the column ‘madonna_ordine_domenicano’ of table ‘immagini_testata’ in server ‘trinitasbeatissima’ has length -1 while in the import version the column has length 2147483647.

But if i import the the solution with the same table not using postgresql, but Sysbase, no error code appears.

Does it exist a solution to the problem?

Tanks in advance.
Gianni Pinna

2

Hi Gianni,

Those are warnings, not errors.
Sybase has a fixed length for these columns, in PostgreSQL you don’t set the length of BLOB’s (and TEXT columns) hence the -1. You can safely ignore these warnings.

Hope this helps.

3

Hi Robert,
tank You, very very much for Your continous responses.
Warning messages ok, excuse me for the mistake.

But the problem is that, if i import a solution wich contains images using Sysbase , i see the images contained in the solution.

If i import th same solution using Postgresl, I do not see the images and THIS IS THE REAL PROBLEM,.

Hope that Your science will find a remedy.

Tanks in advance.

Gianni Pinna.

4

Hi Gianni,

Are you using PostgreSQL 9.0.x perhaps ? If so you need to use the latest JDBC driver and replace the one in your Drivers directory. This will fix the problem of the images not showing.
The JDBC3 driver should suffice.

Hope this helps.

5

Hi Robert,
Excellent! You have science and humility. Where is humility there is glory.

Tank You very much, Robert.

Hope well for Your most remote mean.

Gianni Pinna.