What is the easiest way to access a
JDBC connection from within a JBI component?
Here's what's going on - someone wrote a JBI component in GlassFish to do some Healthcare EDI messaging - it really was complete and utter overkill for what was needed. It's basically a socket listener that opens a socket and listens for messages - when it gets one, it drops it on a JMS queue and send back a "thanks!" kind of response. Originally the "component" used a flat-file to read in information as to what socket to listen on. I need to change this to look at a DB instead. All I wanna do is query the DB for some settings instead of pulling them from a file. Shouldn't I be able to just embed the jdbc prepared statement calls and call the jdbc service? Or do I have to basically build another JBI component that accepts some sort of API call and gives me back a result set?
I'm just confused. When the code used to pull the data from the DB is just a regular "bean" it works great - but I get things like "java.sql.SQLFeatureNotSupportedException: This operation is not supported." when I do it from within the JBI component.
Any insight would be deeply appreciated...
Thanks!
Ryan