It's doesn't work perhaps because you don't give to the system the databasename torque.dsfactory.default.connection.url = jdbc:microsoft:sqlserver://MERCURY:1433;databasename=<Name of the database>
----- Original Message ----- From: "Jeff Peake" <[EMAIL PROTECTED]> To: "'Jetspeed Users List'" <[EMAIL PROTECTED]> Sent: Sunday, March 23, 2003 2:33 AM Subject: RE: Unable to get PSML database working Just and FYI if anyone else has this problem. I changed the "Profile" column from datatype "Binary", to "Text" in the Jetspeed_xxx_Profile tables and all is working well. Jeff Peake -----Original Message----- From: Jeff Peake [mailto:[EMAIL PROTECTED] Sent: Saturday, March 22, 2003 2:14 AM To: [EMAIL PROTECTED] Subject: Unable to get PSML database working I am using JetSpeed 1.4b3, Tomcat 4.1.18, with SQL Server 2000 Developer. I can get the User database working just fine. I am trying to now get the PSML database working. I have set up the Torque.properties file, and run "ant import". No problems there. When I try to load up the site, I get the error: Error retrieving Portal Page: Profile not found. This is for the ANON user, when I login with any of my other users I get the same error. In the jetspeed.log, I see: [22 Mar 2003 02:00:27 DEBUG] - Profiler: fallback called with: BaseProfile[anon/en/US/html/default.psml] [22 Mar 2003 02:00:27 INFO] - Start Initializing service (late): PsmlManager [22 Mar 2003 02:00:27 INFO] - Finish Initializing service (late): PsmlManager [22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService: Returning locator string: User:anon$Page:default.psml$MediaType:html$Country:US$Language:en [22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService: Returning locator string: User:anon$Page:default.psml$MediaType:html$Country:US$Language:en [22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService.refresh: no document found: profile: User:anon$Page:default.psml$MediaType:htmlCountry:USLanguage:en [22 Mar 2003 02:00:27 DEBUG] - DatabasePsmlManagerService: Returning locator string: User:anon$Page:default.psml$MediaType:html$Language:en [22 Mar 2003 02:00:27 ERROR] - PSMLManager: Could not unmarshal the inputstream org.xml.sax.SAXParseException: Content is not allowed in trailing section. at org.apache.xerces.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:118 9) 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.refre sh(DatabasePsmlManagerService.java:983) at org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.getDo cument(DatabasePsmlManagerService.java:589) at org.apache.jetspeed.services.PsmlManager.getDocument(PsmlManager.java:110) at org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallback(Jetsp eedProfilerService.java:767) at org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfil e(JetspeedProfilerService.java:550) at org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(Jet speedProfilerService.java:293) at org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(Jet speedProfilerService.java:585) In my tomcat window I get several: [Fatal Error] :2:2654: Content is not allowed in trailing section. I am using the Microsoft JDBC driver, have also tried the jTDS driver with the same results. Have also tried running a nightly release of JetSpeed...still get the same error. My Torque.prop file: <...snip...> torque.database.default.adapter=mssql torque.dsfactory.default.pool.defaultMaxConnections=10 torque.dsfactory.default.pool.maxExpiryTime=3600 torque.dsfactory.default.pool.connectionWaitTimeout=10 torque.dsfactory.default.connection.driver = com.microsoft.jdbc.sqlserver.SQLServerDriver torque.dsfactory.default.connection.url = jdbc:microsoft:sqlserver://MERCURY:1433 torque.dsfactory.default.connection.user = jetspeed torque.dsfactory.default.connection.password = jetspeed <...snip...> I have verified that there are entries in the "JETSPEED_USER_PROFILE" table. Can anyone help??? Thanks Jeff Peake --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
