i'm getting a data truncation error in my tomcat log. i'm inserting a CURDATE() into a date type but it's giving me a data truncation error. i'm using mysql 5.0.77
[login to view URL]
sql statement insert into wholesale_cust_login (user_login,user_password,active,register_date) values (?,?,?,CURDATE())
the table is
mysql> desc wholesale_cust_login;
+-------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+----------------+
| wholesale_user_id | int(10) | NO | PRI | NULL | auto_increment |
| user_login | text | YES | MUL | NULL | |
| user_password | varchar(100) | YES | | NULL | |
| active | int(1) | YES | | NULL | |
| register_date | date | YES | | NULL | |
+-------------------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
mysql>
May 22, 2010 4:15:32 PM [login to view URL] invoke
SEVERE: [login to view URL]() for servlet jsp threw exception
[login to view URL]: Data truncation: Incorrect date value: 'CURDATE()' for column 'register_date' at row 1
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at org.apache.jsp.wholesale.member.add_005fmember_jsp._jspService([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]([login to view URL])
at [login to view URL]$[login to view URL]([login to view URL])
at [login to view URL]$[login to view URL]([login to view URL])
at [login to view URL](Unknown Source)
No problem at all, I can fix it for you now and give you any additional help if needed. My large experience developing java web applications is the key. Give me a change you won't regret. Good luck with your project anyway!
Hi,
I have 6 years of Experience in Database, SQL, Trigger, cursor , Java,RMI,J2EE and distributed applications.
I am interested in this project. Pleas provide me the details.
Thanks,
COM Tech