wood burning stoves 2.0*
The moose likes JDBC and the fly likes Trying to send Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Trying to send "SET IDENTITY_INSERT...ON"" Watch "Trying to send "SET IDENTITY_INSERT...ON"" New topic
Author

Trying to send "SET IDENTITY_INSERT...ON"

jim gemlo
Greenhorn

Joined: Feb 24, 2004
Posts: 20
to a sqlserver data base using jsp and I get error:
Message: Server caught unhandled exception from servlet [JSP 1.1 Processor]: Unable to compile class for JSP "/osg/InsertTrys/delete/displayserver.jsp" /usr/WebSphere/AppServer/temp/default_host/default_app/osg/InsertTrys/delete/_displayserver_jsp_176.java:269: Method preparedStatement(java.lang.String) not found in interface java.sql.Connection. PreparedStatement stmtSetIdentityValueON = conn.preparedStatement(sqlSetValueIdentityOn);
Here is my code snip:
String sqlSetValueIdentityOn = "SET IDENTITY_INSERT dbo.BACKUP_DIM ON";
PreparedStatement stmtSetIdentityValueON = conn.preparedStatement(sqlSetValueIdentityOn);
what is the correct way to send this to the DB?
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60766
    
  65

Moving to the JDBC forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Trying to send "SET IDENTITY_INSERT...ON"
 
Similar Threads
What exactly we mean by Precompiled SQL Statement
Can i batch preparedStatements?
How to delete a record from a table without a primary key
Identifier expected, (already searched and read about this, still confused
Relieve database bean objects from heap