| Author |
Message
|
| jeevan |
 Posted: Thu Nov 17, 2005 3:29 pm Post subject: steps to get value from a database table |
 |
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
how can I get value for an attribute of a bo. lets say the name of the attribute is flightNumber. the table has flightnum ber and its value in two colums ( i guess I do not know in fact). I have been told there will be a table and my job is to retrive the value.
how i can retrieve the value and populate the attribute of the BO
thanks |
|
| Back to top |
|
 |
| vk |
| Posted: Thu Nov 17, 2005 4:57 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
What exactly is the requirement?
Do you have a JDBC adapter to poll for records? Do you want the FlightNumber to be sent to a queue whenever an entry is made in the table? |
|
| Back to top |
|
|
| jeevan |
| Posted: Thu Nov 17, 2005 5:09 pm Post subject: |
|
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
I am talking about replacing an attribute of a bo in MAP. there are only a very few attributes are mapped from source to destination bos. most of the attribute of the destination BO are filled with value which has to be retrieved from a relationship table.
I hope you got my point.
thanks |
|
| Back to top |
|
|
| kotha |
| Posted: Thu Nov 17, 2005 8:41 pm Post subject: |
|
|
Partisan
Joined: 12 Mar 2005
Posts: 333
|
Make a call to database with JDBC connector and I think you are retrieving the fields from database, use retrieve verb. the BOs are different for different connectors. for JDBC, give TN as table name in the app specific info and CN as column name of that data base where you are trying to retrieve the filed.
Go through with the help documentation. It clearly mentioned the BO requirements for different connectors. |
|
| Back to top |
|
|
| jeevan |
| Posted: Fri Nov 18, 2005 8:14 am Post subject: |
|
|
Grand Master
Joined: 12 Nov 2005
Posts: 1432
|
I am not talking about reating BO. when we design map, some attributes of the Destination BO are to be replaced from a relationship table. This is statement.
I think this is clear.
Now, the question is: how can i retrive a value for the attribute from a relationship table?
Please rem, that the different child/parent of the destination BO have attribute of same name.
parent has EmpID that takes diff value than the empID of the two children
means there are three constant with same name but in diff BO within a map to be replaced by a constant value from a relationship table.
thanks |
|
| Back to top |
|
|
|
|
