[opencms-dev] OpenCms 6 and SQL Server 2k

[Andras Balogh]

Hello,

Regarding the MS-SQL support we have begun to work on this.
We have created the necessary classes and  sql scripts, and i 
sucessfully built a new war file.
First i wanted to run the unittests but i get these errors:
[mkdir] Created dir: D:\eclipse\workspace\opencms6b1\build\test
    [javac] Compiling 100 source files to 
D:\eclipse\workspace\opencms6b1\build\test
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:40: 
warning: com.opencms.defaults.master.CmsMasterContent in 
com.opencms.defaults.master has been deprecated
    [javac] import com.opencms.defaults.master.CmsMasterContent;
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:41: 
warning: com.opencms.defaults.master.CmsMasterDataSet in 
com.opencms.defaults.master has been deprecated
    [javac] import com.opencms.defaults.master.CmsMasterDataSet;
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:42: 
warning: com.opencms.defaults.master.genericsql.CmsDbAccess in 
com.opencms.defaults.master.genericsql has been deprecated
    [javac] import com.opencms.defaults.master.genericsql.CmsDbAccess;
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\xml\page\TestCmsXmlPageInSystem.java:44: 
package org.opencms.workplace.tools.content does not exist
    [javac] import org.opencms.workplace.tools.content.CmsElementRename;
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\test\OpenCmsTestCase.java:1157: 
reference to compare is ambiguous, both method 
compare(org.dom4j.Document,org.dom4j.Document) in 
org.dom4j.util.NodeComparator and method 
compare(org.dom4j.Node,org.dom4j.Node) in 
org.opencms.test.OpenCmsTestCase.InternalNodeComparator match
    [javac] if (comparator.compare(d1, d2) != 0) {
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:108: 
warning: com.opencms.defaults.master.genericsql.CmsDbAccess in 
com.opencms.defaults.master.genericsql has been deprecated
    [javac] CmsDbAccess masterDbAccess = new CmsDbAccess(m_pool);
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:108: 
warning: com.opencms.defaults.master.genericsql.CmsDbAccess in 
com.opencms.defaults.master.genericsql has been deprecated
    [javac] CmsDbAccess masterDbAccess = new CmsDbAccess(m_pool);
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:141: 
warning: com.opencms.defaults.master.genericsql.CmsDbAccess in 
com.opencms.defaults.master.genericsql has been deprecated
    [javac] CmsDbAccess masterDbAccess = new CmsDbAccess(m_pool);
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:141: 
warning: com.opencms.defaults.master.genericsql.CmsDbAccess in 
com.opencms.defaults.master.genericsql has been deprecated
    [javac] CmsDbAccess masterDbAccess = new CmsDbAccess(m_pool);
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:158: 
warning: com.opencms.defaults.master.genericsql.CmsDbAccess in 
com.opencms.defaults.master.genericsql has been deprecated
    [javac] CmsDbAccess masterDbAccess = new CmsDbAccess(m_pool);
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:158: 
warning: com.opencms.defaults.master.genericsql.CmsDbAccess in 
com.opencms.defaults.master.genericsql has been deprecated
    [javac] CmsDbAccess masterDbAccess = new CmsDbAccess(m_pool);
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:159: 
warning: com.opencms.defaults.master.CmsMasterDataSet in 
com.opencms.defaults.master has been deprecated
    [javac] CmsMasterDataSet dataset1 = new CmsMasterDataSet(), dataset2 
= new CmsMasterDataSet();
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:159: 
warning: com.opencms.defaults.master.CmsMasterDataSet in 
com.opencms.defaults.master has been deprecated
    [javac] CmsMasterDataSet dataset1 = new CmsMasterDataSet(), dataset2 
= new CmsMasterDataSet();
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:159: 
warning: com.opencms.defaults.master.CmsMasterDataSet in 
com.opencms.defaults.master has been deprecated
    [javac] CmsMasterDataSet dataset1 = new CmsMasterDataSet(), dataset2 
= new CmsMasterDataSet();
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:159: 
warning: com.opencms.defaults.master.CmsMasterDataSet in 
com.opencms.defaults.master has been deprecated
    [javac] CmsMasterDataSet dataset1 = new CmsMasterDataSet(), dataset2 
= new CmsMasterDataSet();
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:160: 
warning: com.opencms.defaults.master.CmsMasterContent in 
com.opencms.defaults.master has been deprecated
    [javac] CmsMasterContent content = new CmsMasterContent(cms) {
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:160: 
warning: com.opencms.defaults.master.CmsMasterContent in 
com.opencms.defaults.master has been deprecated
    [javac] CmsMasterContent content = new CmsMasterContent(cms) {
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\module\TestModuleLegacy.java:160: 
warning: com.opencms.defaults.master.CmsMasterContent in 
com.opencms.defaults.master has been deprecated
    [javac] CmsMasterContent content = new CmsMasterContent(cms) {
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\xml\page\TestCmsXmlPageInSystem.java:278: 
cannot resolve symbol
    [javac] symbol  : class CmsElementRename
    [javac] location: class org.opencms.xml.page.TestCmsXmlPageInSystem
    [javac] CmsElementRename wp = new CmsElementRename(null,
    [javac] ^
    [javac] 
D:\eclipse\workspace\opencms6b1\opencms\test\org\opencms\xml\page\TestCmsXmlPageInSystem.java:278: 
cannot resolve symbol
    [javac] symbol  : class CmsElementRename
    [javac] location: class org.opencms.xml.page.TestCmsXmlPageInSystem
    [javac] CmsElementRename wp = new CmsElementRename(null,
    [javac] ^
    [javac] 4 errors
    [javac] 16 warnings

What am i doing wrong? My java version  is j2sdk1.4.1_01.
Can You give a little description of the unit tests? They need an 
already existing DB with tables and imported workplace or this will be 
created by the unit tests?
I will deploy the war now and see how the setup process goes.

Best regards,
Andras Balogh.
http://www.reea.net

Alexander Kandzior wrote:

> Matt,
>  
> there's still activity on this project, but more help would be much 
> appreciated since most of the participants are currently occupied with 
> other stuff.
>  
> We have a pre-elminary MS SQL driver contributed by Taras Vasylkevych. 
> It goes as far as to the installation wizard "workplace import", but 
> fails then for some reason. Andras Balogh is currently looking at the 
> code.
>  
> As said, any further help is appreciated. If you are interested I can 
> mail you the current codebase of the driver.
>
> Best Regards,
> Alex.
>
> Alexander Kandzior
> Alkacon Software - The OpenCms Experts
> http://www.alkacon.com <http://www.alkacon.com/>
>
>