Hi all, Thanks for the useful information. We are pursuing an alternative MySQL setup (case insensitive!) since we are on a tight timeframe for rollout next year, but it is good to know about MS SQL as we also have that experience with our other enterprise systems.
cheers, Steve On 23/12/2010, at 2:33 AM, Conan Cook wrote: > 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: [email protected] > [mailto:[email protected]] On Behalf Of Moore, William > (Joe) > Sent: 22 December 2010 14:45 > To: [email protected] > 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: [email protected] > <image001.gif> > > From: [email protected] > [mailto:[email protected]] On Behalf Of Steve Swinsburg > Sent: Tuesday, December 21, 2010 10:03 PM > To: [email protected] > 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 system variable to 1 on Unix, > you must first convert your old database and table names to lowercase before > stopping mysqld 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 [email protected] as: > [email protected] > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/uportal-dev > -- > > You are currently subscribed to [email protected] as: > [email protected] > To unsubscribe, change settings or access archives, see > http://www.ja-sig.org/wiki/display/JSG/uportal-dev -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev
