I'm having an error when running any entity (j2ee EJB entity) method. It´s ORA-00972 Identifier is too long. I now that this may caused by a field's name longer than 30 characters, or data tipe incompatibility.
I tried to run an entity over a table with anly an autonumeric PK, entityTable as entity's name and pk the field but the same error again.
Later, I created some new workspaces and added old projects to them. Some of them worked and others didn´t.
Actually a workspace, which was working perfect, throws again this error.
I try my entity beans at other PCs and them worked.
This must be an enviroment (workspace/project) error, but I don't know how must I do entitys.
- A database error isn't possible.
- I handle entity beans (CPM) using session beans.
The error message indicates that an identifier with more than 30 characters was specified.
ORA-00972 Identifier is too Long
There is a limit in the object identifier in Oracle (usually 30 characters). When going over this limit, this error appears. A table created during the execution of the interface went over this limit. and caused this error (see the execution log for more details).
Check in the topology for the oracle technology, that the maximum lengths for the object names (tables and columns) correspond to your Oracle configuration.