File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Value in database automatically changing to NULL

 
Jagannathan Sundararajan
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13045
6
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How does "page 2" update the database?

Bill
 
Carles Gasques
Ranch Hand
Posts: 199
1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic