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]> 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]>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 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 > > > -- 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
