com.mysql.jdbc.UpdatableResultSet.updateBlob gives AbstractMethodError

12 Message(s) by 6 Author(s) originally posted in java databases

From: pjvleeuwen

Date: Tuesday, October 02, 2007

Hi all,

I'm quite new to all jdbc, but so far working with resultset's over
SQL seemed easy so far, but I'm having some problems writing a blob to
the database

1. <database> One or more large structured sets of persistent
	data, usually associated with software to update and {query}
	the data.  A simple database might be a single file containing
	many {records}, each of which contains the same set of
	{fields} where each field is a certain fixed width.

	A database is one component of a {database management system}.

	See also {ANSI/SPARC Architecture}, {atomic}, {blob}, {data
	definition language}, {deductive database}, {distributed
	database}, {fourth generation language}, {functional
	database}, {object-oriented database}, {relational database}.

	{Carol E. Brown's tutorial
	(http://accounting.rutgers.edu/raw/aies/www.bus.orst.edu/faculty/brownc/lectures/db_tutor/db_tutor.htm)}.

	2. <hypertext> A collection of {nodes} managed and stored in
	one place and all accessible via the same {server}.  {Links}
	outside this are "external", and those inside are "internal".

	On the {World-Wide Web} this is called a {website}.

	3. All the facts and rules comprising a {logic programming}
	program.

	(2005-11-17)

.
What I try to do is two steps:
1. read an image

1. <data, graphics> Data representing a two-dimensional scene.
	A digital image is composed of {pixels} arranged in a
	rectangular array with a certain height and width.  Each pixel
	may consist of one or more {bits} of information, representing
	the brightness of the image at that point and possibly
	including colour information encoded as {RGB} triples.

	{Images} are usually taken from the real world via a {digital
	camera}, {frame grabber}, or {scanner}; or they may be
	generated by computer, e.g. by {ray tracing} software.

	See also {image formats}, {image processing}.

	(1994-10-21)

	2. <mathematics> The image (or range) of a {function} is the
	set of values obtained by applying the function to all
	elements of its {domain}.  So, if f : D -> C then the set f(D)
	= \{ f(d) | d in D \} is the image of D under f.  The image is
	a subset of C, the {codomain}.

	(2000-01-19)

from the web and write

1. <chat> {Unix}'s simple {talk} command and {protocol}.
	write has been largely superseded by {talk} and then {irc}.

	An enhancement, {RWP}, has been proposed.

	2. <tool> A simple {text editor} for {Windows}.

	(1998-04-28)

it to a blob
2. read the blob and display

1. <hardware> {monitor}.

	2. <language> A vector of pointers to {activation records}.
	The Nth element points to the activation record containing
	variables declared at {lexical depth} N.  This allows faster
	access to variables from outer {scopes} than the alternative
	of linked activation records (but most variable accesses are
	either local or global or occasionally to the immediately
	enclosing scope).  Displays were used in some {ALGOL}
	implementations.

	(1996-02-22)

it as an image

I did the same thing before without trying to write to the blob, but I
want to 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}]

the images in DB because the only stay on the web for a
couple of weeks.

Googling for UpdatableResultset updateBlob AbstractMethodError gets me
lost. Any help is well appreciated.

By the way: the image is 18257 bytes and max_allowed_packet of MySQL
is 1048576

Anyone? thanx

### stderr

<programming, operating system> The predefined input/output
	channels which every {Unix} process is initialised with.
	Standard input is by default from the terminal, and standard
	output and standard error are to the terminal.  Each of these
	channels (controlled via a {file descriptor} 0, 1, or 2 -
	stdin, stdout, stderr) can be redirected to a file, another
	device or a {pipe} connecting its process to another process.
	The process is normally unaware of such {I/O redirection},
	thus simplifying prototyping of combinations of commands.

	The {C} programming language library includes routines to
	perform basic operations on standard I/O.  Examples are
	"printf", allowing text to be sent to standard output, and
	"scanf", allowing the program to read from standard input.

	(1996-06-07)

output

<architecture> {Data} transferred from a computer system to
	the outside world via some kind of {output device}.

	Opposite: {input}.

	(1997-04-28)

###
Exception in thread

1. See {multithreading}.

	2. See {threaded code}.

	3. {topic thread}.

	[{Jargon File}]

"main" JAVA.lang.AbstractMethodError:
com.mysql.jdbc.UpdatableResultSet.updateBlob(LJAVA/lang/String;LJAVA/
io/InputStream;)V
at nl.vanleeuwenwilmot.housing.search.woonnet.app.Test.main(Test.JAVA:
52)
######### JAVA class

1. <programming> The prototype for an {object} in an
	{object-oriented language}; analogous to a {derived type} in a
	{procedural language}.  A class may also be considered to be a
	set of objects which share a common structure and behaviour.
	The structure of a class is determined by the {class
	variables} which represent the {state} of an object of that
	class and the behaviour is given by a set of {methods}
	associated with the class.

	Classes are related in a {class hierarchy}.  One class may be
	a specialisation (a "{subclass}") of another (one of its
	"{superclasses}") or it may be composed of other classes or it
	may use other classes in a {client-server} relationship.  A
	class may be an {abstract class} or a {concrete class}.

	See also {signature}.

	2. <programming> See {type class}.

	3. <networking> One of three types of {Internet addresses}
	distinguished by their most significant bits.

	3. <language> A language developed by the {Andrew Project}.
	It was one of the first attempts to add {object-oriented}
	features to {C}.

	(1995-05-01)

###
package nl.vanleeuwenwilmot.housing.search.woonnet.app;

import

<data> To read data that is not in the native format of the
	application.  For example, a {web browser} will have its own
	way of storing {bookmarks} but it will usually provide a
	function to import bookmarks from {Internet Explorer}.  The
	alternative is to provide an independent external conversion
	utility but this is usually less convenient for the user.

	(2004-11-15)

JAVA.awt.BorderLayout;
import JAVA.awt.Image;
import JAVA.io.IOException;
import JAVA.io.InputStream;

import JAVA.net.URL

