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)
