• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help..when I called stored procedure in java codes. some errors message.

 
xiaojun chen
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Help, when I called SQL server stored procedure in java codes. Some errors message in console. The web and ejb server are weblogic. Please help me how to resolve.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The procedure 'sp_fulltext_table' cannot be executed within a transaction.
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(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.execute(Unknown Source)
at weblogic.jdbc.jts.Statement.execute(Statement.java:485)
at weblogic.jdbc.rmi.internal.PreparedStatementImpl.execute(PreparedStatementImpl.java:358)
at weblogic.jdbc.rmi.SerialPreparedStatement.execute(SerialPreparedStatement.java:401)
at com.agile.pc.cmserver.item.ItemDAO.createItemSQL(ItemDAO.java:749)
at com.agile.pc.cmserver.item.ItemService.saveNewObject(ItemService.java:623)
at com.agile.pc.cmserver.base.BaseService.createObjectByNumber(BaseService.java:462)
at com.agile.pc.cmserver.base.CMSessionBean.createObjectByNumber(CMSessionBean.java:123)
at com.agile.pc.cmserver.item.ItemSessionBean_rovu5a_EOImpl.createObjectByNumber(ItemSessionBean_rovu5a_EOImpl.java:5344)
 
R Laksh
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
This error comes when some DDL statements are executed in a transaction. Please commit the transaction before executing the procedure and let me know
Hope this helps
Thank you
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic