We are running uP 4.0.6 with a database schema. Though, I am not sure what the sessions per user limit is set to.
Laura On 2/14/13 11:20 AM, Xin Feng wrote: > Thanks a lot. It did fix my problem. I only need step 2. step 1 is > getting the dialect from filters/local.properties. > > However I ran to other problem as, > Caused by: java.sql.SQLException: ORA-02391: exceeded simultaneous > SESSIONS_PER_USER limit > > In order to run uPortal-4.0.10, we already increase the > SESSIONS_PER_USER limit from 20 to 40. > > What's the proper setting for SESSIONS_PER_USER limit in order to run > uPortal-4.0.10 including cas and delivered portlets? > > Other question would be that do you use a single database for uPortal > or a schema ( shared with other schemas) in the database . > > Thanks, > Xin > > > On Thu, Feb 14, 2013 at 10:32 AM, Laura McCord <[email protected] > <mailto:[email protected]>> wrote: > > Right, I had to use org.hibernate.dialect.Oracle10gDialect. > > In fact, I used the attached email thread to fix the > WebProxyPortlet: > > http://jasig.275507.n4.nabble.com/WebProxyPortlet-does-not-start-in-uP-4-0-8-td4657403.html > > In summary, there were 2 places I had to fix in WebProxyPortlet: > > 1) > > uportal-portlets-overlay/WebProxyPortlet/src/main/webapp/WEB-INF/datasource.properties > I manually added the dialect here > > 2) > > uportal-portlets-overlay/WebProxyPortlet/src/main/webapp/WEB-INF/applicationContextOverrides.xml > > I commented out the jpaVendorAdaptor bean > > Those steps seemed to get rid of the hibernate exception. > > Laura > > > > > On 2/14/13 9:22 AM, Xin Feng wrote: >> Hi Laura, >> >> Thanks. What did you use for >> "environment.build.hibernate.dialect " ? >> >> I used >> >> <jdbc.groupId>com.oracle</jdbc.groupId> >> <jdbc.artifactId>ojdbc6</jdbc.artifactId> >> <jdbc.version>11.2.0.3 </jdbc.version> >> >> with >> >> >> environment.build.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect >> >> uPortal seems working, but WebProxyPortlet failed as following: >> >> Caused by: org.hibernate.HibernateException: unknown Oracle major >> version [11] >> >> And we are heavily using WebProxyPortlet . >> >> Thanks, >> Xin >> >> On Thu, Feb 14, 2013 at 10:01 AM, Laura McCord >> <[email protected] <mailto:[email protected]>> wrote: >> >> Hi Xin, >> >> I used the following driver configuration for Oracle 11g and >> it works. >> >> <jdbc.groupId>com.oracle</jdbc.groupId> >> <jdbc.artifactId>ojdbc6_g</jdbc.artifactId> >> <jdbc.version>11.2.0.3</jdbc.version> >> >> -Laura >> >> >> On 2/14/13 8:56 AM, Xin Feng wrote: >>> Hi, >>> >>> What version of Oracle JDBC driver should be used with >>> Oracle 11g Database? >>> >>> Have anyone tried with Oracle on Exadata? >>> >>> Thanks, >>> Xin >>> -- >>> >>> You are currently subscribed [email protected] >>> <mailto:[email protected]> as:[email protected] >>> <mailto:[email protected]> >>> To unsubscribe, change settings or access archives, >>> seehttp://www.ja-sig.org/wiki/display/JSG/uportal-dev >> >> -- >> >> You are currently subscribed [email protected] >> <mailto:[email protected]> as:[email protected] >> <mailto:[email protected]> >> To unsubscribe, change settings or access archives, >> seehttp://www.ja-sig.org/wiki/display/JSG/uportal-dev >> >> >> -- >> >> You are currently subscribed [email protected] >> <mailto:[email protected]> as:[email protected] >> <mailto:[email protected]> >> To unsubscribe, change settings or access archives, >> seehttp://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
