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@01CBA1B4.613C7B50] 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: 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>>
