Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I use other databases with iAS if I have JDBC drivers ?

April 26, 2017databases Drivers iAS JDBC

0

10 Posted

Can I use other databases with iAS if I have JDBC drivers ?

1 Answer

0

Posted

AYes and no. In principle you can make JDBC calls from your EJBs and Servlets, so any database with a JDBC driver is accessible (you may have to alter the iAS CLASSPATH to get it to find the driver at run-time). In addition, many drivers will support connection pooling and transactions internally; these features are not limited to iAS. However, you won’t be able to get a reference to your datasource through JNDI (you’ll need hard-coded driver references), and you won’t be able to configure it through the admin tool. In addition, you won’t be able to use it in container-managed persistence or container-managed transactions. You may be able to use distributed transactions, but you’ll have to do a lot of extra coding.