• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Updating tables

 
malcolm bailey
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I have a program where I create a table in a database and write to it when required. I have successfully created the table, but when I try to write to it using:
String SQLStatement = "INSERT INTO QUEUEMESSAGES VALUES ('BLAH')";
AptJMSFIXTibcoQueueControl.stmt.executeUpdate(SQLStatement);
AptJMSFIXTibcoQueueControl.conn.commit();
I get the error:
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'QUEUEMESSAGES' in the database.
Help!!
 
malcolm bailey
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I've sorted it out now...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic