topic Re: deploy content to any database on portal side? in Alfresco Archive

deploy content to any database on portal side?

hansraj — Thu, 16 Oct 2008 14:41:26 GMT

Hi,Iam using Alfresco Labs3. As we know Derby is the default DB we get thru this installation.My requirement is, i want to deploy my content to diffrent DB like MS-SQL/Oracle. can we do this ?If so, please tell me the procedure to do this.If i use Enterprise Edition, can i do the deployment of conte

Re: deploy content to any database on portal side?

mrogers — Thu, 16 Oct 2008 20:24:38 GMT

Yes you can use other databases

There are guides on the wiki such as:
http://wiki.alfresco.com/wiki/Database_Configuration

Re: deploy content to any database on portal side?

hansraj — Fri, 17 Oct 2008 06:39:19 GMT

Hi,

Thank you very much for your reply. It's really useful for me.

Now i came to know that we can configure different DB in Alfresco Labs. I followed the wiki guide as you said.

My requirement is something more. Please tell me the procedure how to do content deployment to the configured DB.
For eg, iam going to configure Oracle, could you please tell me how to do deployment to Oracle DB?

Regards,
Hansraj

Re: deploy content to any database on portal side?

mrogers — Fri, 17 Oct 2008 08:33:50 GMT

Could you clarify what you mean by deployment please?

Re: deploy content to any database on portal side?

hansraj — Fri, 17 Oct 2008 11:20:54 GMT

Hi,

Thank you very much for ur reply.

My requirement was deploying content from one machine(alfresco + derby) to another machine(alfresco + oracle) within the same network and then fetch the content from db thru a jsp page.

please clarify the following regarding my above requirement -

1). when i configured alfresco with Oracle(as per the above wiki guide), iam getting port(8080) clash between Tomcat and Oracle. How to configure Tomcat to diffrent port otherthan 8080?

2). what is the database logic to be writtten in jsp to fetch content from db (Oracle)?

Regards,
Hansraj

Re: deploy content to any database on portal side?

hansraj — Sat, 18 Oct 2008 11:40:26 GMT

Hi,

how to deploy content (i.e. insert content) in to a custom table ?

Regards,
Hansraj