Any alternative solution for IBM db beans?

[San-Yih Pan]

Hi,

Does JBoss have the similar datasource package lik com.ibm.db.beans? Especially DBSelect, DBSelectMetaData, DBConnectionSpec, etc.
Or other open source beans? I need to replace IBM db beans when migrate from Web Sphere to JBoss?


Thank you for your help,

[Peter Johnson]

No it doesn't. And without knowing what those beans do it is hard to say what you could use in their place.

[San-Yih Pan]

Mr. Johnson,

In IBM db beans,
DBSelect - is being used to execute the SQL string.
DBConnectionSpec - is being used to set and get Data Source name, URL, username, password, and so on.
DBSelectMetaData - is being used to store ResultSet and set the lables for columns.

You said JBoss doesn't have the similar package. Is there any open source DB bean package we can replace the IBM db beans?
Or we have to implement a homemade uitilities?


Thank you for your help,

[Peter Johnson]

This all sounds like stuff you can do with JDBC. So why would you even use the DB Beans? Other than to make your code dependent on WebSphere so that you are stuck with that as an app server (which is great for IBM, but not for you).

[San-Yih Pan]

Mr. Johnson,

Thank you for your help.