Callable Statement

Hi Everyone,

I have two methods, one to insert data in DB by calling a stored procedure and other is retreive data using a select stmt.

I call insert method and next sequential is select method. In such case I could not retreive the latest data inserted. If I insert a sleep of 1 sec only then I can retreive the data inserted.

Any help is appreciated.

Thanks

[401 byte] By [AravindUSAa] at [2007-11-27 8:11:12]

«« How to send a data from JSP to a lot of Swing clients?
»» "sendError" method as compared to "setStatus"; weired results; Help !

# 1

Why do you think this is a java problem?

For example the stored proc could be inserting the data into a work table, then a work task moves it to the final table, and then that is where you look for it. But the work task takes time to run. And none of that would have anything to do with java.

Conversely you are making an assmption about something which is not true.

jschella at 2007-7-12 19:55:05 >

Database Connectivity

Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Callable Statement

Database Connectivity Hot Topic

Database Connectivity

All Classified