[jira] Closed: (JS2-1067) Jetspeed 2.1.1 with MSSQL Server

["Nishant Malviya (JIRA)" <je...@portals.apache.org>]

     [ https://issues.apache.org/jira/browse/JS2-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nishant Malviya closed JS2-1067.
--------------------------------

    Resolution: Fixed

some insert statements are also required to work jetspeed with mssql

> Jetspeed 2.1.1 with MSSQL Server
> --------------------------------
>
>                 Key: JS2-1067
>                 URL: https://issues.apache.org/jira/browse/JS2-1067
>             Project: Jetspeed 2
>          Issue Type: Bug
>          Components: Deployment
>    Affects Versions: 2.1.1-RC
>         Environment: Windows 2003 Server
>            Reporter: Nishant Malviya
>            Assignee: David Sean Taylor
>            Priority: Critical
>             Fix For: 2.1.1-RC
>
>         Attachments: schema.zip
>
>
> I am unable to configure jetspeed 2.1.1 with MS-SQL server 2000-3a database server.
> I did the following steps to configure jetspeed: 
> Step 1: I have created the database using the scripts given in the product.
>  the script had to be modified little to remove ON DELETE CASCADE to ON DELETE NO ACTION in some the of the tables. after making that change the database got created. but don't know if this will impact jetspeed.
> Step 2: I tried to modify the database.properties with MSSQl driver and database information but still its taking derby as database.
> Can you tell me the steps needed to configure jetspeed with this database. I cannot modify maven file and generate jetspeed as this jetspeed is deployed on customer site.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org