topic How to create a dynamic webpage with database connection in Alfresco Archive

How to create a dynamic webpage with database connection

biswanath — Thu, 22 Mar 2007 04:19:42 GMT

Hi plz any one help me on how to create a dynamic webpage and with database connection.plz suggest some idea.RegardsBiswanath

Re: How to create a dynamic webpage with database connection

eyestreet — Thu, 22 Mar 2007 15:08:28 GMT

Hello again Biswanath,

Inserting pages that contain a db connection should not be a problem so long as the Alfresco virtual-tomcat instance has physical connectivity to the database you intend to query. It should really be as simple as dropping them into Alfresco and then testing it out.

One thing to keep in mind though when working with Databases and ANY web content management solution is how you intend to handle the virtualization aspect of the database. If your database contains global values that will not change from content developer to content developer, then there really is not much of an issue. However, if you intend each content developer to work in his or her own space, with their own copy of the data, you have more to consider. To seperate user "Frank" from user "Sarah" on the database side of the house, both Frank and Sarah's sandboxes would need to be pointed at an instance of the database that only Frank or Sarah (respectively) can modify. This would then follow the sandbox/transparency paradigm that Alfresco has built into their product.

To summarize, whenever a database is used in conjuction with the WCM assets generated inside a WCM tool, thought must be given to how to virtualize that database along with the virtualization of each sandbox.

I hope this helps some. If you have any questions, or if I have been unclear, please respond!

Brent Kastner
Eye Street

Re: How to create a dynamic webpage with database connection

bsawler — Thu, 05 Apr 2007 14:55:16 GMT

Hi,

Currently I am running a document register in OpenOffice base for the documents I enter into Alfresco on a local machine and periodically upload snapshots from time-to-time, which is not ideal.

On my previous job, they had a web based page that connected to a MySQL database and users could query the register (update the register) all via the web. This was very powerful, cause anyone could access a 'live' register from the convienece of a web browser.

It there a way to do the above in Alfresco which ease? I have very little programming skills therefore basic terms would be great.

Thanks,
Bradley