Re: Help with JDBC query
Oops, my mistake, I see the VALUES clause is there but it seems that the
close parenthesis is missing.
-> "?, ?, ?, ?");
} else {
-Richard
At 07:32 PM 1/23/2005, you wrote:
I'm getting the following error in an insert, the update works fine.
Is there a way to get a more informative error message about the error?
Does anyone see a syntax error that I missed?
I'm using MySQL 4.1.8 and Connector/J 3.0.16.
19:13:20,906 INFO [STDOUT] -SQLException-
19:13:20,906 INFO [STDOUT] SQLState: 42000
19:13:20,921 INFO [STDOUT] Message: Syntax error or access violation
message from server: "You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' at line 1"
19:13:20,921 INFO [STDOUT] Vendor: 1064
19:13:20,937 INFO [STDOUT] descriptiveCopy:
sql.setSqlValue("INSERT INTO Restaurant " +
"(Name, Cuisine, ChefsName, Address_1, Address_2," +
"Neighborhood, City, State, ZIP, Country," +
"OfficePhone, ReservationPhone, FaxPhone, Email, Web," +
"HandicappAccess, CreditCards, CostBreakfast, CostLunch, CostDinner," +
"DressCode, Reservations, NonSmoking, OffStreetParking, OutsideDining," +
"Banquet, BanquetCapacity, Catering, ServiceTypes, DeliveryService," +
"LowCarbMenu, ChildMenu, ServesBooze, Entertainment, PhotoURL," +
"ImageCredit, LogoURL, DescriptiveCopy, AtAGlance, NearBy," +
"RestaurantOrder, Subscriber, SubscriptionExpired, UserID) " +
"VALUES(?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?");
} else {
// Update an existing restaurant
sql.setSqlValue("UPDATE Restaurant SET " +
"Name = ?, Cuisine = ?," +
"ChefsName = ?, Address_1 = ?, Address_2 = ?, Neighborhood = ?, City = ?," +
"State = ?, ZIP = ?, Country = ?, OfficePhone = ?, ReservationPhone = ?," +
"FaxPhone = ?, Email = ?, Web = ?, HandicappAccess = ?, CreditCards = ?," +
"CostBreakfast = ?, CostLunch = ?, CostDinner = ?, DressCode = ?,
Reservations = ?," +
"NonSmoking = ?, OffStreetParking = ?, OutsideDining = ?, Banquet = ?,
BanquetCapacity = ?," +
"Catering = ?, ServiceTypes = ?, DeliveryService = ?, LowCarbMenu = ?,
ChildMenu = ?," +
"ServesBooze = ?, Entertainment = ?, PhotoURL = ?, ImageCredit = ?,
LogoURL = ?," +
"DescriptiveCopy = ?, AtAGlance = ?, NearBy = ?" +
"WHERE RestaurantID = ?");
}
List values = new ArrayList();
values.add(request.getParameter("name"));
values.add(request.getParameter("cuisine"));
values.add(request.getParameter("chef"));
values.add(request.getParameter("address1"));
values.add(request.getParameter("address2"));
values.add(request.getParameter("neighborhood"));
values.add(request.getParameter("city"));
values.add(request.getParameter("state"));
values.add(request.getParameter("zip"));
values.add(request.getParameter("country"));
values.add(request.getParameter("officePhone"));
values.add(request.getParameter("reservationPhone"));
values.add(request.getParameter("fax"));
values.add(request.getParameter("email"));
values.add(request.getParameter("web"));
int access = 0;
String param = request.getParameter("access");
if(param != null && param.equals("on")){
access = 1;
}
values.add("" + access);
/**
* visa = 1, mc = 2, amex = 4, discover = 8, diners = 16
* other usable id's are: 32, 64 and 128
*
* This may have to be changed to accomodate Java 5.0 enum
*/
int cc = 0;
param = request.getParameter("visa");
if(param != null && param.equals("on")){
cc |= 1;
}
param = request.getParameter("mastercard");
if(param != null && param.equals("on")){
cc |= 2;
}
param = request.getParameter("americanExpress");
if(param != null && param.equals("on")){
cc |= 4;
}
param = request.getParameter("discover");
if(param != null && param.equals("on")){
cc |= 8;
}
param = request.getParameter("diners");
if(param != null && param.equals("on")){
cc |= 16;
}
values.add("" + cc);
values.add(request.getParameter("costBreakfast"));
values.add(request.getParameter("costLunch"));
values.add(request.getParameter("costDinner"));
values.add(request.getParameter("dressCode"));
values.add(request.getParameter("reservations"));
int nonSmoking = 0;
param = request.getParameter("nonSmoking");
if(param != null && param.equals("on")){
nonSmoking = 1;
}
values.add("" + nonSmoking);
int offStreetParking = 0;
param = request.getParameter("offStreetParking");
if(param != null && param.equals("on")){
offStreetParking = 1;
}
values.add("" + offStreetParking);
int outsideDining = 0;
param = request.getParameter("outsideDining");
if(param != null && param.equals("on")){
outsideDining = 1;
}
values.add("" + outsideDining);
int banquet = 0;
param = request.getParameter("banquet");
if(param != null && param.equals("on")){
banquet = 1;
}
values.add("" + banquet);
values.add(request.getParameter("banquetCapacity"));
int catering = 0;
param = request.getParameter("catering");
if(param
Chanh Le is out of the office.
I will be out of the office starting 1/17/2005 and will not return until 2/7/2005. I am on vacation and back on 02/07/2005. Please contact Paul Bambah and Ravindra Dabbiru for AS400 issues. Thanks. ___ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
Re: Help with JDBC query
Hard to tell but is there a space between ) and VALUES?
Bob
Sent from my Dell Axim X30
-Original Message-
>From: "Jack Lauman"<[EMAIL PROTECTED]>
>Sent: 1/23/05 9:32:45 PM
>To: "SERVLET-INTEREST@JAVA.SUN.COM"
>Subject: Help with JDBC query
>
>I'm getting the following error in an insert, the update works fine.
>
>Is there a way to get a more informative error message about the error?
>
>Does anyone see a syntax error that I missed?
>
>I'm using MySQL 4.1.8 and Connector/J 3.0.16.
>
>19:13:20,906 INFO [STDOUT] -SQLException-
>19:13:20,906 INFO [STDOUT] SQLState: 42000
>19:13:20,921 INFO [STDOUT] Message: Syntax error or access violation
>message from server: "You have an error in your SQL syntax; check the
>manual that corresponds to your MySQL server version for the right
>syntax to use near '' at line 1"
>19:13:20,921 INFO [STDOUT] Vendor: 1064
>19:13:20,937 INFO [STDOUT] descriptiveCopy:
>
>
>sql.setSqlValue("INSERT INTO Restaurant " +
>"(Name, Cuisine, ChefsName, Address_1, Address_2," +
>"Neighborhood, City, State, ZIP, Country," +
>"OfficePhone, ReservationPhone, FaxPhone, Email, Web," +
>"HandicappAccess, CreditCards, CostBreakfast, CostLunch, CostDinner," +
>"DressCode, Reservations, NonSmoking, OffStreetParking, OutsideDining," +
>"Banquet, BanquetCapacity, Catering, ServiceTypes, DeliveryService," +
>"LowCarbMenu, ChildMenu, ServesBooze, Entertainment, PhotoURL," +
>"ImageCredit, LogoURL, DescriptiveCopy, AtAGlance, NearBy," +
>"RestaurantOrder, Subscriber, SubscriptionExpired, UserID) " +
>
> "VALUES(?, ?, ?, ?, ?," +
>"?, ?, ?, ?, ?," +
>"?, ?, ?, ?, ?," +
>"?, ?, ?, ?, ?," +
>"?, ?, ?, ?, ?," +
>"?, ?, ?, ?, ?," +
>"?, ?, ?, ?, ?," +
>"?, ?, ?, ?, ?," +
>"?, ?, ?, ?");
>
>
>} else {
>
>// Update an existing restaurant
>sql.setSqlValue("UPDATE Restaurant SET " +
>"Name = ?, Cuisine = ?," +
>"ChefsName = ?, Address_1 = ?, Address_2 = ?, Neighborhood = ?, City = ?," +
>"State = ?, ZIP = ?, Country = ?, OfficePhone = ?, ReservationPhone = ?," +
>"FaxPhone = ?, Email = ?, Web = ?, HandicappAccess = ?, CreditCards = ?," +
>"CostBreakfast = ?, CostLunch = ?, CostDinner = ?, DressCode = ?,
>Reservations = ?," +
>"NonSmoking = ?, OffStreetParking = ?, OutsideDining = ?, Banquet = ?,
>BanquetCapacity = ?," +
>"Catering = ?, ServiceTypes = ?, DeliveryService = ?, LowCarbMenu = ?,
>ChildMenu = ?," +
>"ServesBooze = ?, Entertainment = ?, PhotoURL = ?, ImageCredit = ?,
>LogoURL = ?," +
>"DescriptiveCopy = ?, AtAGlance = ?, NearBy = ?" +
>"WHERE RestaurantID = ?");
>
>}
>List values = new ArrayList();
>values.add(request.getParameter("name"));
>values.add(request.getParameter("cuisine"));
>values.add(request.getParameter("chef"));
>values.add(request.getParameter("address1"));
>values.add(request.getParameter("address2"));
>values.add(request.getParameter("neighborhood"));
>values.add(request.getParameter("city"));
>values.add(request.getParameter("state"));
>values.add(request.getParameter("zip"));
>values.add(request.getParameter("country"));
>values.add(request.getParameter("officePhone"));
>values.add(request.getParameter("reservationPhone"));
>values.add(request.getParameter("fax"));
>values.add(request.getParameter("email"));
>values.add(request.getParameter("web"));
>
>int access = 0;
>String param = request.getParameter("access");
>if(param != null && param.equals("on")){
>access = 1;
>}
>values.add("" + access);
>
>/**
> * visa = 1, mc = 2, amex = 4, discover = 8, diners = 16
> * other usable id's are: 32, 64 and 128
> *
> * This may have to be changed to accomodate Java 5.0 enum
> */
>int cc = 0;
>param = request.getParameter("visa");
>if(param != null && param.equals("on")){
>cc |= 1;
>}
>
>param = request.getParameter("mastercard");
>if(param != null && param.equals("on")){
>cc |= 2;
>}
>param = request.getParameter("americanExpress");
>if(param != null && param.equals("on")){
>cc |= 4;
>}
>param = request.getParameter("discover");
>if(param != null && param.equals("on")){
>cc |= 8;
>}
>
>param = request.getParameter("diners");
>if(param != null && param.equals("on")){
>cc |= 16;
>}
>values.add("" + cc);
>
> values.add(request.getParameter("costBreakfast"));
>values.add(request.getParameter("costLunch"));
>values.add(request.getParameter("costDinner"));
>values.add(request.getParameter("dressCode"));
>values.add(request.getParameter("reservations"));
>
>int nonSmoking = 0;
>param = request.getParameter("nonSmoking");
>if(param != null && param.equals("on")){
>nonSmoking = 1;
>}
>values.add("" + nonSmoking);
>
>int offStreetParking = 0;
>param = request.getParameter("offStreetParking");
>if(param != null && param.equals("on")){
>offStreetParking = 1;
>}
>values.add("" + offStreetParking);
>
>int outsideDining = 0;
>param = request.getParameter("outsideDining");
>if(p
Re: Help with JDBC query
You are missing the "VALUES" clause before the open parenthesis.
-Richard
At 07:32 PM 1/23/2005, you wrote:
I'm getting the following error in an insert, the update works fine.
Is there a way to get a more informative error message about the error?
Does anyone see a syntax error that I missed?
I'm using MySQL 4.1.8 and Connector/J 3.0.16.
19:13:20,906 INFO [STDOUT] -SQLException-
19:13:20,906 INFO [STDOUT] SQLState: 42000
19:13:20,921 INFO [STDOUT] Message: Syntax error or access violation
message from server: "You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' at line 1"
19:13:20,921 INFO [STDOUT] Vendor: 1064
19:13:20,937 INFO [STDOUT] descriptiveCopy:
sql.setSqlValue("INSERT INTO Restaurant " +
"(Name, Cuisine, ChefsName, Address_1, Address_2," +
"Neighborhood, City, State, ZIP, Country," +
"OfficePhone, ReservationPhone, FaxPhone, Email, Web," +
"HandicappAccess, CreditCards, CostBreakfast, CostLunch, CostDinner," +
"DressCode, Reservations, NonSmoking, OffStreetParking, OutsideDining," +
"Banquet, BanquetCapacity, Catering, ServiceTypes, DeliveryService," +
"LowCarbMenu, ChildMenu, ServesBooze, Entertainment, PhotoURL," +
"ImageCredit, LogoURL, DescriptiveCopy, AtAGlance, NearBy," +
"RestaurantOrder, Subscriber, SubscriptionExpired, UserID) " +
"VALUES(?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?");
} else {
// Update an existing restaurant
sql.setSqlValue("UPDATE Restaurant SET " +
"Name = ?, Cuisine = ?," +
"ChefsName = ?, Address_1 = ?, Address_2 = ?, Neighborhood = ?, City = ?," +
"State = ?, ZIP = ?, Country = ?, OfficePhone = ?, ReservationPhone = ?," +
"FaxPhone = ?, Email = ?, Web = ?, HandicappAccess = ?, CreditCards = ?," +
"CostBreakfast = ?, CostLunch = ?, CostDinner = ?, DressCode = ?,
Reservations = ?," +
"NonSmoking = ?, OffStreetParking = ?, OutsideDining = ?, Banquet = ?,
BanquetCapacity = ?," +
"Catering = ?, ServiceTypes = ?, DeliveryService = ?, LowCarbMenu = ?,
ChildMenu = ?," +
"ServesBooze = ?, Entertainment = ?, PhotoURL = ?, ImageCredit = ?,
LogoURL = ?," +
"DescriptiveCopy = ?, AtAGlance = ?, NearBy = ?" +
"WHERE RestaurantID = ?");
}
List values = new ArrayList();
values.add(request.getParameter("name"));
values.add(request.getParameter("cuisine"));
values.add(request.getParameter("chef"));
values.add(request.getParameter("address1"));
values.add(request.getParameter("address2"));
values.add(request.getParameter("neighborhood"));
values.add(request.getParameter("city"));
values.add(request.getParameter("state"));
values.add(request.getParameter("zip"));
values.add(request.getParameter("country"));
values.add(request.getParameter("officePhone"));
values.add(request.getParameter("reservationPhone"));
values.add(request.getParameter("fax"));
values.add(request.getParameter("email"));
values.add(request.getParameter("web"));
int access = 0;
String param = request.getParameter("access");
if(param != null && param.equals("on")){
access = 1;
}
values.add("" + access);
/**
* visa = 1, mc = 2, amex = 4, discover = 8, diners = 16
* other usable id's are: 32, 64 and 128
*
* This may have to be changed to accomodate Java 5.0 enum
*/
int cc = 0;
param = request.getParameter("visa");
if(param != null && param.equals("on")){
cc |= 1;
}
param = request.getParameter("mastercard");
if(param != null && param.equals("on")){
cc |= 2;
}
param = request.getParameter("americanExpress");
if(param != null && param.equals("on")){
cc |= 4;
}
param = request.getParameter("discover");
if(param != null && param.equals("on")){
cc |= 8;
}
param = request.getParameter("diners");
if(param != null && param.equals("on")){
cc |= 16;
}
values.add("" + cc);
values.add(request.getParameter("costBreakfast"));
values.add(request.getParameter("costLunch"));
values.add(request.getParameter("costDinner"));
values.add(request.getParameter("dressCode"));
values.add(request.getParameter("reservations"));
int nonSmoking = 0;
param = request.getParameter("nonSmoking");
if(param != null && param.equals("on")){
nonSmoking = 1;
}
values.add("" + nonSmoking);
int offStreetParking = 0;
param = request.getParameter("offStreetParking");
if(param != null && param.equals("on")){
offStreetParking = 1;
}
values.add("" + offStreetParking);
int outsideDining = 0;
param = request.getParameter("outsideDining");
if(param != null && param.equals("on")){
outsideDining = 1;
}
values.add("" + outsideDining);
int banquet = 0;
param = request.getParameter("banquet");
if(param != null && param.equals("on")){
banquet = 1;
}
values.add("" + banquet);
values.add(request.getParameter("banquetCapacity"));
int catering = 0;
param = request.getParameter("catering");
if(param != null && param.equals("on")){
catering = 1;
}
values.add("" + cateri
Help with JDBC query
I'm getting the following error in an insert, the update works fine.
Is there a way to get a more informative error message about the error?
Does anyone see a syntax error that I missed?
I'm using MySQL 4.1.8 and Connector/J 3.0.16.
19:13:20,906 INFO [STDOUT] -SQLException-
19:13:20,906 INFO [STDOUT] SQLState: 42000
19:13:20,921 INFO [STDOUT] Message: Syntax error or access violation
message from server: "You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' at line 1"
19:13:20,921 INFO [STDOUT] Vendor: 1064
19:13:20,937 INFO [STDOUT] descriptiveCopy:
sql.setSqlValue("INSERT INTO Restaurant " +
"(Name, Cuisine, ChefsName, Address_1, Address_2," +
"Neighborhood, City, State, ZIP, Country," +
"OfficePhone, ReservationPhone, FaxPhone, Email, Web," +
"HandicappAccess, CreditCards, CostBreakfast, CostLunch, CostDinner," +
"DressCode, Reservations, NonSmoking, OffStreetParking, OutsideDining," +
"Banquet, BanquetCapacity, Catering, ServiceTypes, DeliveryService," +
"LowCarbMenu, ChildMenu, ServesBooze, Entertainment, PhotoURL," +
"ImageCredit, LogoURL, DescriptiveCopy, AtAGlance, NearBy," +
"RestaurantOrder, Subscriber, SubscriptionExpired, UserID) " +
"VALUES(?, ?,
?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?, ?," +
"?, ?, ?, ?");
} else {
// Update an existing restaurant
sql.setSqlValue("UPDATE Restaurant SET " +
"Name = ?, Cuisine = ?," +
"ChefsName = ?, Address_1 = ?, Address_2 = ?, Neighborhood = ?, City = ?," +
"State = ?, ZIP = ?, Country = ?, OfficePhone = ?, ReservationPhone = ?," +
"FaxPhone = ?, Email = ?, Web = ?, HandicappAccess = ?, CreditCards = ?," +
"CostBreakfast = ?, CostLunch = ?, CostDinner = ?, DressCode = ?,
Reservations = ?," +
"NonSmoking = ?, OffStreetParking = ?, OutsideDining = ?, Banquet = ?,
BanquetCapacity = ?," +
"Catering = ?, ServiceTypes = ?, DeliveryService = ?, LowCarbMenu = ?,
ChildMenu = ?," +
"ServesBooze = ?, Entertainment = ?, PhotoURL = ?, ImageCredit = ?,
LogoURL = ?," +
"DescriptiveCopy = ?, AtAGlance = ?, NearBy = ?" +
"WHERE RestaurantID = ?");
}
List values = new ArrayList();
values.add(request.getParameter("name"));
values.add(request.getParameter("cuisine"));
values.add(request.getParameter("chef"));
values.add(request.getParameter("address1"));
values.add(request.getParameter("address2"));
values.add(request.getParameter("neighborhood"));
values.add(request.getParameter("city"));
values.add(request.getParameter("state"));
values.add(request.getParameter("zip"));
values.add(request.getParameter("country"));
values.add(request.getParameter("officePhone"));
values.add(request.getParameter("reservationPhone"));
values.add(request.getParameter("fax"));
values.add(request.getParameter("email"));
values.add(request.getParameter("web"));
int access = 0;
String param = request.getParameter("access");
if(param != null && param.equals("on")){
access = 1;
}
values.add("" + access);
/**
* visa = 1, mc = 2, amex = 4, discover = 8, diners = 16
* other usable id's are: 32, 64 and 128
*
* This may have to be changed to accomodate Java 5.0 enum
*/
int cc = 0;
param = request.getParameter("visa");
if(param != null && param.equals("on")){
cc |= 1;
}
param = request.getParameter("mastercard");
if(param != null && param.equals("on")){
cc |= 2;
}
param = request.getParameter("americanExpress");
if(param != null && param.equals("on")){
cc |= 4;
}
param = request.getParameter("discover");
if(param != null && param.equals("on")){
cc |= 8;
}
param = request.getParameter("diners");
if(param != null && param.equals("on")){
cc |= 16;
}
values.add("" + cc);
values.add(request.getParameter("costBreakfast"));
values.add(request.getParameter("costLunch"));
values.add(request.getParameter("costDinner"));
values.add(request.getParameter("dressCode"));
values.add(request.getParameter("reservations"));
int nonSmoking = 0;
param = request.getParameter("nonSmoking");
if(param != null && param.equals("on")){
nonSmoking = 1;
}
values.add("" + nonSmoking);
int offStreetParking = 0;
param = request.getParameter("offStreetParking");
if(param != null && param.equals("on")){
offStreetParking = 1;
}
values.add("" + offStreetParking);
int outsideDining = 0;
param = request.getParameter("outsideDining");
if(param != null && param.equals("on")){
outsideDining = 1;
}
values.add("" + outsideDining);
int banquet = 0;
param = request.getParameter("banquet");
if(param != null && param.equals("on")){
banquet = 1;
}
values.add("" + banquet);
values.add(request.getParameter("banquetCapacity"));
int catering = 0;
param = request.getParameter("catering");
if(param != null && param.equals("on")){
catering = 1;
}
values.add("" + catering);
