Deploying a HTML file to a database using datadeploy.

Has anyone deployed a HTML file to a database using DataDeploy?

Find more posts tagged with

Comments

You mean drop the HTML page into a CLOB/BLOB?

You could probably do it, I have seen people put images in BLOBs. Why you would do that is beyond me.

Out of the box DD does not do that, but it should not be too difficult to accomplish this.

cesarecastro

The OpenDeploy/DataDeploy administration Guide has instructions on how to Deploy URL Content - File or HTTP, but it is not working as expected and it throws data array errors when deploying to a CLOB.

We are trying to apply a presentation to the content before putting it in the database. This is so the presentation layer be handled by Teamsite TPLs and the Business Logic by the .Net folks.

Thanks for your answer - We are opening a case with Interwoven to tell us why this is throwing array errors.

nipper

What rev of DD ? What DB ? How are you connecting to the DB ? (JDBC/local client).

Oracle had (may still have) an issue with large BLOBs (> 4K) inserted with JDBC.

sudhakera

There is no straight forward way to deploy the html directly to database until and unless you write a custom scirpt(java/perl) using (jdbc/DBI) and call it as post-deploy or script or call it as external task. Basically custom script has to get the list of the files and deploy in to the respective table/column, which is CLOB. But, you got to take care of html escaping, encoding and string conversions between d/b and the routine.

cesarecastro

We are using OD/DD 6.1.1 and deploying out to an Oracle database to a CLOB field. I am thinking about upgrading to 6.2, this may or may not fix the errors but I'll let Interwoven Support with that decision.

sudhakera,

Here is what the OD/DD guide has to say about deploying URL content on page 220 of the Guide.

Deploying URL Content

You can deploy content pointed to from a URL in the following scenarios:

When DCRs and TeamSite metadata are deployed in standalone or DAS mode with user-defined schemas.

When custom DCRs are deployed in standalone or DAS mode with user-defined schemas.

When DCRs and TeamSite metadata are deployed in wide table format.

So, it is supported, I just need to make it work. I will follow up on the issue that Nipper stated. This may be an issue with deploying to Oracle with JDBC which is indeed what we are doing.

cesarecastro

So we were able to deploy the content of a file to the database using DataDeploy. Interwoven support recommended that the table hosting the content (CLOB) be dropped completely and then recreated with the new structure using a CLOB field. After doing so the deployment succeeded and its looking good.

Thanks to all who gave input.

I am looking for a Teamsite Developer. Location: LOS ANGELES, California - compensation is good too. Let me know if any one is interested.