how to save rich text editor content to mysql database

Hey,

May I have answer following questions:

• Are you not using JCR Tar as backend?.
• Do you want to store only RTE content to MYSQL And the rest of the content in the JCR Repository?.

----

Jitendra

Hi 

We can create a component/Service to communicate with JCR nodes or can fetch component dialog values, and can populate it to and DB. Your OSGI Component/Service will fetch the value, create a connection with DB and then feed it accordingly to your logic.

You can refer the following article to help you achieve the needful :-

Link1 :- https://helpx.adobe.com/experience-manager/using/querying-persisting-cq-data-mysql.html

// Querying and Persisting Adobe AEM data into MySQL. The application that is able to query data from MySQL as well as persist data back to the database. This article creates an OSGi bundle that uses the JDBC API to query and persist data. In addition, discusses how to invoke an OSGi bundle operation from the client web page.  

Link 2:- http://aem.matelli.org/fetching-properties-from-dialogs/

// Fetching Properties From Dialogs.

String title = "", text= "";
if (!Resource.RESOURCE_TYPE_NON_EXISTING.equals(myResource.getResourceType())) {
Node node = myResource.adaptTo(Node.class);
title = node.getProperty("jcr:title").getString();
text= node.getProperty("jcr:text").getString();
}

//Extending RTE

Link 4:- https://helpx.adobe.com/experience-manager/using/querying-experience-manager-data-using1.html

//Querying Adobe Experience Manager Data using the JCR API

I hope this could help you.

Thanks and Regards

Kautuk Sahni

Jitendra,

I will use JCR Repository to store image and video files after editting the rich text component. The reason I use mysql database is that the rich text contents will be saved to the specified users and I need query those contents from users to render web pages. I don't know if there is a convenient way to do that in AEM(I am j2ee guy, just start doing AEM projects recently).

Kautuk,

Thank you very much for replying.

I took a look at the link 3 for extending RTE. It seems building a video plugin is a little different from a pullquote. For instances, how and where to store the video files? How to preview the video in RTE? How to define the video size limit? etc

Is there a more direct sample to extend RTE for a video plugin? 

Thanks and regards,

Yy