Hi! I have an EJBJar, composed by any CMP 2.0 Entity Beans. I need to make a "SELECT * FROM my_table ORDER BY column" EJB QL 2.0 don't be able to do that, and i think i could make a method in remotehome of my EJB. This method make a traditional Connection to a Datasource and returns a Vector with info. Is this a good solution? and How can i get the datasource defined in JBossCMP-JDBC.xml?
Thanks at all, and excuse my english ;)
Emilio Sosa
Canary Islands
Spain