Re: default values problem with mysql version 5

Article View: borland.public.jbuilder.database

Article #311

Back to borland.public.jbuilder.database Previous Next

#311

From: Paul Nichols [TeamB]
Date: Fri, 17 Aug 2007 15:46

27 lines
1945 bytes

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.

Technical Details

Message-ID: <46c5c2b8@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!feeder.news-service.com!newsfeed.freenet.de!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <46c5bbd4@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1073da,46beccc389838db9
X-Google-Attributes: gid1073da,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Fri, 17 Aug 2007 11:46:01 -0400
From: "Paul Nichols [TeamB]" <paul@none.com>
User-Agent: Thunderbird 1.5.0.12 (X11/20070604)
MIME-Version: 1.0
Newsgroups: borland.public.jbuilder.database
Subject: Re: default values problem with mysql version 5
References: <46c5bbd4@newsgroups.borland.com>
In-Reply-To: <46c5bbd4@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 76.97.213.175
Message-ID: <46c5c2b8@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1187365560 76.97.213.175 (17 Aug 2007 08:46:00 -0700)
Lines: 28
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!feeder.news-service.com!newsfeed.freenet.de!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message