We have a Legacy application written in C language . The business logic of legacy application resides in PL/SQL stored procedures on database server. The legacy application uses use Pro*C to connect to database server via sqlnet.

Problem:
The key business requirement is to communicate legacy application business logic ( i.e. PL/SQL stored Procedures) with the business logic in Application Server written in Spring. (i.e. JSF, Spring, Hibernate)

We wrote a Spring application which uses plain JDBC to store business logic in the form of Java Stored procedures so as to communicate with PL/SQL stored procedures the business logic of legacy application

The prototype resulted in perfomance problem due to presence of Spring in
the database. We couldn't develop an application using Hibernate due to compatability issues of cgilib.jar file

The other options we are thinking of is to have legacy application call Web Service which in turn will call business logic in JAVA but this would result in a call over the Network

Any pointers/suggestions for best ways to communicate with legacy application will be highly appreciated

Regards
Bansi

I can't see any reason of Spring slowing down your speed. Imo, it's totally orthogonal. Spring doesn't have anything to do with the db directly.

But anyway, it's not the place to discuss Spring. About the pointers, I would suggest you to have a look in the "Java Persistence with Hibernate" book. It's a complete reference about Hibernate and it contains a whole chapter talking about dealing with legacy apps.

We also have a very special db schema in our company. Hibernate offers a lot of options to deal with bizarre schemas (a classical example among others: foreign keys referencing only one column although it references a composite key...).

So maybe you could try and explain more precisely what your problems are, for example with cglib...