WebSphere Commerce custom tables queries and performance implications: goodbye ServerJDBCHelperAccessBean

Executing custom queries against custom tables is an historical problem affecting a lot of ecommerce projects implemented  with several big ecommerce frameworks (Oracle, IBM, SAP).

On WebSphere Commerce the developers have used during a lot of years (and they are still using) an undocumented API (ServerJDBCHelperAccessBean) to access custom tables data and IBM it self suggests to use it on developerworks.

This widely used API has another important inconvenient: it cannot be used to manage custom results caching.

But starting from the cumulative fix #2 for v7 Fixpack 9 (JR53438), we can finally use an optimized and documented API to query our Commerce tables: WCDataCache.

IBM extended the existing Commerce data cache API with a very powerful new method: executeParametrizedQuery.

This method should replace the correspondent ServerJDBCHelperAccessBean call allowing the developers to cache custom query results and associate them a specific dependencyId or a TTL to invalidate them when needed.

This new API has to be used in conjunction with the new data cache settings coming with FixPack 9: maxTimeToLiveForAutoCacheEntries and autoCacheableTableNames.

It’s time to refactor your code then and cache without fears your custom queries.

Advertisements

Websphere Commerce and Portal Architect ✔ Motivated IT professional with more than ten years of experience, combining Java and JEE developer skills with systems and IBM products installation knowledge. ✔ Strong experience and skills on planning, architecting and implementing complex commerce and portal solutions based on IBM middleware products. ✔ Reliable with a strong network attitude, experience on leading developer's teams and manage international relationships. Specialties ✔ Pleasant manner, reliable. ✔ Ability to consider issues from different point of views. ✔ End-oriented work capacity and problem-solving attitude. ✔ Ability to work with deadlines and under pressure. ✔ Ability to prioritise tasks and manage people. ✔ Ability to increase the whole team skills. ✔ Ability to generate commercial leads

Tagged with: ,
Posted in cache, commerce frameworks, websphere commerce

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: