In Addition .. I have another sql query …
String query = "select count(RECORD_ID) from " + source_schema + "." + source_table_name;
The value of both source_schema and source_table_name is known at run time.
How can I accomplish this in iBatis?
Rajiv
_____________________________________________
From: Rajiv Kumar
Sent: Thursday, March 10, 2005 7:43 PM
To: '[email protected]'
Subject: Dynamically passing the name of schema to select statement
Hello,
I have very simple select statement
select * from Level_1_Rules where RULE_ACTIVE=1
All I want to do is qualify table name with schema name.
For every run of my program this schema name is different.
Regards,
Rajiv Kumar
