Import solutuion with 1.000.000 records

Classic Servoy
1

Hi to All,
could Someone tell me if it its possible to import a solution as in subiect, courteusly.
I went in servoy properties and i made:

servoy.maxSampleDataTableRowCount=1000000

However when I try to import the solution wiht records it is not possible to me.

Does it exist some way?

Tanks in advance.
Gianni Pinna.

2

To save time you should import data directly into your backend database.
This may be 100 times faster than importing via Servoy.

3

Hi Christian,
tank You very much for Your essential and promt replay.
But I have a problem, if I work with the DB mamed DB1, my solution works fine.
If I make a copy of the same DB1 wich I call DB2, my same solution does not work fine but returns me errors of “calculation”, related to calculated fiels

It is a problem of many days for me.

Best RGRDS, Christian
Gianni Pinna.

4

Ciao Gianni,

Are you renaming the database itself (like renaming a PostgreSQL database using pgAdmin or some other tool)

or

renaming the database connection used by Servoy?

5

Hi Christian,

tank You for Your lovable “Italian ciao” and for Your promt replay.

I am going to answer You.

Both.
In the same computer_server I:

  1. ----Had my solution named SOLUTION1, in a database named user_data, working with DBSERVER named user_data; Database Server URL: jdbc:postgresql://localhost:5432/SGMOP.

  2. —Made:
    — trought PGADMIN, a copy (model) of database user_data which I named USER_DATA_2;
    — a new DBSERVER that I named user_data_2;
    —Database Server URL: jdbc:postgresql://localhost:5432/USER_DATA_2

  3. Imported SOLUTION1 with DBSERVER user_data_2 in the databese USER_DATA_2.

Then I had the above error message.

Tanks in advance for Your thougt around this matter.

Gianni Pinna.

6

OBSERVATION:

SOLUTION1 was made in a computer which uses Postgres 9.
The computer-server uses Postgres 8 .1.
JDBC DRIVERS are different.
Could this cause the problem?

Tanks again.
Gianni Pinna.

7

Gianni,

What do you mean when you say ‘Imported SOLUTION1 with DBSERVER user_data_2 in the databese USER_DATA_2.’?
When you import a solution and the solution refers to user_data server, it will not use server user_data_2 automatically.

What was the exact error message you had?

Rob

8

Hi Rob,
Tank You for Your replay, excuse me for my non prompt, only now I have seen,Your answer. The reason is that we have decided to expand Servoy licence. In order tho this purpose, we are working from many days to put all solutions in only one databese, and in importing and exporting to and from the server the developed solutions. But we have many difficulties.

You, Robe, wrote:

What do you mean when you say ‘Imported SOLUTION1 with DBSERVER user_data_2 in the databese USER_DATA_2.’?
When you import a solution and the solution refers to user_data server, it will not use server user_data_2 automatically.

I RESPOND. There is no contradction between the two assertions. The reason is, as You know, that in order to use the same solution, althoug in a different release, with two different servers, it is not possible, as You write, make an AUTOMATIC import. In fact it is necessary to diasble MANUALLY the first server and, during the import, select the second.

As for Your error message request now I do not find error message, but I remeber it was related to calculated fields.

Tank You very much for Your answer, I hope to resolve, and buy new licences for new users.
Best Rgrds
Gianni Pinna.