Kapalı

Data Truncation Error

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 [url removed, login to view]

[url removed, login to view]

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 ([url removed, login to view] sec)

mysql>

May 22, 2010 4:15:32 PM [url removed, login to view] invoke

SEVERE: [url removed, login to view]() for servlet jsp threw exception

[url removed, login to view]: Data truncation: Incorrect date value: 'CURDATE()' for column 'register_date' at row 1

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at org.apache.jsp.wholesale.member.add_005fmember_jsp._jspService([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]([url removed, login to view])

at [url removed, login to view]$[url removed, login to view]([url removed, login to view])

at [url removed, login to view]$[url removed, login to view]([url removed, login to view])

at [url removed, login to view](Unknown Source)

Beceriler: Java, JSP, MySQL

Daha fazlasını görün: data truncation error java, data truncation error, java data truncation, java data truncation error, set data, row 44, jsp service, servlet error data truncation, java mysql truncation error, error data truncation, jdbc data truncation error, text truncation jsp, error jsp data truncation, preparedstatement truncation error, truncation error java, error 0, valves, servlet, null, mysql error, mul, jspservlet, jk, java thread, java jdbc

İşveren Hakkında:
( 197 değerlendirme ) Hacienda Heights, United States

Proje NO: #693555

18 freelancer bu iş için ortalamada 36$ teklif veriyor

eperfections

Please see PMB

in 0 gün içinde30$ USD
(308 Değerlendirme)
7.1
arnab0143

-- Please check your pm --

in 0 gün içinde30$ USD
(24 Değerlendirme)
5.9
nsdu

I could help you.

in 0 gün içinde40$ USD
(13 Değerlendirme)
5.1
djfd

see pmb

in 0 gün içinde50$ USD
(9 Değerlendirme)
4.9
gafmxq

easy case, i can do it. see PM

in 0 gün içinde30$ USD
(10 Değerlendirme)
4.4
eslamniazy

hello,very simple to help

in 0 gün içinde30$ USD
(8 Değerlendirme)
3.9
arunjassiar

Please check PMB.

1 gün içinde 30$ USD
(5 Değerlendirme)
3.8
iamsupriyo

I can do this, plz see PMB.

in 0 gün içinde30$ USD
(0 Değerlendirme)
1.0
hernanborre

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 an Daha fazlası

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
laurensius

hi, I can help with ypur script, let's do it

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
baanty

I can resolve this with in a short span of time.... I am an experienced J2EE/DataBase guy..... Please give me a chance...

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
lokeshpareek

I will fix this in one day.

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
Nicksroy

I am an experienced Java programmer and worked a lot on MySQL database. I will fix this bug in the shortest possible time. Thanks!

in 0 gün içinde38$ USD
(0 Değerlendirme)
0.0
weareperfect

Hi, I can do this easily. Regards, toton

in 5 gün içinde100$ USD
(0 Değerlendirme)
0.0
ketan

I am ready to start work on that.

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
shreyanshjogi

hi its nt a big deal i can help you

in 5 gün içinde30$ USD
(0 Değerlendirme)
0.0
GlobeDevelopment

I'm having a solution n can fix it.

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
comtechinc

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

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0