alfresco

[reeva]

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 .

[steve]

Hi,

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

Thanks!

[reeva]

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

[steve]

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

[reeva]

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

With Regards
Reeva

[reeva]

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