Wednesday, 9 January 2013

Persisting Adobe CQ data in a relational database

You can create an Adobe CQ application that captures data from users and stores the data in either the Java Content Repository (JCR) or other back ends such as a relational database. For example, if your organization uses a relational database such as MySQL, you can create an Adobe CQ application that persists data into MySQL.


Assume that you want to create a CQ application that tracks your customers.


When the end user fills in the CQ web form and clicks the Add Customer button, the customer information is added to the database. The primary key value is returned and displayed in the Customer Id field.

This  development article guides you through the process of creating a CQ web application that captures data from an end user and persists the data into MySQL. To view this entire development article, click this link:

http://helpx.adobe.com/experience-manager/using/persisting-cq-data-relational-database.html

Note: If you are interesting in persisting data in the Adobe CQ JCR as opposed to a relational database, then click http://scottsdigitalcommunity.blogspot.ca/2013/01/persisting-cq-data-in-java-content.html.


Adobe Digital Marketing Community


Join the Adobe Digital Marketing Community. Start by clicking this banner

About the Author

I (Scott Macdonald) am a Senior Digital Marketing Community Manager at Adobe Systems with over 16 years in the high tech industry. I am also a programmer with knowledge in Java, JavaScript, C#,C++, HTML, XML and ActionScript. If  you would like to see more CQ or other Adobe Digital Marketing end to end articles like this, then leave a comment and let me know what content you would like to see.

Linked Inhttp://www.linkedin.com/in/scottmacdonald2010
TwitterFollow the Digital Marketing Customer Care team on Twitter @AdobeMktgCare.



2 comments:

  1. Hi Scott - I tried the link for persisting to the mysql but somehow jsp says that CustomerService cannot be resolved.

    ReplyDelete
  2. The line of code in ConnectionHelper is back in the code -- we need this line so CQ finds the Driver file:

    Class.forName("com.mysql.jdbc.Driver").newInstance();

    ReplyDelete