| 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: 56229
|
|
|
Moving to the JDBC forum.
|
[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
|
 |
 |
|
|
subject: Trying to send "SET IDENTITY_INSERT...ON"
|
|
|