aspose file tools*
The moose likes Performance and the fly likes Value in database automatically changing to NULL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » Performance
Bookmark "Value in database automatically changing to NULL" Watch "Value in database automatically changing to NULL" New topic
Author

Value in database automatically changing to NULL

Jagannathan Sundararajan
Greenhorn

Joined: Apr 23, 2013
Posts: 2
Hi All,

Im getting a problem in my tool. I am updating the "last accessed date" in Page1 on my app & when i check in the database this value is reflecting in database too.

But when i click on the Next Page option which takes me to Page2 & after coming back to Page1 from Page2, Page1 shows me NULL value for the last accessed date in both the application & database.

I am using Struts 1.0 framework & an Oracle 11g database.

I am seriously surprised to see this.

Any suggestions would help me greatly.

Thank you in advance.
William Brogden
Author and all-around good cowpoke
Rancher

Joined: Mar 22, 2000
Posts: 12805
    
    5
How does "page 2" update the database?

Bill
Carles Gasques
Ranch Hand

Joined: Apr 19, 2013
Posts: 199
    
    1
Hi,

What are you doing in your code?

Executing an insert without parameters (insert into T(last) values sysdate) or a parametrized query (insert into T(last) values ?).
If you use a parametrized query from where you get the time value?


Cheers,

Jagannathan Sundararajan wrote:Hi All,

Im getting a problem in my tool. I am updating the "last accessed date" in Page1 on my app & when i check in the database this value is reflecting in database too.

But when i click on the Next Page option which takes me to Page2 & after coming back to Page1 from Page2, Page1 shows me NULL value for the last accessed date in both the application & database.

I am using Struts 1.0 framework & an Oracle 11g database.

I am seriously surprised to see this.

Any suggestions would help me greatly.

Thank you in advance.
 
jQuery in Action, 2nd edition
 
subject: Value in database automatically changing to NULL