<World-Wide Web> (URL, previously "Universal") A {standard}
	way of specifying the location of an object, typically a {web
	page}, on the {Internet}.  Other types of object are described
	below.  URLs are the form of address used on the {World-Wide
	Web}.  They are used in {HTML} documents to specify the target
	of a {hyperlink} which is often another HTML document
	(possibly stored on another computer).

	Here are some example URLs:

	 http://www.w3.org/default.html
	 http://www.acme.co.uk:8080/images/map.gif
	 http://www.foldoc.org/?Uniform+Resource+Locator
	 http://www.w3.org/default.html#Introduction
	 ftp://wuarchive.wustl.edu/mirrors/msdos/graphics/gifkit.zip
	 ftp://spy:secret@ftp.acme.com/pub/topsecret/weapon.tgz
	 mailto:fred@doc.ic.ac.uk
	 news:alt.hypertext
	 telnet://dra.com

	The part before the first colon specifies the access scheme or
	{protocol}.  Commonly implemented schemes include: {ftp},
	{http} (World-Wide Web), {gopher} or {WAIS}.  The "file"
	scheme should only be used to refer to a file on the same
	host.  Other less commonly used schemes include {news},
	{telnet} or mailto ({e-mail}).

	The part after the colon is interpreted according to the
	access scheme.  In general, two slashes after the colon
	introduce a {hostname} (host:port is also valid, or for {FTP}
	user:passwd@host or user@host).  The {port} number is usually
	omitted and defaults to the standard port for the scheme,
	e.g. port 80 for HTTP.

	For an HTTP or FTP URL the next part is a {pathname} which is
	usually related to the pathname of a file on the server.  The
	file can contain any type of data but only certain types are
	interpreted directly by most {browsers}.  These include {HTML}
	and images in {gif} or {jpeg} format.  The file's type is
	given by a {MIME} type in the HTTP headers returned by the
	server, e.g. "text/html", "image/gif", and is usually also
	indicated by its {filename extension}.  A file whose type is
	not recognised directly by the browser may be passed to an
	external "viewer" {application}, e.g. a sound player.

	The last (optional) part of the URL may be a query string
	preceded by "?" or a "fragment identifier" preceded by "#".
	The later indicates a particular position within the specified
	document.

	Only alphanumerics, reserved characters (:/?#"<>%+) used for
	their reserved purposes and "$", "-", "_", ".", "&", "+" are
	safe and may be transmitted unencoded.  Other characters are
	encoded as a "%" followed by two {hexadecimal} digits.  Space
	may also be encoded as "+".  Standard {SGML} "&<name>;"
	character entity encodings (e.g. "&eacute;") are also accepted
	when URLs are embedded in HTML.  The terminating semicolon may
	be omitted if &<name> is followed by a non-letter character.

	{The authoritative W3C URL specification
	(http://www.w3.org/hypertext/WWW/Addressing/Addressing.html)}.

	(2000-02-17)

;
import JAVA.sql.Connection;
import JAVA.sql.DriverManager;
import JAVA.sql.ResultSet;
import JAVA.sql.SQLException;
import JAVA.sql.Statement;

import JAVAx.imageio.ImageIO;
import JAVAx.swing.ImageIcon;
import JAVAx.swing.JFrame;
import JAVAx.swing.JLabel;

public class Test {

/**
* @xxxxxxxxxxx args
* @xxxxxxxxxxx IOException
* @xxxxxxxxxxx SQLException
*/
public static void main(String[] args) throws IOException,
SQLException {

Connection con

[SF fandom] A science-fiction convention.  Not used of other
	sorts of conventions, such as professional meetings.  This
	term, unlike many others of SF-fan slang, is widely recognised
	even by hackers who aren't {fans}. "We'd been corresponding on
	the net for months, then we met face-to-face at a con."

	[{Jargon File}]

= null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql:///woonnet",
"root",
"<A2Cc|4w");
} catch (InstantiationException e) {
e.printStackTrace();
System.exit(1);
} catch (IllegalAccessException e) {
e.printStackTrace();
System.exit(1);
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.exit(1);
}

Statement updatestmt =
con.createStatement(ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_UPDATABLE);

ResultSet resultset = updatestmt
.executeQuery("SELECT * FROM `image` WHERE `house_id`
= 1");
resultset.first();
// fine till here
resultset.updateBlob("image", new URL( // <==== line

1. <hardware> An electrical conductor.  For distances larger
	than a breadbox, a single line may consist of two electrical
	conductors in twisted, parallel, or concentric arrangement
	used to transport one logical signal.

	By extension, a (usually physical) medium such as an {optical
	fibre} which carries a signal.

	(1995-09-29)

52
"http://www.woonnet-haaglanden.nl/library/fotos/
18/12845.jpg")
.openStream());
resultset.updateRow();
resultset.close();
updatestmt.close();

Statement readstmt = null;
readstmt =
con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);

resultset = readstmt.executeQuery("SELECT * FROM `image` " //
+ "WHERE `house_id` = 1;");
resultset.first();
InputStream theimage =
resultset.getBlob("image").getBinaryStream();

Image image = ImageIO.read(theimage);

// Use a label to display the image
JFrame frame

1. <networking> A {data link layer} "packet" which contains the
	header and trailer information required by the physical
	medium.  That is, {network layer} {packets} are encapsulated
	to become frames.

	See also {datagram}, {encapsulation}, {packet}, {Maximum
	Transmission Unit}.

	2. <programming> (language implementation) See {activation
	record}.

	3. <hardware> One complete scan of the active area of a
	{display screen}.  Each frame consists of a number N of
	horizontal {scan lines}, each of which, on a computer display,
	consists of a number M of {pixels}.  N is the {vertical
	resolution} of the display and M is the {horizontal
	resolution}.  The rate at which the displayed image is updated
	is the {refresh rate} in frames per second.

	(2000-10-07)

= new JFrame();
JLabel label = new JLabel(new ImageIcon(image));
frame.getContentPane().add(label, BorderLayout.CENTER);
frame.pack();
frame.setVisible(true);
}
}
######

From: =?ISO-8859-1?Q?Arne_Vajh=F8j?=

Date: Tuesday, October 02, 2007

wrote in message:

Googling for UpdatableResultset updateBlob AbstractMethodError gets me
lost. Any help is well appreciated.

### stderr output ###
Exception in thread "main" JAVA.lang.AbstractMethodError:
com.mysql.jdbc.UpdatableResultSet.updateBlob(LJAVA/lang/String;LJAVA/
io/InputStream;)V
at nl.vanleeuwenwilmot.housing.search.woonnet.app.Test.main(Test.JAVA:
52)
######

What version

<programming> One of a sequence of copies of a program, each
	incorporating new modifications.  Each version is usually
	identified by a number, commonly of the form X.Y where X is
	the major version number and Y is the release number.
	Typically an increment in X (with Y reset to zero) signifies a
	substantial increase in the function of the program or a
	partial or total re-implementation, whereas Y increases each
	time the progam is changed in any way and re-released.

	Version numbers are useful so that the user can know if the
	program has changed ({bugs} have been fixed or new functions
	added) since he obtained his copy and the programmer can tell
	if a bug report relates to the current version.  It is thus
	always important to state the version when reporting bugs.
	Statements about compatibility between different software
	components should always say which versions they apply to.

	See {change management}.

	(1997-12-07)

of the MySQL JDBC

<database, programming> (JDBC) Part of the {Java Development
	Kit} which defines an {application programming interface} for
	{Java} for standard {SQL} access to {databases} from Java
	{programs}.

	{Home
	(http://java.sun.com/products/jdk/1.1/docs/guide/jdbc/index.html)}.

	{FAQ (http://www.yoyoweb.com/Javanese/JDBC/FAQ.html)}.

	See also {Open Database Connectivity}.

	(1997-09-04)

driver

1. <operating system> {device driver}.

	2. <programming> The {main loop} of an event-processing
	program; the code that gets commands and dispatches them for
	execution.

	3. <tool> In the {TeX} world and the computerised typesetting
	world in general, a program that translates some
	device-independent or other common format to something a real
	device can actually understand.

	[{Jargon File}]

are you using ?

I suspect an old version that doesn't have this method

<programming> The name given in {Smalltalk} and other
	{object-oriented languages} to a procedure or routine
	associated with one or more {classes}.  An {object} of a
	certain class knows how to perform actions, e.g. printing
	itself or creating a new instance of itself, rather than the
	function (e.g. printing) knowing how to handle different types
	of object.

	Different classes may define methods with the same name
	(i.e. methods may be {polymorphic}).  The term "method" is used
	both for a named operation, e.g. "PRINT" and also for the code
	which a specific class provides to perform tha
	t operation.

	Most methods operate on objects that are instances of a
	certain class.  Some object-oriented languages call these
	"object methods" to distinguish then from "{class methods}".

	In {Smalltalk}, a method is defined by giving its name,
	documentation, temporary local variables and a sequence of
	expressions separated by "."s.

	(2000-03-22)

.

Arne

From: Dyreatnews

Date: Tuesday, October 02, 2007

"pjvleeuwen@xxxxxxxxxxx" <pjvleeuwen@xxxxxxxxxxx> writes:

Hi all,
I'm quite new to all jdbc, but so far working with resultset's over
SQL seemed easy so far, but I'm having some problems writing a blob to
the database.
What I try to do is two steps:
1. read an image from the web and write it to a blob
2. read the blob and display it as an image
I did the same thing before without trying to write to the blob, but I
want to store the images in DB because the only stay on the web for a
couple of weeks.
Googling for UpdatableResultset updateBlob AbstractMethodError gets me
lost. Any help is well appreciated.

Why do you've to use an updatable result set to store the blob? Why
can not you use an ordnary update statment?

I do not know if MySQL supports updatable result sets with blobs, (it
probably does) but why make things more complicated than necessary...?

--
dt

From: pjvleeuwen

Date: Tuesday, October 02, 2007

Sorry for the late response, just back from diner.

Arne

What version of the MySQL JDBC driver are you using ?
<dependency>

<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.0.3</version>
</dependency>
And MySQL monitor

1. A {cathode-ray tube} and associated electronics connected
	to a computer's video output.  A monitor may be either
	{monochrome} (black and white) or colour ({RGB}).  Colour
	monitors may show either digital colour (each of the red,
	green and blue signals may be either on or off, giving eight
	possible colours: black, white, red, green, blue, cyan,
	magenta and yellow) or analog colour (red, green and blue
	signals are continuously variable allowing any combination to
	be displayed).  Digital monitors are sometimes known as {TTL}
	because the voltages on the red, green and blue inputs are
	compatible with TTL logic chips.

	See also {gamut}, {multisync}, {visual display unit}.

	2. A programming language construct which encapsulates
	variables, access procedures and initialisation code within an
	abstract data type.  The monitor's variable may only be
	accessed via its access procedures and only one process may be
	actively accessing the monitor at any one time.  The access
	procedures are {critical sections}.  A monitor may have a
	queue of processes which are waiting to access it.

	3. A hardware device that measures electrical events such as
	pulses or voltage levels in a digital computer.

	4. To oversee a program during execution.  For example, the
	monitor function in the {Unix} {C} library enables profiling
	of a certain range of code addresses.  A histogram is produced
	showing how often the {program counter} was found to be at
	each position and how often each profiled function was called.

	{Unix} {man} page: monitor(3).

	5. A control program within the {operating system} that
	manages the allocation of system resources to active
	programs.

	6. A program that measures software performance.

informed me that I have 5.0.26-community-nt...

Dt

Why do you've to use an updatable result set to store the blob? Why
can not you use an ordnary update statment?

Since I would not know the answer to that question I also tried the
following

PreparedStatement pstmt = con
.prepareStatement("INSERT INTO `image` (`house_id`,
`image`) "
+ "VALUES(1, ?)");
pstmt.setBlob(1, new URL( // <===============line 51
"http://www.woonnet-haaglanden.nl/library/fotos/
18/12845.jpg")
.openStream());
pstmt.executeUpdate();

Exception in thread "main" JAVA.lang.AbstractMethodError:
com.mysql.jdbc.ServerPreparedStatement.setBlob(ILJAVA/io/
InputStream;)V
at nl.vanleeuwenwilmot.housing.search.woonnet.app.Test.main(Test.JAVA:
51)

And if I try setObject like the following I get no error

1. A discrepancy between a computed, observed, or measured
	value or condition and the true, specified, or theoretically
	correct value or condition.

	2. <programming> A mental mistake made by a programmer that
	may result in a program {fault}.

	3. (verb) What a program does when it stops as result of a
	programming error.

	(2000-03-28)

at 51, but a
null-pointer exception

An error condition that changes the normal {flow of control}
	in a program.  An exception may be generated ("raised") by
	{hardware} or {software}.  Hardware exceptions include
	{reset}, {interrupt} or a signal from a {memory management
	unit}.  Exceptions may be generated by the {arithmetic logic
	unit} or {floating-point unit} for numerical errors such as
	divide by zero, {overflow} or {underflow} or {instruction
	decoding} errors such as privileged, reserved, {trap} or
	undefined instructions.  Software exceptions are even more
	varied and the term could be applied to any kind of error
	checking which alters the normal behaviour of the program.

	(1994-10-31)

after reading it.

public static void main(String[] args) throws IOException,
SQLException {

Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql:///woonnet",
"root",
"<A2Cc|4w");
} catch (InstantiationException e) {
e.printStackTrace();
System.exit(1);
} catch (IllegalAccessException e) {
e.printStackTrace();
System.exit(1);
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.exit(1);
}

PreparedStatement pstmt = con
.prepareStatement("INSERT INTO `image` (`house_id`,
`image`) "
+ "VALUES(1, ?)");
pstmt.setObject(1, new URL(
"http://www.woonnet-haaglanden.nl/library/fotos/
18/12845.jpg")
.openStream());
pstmt.executeUpdate();

Statement readstmt = null;
readstmt =
con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);

ResultSet resultset = readstmt.executeQuery("SELECT * FROM
`image` " //
+ "WHERE `house_id` = 1;");
resultset.first();
InputStream theimage =
resultset.getBlob("image").getBinaryStream();

Image image = ImageIO.read(theimage);

// Use a label to display the image
JFrame frame = new JFrame();
JLabel label = new JLabel(new ImageIcon(image)); // <=== line
69
frame.getContentPane().add(label, BorderLayout.CENTER);
frame.pack();
frame.setVisible(true);
}

Exception in thread "main" JAVA.lang.NullPointerException
at JAVAx.swing.ImageIcon.<init>(ImageIcon.JAVA:161)
at nl.vanleeuwenwilmot.housing.search.woonnet.app.Test.main(Test.JAVA:
69)Further more I tried reading the inputstream to a string

<programming> A sequence of {data} values, usually {bytes},
	which usually stand for {characters} (a "character string").
	The {mapping} between values and characters is determined by
	the {character set} which is itself specified implcitly or
	explicitly by the environment in which the string is being
	interpreted.

	The most common character set is {ASCII} but, since the late
	1990s, there has been increased interest in larger character
	sets such as {Unicode} where each character is represented by
	more than eight {bits}.

	Most programming languages consider strings (e.g.
	"124:shabooya:\n", "hello world") basically distinct from
	numbers which are typically stored in fixed-length {binary} or
	{floating-point} representation.

	A {bit string} is a sequence of {bits}.

	(1999-12-21)

(and play
ignorant on charset headaches), but I could not get that to work...
(furthermore, it does not seem the right way to go).

*Any* suggestions are warmly welcome. I stay tuned..
(oh and off topic suggestions on coding like dt.'s are also welcome,
there's just a lot that I do not know...)

From: David Harper

Date: Tuesday, October 02, 2007

wrote in message:
[SNIP]

### stderr output ###
Exception in thread "main" JAVA.lang.AbstractMethodError:
com.mysql.jdbc.UpdatableResultSet.updateBlob(LJAVA/lang/String;LJAVA/
io/InputStream;)V
at nl.vanleeuwenwilmot.housing.search.woonnet.app.Test.main(Test.JAVA:
52)
######
[SNIP]

The Java

<programming, language, portability> (After the Indonesian island, a
	source of {programming fluid}) A simple, {object-oriented},
	{distributed}, {interpreted}, robust, secure,
	{architecture-neutral}, {portable}, {multithreaded}, dynamic,
	buzzword-compliant, general-purpose programming language
	developed by {Sun Microsystems} in the early 1990's (initially for
	set-top television controllers), and released to the public in 1995.

	Java first became popular by being the earliest portable
	dynamic client-side content for the {World-Wide Web} in the
	form of {platform}-independent Java "applets". In the late
	1990's and into the 2000's it has also become very popular
	on the server side, where an entire set of {APIs} defines the {J2EE}.

	Java is both a set of public specifications (controlled by
	{Sun Microsystems} through the {JCP}) and a series of
	implementations of those specifications.

	Java is syntactially similar to {C++} without user-definable
	{operator overloading}, (though it does have {method}
	overloading), without {multiple inheritance}, and extensive
	automatic {coercions}.  It has automatic {garbage collection}.
	Java extends {C++}'s {object-oriented} facilities with those
	of {Objective C} for {dynamic method resolution}.

	Whereas programs in C++ and similar languages are compiled
	and linked to platform-specific binary executables, Java
	programs are typically compiled to portable {architecture-neutral}
	{bytecode} or ".class" files, which are run using a {Java
	Virtual Machine}.  The JVM is also called an {interpreter},
	though it is more correct to say that it uses {Just-In-Time
	Compilation} to convert the {bytecode} into {native} {machine
	code}, yielding greater efficiency than most interpreted
	languages, rivalling C++ for many long-running, non-GUI
	applications.  The run-time system is typically written in
	{POSIX}-compliant {ANSI C} or {C++}.  Some implementations
	allow Java class files to be translated into {native}
	{machine code} during or after compilation.

	The Java compiler and {linker} both enforce {strong type
	checking} - procedures must be explicitly typed.  Java
	supports the creation of {virus}-free, tamper-free systems
	with {authentication} based on {public-key encryption}.

	Java has an extensive library of routines for all kinds of
	programming tasks, rivalling that of other languages.

	For example, the "java.net} package supports {TCP/IP}
	{protocols} like {HTTP} and {FTP}.  Java applications can
	access objects across the {Internet} via {URLs} almost as easily as
	on the local {file system}. There are also capabilities for
	several types of distributed applications.

	The Java {GUI} libraries provide portable interfaces.  For example,
	there is an abstract Window class and implementations of it
	for {Unix}, {Microsoft Windows} and the {Macintosh}.
	The "java.awt" and "javax.swing" classes can be used either in
	Web-based "Applets" or in client-side or "desktop" applications.

	There are also packages for developing {XML} applications,
	{web services}, {servlets} and other web applications,
	{security}, date and time calculations and I/O formatting,
	database ({JDBC}), and many others.

	Java is not directly related to {JavaScript} despite the name.

	{Home (http://java.sun.com/)}.

	{Usenet} newsgroup: {news:comp.lang.java}.

	(2005-01-21)

API

<programming> (API, or "application programming interface")
	The interface (calling conventions) by which an {application
	program} accesses {operating system} and other services.  An
	API is defined at {source code} level and provides a level of
	{abstraction} between the application and the {kernel} (or
	other privileged utilities) to ensure the {portability} of the
	code.

	An API can also provide an interface between a {high level
	language} and lower level utilities and services which were
	written without consideration for the {calling conventions}
	supported by compiled languages.  In this case, the API's main
	task may be the translation of parameter lists from one format
	to another and the interpretation of {call-by-value} and
	{call-by-reference} arguments in one or both directions.

	(1995-02-15)

(application

1. {application program}.

	2. {function application}.

program

<programming> (Or "computer program", "program", "code") The
	instructions executed by a computer, as opposed to the
	physical device on which they run (the "{hardware}").

	The term was coined by the eminent statistician, {John Tukey}.

	Programs stored on {non-volatile storage} built from
	{integrated circuits} (e.g. {ROM} or {PROM}) are usually
	called {firmware}.

	Software can be split into two main types - {system software}
	and application software or {application programs}.  System
	software is any software required to support the production or
	execution of application programs but which is not specific to
	any particular application.  Examples of system software would
	include the {operating system}, {compilers}, editors and
	sorting programs.

	Examples of application programs would include an accounts
	package or a {CAD} program.  Other broad classes of
	application software include {real-time} software, {business
	software}, scientific and engineering software, {embedded
	software}, personal computer software and {artificial
	intelligence} software.

	Software includes both {source code} written by humans and
	executable {machine code} produced by {assemblers} or
	{compilers}.  It does not usually include the data processed
	by programs unless this is in a format such as {multimedia}
	which depends on the use of computers for its presentation.
	This distinction becomes unclear in cases such as {spread
	sheets} which can contain both instructions (formulae and
	{macros}) and data.  There are also various intermediate
	compiled or {semi-compiled}, forms of software such as
	{library} files and {byte-code}.

	Some claim that {documentation} (both paper and electronic) is
	also software.  Others go further and define software to be
	programs plus documentation though this does not correspond
	with common usage.

	The noun "program" describes a single, complete and
	more-or-less self-contained list of instructions, often stored
	in a single {file}, whereas "code" and "software" are
	uncountable nouns describing some number of instructions which
	may constitute one or more programs or part thereof.  Most
	programs, however, rely heavily on various kinds of {operating
	system} software for their execution.  The nounds "code" and
	"software" both refer to the same thing but "code" tends to
	suggest an interest in the implementation details whereas
	"software" is more of a user's term.

	(2002-07-21)

ming int

1. <programming> A common name for the {integer} data type.
	In {C} for example, it means a (signed) integer of the
	computer's native {word length}.

	2. <networking> The {top-level domain} for international
	organisations.

	(1999-01-26)

erface)documentation for JAVA.lang.AbstractMethodError explains:

public class AbstractMethodError
extends IncompatibleClassChangeError

Thrown when an application tries to call an abstract method. Normally,
this error is caught by the compiler

<programming, tool> A program that converts another program
	from some {source language} (or {programming language}) to
	{machine language} (object code).  Some compilers output
	{assembly language} which is then converted to {machine
	language} by a separate {assembler}.

	A compiler is distinguished from an assembler by the fact that
	each input statement does not, in general, correspond to a
	single machine instruction or fixed sequence of instructions.
	A compiler may support such features as automatic allocation
	of variables, arbitrary arithmetic expressions, control
	structures such as FOR and WHILE loops, variable {scope},
	input/ouput operations, {higher-order functions} and
	{portability} of source code.

	{AUTOCODER}, written in 1952, was possibly the first primitive
	compiler.  {Laning and Zierler}'s compiler, written in
	1953-1954, was possibly the first true working algebraic
	compiler.

	See also {byte-code compiler}, {native compiler}, {optimising
	compiler}.

	(1994-11-07)

; this error can only occur at run

<operating system, programming> The process of carrying out
	the {instructions} in a computer program by a computer.

	See also {dry run}.

	(1996-05-13)

time if the definition of some class has incompatibly changed since
the currently executing method was last compiled.

This can happen if you've two versions of the Connector/J JAR file

<file system> An element of data storage in a {file system}.

	The history of computing is rich in varied kinds of files and
	{file systems}, whether ornate (e.g., {Macintosh file system}
	for a well-known case) or deficient (e.g., many simple
	pre-1980s file systems don't allow {directories}).

	However, the prototypical file has these characteristics:

	* It is a single sequence of bytes (but consider {Macintosh}
	{resource forks}).

	* It has a finite length, unlike, e.g. a {Unix} {device}.

	* It is stored in a {non-volatile storage} medium (but see
	{ramdrive}).

	* It exists (nominally) in a {directory}.

	* It has a name that it can be referred to by in file
	operations, possibly in combination with its {path}.

	Additionally, a file system may associate other information
	with a file, such as {permission} bits or other {file
	attributes}; timestamps for file creation, last revision, and
	last access; revision numbers (a` la VMS), and other kinds of
	{magic}.

	Compare: {document}.

	(1997-04-08)

,
and you are using the newer one when compiling your code

<software> Instructions for a computer in some programming
	language, often {machine language}.  The word "code" is often
	used to distinguish instructions from {data} (e.g. "The code
	is marked 'read-only'") whereas "{software}" is used in
	contrast with "{hardware}" and may consist of more than just
	code.

	(2000-04-08)

but an older
version when running it. Check your compile-time and run-time
classpaths to ensure that they both reference

1. <programming> An {address}, from the point of view of a
	programming language.  A pointer may be typed, with its {type}
	indicating the type of data to which it points.

	The terms "pointer" and "reference" are generally
	interchangable although particular programming languages often
	differentiate these two in subtle ways.  For example, {Perl}
	always calls them references, never pointers.  Conversely, in
	C, "pointer" is used, although "a reference" is often used to
	denote the concept that a pointer implements.

	{Anthony Hoare} once said:

	Pointers are like jumps, leading wildly from one part of the
	data structure to another.  Their introduction into high-level
	languages has been a step backward from which we may never
	recover.

	[C.A.R.Hoare "Hints on Programming Language Design", 1973,
	Prentice-Hall collection of essays and papers by Tony Hoare].

	2. <operating system> (Or "mouse pointer") An {icon}, usually
	a small arrow, that moves on the screen in response to
	movement of a {pointing device}, typically a {mouse}.  The
	pointer shows the user which object on the screen will be
	selected etc. when a mouse button is clicked.

	(1999-07-07)

the newer version of the
JAR file.

David Harper
Cambridge, England

From: pjvleeuwen

Date: Tuesday, October 02, 2007

David

Thrown when an application tries to call an abstract method. Normally,
this error is caught by the compiler; this error can only occur at run

version when running it. Check your compile-time and run-time
classpaths to ensure that they both reference the newer version of the
JAR file.

Thanks, but I only *have* one version. I guess the MySQL Connection\J
guys felt that the next "*Normally* this error..." was optional. :)

$ ls -R .m2/repository/mysql/
.m2/repository/mysql/:
mysql-connector-JAVA

.m2/repository/mysql/mysql-connector-JAVA:
5.0.3

.m2/repository/mysql/mysql-connector-JAVA/5.0.3:
mysql-connector-JAVA-5.0.3.jar

<file format, filename extension> (jar) A compressed {archive}
	file containing {Java} {class} files, filename extension:
	".jar".  The {Java Development Kit} contains a tool called
	"jar" for creating .jar files, similar to the standard {Unix}
	{tar} command.  As well as archiving and compressing the Java
	class files, it also inserts a "manifest" file which can
	contain information about the class files, such as a {digital
	signature}.  Combining class files into a single archive file
	makes it possible to download them in a single {HTTP}
	transaction.  This, and the {compression}, speeds up execution
	of Java programs delivered via the {Internet}.

	(2001}-02-03)

mysql-connector-JAVA-5.0.3.jar.sha1
mysql-connector-JAVA-5.0.3.pom mysql-connector-JAVA-5.0.3.pom.sha1

From: Lew

Date: Tuesday, October 02, 2007

wrote in message:

ResultSet.TYPE_FORWARD_ONLY,
...
resultset.first();

<http://JAVA.sun.com/JAVAse/6/docs/api/JAVA/sql/ResultSet.html#first()>

Returns:
true if the cursor

1. <hardware> A visually distinct mark on a display indicating
	where newly typed text will be inserted.  The cursor moves as
	text is typed and, in most modern editors, can be moved around
	within a document by the user to change the insertion point.

	2. <database> In {SQL}, a named control structure used by an
	{application program} to point to a row of data.  The position
	of the {row} is within a {table} or {view}, and the cursor is
	used interactively so select rows from columns.

	(1996-12-27)

is on a valid row; false if there are no rows in the result set

You do not check the return code. This might not matter here, but you should
be aware of it.

Throws:
SQLException - if ... this method is called on a ... result set type

<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)

... TYPE_FORWARD_ONLY

Which is what you typed your ResultSet.

PreparedStatement pstmt = con
.prepareStatement("INSERT INTO `image` (`house_id`,
`image`) "
+ "VALUES(1, ?)");
pstmt.setBlob(1, new URL( // <===============line 51
"http://www.woonnet-haaglanden.nl/library/fotos/18/12845.jpg" )
.openStream());
pstmt.executeUpdate();
Exception in thread "main" JAVA.lang.AbstractMethodError:
com.mysql.jdbc.ServerPreparedStatement.setBlob(ILJAVA/io/
InputStream;)V
at nl.vanleeuwenwilmot.housing.search.woonnet.app.Test.main(Test.JAVA:
51)

This is pretty much the same error you got with the ResultSet.

And if I try setObject like the following I get no error at 51, but a
null-pointer exception after reading it.
public static void main(String[] args) throws IOException,
SQLException {
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();

You do not need the newInstance(). You could also do the forName() call in a
static initializer.

...

PreparedStatement pstmt = con
.prepareStatement("INSERT INTO `image` (`house_id`,
`image`) "
+ "VALUES(1, ?)");
pstmt.setObject(1, new URL(
"http://www.woonnet-haaglanden.nl/library/fotos/18/12845.jpg")
.openStream());
pstmt.executeUpdate();
Statement readstmt = null;
readstmt =
con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet resultset = readstmt.executeQuery("SELECT * FROM
`image` " //
+ "WHERE `house_id` = 1;");
resultset.first();

This time it's with a ResultSet.TYPE_SCROLL_INSENSITIVE, but you still should
consider using next() instead, and you must check the return code!

InputStream theimage =
resultset.getBlob("image").getBinaryStream();
Image image = ImageIO.read(theimage);
// Use a label to display the image
JFrame frame = new JFrame();
JLabel label = new JLabel(new ImageIcon(image)); // <=== line
69
frame.getContentPane().add(label, BorderLayout.CENTER);
frame.pack();
frame.setVisible(true);
}
Exception in thread "main" JAVA.lang.NullPointerException
at JAVAx.swing.ImageIcon.<init>(ImageIcon.JAVA:161)
at nl.vanleeuwenwilmot.housing.search.woonnet.app.Test.main(Test.JAVA:
69)
Further more I tried reading the inputstream

That's "InputStream".

to a string (and playignorant on charset headaches), but I could not get that to work...
(furthermore, it does not seem the right way to go).

It is not, but byte[]'d be all right.

The AbstractMethodError only occurs if the implementing class for the abstract
call isn't available or incompatible at run time. Something is not finding
the MySQL-specific implementation of these methods. I'd review how you've
the MySQL JAR located in your classpath.

It's a weird one, because a classpath issue shows up at compile time, or worst
case, at runtime when the Class.forName() fails. How you could get to the
MySQL Driver class and not have access to its implementation classes is a mystery.

There's a clue, however, at the MySQL web site:
<http://dev.mysql.com/doc/refman/5.0/en/connector-j-installing-classpath.html>
where the tell you to put the JAR

mysql-connector-JAVA-[version]-bin.jar

in your classpath, but you have got

mysql-connector-JAVA-5.0.3.jar

I download

<jargon> To transfer data from one computer to another.
	Downloading usually refers to transfer from a larger "host"
	system (especially a {server} or {mainframe}) to a smaller
	"client" system, especially a {microcomputer} or specialised
	peripheral, and "{upload}" usually means from small to large.

	Others hold that, technically, download means "receive" and
	upload means "send", irrespective of the size of the systems
	involved.

	Note that in communications between ground and space,
	space-to-earth transmission is always "down" and the reverse
	"up", regardless of size.  So far the in-space machines have
	invariably been smaller; thus the upload/download distinction
	has been reversed from its usual sense.

	[{Jargon File}]

	(2003-11-04)

ed the latest Connector/J (version 5.0.7) and there was only the
*-bin.jar version, not the version without the "-bin".

--
Lew

From: David Harper

Date: Wednesday, October 03, 2007

wrote in message:

David
Thrown when an application tries to call an abstract method. Normally,
this error is caught by the compiler; this error can only occur at run
version when running it. Check your compile-time and run-time
classpaths to ensure that they both reference the newer version of the
JAR file.
Thanks, but I only *have* one version. I guess the MySQL Connection\J
guys felt that the next "*Normally* this error..." was optional. :)

I suspect that I was not thinking clearly last night. Sorry. Here's a
more likely explanation.

Your code never refers directly to the concrete implementation classes
in the Connector/J JAR file (such as com.mysql.jdbc.Driver) but only to
the classes (actually, mostly interfaces, like JAVA.sql.Driver) in
JAVA.sql.* and JAVAx.sql.*

Therefore, your compiler will have no reason to check any of the classes
in the Connector/J JAR file, and the abstract method problem isn't
detected at compile time. Remember that JAVA.sql.ResultSet, like
JAVA.sql.Driver, is an interface, not a class.

You only hit

1. <architecture> {cache hit}.

	2. <World-Wide Web> A request to a {web server} from a {web
	browser} or other {client} (e.g. a {robot}).

	The number of hits on a server may be important for
	determining advertising revenue.

	In the course of loading a single {web page}, a browser may
	hit a web server many times e.g. to retrieve the page itself
	and each {image} on the page.  In contrast, caching by
	browsers and {web proxies} reduces the number of hits on the
	server because some requests are satisfied from the cache.

	3. <jargon> To press and release a key on the keyboard.  Some
	prefer the less aggressive "tap".

	(2000-02-20)

the abstract method problem when you actually run your
code, and the JAVA virtual

<jargon, architecture> (Via the technical term {virtual
	memory}, probably from the term "virtual image" in optics)
	1. Common alternative to {logical}; often used to refer to the
	artificial objects (like addressable {virtual memory} larger
	than physical memory) created by a computer system to help the
	system control access to shared resources.

	2. Simulated; performing the functions of something that isn't
	really there.  An imaginative child's doll may be a virtual
	playmate.

	Opposite of {real} or physical.

	[{Jargon File}]

	(1994-11-30)

machine

Common term for "computer", usually when considered at the
	hardware level.  The {Turing Machine}, an early example of
	this usage, was however neither hardware nor software, but
	only an idea.

	[Earlier use?]

	(1995-02-15)

needs to load

1. To copy {data} (often {program} {code} to be {run}) into
	{memory}, possibly {parsing} it somehow in the process.
	E.g. "{WordPerfect} can't load this {RTF} file - are you sure
	it didn't get corrupted in the {download}?"  Opposite of
	{save}.

	2. The degree to which a computer, {network}, or other
	resource is used, sometimes expressed as a percentage of the
	maximum available.  E.g. "What kind of CPU load does that
	program give?", "The network's constantly running at 100%
	load".  Sometimes used, by extension, to mean "to increase the
	level of use of a resource".  E.g. "Loading a spreadsheet
	really loads the CPU".  See also: {load balancing}.

	3. To {install} a piece of {software} onto a system.
	E.g. "The computer guy is gonna come load Excel on my laptop
	for me".  This usage is widely considered to be incorrect.

	(2002-07-02)

the concrete classes
such as com.mysql.jdbc.Driver, which implements the JAVA.sql.Driver
interface.

When your program reaches the call to ResultSet.updateBlob at line 52,
the JVM

<language, architecture> (JVM) A specification for software
	which interprets {Java} programs that have been compiled into
	{byte-codes}, and usually stored in a ".class" file.  The JVM
	{instruction set} is {stack}-oriented, with variable
	instruction length.  Unlike some other instruction sets, the
	JVM's supports {object-oriented} programming directly by
	including instructions for object {method} invocation (similar
	to {subroutine} call in other instruction sets).

	The JVM itself is written in {C} and so can be {ported} to run
	on most {platforms}.  It needs {thread} support and {I/O} (for
	{dynamic class loading}).  The Java byte-code is independent
	of the platform.

	There are also some hardware implementations of the JVM.

	{Specification
	(http://www.javasoft.com/docs/books/vmspec/html/VMSpecTOC.doc.html)}.

	{Sun's Java chip
	(http://news.com/News/Item/0,4,9328,00.html)}.

	[Documentation?  Versions?]

	(2000-01-03)

attempts to call the method updateBlob on a concrete
com.mysql.jdbc.UpdatableResultSet object. That method is apparently
abstract, and you get the mysterious AbstractMethodError.

I hope this makes better sense :-)

David Harper
Cambridge, England

From: pjvleeuwen

Date: Wednesday, October 03, 2007

David

When your program reaches the call to ResultSet.updateBlob at line 52,
the JVM attempts to call the method updateBlob on a concrete
com.mysql.jdbc.UpdatableResultSet object. That method is apparently
abstract, and you get the mysterious AbstractMethodError.

So MySQL Connector/J does not implement any code for handling blobs
here. Makes the most sence to me. Forget about the nice blob interface
then.

Lew

> to a string (and playignorant on charset headaches), but I could not get that to work...
> (furthermore, it does not seem the right way to go).
It is not, but byte[]'d be all right.

You are very right there. I liked the Blob's because they work with
streams, but the following code below works! With byte[].I will just wrap it in an URL2Bytes utility class and all is done.
Thanks for all your tips! Ciao

public static void main(String[] args)
throws MalformedURLException,
IOException, SQLException {
// download photo to byte[]
URL fileurl = new URL(
"http://www.woonnet-haaglanden.nl/"
+ "library/fotos/18/12845.jpg");
int length = fileurl.openConnection()
.getContentLength();
byte[] bytebuf = new byte[length];
InputStream is = fileurl.openStream();
byte[] b = new byte[1];
for (int I = 0; is.read(b) > -1; i++) {
bytebuf[i] = b[0];
}

// write to DB
Connection con = null;
try {
Class
.forName(
"com.mysql.jdbc.Driver")
.newInstance();
con = DriverManager.getConnection(
"jdbc:mysql:///woonnet",
"root", "<A2Cc|4w");
} catch (InstantiationException e) {
e.printStackTrace();
System.exit(1);
} catch (IllegalAccessException e) {
e.printStackTrace();
System.exit(1);
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.exit(1);
}
PreparedStatement pstmt = con
.prepareStatement("INSERT INTO `image` "
+ "(`house_id`, `image`) "
+ "VALUES(4, ?)");
pstmt.setBytes(1, bytebuf);
pstmt.executeUpdate();

// read from DB
Statement readstmt = con
.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet resultset = readstmt
.executeQuery("SELECT * FROM `image` " //
+ "WHERE `house_id` = 4;");
resultset.first();
byte[] readbytes = resultset
.getBytes("image");
Image image = ImageIO
.read(new ByteArrayInputStream(
readbytes));

// Use a label to display the image
JFrame frame = new JFrame();
JLabel label = new JLabel(new ImageIcon(
image));
frame.getContentPane().add(label,
BorderLayout.CENTER);
frame.pack();
frame.setVisible(true);
}

From: Lew

Date: Wednesday, October 03, 2007

wrote in message:

public static void main(String[] args)
throws MalformedURLException,
IOException, SQLException {
...
// write to DB
Connection con = null;
try {
Class
.forName(
"com.mysql.jdbc.Driver")
.newInstance();

Why are you creating a throwaway instance

<programming> An individual {object} of a certain {class}.
	While a class is just the type definition, an actual usage of
	a class is called "instance".  Each instance of a class can
	have different values for its {instance variables}, i.e. its
	{state}.

	(1998-03-06)

here?

--
Lew

From: Lew

Date: Wednesday, October 03, 2007

wrote in message:

PreparedStatement pstmt = con
.prepareStatement("INSERT INTO `image` "
+ "(`house_id`, `image`) "
+ "VALUES(4, ?)");

Remember, prepareStatement() "[t]hrows ... SQLException ... if a database
access error occurs or this method is called on a closed connection."

pstmt.executeUpdate();

This method call returns a value that you shouldn't ignore, nor should you
ignore the possible SQLException.

// read from DB
Statement readstmt = con
.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);

"Throws ... SQLException ... if a database access error occurs or this method
is called on a closed connection"

ResultSet resultset = readstmt
.executeQuery("SELECT * FROM `image` " //
+ "WHERE `house_id` = 4;");

possible SQLException

resultset.first();

Why not call next(), and why, oh, why do you disregard the returned value?

--
Lew

From: =?UTF-8?B?QXJuZSBWYWpow7hq?=

Date: Thursday, October 04, 2007

wrote in message:
wrote in message:
public static void main(String[] args)
throws MalformedURLException,
IOException, SQLException {
...
// write to DB
Connection con = null;
try {
Class
.forName(
"com.mysql.jdbc.Driver")
.newInstance();
Why are you creating a throwaway instance here?

That is a common practice when loading the MySQL JDBC
driver.

My guess is that some very old version of the driver
register

1. One of a small number of high-speed memory locations in a
	computer's {CPU}.  Registers differ from ordinary
	{random access memory} in several respects:

	There are only a small number of registers (the "register
	set"), typically 32 in a modern processor though some,
	e.g. {SPARC}, have as many as 144.  A register may be directly
	addressed with a few bits.  In contrast, there are usually
	millions of words of main memory (RAM), requiring at least
	twenty bits to specify a memory location.  Main memory
	locations are often specified indirectly, using an {indirect
	addressing} mode where the actual memory address is held in a
	register.

	Registers are fast; typically, two registers can be read and a
	third written -- all in a single cycle.  Memory is slower; a
	single access can require several cycles.

	The limited size and high speed of the register set makes it
	one of the critical resources in most computer architectures.
	{Register allocation}, typically one phase of the {back-end},
	controls the use of registers by a compiled program.

	See also {accumulator}, {FUBAR}, {orthogonal}, {register
	dancing}, {register allocation}, {register spilling}.

	2. An addressable location in a {memory-mapped} peripheral
	device.  E.g. the transmit data register in a {UART}.

ed itself with DriverManager in the constructor,
so that it was necessary.

It isn't necessary today and hasn't been for many years,
but you'll see that code all the time.

The MySQL docs even use it even though they blame JAVA:

<quote>
Example 3.1. Registering the Driver With the DriverManager

The following section of JAVA code shows how you might register MySQL
Connector/J from the main() method of your application.

import JAVA.sql.Connection;
import JAVA.sql.DriverManager;
import JAVA.sql.SQLException;

// Notice, don't import com.mysql.jdbc.*
// or you'll have problems!

public class LoadDriver {
public static void main(String[] args) {
try {
// The newInstance() call is a work around for some
// broken

Not working properly (of programs).

JAVA implementations

Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
// handle

1. <programming, operating system> A simple item of data that
	identifies a resource.  For example, a {Unix} file handle
	identifies an open file and associated data such as whether it
	was opened for read or write and the current read/write
	position.  On the {Macintosh}, a handle is a pointer to a
	pointer to some dynamically-allocated memory.  The extra level
	of indirection allows on-the-fly {memory compaction} or
	{garbage collection} without invalidating application program
	references to the allocated memory.

	2. <jargon> An alias used intended to conceal a user's true
	identity in an electronic message.  The term is common on
	Citizen's Band and other amateur radio but, in that context
	usually means the user's real name as {FCC} rules forbid
	concealing one's identity.

	Use of grandiose handles is characteristic of {crackers},
	{weenies}, {spods}, and other lower forms of network life;
	true hackers travel on their own reputations.

	Compare {nick}.

	[{Jargon File}]

	(2004-07-20)

the error
}
</quote>

Arne

Next Message: [Aaron J Tarter] Re: [comp.lang.JAVA.databases] Derby eclipse install