Jetspeed PSML User db - MS SQL SERVER doesn't work

[Sandeep Dixit <sd...@ohioedge.com>]

I am getting unmarshal exception as the following when trying to use
Jetspeed PSML database with MS SQL SERVER 2000. Any help would be
appreciated.

2003-08-12 17:55:05,622 INFO  [STDOUT] 227104 [PoolThread-9] DEBUG
org.apache.torque.util.BasePeer  - SELECT JETSPEED_ROLE_PROFILE.PSML_ID,
JETSPEED_ROLE_PROFILE.ROLE_NAME, JETSPEED_ROLE_PROFILE.MEDIA_TYPE,
JETSPEED_ROLE_PROFILE.LANGUAGE, JETSPEED_ROLE_PROFILE.COUNTRY,
JETSPEED_ROLE_PROFILE.PAGE, JETSPEED_ROLE_PROFILE.PROFILE FROM
JETSPEED_ROLE_PROFILE WHERE JETSPEED_ROLE_PROFILE.LANGUAGE IS NULL  AND
JETSPEED_ROLE_PROFILE.ROLE_NAME='admin' AND
JETSPEED_ROLE_PROFILE.PAGE='default.psml' AND
JETSPEED_ROLE_PROFILE.COUNTRY IS NULL  AND
JETSPEED_ROLE_PROFILE.MEDIA_TYPE='html'
2003-08-12 17:55:05,642 DEBUG [org.apache.torque.util.BasePeer] Elapsed
time=10 ms
2003-08-12 17:55:05,642 INFO  [STDOUT] 227124 [PoolThread-9] DEBUG
org.apache.torque.util.BasePeer  - Elapsed time=10 ms
2003-08-12 17:55:05,722 ERROR [STDERR] [Fatal Error] :1:1: Content is not
allowed in prolog.
2003-08-12 17:55:05,742 INFO  [STDOUT] 227204 [PoolThread-9] ERROR STDERR 
- [Fatal Error] :1:1: Content is not allowed in prolog.
2003-08-12 17:55:05,742 INFO  [STDOUT] [Tue Aug 12 17:55:05 MDT 2003] --
ERROR -- PSMLManager: Could not unmarshal the inputstream
	Exception:  org.xml.sax.SAXParseException: Content is not allowed in
prolog.{file: [not available]; line: 1; column: 1}
	Stack Trace follows:
	org.xml.sax.SAXParseException: Content is not allowed in prolog.
	at
org.apache.xerces.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1162)
	at org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:338)
	at org.exolab.castor.xml.Unmarshaller.unmarshal(Unmarshaller.java:270)
	at
org.apache.jetspeed.services.psmlmanager.db.DBUtils.bytesToPortlets(DBUtils.java:100)
	at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.refresh(DatabasePsmlManagerService.java:996)
	at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.getDocument(DatabasePsmlManagerService.java:589)
	at
org.apache.jetspeed.services.PsmlManager.getDocument(PsmlManager.java:110)
	at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallback(JetspeedProfilerService.java:776)
	at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfile(JetspeedProfilerService.java:550)
	at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(JetspeedProfilerService.java:310)
	at
org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(JetspeedProfilerService.java:585)
	at org.apache.jetspeed.services.Profiler.getProfile(Profiler.java:126)
	at
org.apache.jetspeed.modules.actions.JetspeedAccessController.doPerform(JetspeedAccessController.java:99)
	at org.apache.turbine.modules.Action.perform(Action.java:87)
	at org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
	at org.apache.turbine.Turbine.doGet(Turbine.java:529)
	at org.apache.turbine.Turbine.doPost(Turbine.java:658)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360)
	at
org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294)
	at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558)
	at org.mortbay.http.HttpContext.handle(HttpContext.java:1714)
	at
org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:507)
	at org.mortbay.http.HttpContext.handle(HttpContext.java:1664)
	at org.mortbay.http.HttpServer.service(HttpServer.java:863)
	at org.jboss.jetty.Jetty.service(Jetty.java:460)
	at org.mortbay.http.HttpConnection.service(HttpConnection.java:775)
	at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939)
	at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792)
	at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201)
	at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289)
	at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:455)