DataTrunctation error when BLOB/CLOB greater than 64K

2 Message(s) by 2 Author(s) originally posted in mysql java

From: Bill Karwin

Date: Friday, February 24, 2006

wrote in message

In {object-oriented programming} sending a message to an
	{object} (to invoke a {method}) is equivalent to calling a
	{procedure} in traditional programming languages, except that
	the actual code executed may only be selected at run time
	depending on the {class} of the object.  Thus, in response to
	the message "drawSelf", the method code invoked would be
	different if the target object were a circle or a square.

	(1995-02-16)

Is there a way to lift the restriction

A {bug} or design error that limits a program's capabilities,
	and which is sufficiently egregious that nobody can quite work
	up enough nerve to describe it as a {feature}.  Often used
	(especially by {marketroid} types) to make it sound as though
	some crippling bogosity had been intended by the designers all
	along, or was forced upon them by arcane technical constraints
	of a nature no mere user could possibly comprehend (these
	claims are almost invariably false).

	Old-time hacker Joseph M. Newcomer advises that whenever
	choosing a quantifiable but arbitrary restriction, you should
	make it either a power of 2 or a power of 2 minus 1.  If you
	impose a limit of 17 items in a list, everyone will know it is
	a random number - on the other hand, a limit of 15 or 16
	suggests some deep reason (involving 0- or 1-based indexing in
	binary) and you will get less {flamage} for it.  Limits which
	are round numbers in base 10 are always especially suspect.

	[{Jargon File}]

on how much data

<data, data processing, jargon> /day't*/ (Or "raw data")
	Numbers, {characters}, {images}, or other method of recording,
	in a form which can be assessed by a human or (especially)
	input into a {computer}, stored and {processed} there, or
	transmitted on some {digital channel}.  Computers nearly
	always represent data in {binary}.

	Data on its own has no meaning, only when interpreted by some
	kind of {data processing system} does it take on meaning and
	become {information}.

	People or computers can find patterns in data to perceive
	information, and information can be used to enhance
	{knowledge}.  Since knowledge is prerequisite to wisdom, we
	always want more data and information.  But, as modern
	societies verge on {information overload}, we especially need
	better ways to find patterns.

	1234567.89 is data.

	"Your bank balance has jumped 8087% to $1234567.89" is
	information.

	"Nobody owes me that much money" is knowledge.

	"I'd better talk to the bank before I spend it, because of
	what has happened to other people" is wisdom.

	(1999-04-30)

can be written
to a LOB in MySQL from JDBC?

Regardless of JDBC, 64KB is the size limit on the plain BLOB

1. {binary large object}.

	2. <architecture> {blitter object}.

	[{Jargon File}]

datatype

<theory, programming> (Or "data type") A set of values from
	which a {variable}, {constant}, {function}, or other
	{expression} may take its value.  A type is a classification
	of data that tells the {compiler} or {interpreter} how the
	programmer intends to use it.  For example, the process and
	result of adding two variables differs greatly according to
	whether they are integers, floating point numbers, or strings.

	Types supported by most programming languages include
	{integers} (usually limited to some range so they will fit in
	one {word} of storage), {Booleans}, {floating point numbers},
	and characters.  {Strings} are also common, and are
	represented as {lists} of characters in some languages.

	If s and t are types, then so is s -> t, the type of
	{functions} from s to t; that is, give them a term of type s,
	functions of type s -> t will return a term of type t.

	Some types are {primitive} - built-in to the language, with no
	visible internal structure - e.g. Boolean; others are
	composite - constructed from one or more other types (of
	either kind) - e.g. {lists}, {arrays}, {structures}, {unions}.
	{Object-oriented programming} extends this with {classes}
	which encapsulate both the structure of a type and the
	operations that can be performed on it.

	Some languages provide {strong typing}, others allow {implicit
	type conversion} and/or {explicit type conversion}.

	(2003-12-22)

in
MySQL. You can declare the field

<data, database> An area of a {database} {record}, or
	{graphical user interface} {form}, into which a particular
	item of data is entered.

	Example usage: "The telephone number field is not really a
	numerical field", "Why do we need a four-digit field for the
	year?".

	A {database} {column} is the set of all instances of a given
	field from all records in a {table}.

	(1999-04-26)

in the database as a MEDIUMBLOB or
LONGBLOB if you need longer data.

See http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html for
details on the maximum size of respective BLOB types.

Alternately, in MySQL 4.1 and later, you can specify a length argument

<programming> (Or "arg") A value or reference passed to a
	{function}, {procedure}, {subroutine}, command or program, by
	the caller.  For example, in the function definition

		square(x) = x * x

	x is the {formal argument} or "parameter", and in the call

		y = square(3+4)

	3+4 is the {actual argument}.  This will execute the function
	square with x having the value 7 and return the result 49.

	There are many different conventions for passing arguments to
	functions and procedures including {call-by-value},
	{call-by-name}, {call-by-reference}, {call-by-need}.  These
	affect whether the value of the argument is computed by the
	caller or the callee (the function) and whether the callee can
	modify the value of the argument as seen by the caller (if it
	is a variable).

	Arguments to functions are usually, following mathematical
	notation, written in parentheses after the function name,
	separated by commas (but see {curried function}).  Arguments
	to a program are usually given after the command name,
	separated by spaces, e.g.:

		cat myfile yourfile hisfile

	Here "cat" is the command and "myfile", "yourfile", and
	"hisfile" are the arguments.

	(2006-05-27)

to
the BLOB type keyword, and it'll promote the field to the BLOB type that
can store

[probably from "main store"] In some varieties of Commonwealth
	hackish, the preferred synonym for {core}.  Thus, "bringing a
	program into store" means not that one is returning
	shrink-wrapped software but that a program is being {swap}ped
	in.

	[{Jargon File}]

that length of data.
For example:

CREATE TABLE mytable (
...
myLongBlobField BLOB(120000),
...
);

The field will be created as a MEDIUMBLOB, since 120KB is too large to fit
in a plain BLOB. A subsequent "SHOW CREATE TABLE mytable" statement shows
the field to be of type MEDIUMBLOB.

Regards,
Bill K.

From: rdifalco

Date: Saturday, February 25, 2006

Is there a way to lift the restriction on how much data can be written
to a LOB in MySQL from JDBC?

R.--
MySQL JAVA Mailing List
For list

<data> A data structure holding many values, possibly of
	different types, which is usually accessed sequentially,
	working from the head to the end of the tail - an "ordered
	list".  This contrasts with a (one-dimensional) {array}, any
	element of which can be accessed equally quickly.

	Lists are often stored using a cell and pointer arrangement
	where each value is stored in a cell along with an associated
	pointer to the next cell.  A special pointer, e.g. zero, marks
	the end of the list.  This is known as a (singly) "linked
	list".  A doubly linked list has pointers from each cell to
	both next and previous cells.

	An unordered list is a {set}.

	(1998-11-12)

archives: http://lists.mysql.com/JAVA
To unsubscribe: http://lists.mysql.com/JAVA?unsub=3Dmysql-JAVA@xxxxxxxxxxx

Next Message: Handling numerous rows from SQL query