File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes executeUpdate() ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "executeUpdate() ?" Watch "executeUpdate() ?" New topic
Author

executeUpdate() ?

Nick Neidig
Greenhorn

Joined: Aug 29, 2003
Posts: 12
The class runs fine when I omit s.executeUpdate(). I am unsure of what the problem might be. I am using Windows XP and connecting to an Access database. Thanks for your help.
Nick
package be314;
import java.sql.*;
public class Fordate1 {
public static void main (String args []) {
try {
Class.forName(
"sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(
"jdbc dbc:Music");
System.out.println("A success");
Statement s = c.createStatement();
s.executeUpdate (
"CREATE TABLE Customer (CustomerID INTEGER, Address VARCHAR
(25))");
ResultSet r =
s.executeQuery(
"SELECT Albums.Album FROM Albums WHERE Albums.Album)
Between 'A' And 'B')");
while(r.next()) {
System.out.println(
r.getString("Album"));
}
System.exit(0);
} catch (Exception) {
System.exit(0);
}
}
}
Lu Battist
Ranch Hand

Joined: Feb 17, 2003
Posts: 104
It would greatly help if you would print the error message in the catch block. My guess, from looking at your source code, is that the table Customer that you're trying to create already exists in the database.
Nick Neidig
Greenhorn

Joined: Aug 29, 2003
Posts: 12
Thank you Lu. I went ahead and printed out the error message and you were absolutely correct.
Jason Steele
Ranch Hand

Joined: Apr 25, 2003
Posts: 100
you have an error in the syntax of your SELECT statement after WHERE. Take off the paren.


An egg is a chicken's house!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: executeUpdate() ?
 
Similar Threads
I have some doubts.
System.exit()------question?
Another executeUpdate() ?
doubt about try catch finally and method return
Very basic but tough question