Hello RPT Users,

Has anyone tried RPT for database testing? Here's what I'm working with: 1000 of claims import from one database to another. We need to test how these database behave when importing claims. The protocol or the test nature between these databases is TCP/IP. The test script should contain SQL based request and response between database.

Any suggestion is appreciated:)

Hello,

Thank you for your query. In Rational Performance Tester, there is no test extension specific to test databases as the primary interface. Using TCP/IP (socket level record/playback) for SQL database record/playback is a futile exercise in general. A better approach is to either:
1) Use custom code using JDBC to access the DB, but this can be very low level (lots of calls), or
2) As DB2 folks do, write an EJB on the app server that does the DB2 communication, and then use custom code to call the (higher level) EJB.

We hope this helps answer your question.

- Rational Performance Tester development team.

Thank you for your expertise, Marianne! This was very helpful. 

Thanks a lot! This custom code will be included inside RPT or outside? Best Regards,
Mohammed Fadin
DevOps Specialist- Client Technical Professional
IBM Hybrid Cloud
IBM Middle East FZ-LLC
Saudi Arabia Branch
Mobile: +966 555644150
23rd Floor, Kingdom Tower, Olaya Street,
P.O.BOX 11533, Saudi Arabia ----- Original message -----
From: Marianne Hollier <devops@lists.imwuc.org>
To: DevOps@lists.imwuc.org
Cc:
Subject: [DevOps] - RE: testing databases with RPT
Date: Fri, Feb 10, 2017 8:42 PM

Hello,
Thank you for your query. In Rational Performance Tester, there is no test extension specific to test databases as the primary interface. Using TCP/IP (socket level record/playback) for SQL database record/playback is a futile exercise in general. A better approach is to either:
1) Use custom code using JDBC to access the DB, but this can be very low level (lots of calls), or
2) As DB2 folks do, write an EJB on the app server that does the DB2 communication, and then use custom code to call the (higher level) EJB.
We hope this helps answer your question.
- Rational Performance Tester development team. Site Links: View post online   View mailing list online   Start new thread via email   Unsubscribe from this mailing list   Manage your subscription  

This email has been sent to: mfadin@sa.ibm.com

The custom code would need to be written by your team outside of RPT.