Datadeploy to DB-Extract one field to create .jsp

ccya99

We are using Datadeploy 5.0.2. We would like to take one field (a VisualFormat paragrph field) from our DCR and at deploy time, create a .jsp for that one paragraph and store the path to that jsp in the database record for that DCR. Anytime that record is accessed from our site it would "include" that jsp text in the record and display it to the user.

Has anyone done that or can you tell me where we would start?

Thanks in advance.

Migrateduser

Absolutely possible. If I understand correctly, you want to construct the jsp on the fly, store that jsp in the table itself?

Here is what I recommend:

1. I believe you are using DD520 (there is no DD502). You should upgrade to DD521 + Service Pack1. DD521 is compatible with TS50x.

2. Take a look at the external tuple pre-processor interface. With this interface, you would implement a Java class based on the java interface piublised with DD. Your java class's method will be invoked after the source data is retrieved and before the data is deployed to the database. This gives you an opportunity to manipulate the data being deployed. The "paragraph" field in the DCR is available to the method in the form of a Hashtable. You construct the jsp in memory and set it to the Hashtable object and return it to DD. The "key" name that you set in the Hashtable will become the value-from-field in the DD config file. DD would then deploy the jsp content to a column of your choice, depending on how you mapped to the field.

3. The DD admin guide describes the External tuple preprocessor implementation and feature in detail. take a look at it. There is an example under ddhome/conf directory. The interface definition is also available under the same directory (called IWExternalTupleProcessor.java)

example.txt