db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: JDBC driver error codes documentation, where?
Date Wed, 09 Feb 2005 22:23:03 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<body bgcolor="#ffffff" text="#000000">
You can get the error messages using property
retrieveMessagesFromServerOnGetMessage, which defaults to FALSE.<br>
&lt;satheesh&gt; java -D<b>ij.retrieveMessagesFromServerOnGetMessage=true</b>
ij&gt; connect 'jdbc:derby://localhost:1527/tdb' user 'junk' password
ij&gt;&nbsp; INSERT INTO Item (name) VALUES ("Panasonic DVD Player");<br>
ERROR 42X04: Column 'Panasonic DVD Player' is not in any table in the
FROM list or it appears within a join specification and is outside the
scope of the join specification or it appears in a HAVING clause and is
not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement
then 'Panasonic DVD Player' is not a column in the target table.<br>
IBM actually announced contributing source code for JDBC driver by
around March 2005. I think we should make this property default to TRUE
in Apache driver, if and when it is accepted by the community.<br>
Jonathan Eric Miller wrote:<br>
<blockquote cite="mid001801c50ef2$a3d92a40$e3118780@skate" type="cite">Does
anyone know where the error codes are listed for the JDBC driver?
The following is the error I get in ij if I accidentally use double
quotes instead of single quotes. Why oh why doesn't IBM's JDBC driver
print intelligible error messages? I can live with it as long as there
is documentation somewhere that maps the error codes into descriptive
text, but, where is it?
Any news on IBM turning over the source code for the JDBC driver?
ij&gt; INSERT INTO Item (name) VALUES ("Panasonic DVD Player");
Panasonic DV
D Player&para;42X04
ij&gt; INSERT INTO Item (name) VALUES ('Panasonic DVD Player');
1 row inserted/updated/deleted

View raw message