Macrobject Community   Macrobject Software Knowledge Management and Collaboration Platform Search       Forums Home

Change DB Scheme at Runtime Started by Flywheel at 02-19-2009 1:10 AM. Topic has 5 replies. Macrobject Comm... » Developing Tool... » DObject O/R Map... » Change DB Scheme at Runtime

Search

02-19-2009, 1:10 AM Flywheel Joined on 02-19-2009 Posts 4 Change DB Scheme at Runtime Hi. I am using DObject to access an oracle DB. I have 2 Databases with identical  tables. Is it possible  to change the scheme at runtime i.e.      scheme1.tableXY            scheme2.tableXY thanx    Report

02-19-2009, 6:11 AM David Joined on 01-26-2008 Posts 193 Re: Change DB Scheme at Runtime Which action do you want? Please give us some more details. PS: DObject supports multi-scheme access.    Report

02-19-2009, 6:38 AM Flywheel Joined on 02-19-2009 Posts 4 Re: Change DB Scheme at Runtime Hi David, For my Oracle DB i have a different User with limited rights, so i have to supply  a qualifier  (Scheme)  with the tablename  or to access the same table in another scheme. i.e.    select * from test.table1  and select * from prod.table1       If i generate the code with AutoCode, i have to give a scheme i.e. test this works fine as long as my DB scheme is test Where do i have to change the scheme name at runtime which is given via a config file to access  prod.table1   thank you regards    Report

02-20-2009, 4:45 AM David Joined on 01-26-2008 Posts 193 Re: Change DB Scheme at Runtime As this situation, you could regenerate the code with CodeAuto. All code you written not need modify.    Report

02-20-2009, 5:16 AM Flywheel Joined on 02-19-2009 Posts 4 Re: Change DB Scheme at Runtime Sorry David, what i meant is : at Runtime  i read the scheme i.e.   TEST   or PROD  from a config file and  replace this in my queries scheme := 'xyz'; Query := ' select  * from ' + scheme + '.table1'; to access different schemes without recompiling my app. How can this be done using DObject ? thanks    Report

02-22-2009, 8:34 AM David Joined on 01-26-2008 Posts 193 Re: Change DB Scheme at Runtime Sorry for the delayed response. DObject can not support change scheme at the runtime by itself. As you see, DObject use a connection string as it's entry, you could modify the connection string at runtime to fit your requirement. Any questions please feel free to contact us, thanks. David.    Report

Macrobject Comm... » Developing Tool... » DObject O/R Map... » Change DB Scheme at Runtime

(please select) Forums Home |- Search Forums |- Active Topics |- Unanswered Posts User Options |- Sign In |- Create a New Account |- Forgot Password Order and Registration Issues |- Registration Issues Help Authoring Tools |- Word-2-CHM Converter |- Word-2-Web Converter |- CHM-2-Word Converter |- CHM-2-HTML Converter |- CHM-2-Web Converter Developing Tools |- Obfuscator.NET |- OQL.NET Object Query Language |- NObject O/R Mapping Framework |- DObject O/R Mapping Suite |- Nuva Language |- CodeAuto Code Generator |- CodeAuto Studio Miscellaneous |- Miscellaneous