uPortal IRC Logs-2014-01-17

Owned by Apereo Infrastructure
Last updated: Jan 17, 2014
2 min read

[13:48:40 CST(-0600)] <apetro__> Anyone happen to have run Jasig/uPortal/master against an Oracle RDBMS lately?

[13:48:40 CST(-0600)] <apetro__> We've having problems here at Wisc in our predev environment (against an Oracle RDBMS) but not on local dev environments (against HSQL) in uw-master, which is our stuff wtih latest Jasig/uPortal/master merged in

[13:54:48 CST(-0600)] <jwennmacher> yes we just setup a client with Oracle 11 - at least to the point initdb works and you can log in and it looks OK. No performance testing or anything

[13:55:12 CST(-0600)] <jwennmacher> What are you seeing?

[13:56:32 CST(-0600)] <apetro__> unable to create portal cookie. ORA error wrt unable to find a function or procedure / table or view

[13:56:32 CST(-0600)] <apetro__> those are two different errors

[13:56:53 CST(-0600)] <jwennmacher> during initdb?

[13:56:57 CST(-0600)] <apetro__> think it's got something to do with upgrading from an existing database

[13:57:00 CST(-0600)] <apetro__> no. not running initdb

[13:57:17 CST(-0600)] <jwennmacher> we did not see either of those. This was a brand new install

[13:57:22 CST(-0600)] <apetro__> errors happen on db-update (which fails) and on attempt to login (not having a previously established portal cookie)

[13:58:06 CST(-0600)] <apetro__> currently cranking up Hibernate logging to get more of a clue of exactly what database objects not being found. Also provisioning up an Oracle user so as to test vanilla uPortal upgrade against Oracle (without the accumulated wisconsin-local data and code (smile) )

[13:58:26 CST(-0600)] <jwennmacher> fun fun ... (smile)

[17:31:50 CST(-0600)] <vertein> @jwennmacher, question about the auto completion

[17:32:10 CST(-0600)] <vertein> I Just started looking at the code

[17:32:27 CST(-0600)] <vertein> what is the auto completion feature all about

[17:38:22 CST(-0600)] <tlev> We found the issue with oracle. we were not using the filtering for the database configuration, instead just overlaying on rdbm.properties. That worked fine until our last merge of master where persistence.xml was introduced into the filtering. So basically it was trying to use hsql dialect to talk to an oracle database. It worked pretty well until you tried to get a sequence next val.