This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I have encountered the following problem which I hope y'all good folks could help me out on. I have recently written a JDBC program that will call a stored procedure (via CallableStatement) in Oracle, return some data into the program, then pass all these data into a stored procedure in Sybase. The stored procedure in Sybase will return some values on which the program validates and then calls another stored procedure in Oracle to update several tables in the database. My program works so far but it is taking a long time to perform one single operation, I'm just wondering if there is a way I can speed up this process without doing anything in the backend like creating indexes on the Sybase database or so.
Thank you very much Jeanne. I have followed your advice and have tracked down the problem which resides on the Sybase stored procedure itself. I will explore more on how to streamline the stored procedure. Thanks again!
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: Speed Up JDBC Process with Oracle and Sybase