How to get SQL query data in Data Multiselect CCE?

Sheetal_Bhavsar

I want to get the output of this query as the list of options in the data on the left pane on Data Multiselect Widget.

Query:

select <COLUMN_A> from  <TABLE_NAME> where CTD_XML_NM ='TaxYearData'

Configurations of the multiselect are as:

• Data Management tab:

Reference data: Java Class    value: com.vignette.wcm.widgets.base.referencedata.SQLReferenceDataImpl

• Presentation Tab:

Rendering Override: JSP   value: /vgn-wcm-up/secure/widgets/wcmdatamultiselect/wcmdatamultiselectrender.jsp

• Miscallenous Tab:

Data set as:

<properties>
<sql>
select TITLE_TXT from  HRB_CONTENT_ARTICLE where CTD_XML_NM ='TaxYearData'
</sql>
</properties>

 

Now when I create a CI for this CTD, the Multi select Widget does not error and throws this error on the CIF:

(error rendering wcmrelatorrender.jsp, see logs):java.lang.ClassCastException: weblogic.jndi.internal.WLEventContextImpl
java.lang.ClassCastException: weblogic.jndi.internal.WLEventContextImpl

 

Have i done anything wrong. Would be great help If i get to know one real example with the usage of SQLReferenceDataImpl

 

Thanks,

Sheetal.

 

Dexter_Ellingson

We use SQLReferenceDataImpl with Data Select CCE widgets. In theMiscellaneous tab, we have a element around our query. In otherwords, our xml looks like this: vignette.jdbc.VgnNonTxDataSource select ... from ... where ... Try adding the element, and perhaps the element.That's the only major difference I see between your config and ours.From: "eLink Entry: Vignette V7 and V8 Web Content Management" To: "eLink Recipient" Date: 11/16/2010 10:03 AMSubject: How to get SQL query data in Data Multiselect CCE? How to get SQL query data in Posted by sheetal.bhavsar@hrblock.com Data Multiselect CCE? (Bhavsar, Sheetal) On 2010/11/16 10:58 I want to get the output of this query as the list of options in the data on the left pane on Data Multiselect Widget. Query: select from where CTD_XML_NM ='TaxYearData' Configurations of the multiselect are as: Data Management tab: Reference data: Java Class value: com.vignette.wcm.widgets.base.referencedata.SQLReferenceDataImpl Presentation Tab: Rendering Override: JSP value: /vgn-wcm-up/secure/widgets/wcmdatamultiselect/wcmdatamultiselectren der.jsp Miscallenous Tab: Data set as: select TITLE_TXT from HRB_CONTENT_ARTICLE where CTD_XML_NM ='TaxYearData' Now when I create a CI for this CTD, the Multi select Widget does not er! ror and throws this error on the CIF: (error rendering wcmrelatorrender.jsp, see logs):java.lang.ClassCastException: weblogic.jndi.internal.WLEventContextImpl java.lang.ClassCastException: weblogic.jndi.internal.WLEventContextImpl Have i done anything wrong. Would be great help If i get to know one real example with the usage of SQLReferenceDataImpl Thanks, Sheetal. [To post a comment, use the normal reply function] Forum: Vignette V7 and V8 Web Content Management Livelink knowledge-wlweb01 Server: