Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Access JDBC from within a JBI component

 
Wryan Hulslander
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic