PortletPreferences and Oracle

[tgoodyear]

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

[roy.russo]

http://www.jboss.com/index.html?module=bb&op=viewtopic&t=62647

Versions?

[tgoodyear]

Sorry forgot the versions.

Oracle 9.2.0.6.0

Red Hat 3.0

JBOSS AS 4.0.3 SP1

JBoss Portal 2.2.1

[roy.russo]

1. User preferences for non-logged-in users are stored in the individual portletsessions.

2. I'm not sure how you're testing the problem with user pref persistence. Could you use the weatherportlet or some portlet we have in common to test this? You can find the RSSNews and Weatherportlet at portletswap.com

I have not tested on ora9, but ora 10gxe.