Monday, October 7, 2013

JDBC Helpers in Commerce


ReportJDBCHelperBeanBase : If you want to connect a dedicated reporting database which is different than the production database then extend this class to execute your reporting query .
How ? :
Create new datasource in your was console .
Use below method to execute the query by passing the datasource name (don;t pass jdbc/) and report query
Vector executeQuery(String dsName, String queryString)


ServerJDBCHelperAccessBean : Good to use if you want to connect same database where u r wcs tables are running

BaseJDBCHelper:
BaseHelper: You can use ds name/username/password and get the datasource connection



Thanks
Bipin