3 Replies Latest reply on May 2, 2006 9:07 PM by Roy Russo

    PortletPreferences and Oracle

    Todd Goodyear Newbie

      Currently have JBOSS portal pointing to an Oracle database.

      When trying to set portletpreferences if the user is not logged then settings are stored in session cookie but if the user is logged in then I am unable to get the preferences to store. I don't get any exceptions. The remoteuser is set the the correct username and the same user exists in JBP_User table and in the JBP_ROLE_MEMBERSHIP as a user role.

      Anything special I need to support ORACLE.

      The portal-oracle-ds.xml looks like:

      <?xml version="1.0" encoding="UTF-8"?>

      <local-tx-datasource>
      <jndi-name>PortalDS</jndi-name>
      <connection-url>jdbc:oracle:thin:jbossportal/jbossportal@dbserver:1526:dev</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>jboss</user-name>
      jboss
      </local-tx-datasource>


      In mySql the following is required for it to work
      ?useServerPrepStmts=false&amp;jdbcCompliantTruncation=false

      but not sure if this matters on Oracle or if it has similar settings.

      Also is there any way to have the preferences saved in a persisted cookie for non-logged in users.

      Thanks
      Todd