on 02-27-2006 1:07 PM
I have to implement a Java Mapping Program which will require frequent database Access to compare and read table data from some other data base .
What is the most optimum procedure to implement it ?
Should i make a jdbc call every time from the code or should i use EJB(Session beans + Entity beans)...
or any other process besides these 2 to acheive maximum performance
Please Suggest
regards
Nilesh Taunk.
Hi Nilesh,
I think the technique suggested by Ananth is the best way to do a DB lookup using Java Mapping,. The link provided by him is a very good blog to do the same. Do refer to it.
Regqrds,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Be sure, that you omitt any unnecessary DB call, so use one big call and cache values instead of severall small calls. You might also look into the new functionality of java initialization block etc. in message mappings, if you could possibly use a message mapping instead of a java mapping.
Regards
Christine
Hi Nilesh,
I would suggest you to use XI DB Lookup API's for accessing Database. Eventhough it will not give you maximum performance, it will be very easy to change the configuration parameters in JDBC Adapter (No need for hardcoding user id/password/Driver details etc.) and you can refer the same in your Lookup API's.
Please refer the link: <a href="/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler Weblog</a>
Regards,
Ananth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.