'Create' relations vs 'Servoy' relations

Classic Servoy
1

Hi,

I was trying to ‘get’ the database relations in an Oracle schema and got an error:
“com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: ORA-01424: missing or illegal character following the escape character”

Rather than mess around trying to figure out what is causing that error I’m just planning to go ahead and either:

  1. ‘Create’ the named relationship within Servoy
    or
  2. See if I can use the actual PrimaryKey/ForeignKey relationship that is named within Oracle by using that ‘name’ in Servoy.

My questions are:

  • Does anyone know if there is a real gain by in using the ‘actual’ relationship constraint within the db rather than the Servoy ‘join’.

  • If there is a benefit to using the actual constraint, can I just use the database name for it somehow so that Servoy uses that constraint?

2

I was trying to ‘get’ the database relations in an Oracle schema and got an error:
“com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: ORA-01424: missing or illegal character following the escape character”

can you create a case for this? we should look at this why you can’t ask the oracle server for the relations.

Does anyone know if there is a real gain by in using the ‘actual’ relationship constraint within the db rather than the Servoy ‘join’.

No it is just a quick help to generate servoy relations

If there is a benefit to using the actual constraint, can I just use the database name for it somehow so that Servoy uses that constraint?

no servoy doesn’t use constraints from the database. For example a null check is still done by the database or a foreign key isn’t checked by us but by the database.
It is a good thing that those are defined at your database because that will result that never wrong data can be created.

3

Hi Johan,

Should I do a DDL statement of the whole database schema? Would that be simplest? I tried to generate a STACKTRACE but that doesn’t show anything and the Servoy log just gives that error message. But I can easily send you the schema. In fact that is what I’ll do. I’ve created a case and attached the schema statements. Any Servoy solution attached to that should generate then the error message.