mysql tk_mysql改造.txt

最新推荐文章于 2021-10-20 15:47:00 发布

木得黑

最新推荐文章于 2021-10-20 15:47:00 发布

阅读量131

点赞数

文章标签： mysql tk

本文链接：https://blog.csdn.net/weixin_31904867/article/details/113256506

版权

cms mysql改造需要处理数据库问题

2015-08-06 17:44:58,149 [main] ERROR com.frameworkset.common.poolman.util.SQLUtil - create or replace function site_flow_id(a_site_id int) return int

l_parent_workflow char(1);

l_parent_id number(10);

l_workflow int;

begin

select PARENT_WORKFLOW,mainsite_id,flow_id

into l_parent_workflow,l_parent_id,l_workflow

from td_cms_site where site_id = a_site_id;

if l_parent_workflow = '0' then

return l_workflow;

end if;

if l_parent_workflow = '1' then

return site_flow_id(l_parent_id);

end if;

return -1;

end;

java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'function site_flow_id(a_site_id int) return int

l_parent_wo' at line 1

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3020)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2949)

at com.mysql.jdbc.Statement.execute(Statement.java:538)

at com.frameworkset.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)

at com.frameworkset.common.poolman.util.SQLUtil.innerExecuteJDBC(SQLUtil.java:573)

at com.frameworkset.common.poolman.util.SQLUtil.doJDBC(SQLUtil.java:713)

at com.frameworkset.common.poolman.util.SQLUtil.doJDBC(SQLUtil.java:525)

at com.frameworkset.common.poolman.util.SQLUtil.executeSql(SQLUtil.java:480)

at com.frameworkset.common.poolman.DBUtil.executeUpdate(DBUtil.java:2128)

at com.frameworkset.common.poolman.DBUtil.executeUpdate(DBUtil.java:2113)

at org.frameworkset.persistent.db.DBInit.insertData(Unknown Source)

at org.frameworkset.persistent.db.DBInit.insertDataToDB(Unknown Source)

at org.frameworkset.persistent.db.DBInit.execute(Unknown Source)

at org.frameworkset.persistent.db.DBInit.main(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.frameworkset.runtime.CommonLauncher.run(CommonLauncher.java:168)

at org.frameworkset.runtime.CommonLauncher.main(CommonLauncher.java:266)

2015-08-06 17:44:58,151 [main] ERROR com.frameworkset.common.poolman.util.SQLUtil - create or replace function channel_flow_id(ch_id int) return int

l_parent_workflow char(1);

l_parent_id number(10);

l_site_id number(10);

l_workflow int;

begin

select PARENT_WORKFLOW,parent_id,site_id,workflow

into l_parent_workflow,l_parent_id,l_site_id,l_workflow

from td_cms_channel where channel_id = ch_id;

if l_parent_workflow = '0' then

return l_workflow;

end if;

if l_parent_workflow = '1' then

if l_parent_id is null then

--select flow_id into l_workflow from td_cms_site where site_id = l_site_id;

--return l_workflow;

return site_flow_id(l_site_id);

end if;

return channel_flow_id(l_parent_id);

end if;

return -1;

end;

java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'function channel_flow_id(ch_id int) return int

l_parent_wor' at line 1