Hi Steve, I'll second what Joe said, we've been running on SQL Server for several years. We use a third-party jdbc driver called Merlia from a company called iNet because originally it was the only one that met our needs for failover, but the Microsoft v3 jdbc driver does it all now; jtds seems to be what a lot of people use. I very much get the impression that there's not much to choose from betwen MSSQL jdbc drivers.
The only issue we've encountered with SQL Server is that use of portlet preferences causes (lots of) deadlocks under load; there are a couple of recommended settings in the Jasig wiki about this, but they didn't solve the problem for us and we couldn't find a solution. Fortunately we only had a couple of portlets that rely on portlet preferences, so we just wrote our own preferences persistence code and use that instead. If you experience this, it could be a problem if you use lots of off-the-shelf portlets. Also, I tried to deploy uPortal using Amazon Webservices, and found that their RDS (Relational Database Service), which is based on MySQL, required case-sensitivity and didn't give the user the option to change it, which unfortunately meant I was unable to use that service. Of course, I could just run normal virtual machines and install any database I felt like, but it was a shame to miss out on some of the cloud integration that comes with RDS. Ta, Conan Cook Senior Applications Developer Academic Technologies Group (ATG) University of the West of England Frenchay Campus Bristol BS16 1QY Telephone: 01173 281 053 From: bounce-12873496-15797...@lists.wisc.edu [mailto:bounce-12873496-15797...@lists.wisc.edu] On Behalf Of Moore, William (Joe) Sent: 22 December 2010 14:45 To: uportal-dev@lists.ja-sig.org Subject: RE: [uportal-dev] converting all references to tables to uppercase I can answer the question about MS SQL. We've been running in production for several years. * There are a few places where the SQL syntax for concatenation needs to be changed in context files (files that are modified anyway in a normal implementation) * The pom entries need to be changed for jdbc * In our case, the jtds file needs to be manually installed into the local mvn repository * The entries in rdbm.properties need to be consistent with the above changes (of course) Each of these steps have been consistent since at least uPortal 2.6. I haven't yet taken them for 3.3, but I have no reason to think the jdbc portability will be a problem. I'm going to try to get that tested in the next few days. Joe Moore Assistant Director of MIS Administrative and Research Computing South Dakota State University SAD #123, Box 2201 Brookings, SD 57007 Phone: 605.688.4678 Fax: 605.688.4605 Email: joe.mo...@sdstate.edu [cid:image001.gif@01CBA1EC.C42A2040] From: bounce-12860286-23525...@lists.wisc.edu [mailto:bounce-12860286-23525...@lists.wisc.edu] On Behalf Of Steve Swinsburg Sent: Tuesday, December 21, 2010 10:03 PM To: uportal-dev@lists.ja-sig.org Subject: Re: [uportal-dev] converting all references to tables to uppercase >From reading the MySQL manual, it says we'd need to adjust every other >database and table as well. And apparently many other systems use this same >database server. "If you plan to set the lower_case_table_names<http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names> system variable to 1 on Unix, you must first convert your old database and table names to lowercase before stopping mysqld<http://dev.mysql.com/doc/refman/5.0/en/mysqld.html> and restarting it with the new variable setting." I've raised this with the db admins but it's not something they want to do. This is unfortunate, since a case insensitive setup is best practice for this exact reason. I'm pursuing alternatives. Does uPortal run ok on SQL Server? thanks, Steve ... rest of thread deleted for this message ... -- You are currently subscribed to uportal-dev@lists.ja-sig.org as: conan.c...@uwe.ac.uk To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev -- You are currently subscribed to uportal-dev@lists.ja-sig.org as: arch...@mail-archive.com To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev
<<inline: image001.gif>>