selectItems populating from mySQL table

kimlord Jul 23, 2007 8:49 PM

I am new to seam and am looking for a simple example for populating a s:selectItems from a mySQL table. I used seam-gen to set up a CRUD project and would like dropdowns for foreign keys rather than ids. I have looked over many examples and am not sure how to proceed. All examples I have tried have resulted in errors.

Any guidance would be greatly appreciated,
Kim

1. Re: selectItems populating from mySQL table

norman.richards Jul 23, 2007 9:51 PM (in response to kimlord)

Here's one from the seam docs:

<h:selectOneMenu value="#{person.continent}" required="true">
 <s:selectItems value="#{continents.resultList}" var="continent"
label="#{continent.name}"
 noSelectionLabel="Please Select..."/>
 <s:convertEntity />
</h:selectOneMenu>

2. Re: selectItems populating from mySQL table

kimlord Jul 24, 2007 5:33 AM (in response to kimlord)

I have seen that example but don't know how to get continents. I think in that example there is a statement in the components.xml that makes the query. Is that the only way and when do I need a custom converter?
Thanks,
Kim
Actions
3. Re: selectItems populating from mySQL table

kimlord Jul 24, 2007 6:38 AM (in response to kimlord)

I tried convertEntity but am getting the following error:

<s:convertEntity> Tag Library supports namespace: http://jboss.com/products/seam/taglib, but no tag was defined for name: convertEntity

What am I doing wrong?

Thanks,
Kim
Actions
4. Re: selectItems populating from mySQL table

norman.richards Jul 24, 2007 9:20 AM (in response to kimlord)

Please look at the example apps. I think that example is from the wiki app.
Actions

Go to original post