Couldn't retrieve form data/Can't work w/o primaryKey (ORCL)

Classic Servoy
1

Mac OS X 10.3 (7B85)
Servoy R2 (1.0)
Oracle9i Enterprise Edition Release 9.2.0.3.0
classes12.jar (Oracle Mac OS X JDBC Driver)

With the above software setup, I can sucessfully connect to an Oracle database and read its schema into Servoy.

However, I encounter a problem when I build a Servoy form displaying columns from a table (e.g., ‘PERSONAL_DATA’) in the Oracle database. When I open the form, I get the error: Could not retrieve form data. Details>> Cannot work without primaryKey on table ‘PERSONAL_DATA’.

While I’ve used the ‘PERSONAL_DATA’ table to explain the problem I’m having, I get the same error message with other tables from the Oracle database. The tables I’ve attached to the forms are simple and have one column designated as a ‘Primary Key’.

In ‘Define Dataproviders’, I can’t check ‘Primary Key’ on the field that is, in fact, the primary key. (Actually, I can’t designate any of the fields as primary keys.)

I’d appreciate any feedback that will enable me view the Oracle data in Servoy.

Thanks.

Brad Conley

2

Don’t know for sure but the message is, as you figured out, a message that you need a primary key. Not so strange.

I too have noticed that you can only change the properties of a field and nothing else like type, length, primary key, allow null. Not so strange but on the other hand maybe we should ask for this.

What you can do, probably is add a field and make that one the primary key…

3

Are you sure you have primary keys on that table? I have a similar setup here and it works perfect. Make sure you have real primary key constraints defined in your backend tables.

4

Thank you for the replies to my original post.

I thought I included a primary key, but I don’t know for certain whether I have the primary key for the table. I will try to find out whether there is a primary key, and if so, what it is.

I have only limited access to the back-end database, so I can’t add a primary key (or any other column) to the table. Is a primary key in a back-end database required by Servoy?

Brad Conley

5

Yes, in the current version of Servoy you can only use primary keys defined in the backend database. In future version we will support Servoy side definition of primary keys.