topic Re: alfresco in Alfresco Archive

alfresco

reeva — Mon, 16 Apr 2007 11:47:30 GMT

hi , this is the 1st time i am working on alfresco .I am supposed to import alfresco api in netbeans ,then configure it to sql database for downloading and uploading file . So far i just have downloaded sdk ,can anyone kindly give me some idea how to proceed further .

Re: alfresco

steve — Thu, 17 May 2007 10:23:34 GMT

Hi,

Could you repost the steps you are trying to achieve please?
I don't quite understand what you are trying to do.

Thanks!

Re: alfresco

reeva — Thu, 17 May 2007 11:35:29 GMT

Thanks Steve
Well i have configured alfresco using MYSQL server .I am actually in a project where we are going to use alfresco .We need the functionalities provied in alfresco ,for example versioning and workflow control etc .
Now what happens is whenever i upload any file it's getting stored in alf_data .
i want to store files or documents in our local database by using alfresco .
how can i do that ?

One problem i am having is i am still not able to configure alfresco with sql server .
Could you kindly provide me the steps to follow for configuring alfresco with SQL server.

I have followed all the steps written in readme.txt but couldn't successfully configure alfresco with sql server .
I would be really glad if you kindly suggest me something regard all those .

with regards
reeva

Re: alfresco

steve — Thu, 17 May 2007 15:46:55 GMT

Hi,

To work with MS SQL Server you just need to change a couple of config files:

\tomcat\shared\classes\alfresco\extension\custom-db-connection.properties
Comment out the existing connection details and uncomment the lines as below:
#
# SQLServer connection (requires jdts-1.2.jar or equivalent - http://jtds.sourceforge.net/)
#
db.driver=net.sourceforge.jtds.jdbc.Driver
db.url=jdbc:jtds:sqlserver://localhost/alfresco

\tomcat\shared\classes\alfresco\extension\custom-hibernate-dialect.properties
#
# SQLServer dialect
#
hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect

You will have to ensure that:
1. you have downloaded jdts-1.2.jar or equivalent - http://jtds.sourceforge.net/
2. These files are placed in \tomcat\common\lib
3. You have created a user and an associated tablespace in MS SQL Server called 'alfresco'
4. You can connect to MS SQL Server as the alfresco user created above

On you other question, we don't supply a method of storing your files in the DB. However, there are other users on the forums who have implemented this - so I suggest you search and contact these users about their experiences.

Hope this helps,

Steve

Re: alfresco

reeva — Fri, 18 May 2007 06:06:39 GMT

Thanks Steve
                    Thanks a lot for your reply .I shall follow those steps for configuring alfresco with sql server .

Thanks

With Regards
Reeva

Re: alfresco

reeva — Tue, 05 Jun 2007 12:36:24 GMT

Hi Steve
I have successfully configured alfresco with sql server , now i am with another problem .
I want to use alfresco api for uploading files .
Can you kindly suggest me how can i do that ?

With Warm Regards
Reevz