Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Java-Firebird SQL

843859Dec 23 2009 — edited Jan 9 2010
Hello. I am not certain this is the right forum, but hopefully I can receive some help.

I have an application that does several database searches on an inventory-keeping database, and all the searches together take about 30 seconds. The searches require user input (3 parameters: Part #, "From" date, and "To" date), so they must be executed after the application is already launched.

My question might be a bit confusing... But is there any way to transfer the data I need to Java objects and then execute the SQL off of that? Is the solution I'm thinking about practical? My concern is: Users like to see "loading" at the front of the program, when they click to load the program. No one likes to wait in the middle of the program. I would like for the program to do most of the heavy lifting up front, but like I said, it requires user-input. The database is massive, which is one reason why things take so long.

Any advice would be very welcome. I am a moderately experienced Java developer, and a not-so experienced database programmer.

Thank you in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2010
Added on Dec 23 2009
25 comments
783 views