connection string mysql ireport error java sql date
Connection String mysql
?zeroDateTimeBehavior=convertToNull&autoReconnect=true&characterEncoding=UTF-8&characterSetResults=UTF-8
iReport akan ERROR pada tipe data tanggal (java.sql.Date) jika pada connection string mysql
tidak ditambah
?zeroDateTimeBehavior=convertToNull&autoReconnect=true&characterEncoding=UTF-8&characterSetResults=UTF-8
kita coba
kita cek desc table
error :
Unable to get value for field 'tanggal' of class 'java.sql.Date'
Caused by: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
sekarang kita tambah connection string
?zeroDateTimeBehavior=convertToNull&autoReconnect=true&characterEncoding=UTF-8&characterSetResults=UTF-8
dan ketika dijalankan sudah tidak error lagi :)