Hi Harald, I don't think MMBase supports MSSQL at the moment.
See: \WEB-INF\config\databases And your the error in your log: Use for storage configuration :/org/mmbase/storage/implementation/database/resources/MSSQL.xml org.mmbase.module.Module - startModules(): module([EMAIL PROTECTED]) not found to 'init'!: class java.lang.RuntimeException: failure reading document: null java.net.MalformedURLException Or are you trying to create the MSSQL connection at the moment? I know there are more organisations which would like to use a MMBase2MSSQL connection, because MSSQL is their preferred database. Kind regards, Henk. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Harald Lammers (Ordina) > Sent: Friday, February 18, 2005 1:53 PM > To: developers@mmbase.org > Subject: [Developers] Problem MSSQL > > > Hello, > > I'll try to connect mmbase 1.7.3 to the Microsoft SQL server > 2000. I've > tried a lot but there is something wrong. > > Can anybody help me, the logging message is bellow this message. > > Thanks > > Best regard, > Harald Lammers. > > > *** > > INFO: Installing web application at context path > /mmbase173.harald from > URL file:D:\deploy\jakarta-tomcat-5.0.28\webapps\mmbase173.harald > 2005-02-18 13:48:15,364 INFO Configuring logging with > D:\deploy\jakarta-tomcat-5.0.28\webapps\mmbase173.harald\WEB-I > NF\config\log\log.xml > 2005-02-18 13:48:15,615 INFO Class to use for logging > org.mmbase.util.logging.log4j.Log4jImpl > 2005-02-18 13:48:15,785 INFO Starting the file-watcher thread > 2005-02-18 13:48:16,085 SERVICE util.logging.log4j.Log4jImpl - > Redirecting stderr to MMBase logging (If you don't like this, > then put > the STDER logger to 'fatal') > 2005-02-18 13:48:16,085 INFO mmbase.module.core.MMBaseContext - > =========================== > 2005-02-18 13:48:16,085 INFO mmbase.module.core.MMBaseContext - > MMBase logging initialized. > 2005-02-18 13:48:16,085 INFO mmbase.module.core.MMBaseContext - > =========================== > 2005-02-18 13:48:16,085 INFO mmbase.module.core.MMBaseContext - > user.dir : D:\deploy\jakarta-tomcat-5.0.28\bin > 2005-02-18 13:48:16,085 INFO mmbase.module.core.MMBaseContext - > mmbase.config : > D:\deploy\jakarta-tomcat-5.0.28\webapps\mmbase173.harald\WEB-I > NF\config > 2005-02-18 13:48:16,085 INFO mmbase.module.core.MMBaseContext - > mmbase.outputfile : null > 2005-02-18 13:48:16,105 INFO mmbase.module.core.MMBaseContext - > version : MMBase 1.7.3-final > 2005-02-18 13:48:16,105 INFO > mmbase.module.core.MMBaseContext - total > memory : 6 Mbyte > 2005-02-18 13:48:16,185 INFO > mmbase.module.core.MMBaseContext - free > memory : 3 Mbyte > 2005-02-18 13:48:16,185 INFO mmbase.module.core.MMBaseContext - > system locale : nl_NL > 2005-02-18 13:48:16,376 INFO > mmbase.module.core.MMBaseContext - start > time : vrijdag 18 februari 2005 13:48:16 uur CET > 2005-02-18 13:48:16,376 INFO mmbase.module.core.MMBaseContext - > mmbase.htmlroot : > D:\deploy\jakarta-tomcat-5.0.28\webapps\mmbase173.harald > 2005-02-18 13:48:16,376 INFO mmbase.module.core.MMBaseContext - > Finding root url > 2005-02-18 13:48:16,376 INFO mmbase.module.core.MMBaseContext - > context : /mmbase173.harald/ > 2005-02-18 13:48:16,376 INFO > org.mmbase.servlet.MMBaseServlet - Init > of servlet version. > 2005-02-18 13:48:16,376 SERVICE org.mmbase.servlet.MMBaseServlet - > Reading servlet mappings from > D:\deploy\jakarta-tomcat-5.0.28\webapps\mmbase173.harald/WEB-I > NF/web.xml > 2005-02-18 13:48:16,406 SERVICE org.mmbase.module.Module - Loading > MMBase modules... > 2005-02-18 13:48:16,506 SERVICE org.mmbase.module.Module - Loading > module config with class org.mmbase.module.Config > 2005-02-18 13:48:16,546 INFO > org.mmbase.servlet.MMBaseServlet - Init > of servlet images. > 2005-02-18 13:48:16,546 SERVICE org.mmbase.servlet.MMBaseServlet - > Associating function 'images' with servlet name images > 2005-02-18 13:48:16,566 SERVICE org.mmbase.module.Module - Loading > module jdbc with class org.mmbase.module.database.JDBC > 2005-02-18 13:48:16,586 SERVICE org.mmbase.servlet.MMBaseServlet - > Associating function 'attachments' with servlet name images > 2005-02-18 13:48:16,586 SERVICE org.mmbase.servlet.MMBaseServlet - > Associating function 'downloads' with servlet name images > 2005-02-18 13:48:16,616 SERVICE org.mmbase.module.Module - Loading > module mmadmin with class org.mmbase.module.tools.MMAdmin > 2005-02-18 13:48:16,646 INFO > org.mmbase.servlet.MMBaseServlet - Init > of servlet attachments. > 2005-02-18 13:48:16,646 SERVICE org.mmbase.servlet.MMBaseServlet - > Associating function 'attachments' with servlet name attachments > (previous assocation was with images) > 2005-02-18 13:48:16,646 SERVICE org.mmbase.servlet.MMBaseServlet - > Associating function 'downloads' with servlet name > attachments (previous > assocation was with images) > 18-feb-2005 13:48:16 org.apache.coyote.http11.Http11Protocol start > INFO: Starting Coyote HTTP/1.1 on http-8080 > 18-feb-2005 13:48:17 org.apache.jk.common.ChannelSocket init > INFO: JK2: ajp13 listening on /0.0.0.0:8009 > 18-feb-2005 13:48:17 org.apache.jk.server.JkMain start > INFO: Jk running ID=0 time=0/60 > config=D:\deploy\jakarta-tomcat-5.0.28\conf\jk2.properties > 18-feb-2005 13:48:17 org.apache.catalina.startup.Catalina start > INFO: Server startup in 7180 ms > 2005-02-18 13:48:17,407 SERVICE org.mmbase.module.Module - Loading > module mmbaseroot with class org.mmbase.module.core.MMBase > 2005-02-18 13:48:17,467 SERVICE org.mmbase.module.Module - Starting > modules [mmadmin, config, jdbc, mmbaseroot] > 2005-02-18 13:48:17,477 INFO mmbase.module.database.JDBC - Loaded > JDBC driver: com.microsoft.jdbc.sqlserver.SQLServerDriver > 2005-02-18 13:48:17,497 INFO org.mmbase.module.Module - Starting > module mmadmin > class org.mmbase.module.Module > 2005-02-18 13:48:17,507 INFO org.mmbase.module.Module - Starting > module config > class org.mmbase.module.Module > 2005-02-18 13:48:17,507 INFO org.mmbase.module.Module - Starting > module jdbc > class org.mmbase.module.Module > 2005-02-18 13:48:17,517 INFO mmbase.module.database.JDBC - Module > JDBC started (host: 'localhost' port: '1433' database: > 'DatabaseName=mmbase;User=mmbase;Password=mmbase' user: > 'mmbase' driver: > 'com.microsoft.jdbc.sqlserver.SQLServerDriver') > 2005-02-18 13:48:17,517 INFO org.mmbase.module.Module - Starting > module mmbaseroot > class org.mmbase.module.Module > 2005-02-18 13:48:17,527 INFO > mmbase.module.database.JDBCProbe - JDBC > probe starting > 2005-02-18 13:48:17,527 SERVICE mmbase.module.core.MMBase - Init of > MMBase 1.7.3-final ([EMAIL PROTECTED]) > 2005-02-18 13:48:17,527 INFO mmbase.module.core.MMBase - MMBase > default locale : nl > 2005-02-18 13:48:17,557 SERVICE mmbase.module.database.MultiPool - > Creating a multipool for database mmbase containing : 20 connections, > which will be refreshed after 256 queries > 2005-02-18 13:48:17,938 SERVICE mmbase.module.database.MultiPool - > Connection pool has 20 connections > 2005-02-18 13:48:17,988 INFO mmbase.module.core.MMBase - Starting > builder : object > 2005-02-18 13:48:18,178 SERVICE org.mmbase.cache.Cache - > Creating cache > NodeListCache: List Results > 2005-02-18 13:48:18,178 INFO org.mmbase.cache.QueryResultCache - > Instantiated a org.mmbase.cache.NodeListCache > 2005-02-18 13:48:18,178 SERVICE org.mmbase.cache.Cache - Setting > NodeListCache active with size 300 > 2005-02-18 13:48:18,178 SERVICE org.mmbase.cache.Cache - > Creating cache > TypeCache: Cache for node types > 2005-02-18 13:48:18,178 SERVICE org.mmbase.cache.Cache - Setting > TypeCache active with size 200 > 2005-02-18 13:48:18,188 SERVICE org.mmbase.cache.Cache - > Creating cache > Nodes: Node number -> MMObjectNodes > 2005-02-18 13:48:18,188 SERVICE org.mmbase.cache.Cache - > Setting Nodes > active with size 4096 > 2005-02-18 13:48:18,258 INFO mmbase.module.core.MMBase - Starting > builder : typedef > 2005-02-18 13:48:18,298 INFO mmbase.module.core.MMBase - Starting > builder : reldef > 2005-02-18 13:48:18,369 INFO mmbase.module.core.MMBase - Starting > builder : insrel > 2005-02-18 13:48:18,379 SERVICE org.mmbase.cache.Cache - > Creating cache > RelatedCache: Cache for Related Nodes > 2005-02-18 13:48:18,379 SERVICE org.mmbase.cache.Cache - Setting > RelatedCache active with size 25 > 2005-02-18 13:48:18,419 INFO mmbase.module.core.MMBase - Starting > builder : typerel > 2005-02-18 13:48:18,449 INFO mmbase.module.core.MMBase - Starting > builder : oalias > 2005-02-18 13:48:18,469 SERVICE org.mmbase.cache.Cache - > Creating cache > AliasCache: Cache for node aliases > 2005-02-18 13:48:18,469 SERVICE org.mmbase.cache.Cache - Setting > AliasCache active with size 128 > 2005-02-18 13:48:18,479 SERVICE mmbase.module.core.MMBase - > Reading all > builders of directory > D:\deploy\jakarta-tomcat-5.0.28\webapps\mmbase173.harald\WEB-I > NF\config\builders > 2005-02-18 13:48:18,479 SERVICE mmbase.module.core.MMBase - > Reading all > builders of directory > D:\deploy\jakarta-tomcat-5.0.28\webapps\mmbase173.harald\WEB-I > NF\config\builders\core > 2005-02-18 13:48:18,489 INFO mmbase.module.core.MMBase - Starting > builder : daymarks > 2005-02-18 13:48:18,549 INFO mmbase.module.core.MMBase - Starting > builder : mmservers > 2005-02-18 13:48:18,589 INFO mmbase.module.core.MMBase - Starting > builder : syncnodes > 2005-02-18 13:48:18,629 INFO mmbase.module.core.MMBase - Starting > builder : versions > 2005-02-18 13:48:18,739 SERVICE mmbase.module.core.MMBase - > Initializing > storage: > 2005-02-18 13:48:18,739 SERVICE mmbase.module.core.MMBase - > Initializing > storage > 2005-02-18 13:48:18,859 SERVICE > storage.implementation.database.DatabaseStorageManagerFactory - No > data-source configured, using Generic data source > 2005-02-18 13:48:18,869 SERVICE > storage.implementation.database.DatabaseStorageManagerFactory - > Connecting to catalog with name mmbase > 2005-02-18 13:48:18,899 SERVICE > storage.implementation.database.DatabaseStorageManagerFactory > - Use for > storage configuration > :/org/mmbase/storage/implementation/database/resources/MSSQL.xml > 2005-02-18 13:48:18,929 ERROR org.mmbase.module.Module - > startModules(): module([EMAIL PROTECTED]) > not found > to 'init'!: class java.lang.RuntimeException: failure reading > document: null > java.net.MalformedURLException > 2005-02-18 13:48:18,929 ERROR org.mmbase.module.Module - > java.lang.RuntimeException: failure reading document: null > java.net.MalformedURLException > at > org.mmbase.util.xml.DocumentReader.<init>(DocumentReader.java:165) > at > org.mmbase.storage.util.StorageReader.<init>(StorageReader.java:64) > at > org.mmbase.storage.implementation.database.DatabaseStorageMana > gerFactory.getDocumentReader(DatabaseStorageManagerFactory.java:259) > at > org.mmbase.storage.StorageManagerFactory.load(StorageManagerFa > ctory.java:201) > at > org.mmbase.storage.implementation.database.DatabaseStorageMana > gerFactory.load(DatabaseStorageManagerFactory.java:206) > at > org.mmbase.storage.StorageManagerFactory.init(StorageManagerFa > ctory.java:144) > at > org.mmbase.storage.StorageManagerFactory.newInstance(StorageMa > nagerFactory.java:107) > at > org.mmbase.module.core.MMBase.initializeStorage(MMBase.java:1402) > at org.mmbase.module.core.MMBase.init(MMBase.java:386) > at org.mmbase.module.Module.startModule(Module.java:79) > at org.mmbase.module.Module.startModules(Module.java:281) > at org.mmbase.module.Module.getModule(Module.java:326) > at org.mmbase.module.core.MMBase.getMMBase(MMBase.java:609) > at > org.mmbase.servlet.MMBaseStartThread.run(MMBaseStartThread.java:40) > 2005-02-18 13:48:18,939 SERVICE org.mmbase.module.ModuleProbe > - Starting > main thread of ModuleProbe > class org.mmbase.module.Module > 2005-02-18 13:48:18,939 SERVICE mmbase.module.core.MMBase - Init of > MMBase 1.7.3-final ([EMAIL PROTECTED]) > 2005-02-18 13:48:18,939 INFO mmbase.module.core.MMBase - MMBase > default locale : nl > 2005-02-18 13:48:18,939 SERVICE mmbase.module.core.MMBase - > Reading all > builders of directory > D:\deploy\jakarta-tomcat-5.0.28\webapps\mmbase173.harald\WEB-I > NF\config\builders > 2005-02-18 13:48:18,939 SERVICE mmbase.module.core.MMBase - > Reading all > builders of directory > D:\deploy\jakarta-tomcat-5.0.28\webapps\mmbase173.harald\WEB-I > NF\config\builders\core > 2005-02-18 13:48:18,939 SERVICE mmbase.module.core.MMBase - > Initializing > storage: > 2005-02-18 13:48:18,939 SERVICE mmbase.module.core.MMBase - > Initializing > storage > 2005-02-18 13:48:18,939 SERVICE > storage.implementation.database.DatabaseStorageManagerFactory - No > data-source configured, using Generic data source > 2005-02-18 13:48:18,939 SERVICE > storage.implementation.database.DatabaseStorageManagerFactory - > Connecting to catalog with name mmbase > 2005-02-18 13:48:18,949 SERVICE > storage.implementation.database.DatabaseStorageManagerFactory > - Use for > storage configuration > :/org/mmbase/storage/implementation/database/resources/MSSQL.xml > 2005-02-18 13:48:18,959 FATAL > org.mmbase.servlet.MMBaseStartThread - > Could not find the MMBase module!failure reading document: null > java.net.MalformedURLException > 2005-02-18 13:48:18,959 INFO org.mmbase.servlet.MMBaseServlet - > MMBase servlets are ready to receive requests > > *** > _______________________________________________ > Developers mailing list > Developers@lists.mmbase.org > http://lists.mmbase.org/mailman/listinfo/developers > _______________________________________________ Developers mailing list Developers@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/developers