Thanks for your quick answer.
Yes I'm trying to create the MSSQL connection. Can you tell me who want also connect to this database?
Thanks Harald.
> 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: [email protected] >> 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 >> [email protected] >> http://lists.mmbase.org/mailman/listinfo/developers >> _______________________________________________ Developers mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/developers
