-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: Spring JDBC OR Hibernate
PostPosted: Fri Mar 09, 2007 2:51 pm 
Beginner
Beginner

Joined: Wed Oct 25, 2006 12:10 pm
Posts: 41
We are having problems with Hibernate communicating to legacy application as its business logic is in PL/SQL Stored procedures.
So we are thinking to use JDBC . Is Spring JDBC similar to plain JDBC .
What are the pros - cons of Spring JDBC over Hibernate & plain JDBC
Any pointers/suggestions for best ways to communicate with legacy application will be highly appreciated

Regards
Bansi


Top
 Profile  
 
 Post subject:
PostPosted: Fri Mar 09, 2007 6:52 pm 
Beginner
Beginner

Joined: Wed Oct 25, 2006 12:10 pm
Posts: 41
Here is some more info
We have two applications we support. The first is written in C with much of the business logic written in Oracle PL/SQL procedures and stored in our database. The second application uses Oracle Forms which resides on our database server with much of its business logic written in PL/SQL as well. The first application is a background job installed on many clients and creates an Oracle connection via sqlnet to execute the stored procedures in the second program. The second application is being rewritten in Java. In order to minimize the amount of rewrite on the first program we are investigating methods for the PL/SQL stored procedure in the first application to interact with the new Java business logic written in the second application. The Oracle Forms application will be replaced with a web application using JSF, Spring and Hibernate. We have considered the following options:

1. Rewrite the first application in Java
2. Have the first application call the second application via a web service in order to access the Java business logic (uses the Oracle UTL_DBWS package to call the web service from PL/SQL)
3. Load a copy of our Java application into the database using Oracle's JVM. The first application would then call a Java stored procedure in the database.
4. Have the first applications PL/SQL make an operating system call to access a separate JVM running a copy of the first applications business logic

Comments on each option are as follows:
1. Rewrite of the first application is not an option due to schedule and lack of resources
2. Fair amount of concern related to performance (has to support hundreds of transactions per minute). Also concerns about session and state.
3. Hibernate doesn't work in Oracle's JVM due to compatibility with cgilib jar file issues, requires us to scrap Hibernate and just JDBC or have two copies of the Java Business logic.
4. Requires setting up a separate JVM and writing the interface

There are probably more options. BTW, we are not interested in purchasing a third party solution due to budget issues.

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


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.