[jboss-user] [EJB 3.0] - Re: [JDBCExceptionReporter]'last_insert_id' is not a recogni

[pakhi]

Hey.. thanks for your reply... I really appreciate the same so soon... 
But now i am getting the error as follows:

15:56:14,638 ERROR [MultipleHiLoPerTableGenerator] could not read or init a hi value
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.	at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
	at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
	at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
	at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
	at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(

I made this change as you guided... 
                @Id
	@GeneratedValue(strategy = GenerationType.TABLE)
	@Column (name="id")
	public int getId() {
		return id;
	}

Please guide, is there some constaint in inserting into the table though this entity bean. 

Thanks again... :)

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4054691#4054691

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4054691