Search code examples
javaexcelejbcorbavba

Best solution for using EJBs from Excel

We would like to give access to some of our EJBs from Excel. The goal is to give an API usable from VBA.

Our EJBs are mostly Stateless Session Beans that do simple CRUD operations with POJOs.

Some possible solutions:

  • Exposing the EJBs as WebServices and create a VB/C# dll wrapping them,
  • Using Corba to access the EJBs from C#,
  • Creating a COM Library that uses Java to access the EJBs,

Pointers to frameworks for these solution or other ideas are welcome.

Solution

  • You could take a look at IIOP.NET, which addresses this issue.