uPortal IRC Logs-2011-06-28

Owned by Apereo Infrastructure
Last updated: Jun 28, 2011Version comment
3 min read

[11:08:10 CDT(-0500)] <athena> EricDalquist: any thoughts about the database stuff?
[11:08:15 CDT(-0500)] <EricDalquist> yeah
[11:08:19 CDT(-0500)] <EricDalquist> stupid error on my part
[11:08:21 CDT(-0500)] <EricDalquist> getting it fixed now
[11:09:07 CDT(-0500)] <athena> ok (smile)
[11:09:10 CDT(-0500)] <athena> no worries
[11:09:19 CDT(-0500)] <athena> wound up reverting those patches for now
[11:09:40 CDT(-0500)] <EricDalquist> also got an answer from the hsqldb devs about my problems
[11:09:45 CDT(-0500)] <EricDalquist> so testing their suggestions now
[11:10:17 CDT(-0500)] <athena> oh awesome
[11:11:42 CDT(-0500)] <EricDalquist> yup their fix worked
[11:11:58 CDT(-0500)] <EricDalquist> so apparently hsqldb 2.2 does not support external pooling of prepared statements
[11:17:33 CDT(-0500)] <athena> oh, huh
[11:17:52 CDT(-0500)] <EricDalquist> so disabling statement pooling in dbcp makes it work
[11:18:21 CDT(-0500)] <athena> ah
[11:18:30 CDT(-0500)] <athena> suppose we're not going to run hsql in prod anyway
[11:18:33 CDT(-0500)] <EricDalquist> yeah
[11:18:44 CDT(-0500)] <EricDalquist> just annoying that we can't default that setting to true
[11:19:13 CDT(-0500)] <EricDalquist> though I had talked with steveS about building a catalog of validation queries based on hibernate dialects
[11:19:25 CDT(-0500)] <EricDalquist> we could do the same for the statement pooling flag
[11:21:17 CDT(-0500)] <athena> yeah
[11:21:19 CDT(-0500)] <athena> that'd be nice
[11:32:48 CDT(-0500)] <EricDalquist> ok athena the db fixes are in
[11:32:55 CDT(-0500)] <athena> ok
[11:33:14 CDT(-0500)] <athena> will test in a bit - getting ready for a meeting
[11:33:25 CDT(-0500)] <athena> though . . . maybe i can sneak it in before then
[11:33:27 CDT(-0500)] <athena> we'll see (smile)
[11:33:40 CDT(-0500)] <EricDalquist> no problem
[11:33:53 CDT(-0500)] <EricDalquist> I'm thinking about setting up an ubuntu vm with postgtres and mysql on it
[11:33:56 CDT(-0500)] <EricDalquist> so I can test
[11:34:28 CDT(-0500)] <athena> oh nice (smile)
[11:34:33 CDT(-0500)] <athena> what os are you running now?
[11:34:41 CDT(-0500)] <EricDalquist> I'm running ubuntu
[11:34:46 CDT(-0500)] <athena> ah
[11:34:48 CDT(-0500)] <athena> just a clean one?
[11:34:54 CDT(-0500)] <EricDalquist> but I don't feel like installing a bunch of DBs in my main OS
[11:34:58 CDT(-0500)] <athena> gotcha
[11:35:05 CDT(-0500)] <athena> i eventually installed both psql and mysql on my mac
[11:35:08 CDT(-0500)] <athena> wasn't too big of a deal
[11:35:13 CDT(-0500)] <EricDalquist> plus VB provides pre-installed images: http://virtualboxes.org/images/ubuntu/#ubuntu1104
[11:35:14 CDT(-0500)] <EricDalquist> (smile)
[11:35:52 CDT(-0500)] <athena> nice (smile)
[12:32:44 CDT(-0500)] <athena> hey EricDalquist - did you get a chance to create the manual space for laura? looks like i don't have permisisons for it
[12:32:50 CDT(-0500)] <EricDalquist> oh no
[12:32:59 CDT(-0500)] <EricDalquist> I'll take a look at that soon
[12:33:03 CDT(-0500)] <athena> oh thanks (smile)
[12:33:06 CDT(-0500)] <athena> about to test the psql stuff
[12:33:09 CDT(-0500)] <EricDalquist> thanks
[13:06:53 CDT(-0500)] <athena> Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [org.jasig.portal.portlet.dao.jpa.PortletDefinitionImpl]; SQL [insert into UP_PORTLET_DEF (PORTLET_APVL_DT, PORTLET_APVL_ID, PORTLET_DESC, ENTITY_VERSION, PORTLET_EXP_DT, PORTLET_EXP_ID, PORTLET_FNAME, PORTLET_NAME, PORTLET_FRAMEWORK, PORTLET_APPLICATION_NAME, PORTLET_WEBAPP_NAME, PORTLET_PREFS_ID, PORTLET_TYPE_ID, PORTLET_PUBL_DT, PORTLET_PUBL_ID
[13:07:06 CDT(-0500)] <athena> also an error in the CAS tests
[13:07:28 CDT(-0500)] <athena> let me track the first down
[13:07:31 CDT(-0500)] <EricDalquist> ok
[13:07:51 CDT(-0500)] <EricDalquist> I did just find about a dozen column names that are using reserved keywords
[13:07:58 CDT(-0500)] <EricDalquist> so I'm going to have to change all of those too
[13:08:03 CDT(-0500)] <athena> ah
[13:08:07 CDT(-0500)] <EricDalquist> brb
[13:18:19 CDT(-0500)] <athena> ok, got around that first error
[13:18:47 CDT(-0500)] <athena> now back to this: http://pastebin.com/ikmudYr2
[13:18:52 CDT(-0500)] <athena> which i believe we saw a while ago
[13:19:13 CDT(-0500)] <EricDalquist> yup
[13:19:28 CDT(-0500)] <EricDalquist> ok I'm close to having pgsql installed
[13:19:31 CDT(-0500)] <athena> ok
[13:19:37 CDT(-0500)] <EricDalquist> and then I can do both oracle and postgres clob testing
[13:19:42 CDT(-0500)] <athena> ok, great
[13:19:54 CDT(-0500)] <EricDalquist> grr
[13:20:02 CDT(-0500)] <athena> i do very much have to have up-trunk installed and running well in advance of tomorrow's coop dev summit because i need to demo
[13:20:05 CDT(-0500)] <EricDalquist> xcode 3.2.4 is failing to install for me (sad)
[13:20:18 CDT(-0500)] <EricDalquist> ok
[13:20:19 CDT(-0500)] <athena> so i can help with testing for a few hours more, but after that i'll have to revert
[13:20:22 CDT(-0500)] <athena> oh no (sad)
[13:20:26 CDT(-0500)] <EricDalquist> that's fine
[13:20:40 CDT(-0500)] <athena> man let me tell you how well trying to download xcode from the sakai conference did not go
[13:20:47 CDT(-0500)] <athena> file or two didn't get restored from backup
[13:20:48 CDT(-0500)] <EricDalquist> hah
[13:20:53 CDT(-0500)] <athena> and suddenly i couldn't demo umobile anymore
[13:20:54 CDT(-0500)] <athena> (neat)