Passing a realtime variable into a file

[Srikanth Kalla]

Hi ,
In our program we read the sql scripts via a filereader then execute them ,modify the results and renter the modified results into another database.Now we are asked to retrieve only data higher than some time stamp (which varies from day to day) .So for this we need to modify the sql scripts to retrieve only the time bound data. Can we pass real time datatime value into a file via java so that this variable can be used in sql conditions for refining the data.

[Jeff Verdegan]

Srikanth Kalla wrote:Can we pass real time datatime value into a file via java so that this variable can be used in sql conditions for refining the data.

It's not clear what you mean by this. I think you might be asking about using a timestamp of "now" in a SQL query via Java, but I'm not sure. If that's what you mean, then something like this is how you would do it:

// find all sessions that are already expired
String query = "select * from session where expiration < ?"
Timestamp now = new Timestamp(System.currentTimeMillis());
PreparedStatement ps = conn.prepareStatement(query);
ps.setTimestamp(1, now);
ResultSet rs = ps.executeQuery();

I have no idea what you mean by "pass a real time value into a file via java" though.