weblocig配置jndi链接mysql数据库报错
weblogic服务器链接mysql数据库时,使用配置文件方式无问题;
在改为jndi方式时,在执行同样的SQL时报错:
SELECT GROUP_CONCAT(s.PNO) AS PNO,GROUP_CONCAT(s.SUMPREMIUM) AS SUMPREMIUM,s.SNO AS SNO,s.DTNO,s.ISFAIL,car.LNO,s.INPUTDATE AS INPUTDATE,GROUP_CONCAT(s.CARTAX) AS CARTAX,GROUP_CONCAT(s.CARSTATUS) AS CARSTATUS FROM PMAIN AS s, plifetable AS pl,pcar AS car WHERE s.SNO = car.SNO AND s.SNO = pl.SNO INPUTDATE BETWEEN '2018-01-01' AND '2018-06-14' AND s.DELETED IS NULL GROUP BY s.SNO ORDER BY s.INPUTDATE DESC LIMIT 0,10