Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • 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)
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This sounds like a configuration issue for your MSSQL DBA to figure out.
 
Vedhas Pitkar
Ranch Hand
Posts: 445
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes,maybe the configuration is incorrect.Just check whether a simple stored procedure works just through JDBC,no transactions.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic