StrataFrame Forum

Wrong stored procedure name generated when using different DB schemes

http://forum.strataframe.net/Topic17848.aspx

By Jiri Brazda - 7/15/2008

Hi,

In this post I have described problems with DDT and different db schemes. It was solved by fix.

Now I have found additional problem - when I force using stored procedure for update, it causes app crash reporting that "Book_Update" stored procedure doesn't exist. This is true since the Book table is in M02 scheme and stored procedures created by DDT are created in the same scheme.

I have solved this issue by manually setting the UpdateStoredProcedureName property on BO to "M02.Book_Update". However it would by nice when the Business Object Mapper generate it automatically.

Thanks

Jiri Brazda

By Trent L. Taylor - 7/15/2008

Thanks, I will look into this on the schema name.