🚀 go-pugleaf

Paul Nichols [TeamB] wrote:
> Anton Jungreuthmayer wrote:
>> I have an application written in java with jBuilder.
>>
>> This uses JDBC to access a mySQL database which I am converting from 
>> version 4.1 to version 5.0
>>
>> When my application tries to INSERT a record but does not specify a 
>> value for a text field that is defined as NOT NULL with no default set 
>> the following error message is returned :
>>
>> Field 'somedata' doesn't have a default value
>>
>> this doesn't happen with JDBC on mysql 4.1
>> It also doesn't happen when I run the command in mysql, or when using 
>> mySql query browser but only when I connect using JDBC
>>
>> Any clues ?
>>
>> Anton
> 
> This is probably a result of the changes to mySQL 5 and the JDBC 
> Drivers. Which MySQL JDBC driver (5.1 is the latest) are you using and 
> which JDK version?
> 
> This is not going to be related to JB, unless you are using the 
> QueryDataSet, which may or may not work correctly with newer JDBC 
> implementations.
> 

JDBC driver - 5.0.6
java version 1.5.0_04-b05