Create a person - Why not the ID attribute appears (primary key)

Hi,

the model you created seems to be correct. Usually, you don't need to couple the "id" parameter, because it is automatically generated when the instance (in your case a Person) is created and saved into the database.

You should check the generation type of the ID parameter: in the Domain Model, select the id Attribute of the "Personas" Entity -> Properties panel -> Mapping tab -> "ID Generator" property. The default value is "Increment (select max + 1)". In this case, the "id" is incremented and assigned to the new instance.

You should check if the data of the new person appear in the database, inside the "Personas" table. In this case, the creation ends with success but the new data are not displayed in the page.

You should also check if both the "Person" Details component and the "Person List" component display some attributes. The "Display Attributes" property has to be set in order to see the data in the page.

You could also try to run the "Find Model Problems" command and check the possible warning / errors of the model.

Hi,

in your case the ID Generator is set to the "Identity (auto increment)". The id attribute is mapped with a key column of a table (e.g. Personas) in the MySQL database. You should check that the id column of the MySQL table (e.g. Personas) has the "Auto Increment" property set. For example:

or

ALTER TABLE `<database name>`.`<table name>` CHANGE COLUMN `id` `id` <column type> NOT NULL AUTO_INCREMENT;

where in this example <column type> is INT(11).

In this way, the id should be automatically generated when the new instance (e.g. a new person) is created and saved in the database.

Hi Michela, thanks for your reply.

Sure, I understand the autoincrement but only wanted to comment that if the autoincrement could be the reason why you do not add a new person.

When I say that I can not add a new person, it's because when I save (button-link), it deletes the tag values ​​and do not add anything in MySQL database. To verify the operation, I access MySQL through the console and I see my list of persons for my web application, in neither case appears the person added.

It is important to note that operations Update, Delete and Read, works well.

Then, I check the RTXError.log and an exception occurs:

04 Oct 2013 06:02:47,417  ERROR [http-8080-3]  (com.webratio.units.operation.rtx.db.CreateUnitService_$$_javassist_53:72) - [5B3DC45A89A43DAABDC22A7960286AD4][cru2]Could not execute service
org.hibernate.exception.GenericJDBCException: could not insert: [com.webratio.webapp.Personas]
    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
...
Caused by: java.sql.SQLException: Field 'observaciones' doesn't have a default value
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
...

The structure of Person table is:

Finally, that the MySQL database is the another group working and I'm in another software project, then, I want to use that database and, therefore, should not modify this database structure.

Thank you,

Jose

Hi Laura and Michela.

I solved this problem.

In the Person table, had 6 field that require a default value. Then, I add in the Form Component of WebRatio (used wizard) and solved the problem.

Thanks again,

Jose