jdbc用的是mybatis3.3,调用存储过程是发现这个异常,该存储过程在mysql中运行无任何报错,求大侠支招
报错信息:The specified JRE installation does not exist
一、确认配置的JRE是否存在,如下所示:
二、如果配置没有问题,把服务删掉,再新建
window->perferences->server->installed runtimes 里的删掉,重新建立服务,再运行
三、如果server不存在,window-&......
答案就在这里:The specified JRE installation does not exist
----------------------你好,人类,我是来自CSDN星球的问答机器人小C,以上是依据我对问题的理解给出的答案,如果解决了你的问题,望采纳。
提示你这个函数不存在,参考一下这个调用方式:
http://blog.csdn.net/caiwenfeng_for_23/article/details/9296477
<select id="insertGoodsOrder" statementType="CALLABLE" parameterMap="goodsOrder" >
{CALL proc_order(?,?,?,?,?,?)}
</select>
<parameterMap type="java.util.Map" id="goodsOrder">
<parameter property="orderNum" jdbcType="VARCHAR" mode="IN" />
<parameter property="uid" jdbcType="INTEGER" mode="IN" />
<parameter property="gid" jdbcType="INTEGER" mode="IN" />
<parameter property="daID" jdbcType="INTEGER" mode="IN" />
<parameter property="count" jdbcType="INTEGER" mode="IN" />
<parameter property="result" jdbcType="INTEGER" mode="OUT" />
</parameterMap>
CREATE PROCEDURE proc_order(IN orderNum VARCHAR(32),IN userid INT(11),IN gid INT(11),IN daID INT(11),IN gCount INT(11),OUT result INT(11))
label_order:BEGIN
SELECT 0 INTO result;
SELECT COUNT(1) INTO @hasOrder FROM fa_goodsordergroup WHERE fa_gogNum=orderNum;
IF @hasOrder > 0 THEN
BEGIN
LEAVE label_order;
END;
END IF;
SELECT fa_giDiscount*gCount INTO @totalMoney FROM fa_goodsinfos WHERE fa_giID=gid;
/*插入订单组*/
INSERT INTO fa_goodsordergroup(fa_osID,fa_uid,fa_daID,fa_gogNum,fa_goiCreateTime,fa_totalMoney,fa_payable,fa_pocket)
VALUES(3,userid,daID,orderNum,DEFAULT,@totalMoney,@totalMoney,0);
SELECT ROW_COUNT() INTO result;
SELECT LAST_INSERT_ID() INTO @gogID;
/*插订单详情*/
IF result < 1 THEN
BEGIN
LEAVE label_order;
END;
END IF;
INSERT INTO fa_goodsorderinfos(fa_goiNum,fa_giID,fa_gogID,fa_goiCount,fa_goiSubtotal)
VALUES(orderNum,gid,@gogID,gCount,@totalMoney);
SELECT ROW_COUNT()+result INTO result;
COMMIT;
END;
这是代码,mybatis3.3的版本应该没有问题了吧,之前的源码丢了,后来从服务器上down下来的,反编译得到的,但xml不需要反编译啊,服务器上运行,一切正常。