Access Database from Custom Action

[simas_ch]

Hi,

In a custom action I need to access a database table to get some configuration.

What's the best way to do this?

Thanks,

Simon

[mageshbk]

Have you tried the SQL Gateway? See helloworld_sql_action quickstarts.

[simas_ch]

Is there a way to get a jdbc connection?

[mageshbk]

Simon,

Did you try Hibernate?

[simas_ch]

The question is how to get a JDBC Connection or a JPA Entity Manager or Hibernate session in a custom action.

[tcunning]

You could either :

- roll your own code to connect / disconnect / perform queries (I'd suggest using a JNDI datasource)

- take a look at something like this (http://code.google.com/p/breakingwoods/wiki/JBossESBApacheDBUtils), either to use or to get ideas for building your own

There's nothing really out-of-the-box in this area though, although if you search the forums you'll probably find lots of examples of others doing this sort of thing.

[simas_ch]

Thanks a lot for your help.