topic Re: DB-Scripts for MS SQL Server needed in Alfresco Archive

DB-Scripts for MS SQL Server needed

gbaindl — Thu, 05 Jul 2007 20:31:13 GMT

Has everyone built the db-scripts (create, …) for MS SQL Server? If I startet the file "AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-64635.sql" I get many error and I'm not a SQL Specialist for the different SQL-Types.

Re: DB-Scripts for MS SQL Server needed

mikeh — Thu, 05 Jul 2007 21:59:49 GMT

http://forums.alfresco.com/viewtopic.php?t=7294

Re: DB-Scripts for MS SQL Server needed

davidc — Fri, 06 Jul 2007 09:10:22 GMT

You need to change Alfresco's sql dialect to SQL Server. It's much easier.

http://wiki.alfresco.com/wiki/Database_Configuration

Re: DB-Scripts for MS SQL Server needed

gbaindl — Fri, 06 Jul 2007 09:29:01 GMT

Hi David,

thanks, but this is what I did. Here is the configuration in repository.properties:

# Database configuration MS SQL Server
db.schema.update=true
db.driver=net.sourceforge.jtds.jdbc.Driver
db.name=Alfresco
db.url=jdbc:jtds:sqlserver://xxx.web-shuttle.de:1433;DatabaseName=${db.name}
db.username=Alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=20

The alfresco start file can connect to the database, but it runs the mysql-comands and this brings up an error.

I would be good, if there is a detailed installation documentation about eyery step and change in every file. So I can reinstall Alfresco.

Thanks for your help.

Georg

Re: DB-Scripts for MS SQL Server needed

davidc — Fri, 06 Jul 2007 09:36:33 GMT

You're missing the dialect config. The configuration steps are listed in the URL I pasted earlier. There's also a link to the list of dialects for all databases.

Re: DB-Scripts for MS SQL Server needed

gbaindl — Fri, 06 Jul 2007 16:22:33 GMT

Now I found the wrong thing. I forgot to copy the jtds-1.2.jar File to the lib Folder. Now it runs with MS SQL Server. Thank you fpor your help

Georg

Re: DB-Scripts for MS SQL Server needed

akshayakher — Tue, 24 Jul 2007 17:33:23 GMT

Can you simplify and give more details on that. I am trying to configure Alfresco 2.0 with MS SQL

Thanks for your help in advance
Akshaya

Re: DB-Scripts for MS SQL Server needed

nick_gti — Tue, 24 Jul 2007 20:19:57 GMT

Can you simplify and give more details on that. I am trying to configure Alfresco 2.0 with MS SQL

Thanks for your help in advance
Akshaya

Here is how i got it to work.

Also please note this was a fresh install of alfresco 2.1RC1 on windows 2003 server.

First edit the custom-hibernate-dialect.properties located in the tomcat\shared\classes\alfresco\extension folder.
Contents of my file.

# Sample Hibernate configuration to disnable Hibernate schema updates
# Values are "validate" or "update" (default)
#hibernate.hbm2ddl.auto=validate

#
# Microsoft SQL dialect
#
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
‍‍‍‍‍‍‍‍‍

Second edit custom-repository.properties
added to the file:


db.schema.update=true
db.driver=net.sourceforge.jtds.jdbc.Driver
db.name=Alfresco
db.url=jdbc:jtds:sqlserver://MYSQLSERV:1433;DatabaseName=${db.name}
db.username=Alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=20
‍‍‍‍‍‍‍‍‍‍

Third copy the jtds-1.2.jar file you download to \tomcat\common\lib\

Forth: I made a new database using sql enterprise manager called Alfresco
Created a sql user account named alfresco that is a member of the Alfresco database and had system administration role.

Once this is all done i started alfresco up and it ran the scripts and i was ready to go.

Re: DB-Scripts for MS SQL Server needed

akshayakher — Tue, 24 Jul 2007 20:24:29 GMT

Thank you so much. I will try and implement this.

Regards
Akshaya

Re: DB-Scripts for MS SQL Server needed

akshayakher — Thu, 26 Jul 2007 20:41:22 GMT

one more clarification.

jtds-1.2.jar file you would be getting when we download tomcat right or when we download alfresco?

Also will this whole setup work with Alfresco 2.0

Thanks a lot for your help.

Regards
Akshaya

Re: DB-Scripts for MS SQL Server needed

akshayakher — Thu, 26 Jul 2007 20:42:50 GMT

also if the sql is on some other machine/server how can we tweak this code

db.url=jdbc:jtds:sqlserver://MYSQLSERV:1433;DatabaseName=${db.name}

Re: DB-Scripts for MS SQL Server needed

nick_gti — Thu, 26 Jul 2007 21:19:44 GMT

Download jtds from http://jtds.sourceforge.net/index.html

Extract the download and just copy the jtds-1.2.jar file to:
tomcat\common\lib

On this line


db.url=jdbc:jtds:sqlserver://MYSQLSERV:1433;DatabaseName=${db.name}
‍‍‍

MYSQLSERV is your database server's hostname or ip.

Re: DB-Scripts for MS SQL Server needed

akshayakher — Mon, 30 Jul 2007 19:57:27 GMT

Hi,

I tried all the steps given above..i dont know what I am missing here but just not working..its trying to find hsql, here is the error

Exception in thread "HSQLDB Timer 8aaff4" java.lang.NullpointerException
at org.hsqldb.lib.Hsqltimer.nextTask<unknown source>
at org.hsqldb.lib.Hsqltimer$TaskRunner.run<Unknown Source>
at java.lang.Thread.run<Thread.java:595>

Are above instructions possible with SQL2005 and Alfresco 2.0

Please help!!!

Thanks
Akshaya