Re: [uportal-dev] uPortal-4.0.10 with Oracle 11g Database Exadata

[Eric Dalquist]

Replied on uportal-user email list.

-Eric

On 2/14/13 4:42 PM, Laura McCord wrote:

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,








Thanks,
Xin

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 . On Thu, Feb 14, 2013 at 10:32 AM, Laura McCord <lmcc...@ucmerced.edu <mailto:lmcc...@ucmerced.edu>> 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
    <lmcc...@ucmerced.edu <mailto:lmcc...@ucmerced.edu>> 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 touportal-...@lists.ja-sig.org  
<mailto:uportal-dev@lists.ja-sig.org>  as:lmcc...@ucmerced.edu  
<mailto:lmcc...@ucmerced.edu>
        To unsubscribe, change settings or access archives, 
seehttp://www.ja-sig.org/wiki/display/JSG/uportal-dev

--

        You are currently subscribed touportal-...@lists.ja-sig.org  
<mailto:uportal-dev@lists.ja-sig.org>  as:xinf...@umich.edu  
<mailto:xinf...@umich.edu>
        To unsubscribe, change settings or access archives, 
seehttp://www.ja-sig.org/wiki/display/JSG/uportal-dev



    You are currently subscribed touportal-...@lists.ja-sig.org  
<mailto:uportal-dev@lists.ja-sig.org>  as:lmcc...@ucmerced.edu  
<mailto:lmcc...@ucmerced.edu>
    To unsubscribe, change settings or access archives, 
seehttp://www.ja-sig.org/wiki/display/JSG/uportal-dev

-- --

--

You are currently subscribed to uportal-dev@lists.ja-sig.org as: 
eric.dalqu...@doit.wisc.edu
To unsubscribe, change settings or access archives, see 
http://www.ja-sig.org/wiki/display/JSG/uportal-dev

smime.p7s
Description: S/MIME Cryptographic Signature