[#UP-849] RDBMPortletPreferencesStore doesn't support MS-SQL

uPortal

RDBMPortletPreferencesStore doesn't support MS-SQL

Created: 25/Feb/05 01:50 PM Updated: 03/Jul/07 04:10 PM

Component/s:

Database

Affects Version/s:

2.4.1, 2.4.2

Fix Version/s:

2.4.3

Original Estimate:

Unknown

Remaining Estimate:

Unknown

Time Spent:

Unknown

File Attachments:

UP-849_patch.txt (1 kb)

Environment:

MS-SQL Server, Tomcat 5.5, Windows

Issue Links:

Generic Relation

This issue relates to:
	~~UP-1039~~ 2.5: RDBMPortletPreferencesStore does...
	~~UP-1158~~ o.j.p.layout.dlm.RDBMDistributedLayou...

Description

« Hide

When trying to render portlets using the MS-SQL JDBC driver I get this error and stacktrace in the portlet window (this is for Test Portlet 1 but it happens for all the "out-of-the box" portlets):
Channel ID:
15-3

Message:
IChannelRenderer.completeRendering() threw

Error type:
Channel failed to render (code 1)

Problem type:

Error message
Initialization of the portlet container failed. [based on exception: Could not load portlet definition preferences: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 2.]

Inner exception:

java.io.IOException: Could not load portlet definition preferences: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 2.
at org.jasig.portal.container.om.portlet.PortletDefinitionImpl.loadPreferences(PortletDefinitionImpl.java:218)
at org.jasig.portal.channels.portlet.CPortletAdapter.initPortletWindow(CPortletAdapter.java:220)
at org.jasig.portal.channels.portlet.CPortletAdapter.renderCharacters(CPortletAdapter.java:476)
at org.jasig.portal.MultithreadedCharacterChannelAdapter.renderCharacters(MultithreadedCharacterChannelAdapter.java:71)
at org.jasig.portal.ChannelRenderer$Worker.run(ChannelRenderer.java:486)
at org.jasig.portal.utils.threading.Worker.run(Worker.java:88)

Outer exception:

java.io.IOException: Could not load portlet definition preferences: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 2.
at org.jasig.portal.container.om.portlet.PortletDefinitionImpl.loadPreferences(PortletDefinitionImpl.java:218)
at org.jasig.portal.channels.portlet.CPortletAdapter.initPortletWindow(CPortletAdapter.java:220)
at org.jasig.portal.channels.portlet.CPortletAdapter.renderCharacters(CPortletAdapter.java:476)
at org.jasig.portal.MultithreadedCharacterChannelAdapter.renderCharacters(MultithreadedCharacterChannelAdapter.java:71)
at org.jasig.portal.ChannelRenderer$Worker.run(ChannelRenderer.java:486)
at org.jasig.portal.utils.threading.Worker.run(Worker.java:88)

Description

When trying to render portlets using the MS-SQL JDBC driver I get this error and stacktrace in the portlet window (this is for Test Portlet 1 but it happens for all the "out-of-the box" portlets): Channel ID: 15-3 Message: IChannelRenderer.completeRendering() threw Error type: Channel failed to render (code 1) Problem type: Error message Initialization of the portlet container failed. [based on exception: Could not load portlet definition preferences: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 2.] Inner exception: java.io.IOException: Could not load portlet definition preferences: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 2. at org.jasig.portal.container.om.portlet.PortletDefinitionImpl.loadPreferences(PortletDefinitionImpl.java:218) at org.jasig.portal.channels.portlet.CPortletAdapter.initPortletWindow(CPortletAdapter.java:220) at org.jasig.portal.channels.portlet.CPortletAdapter.renderCharacters(CPortletAdapter.java:476) at org.jasig.portal.MultithreadedCharacterChannelAdapter.renderCharacters(MultithreadedCharacterChannelAdapter.java:71) at org.jasig.portal.ChannelRenderer$Worker.run(ChannelRenderer.java:486) at org.jasig.portal.utils.threading.Worker.run(Worker.java:88) Outer exception: java.io.IOException: Could not load portlet definition preferences: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 2. at org.jasig.portal.container.om.portlet.PortletDefinitionImpl.loadPreferences(PortletDefinitionImpl.java:218) at org.jasig.portal.channels.portlet.CPortletAdapter.initPortletWindow(CPortletAdapter.java:220) at org.jasig.portal.channels.portlet.CPortletAdapter.renderCharacters(CPortletAdapter.java:476) at org.jasig.portal.MultithreadedCharacterChannelAdapter.renderCharacters(MultithreadedCharacterChannelAdapter.java:71) at org.jasig.portal.ChannelRenderer$Worker.run(ChannelRenderer.java:486) at org.jasig.portal.utils.threading.Worker.run(Worker.java:88)

Show »

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

Elliot Metsger [25/Feb/05 01:51 PM]

[ Permlink | « Hide ]

Elliot Metsger [25/Feb/05 01:52 PM]

I will try submit a patch for this issue if I can dig into and learn the code -

[ Permlink | « Hide ]

Elliot Metsger [25/Feb/05 03:28 PM]

I'm sorry - this issue affects uPortal 2.4.1 not 2.4.2 (I got my versions crossed - we don't have 2.4.2 running yet on the windows platform). I don't have permissions to edit the issue but if one of the admins could that wouuld be great. Thanks -

[ Permlink | « Hide ]

Elliot Metsger [25/Feb/05 11:22 PM]

Here is a patch, untested! We will try to get this tested ASAP, but it is the weekend.

FYI I think both uPortal 2.4.1 and uPortal 2.4.2 share this error since org/jasig/portal/RDBMPortletPreferencesStore.java has the same version id in both CVS tags.

[ Permlink | « Hide ]

Elliot Metsger [16/Mar/05 03:20 PM]

This patch has been tested and it works....

[ Permlink | « Hide ]

Andrew Petro [03/May/05 10:10 AM]

The bug identified in ~~UP-849~~ as applying to 2-4-patches also applies to the HEAD and needs to be resolved for uPortal 2.5.

[ Permlink | « Hide ]

Elliot Metsger [12/Jul/05 12:06 AM]

Same exception seen in other RDBM-related classes for UPortal 2.4 and 2.5.

[ Permlink | « Hide ]

Andrew Petro [15/Jul/05 06:35 PM]

Applied patch to 2-4-patches.