I get the following error using either the 3.0 or 3.01 jars of the
Connector/J:
com.mysql.jdbc.NotUpdatable: Result Set not updateable. The query that
generated this result s
et must select only one table, and must select all primary keys from
that table. See the JDBC 2.1 API Specification, section 5.6 for more
details.
at com.mysql.jdbc.ResultSet.updateObject(ResultSet.java:4252)
at com.mysql.jdbc.ResultSet.updateObject(ResultSet.java:4295)
at
com.bromsoft.soccer.batch.SelectDistinctPlayerAddress.initalize(SelectDistinctPlayerAddress.java:88)
at
com.bromsoft.soccer.batch.SelectDistinctPlayerAddress.<init>(SelectDistinctPlayerAddress.java:41)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)com.bromsoft.soccer.batch.SelectDistinctPlayerAddress.initalize(SelectDistinctPlayerAddress.java:88)
at
com.bromsoft.soccer.batch.SelectDistinctPlayerAddress.<init>(SelectDistinctPlayerAddress.java:41)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
I under stand the error but I am not using join and by doing a select *,
I should be including the primary key...
This is the snipplet of code that is causing the problem:
Connection con =
ConnectIO.getStaticConnection(Soccer.getDBString());
ConnectIO.executePreparedStatement(con,
"update players set selected = \"F\" ");
cat_.info("Players selected field has been cleared.");
ResultSet rs = ConnectIO.getResultSet(con,
"select id, zipcode, state, city, address,
lastname, firstname, selected, status from players where status = \"A\"
order by ZipCode, State, City, Address, LastName, FirstName ");
while (rs.next()) {
Integer id = (Integer) rs.getObject("ID");
String firstName = (String) rs.getObject("FirstName");
String lastName = (String) rs.getObject("LastName");
String address = (String) rs.getObject("Address");
String city = (String) rs.getObject("City");
String state = (String) rs.getObject("State");
String zipCode = (String) rs.getObject("ZipCode");
if (!address.equals(lastAddress) ||
!city.equals(lastCity) ||
!state.equals(lastState) ||
!zipCode.equals(lastZipCode)) {
rs.updateObject("Selected", "T");
rs.updateRow();
v1.clear();
v1.add(lastName);
v1.add(firstName);
msg = pf.print("%s %s has been selected.",v1);
cat_.info(msg);
count++;
}
lastAddress = address;
lastCity = city;
lastState = state;
lastZipCode = zipCode;
}
v1.clear();
pf.setPattern("%i players have been selected.");
v1.add(new Integer(count));
msg = pf.print(v1);
cat_.info(msg);
This is the table that is being updated:
--
-- Table structure for table 'players'
--
DROP TABLE IF EXISTS players;
CREATE TABLE players (
ID int(9) NOT NULL auto_increment,
Selected char(1) default 'F',
FirstName varchar(30) default NULL,
LastName varchar(30) default NULL,
Address varchar(30) default NULL,
City varchar(20) default NULL,
State char(2) default NULL,
ZipCode varchar(10) default NULL,
Sex char(1) default NULL,
BirthDate date default NULL,
Coach varchar(30) default NULL,
YearsPlayed int(2) default NULL,
LastyearPlayed varchar(4) default NULL,
LastSeasonPlayed varchar(10) default NULL,
LastYearEligible varchar(4) default NULL,
Phone varchar(15) default NULL,
LastGrade char(2) default NULL,
Shirt_Size char(3) default NULL,
Speed_Rating int(2) default NULL,
Soccer_Rating int(2) default NULL,
Attitude_Rating int(2) default NULL,
Overall_Rating int(2) default NULL,
Comments varchar(100) default NULL,
Players_Comments varchar(100) default NULL,
PayType
enum('NotPaid','Cash','Check','MoneyOrder','Reg-NoCharge','Reg-NonPay')
default 'NotPaid',
PayId varchar(10) default NULL,
PayAmount decimal(6,2) unsigned zerofill default '0000.00',
PayDate date default NULL,
Print char(1) default 'F',
AddDate date default NULL,
ChangeDate date default NULL,
WillCoach char(1) default 'F',
WillSponsor char(1) default 'F',
WillVolunteer char(1) default 'F',
Status char(1) default 'A',
PRIMARY KEY (ID)
) TYPE=MyISAM;
I do not understand why I am getting the error. Please advise.
This does work with the 2.14 drivers.
--Steve Bromley
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
