Hi,

We are using Oracle 9x and Non Adapter based Generation.

We have a production DB and Development DB.

Even though the schemas are exact, we are getting errors when running same Generated DLL(generated against Dev DB ) against production DB

The specific error says Table/View not found.

But when generating against Production DB with same tables selected ( using LLB Designer and selecting tables ) we are not getting the errors.

Any ideas.

The schema names are the same, the table names are the same and you have the same synonyms defined in production as in development? It can be tables and schemas are defined globally in development but not in production.

If the schema names are different, please look into overwriting the schema name, if you're using adapter. (Using the generated code -> Adapter -> DataAccessAdapter functionality). If you're using selfservicing, consider renaming the schema in the catalog explorer.

We will not have control on Schema names with our clients. I used self service through out.

Do you think If we move to adapter mode does it change a lot on our side ??

I used self service(vs.net) mode till now.

1.0.2004.2, which will be released within a few hours (it's currently in RC stage) allows you to specify from - to namepairs to overwrite schema names on the fly, also for selfservicing. This can be controlled in the .config file.

For now I changed the template to get schema name from config file ( luckily it was all generated into one file EntityFieldFactory.template in drivers\oracle.... )

Is loading the new Auto ID generated by Trigger into a new Entity Saved feature exists in this version for self service ??

jakkamma wrote:

Is loading the new Auto ID generated by Trigger into a new Entity Saved feature exists in this version for self service ??

It's a global setting in the .config file. Please see the new documentation on configuration of your application in the Use the generated code section.