How to retrieve DB details from a property file

can we retrieve DataBase informations from a property file
rather than writing them in a iw_sql_open tag
and i'm using the iw_sql_open and iw_sql_iterate tags to iterate the result set

[html]

user_name = "aaa"
password = "bbbb"
aux_env = "ORACLE_HOME => '/opt/u01/product/oracle/10g',
ORACLE_SID => 'SID2'" >
[/html]
can some one help me to solve this issue

Find more posts tagged with

Comments

Adam Stoller

can we retrieve DataBase informations from a property file
rather than writing them in a iw_sql_open tag
and i'm using the iw_sql_open and iw_sql_iterate tags to iterate the result set

[html]

user_name = "aaa"
password = "bbbb"
aux_env = "ORACLE_HOME => '/opt/u01/product/oracle/10g',
ORACLE_SID => 'SID2'" >
[/html]
can some one help me to solve this issue

You could write part of, or the entire, PT in Perl - retrieve the information from the properties file using any number of modules that exist out there for doing such (e.g.: Config: Smiley Tongue

roperties or Util: Smiley Tongue

roperties, I'm sure there are others), and then either call the iw_sql_**** stuff - or call Perl DBI code directly.

plain_listing_report.rptdesign

ishkmi

You could write part of, or the entire, PT in Perl - retrieve the information from the properties file using any number of modules that exist out there for doing such (e.g.: Config:roperties or Util:roperties, I'm sure there are others), and then either call the iw_sql_**** stuff - or call Perl DBI code directly.

cant we do it in Interwoven tags rather than using the Perl code
Or use the perl just only to load the property file details and use the interwoven tags to iterate through the result set ??

Adam Stoller

cant we do it in Interwoven tags rather than using the Perl code
Or use the perl just only to load the property file details and use the interwoven tags to iterate through the result set ??

what part of the following didn't you understand?

... and then either call the iw_sql_**** stuff - or call Perl DBI code directly.

Also - the iw_sql_**** stuff is Perl code that was wrapped up to make it appear in XML format - if you want to, you can create your own custom XML tags for the PT processor that will do all that you want - but you'll be writing the custom PT tag in Perl so that the users of the custom PT tag don't have to know Perl.

Lastly, if you have plans to try to take advantage of some of the non-OS-user-account stuff that is going to become possible as of TS671SP1 (I believe scheduled for release at end of either June or July) - you'll have to use a completely different mechanism -- because you cannot use Perl-based PT's with non-OS-user accounts - you have to use XSLT (and not iwov_xslt).

ishkmi

thanks 4 ur reply
so we can use perl and interwoven tags interchanging
so can u give me an idea how to use the perl code to read the property file and use the iw_sql_open and iw_sql_iterate tags to iterate the result set???
for example if i have use perl to create a db connection and we have the connection in a variable called $db_conn how to use it inside the interwowen tag iw_sql_iterate to go through the resultset??

can anyone help me to solve this issue

Adam Stoller

thanks 4 ur reply
so we can use perl and interwoven tags interchanging
so can u give me an idea how to use the perl code to read the property file and use the iw_sql_open and iw_sql_iterate tags to iterate the result set???
for example if i have use perl to create a db connection and we have the connection in a variable called $db_conn how to use it inside the interwowen tag iw_sql_iterate to go through the resultset??

can anyone help me to solve this issue

If I had all the time in the world (which I don't) to write everyone else's code for them for free (which I won't) then yes - I might be able to show you how to do this.

Instead - I suggest you try to figure it out on your own - if you run into trouble - post your code and let others (who may have time) attempt to reproduce the issues of your code and perhaps suggest ways of fixing it.