Don't see tables in solution, but created them

Classic Servoy
1

Hello All

I have with your help successfully created a sybase db :-) As I have the model designed in EOModeler (Enterprise Object Modeler Tool in WebObjects), I connected the EOModeler (via JDBC) to my newly created database successfully. The I created two tables out of EOModeler also successfully, i. e. I can see them from within EOModeler (all the other tables as well), see attachment (one of the tables is IMPORT_POSITIONS).

Now the problem: When I open the solution in Developer and want to create a new form, in the New Form dialog window I don’t see the existing tables, radio button Using existing table: selected. And yes, I made a named connection to my database in Application Preferences which points to my database. It also shows up in the New Form dialog window in the popup Using Server.

What do I miss?

Best regards, Robert

Picture 1.jpg
Picture 1.jpg779×460 52.2 KB

2

Hello,

Servoy uses a standard JDBC connection to a database. All table info is read while Developer starts. There is a few possible causes to your problem:

  1. The table you created belongs to a different user than your WO user (so the Servoy connection doesn’t see it) - where, for example, is that table import that I can see in the diagram but not the table list?
  2. The table is created while Servoy Developer is already running (table info is read upon startup, so a restart of developer should fix the problem)
  3. WO might use some sort of transaction that is not yet commited, so other tools can’t see that table

What happens if you connect using a simple SQL tool (with the same user account as Seroy) and type some SELECT * FROM your_missing_table?

Hope this helps
Patrick

3

Hello Patrick

Thanks for your reply, I found the error with your help (so it helped :-).

See comments below.

Best regard, Robert

patrick:
Hello,

Servoy uses a standard JDBC connection to a database. All table info is read while Developer starts. There is a few possible causes to your problem:

  1. The table you created belongs to a different user than your WO user (so the Servoy connection doesn’t see it) - where, for example, is that table import that I can see in the diagram but not the table list?

I used the wrong URL Info pointing to the crm solution instead of my new SoaringSky solution.

  1. The table is created while Servoy Developer is already running (table info is read upon startup, so a restart of developer should fix the problem)

Thanks for the info.

  1. WO might use some sort of transaction that is not yet commited, so other tools can’t see that table

CREATE TABLE … is a DDL statement and does not need a commit (to be executed).

What happens if you connect using a simple SQL tool (with the same user account as Seroy) and type some SELECT * FROM your_missing_table?

Hope this helps
Patrick