Postgres Importing Solution Problems, Sysbase No Problem

Classic Servoy
1

Hi to all,
I am trying to import a solution from Sysbase, where it wos working fine, to Postgres 9.
But while importing i see this error message:

com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: Column ‘quantità’ in table ‘righefatture’ for connection ‘trinitasbeatissima’ does not exist and could not be created.

I think that if the colum name should have been “quantita” instead of “quantità” the problem should not be introduced. But, I repeat , with Sysbase no problem

Is there a solution to the problem, without renaiming the colum name?

Tanks in advance

Gianni Pinna.

2

Hi Gianni,

The column name quantità can be created in PostgreSQL. But you always have to reference it then (in SQL only) with double quotes or else it won’t work.
So my guess is that Servoy tries to create the column but doesn’t use double quotes and therefor it errors on it.
Try to create the column yourself using PgAdmin, restart Servoy and import the solution, see if that works.

Hope this helps.

3

Hi Robert,
now I am going to try in accord to Your precious suggestions.

Tank You very much Robert, Persons as You are, are able to make less difficult the way in order to use of two excellent instruments as Servoy and Postgresql.

Gianni Pinna.

4

Hi Robert,
i inserted this command on psql

ALTER TABLE clienti ADD COLUMN "località text ;"

and the result was

ERROR: invalid byte sequence for encoding "UTF8" : 0x85

Gianni Pinna

5

Hi Gianni,

You could use PgAdmin where you simply fill in a field and PgAdmin creates the SQL for you.
The proper syntax is:

ALTER TABLE clienti ADD COLUMN "località" text ;

So only the column name is in double quotes.

Hope this helps.

6

Hi Robert,

Tank You very much.

All right simply filling in a field of Pgadmin in accord to Your patient suggestion.
For the verity i writed on pgsql the exact command as You writed:

ALTER TABLE clienti ADD COLUMN "località" text ;

altought I writed You with mistake. Excuse me.

But, Robert, this problem solved tanks to You, the end of importing solutions from Sysbase to Postgres, is not still achieved.
I see another error message about a table, the fields of wich, i used in Servoy in order to images.

The error is:

The server version of the column 'san_domenico' of table 'immagini_testata' in server 'tedeumpermariamop' 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 'tedeumpermariamop' 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 'tedeumpermariamop' 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 'tedeumpermariamop' has length -1 while in the import version the column has length 2147483647.

Is there a solution to this?

Tanks in advance

Gianni Pinna.