连接数据库异常报错

lishuai2018

tubairabbit 发表于 2016-9-21 16:12
同问，我也是“数据源配置正确，测试连接成功”（在数据库标签可以建表，修改表，编辑数据），dbconfig.m也 ...

贴一下你action

lishuai2018

tubairabbit 发表于 2016-9-21 16:12
同问，我也是“数据源配置正确，测试连接成功”（在数据库标签可以建表，修改表，编辑数据），dbconfig.m也 ...

贴一下你后台和dbconfig.m文件

tubairabbit

lishuai2018 发表于 2016-9-21 16:51
贴一下你action

是说贴这个吗？
报错的是oajsdetail.service.m
<?xml version="1.0" encoding="UTF-8"?><model xmlns="http://www.justep.com/model"><action xmlns="http://www.w3.org/1999/xhtml" name="queryJiashuidetail" impl="action:common/CRUD/query"><private name="condition" type="String"></private><private name="db" type="String">CopyTD_OA</private><private name="tableName" type="String">jiashuidetail</private><public name="columns" type="Object"></public><public name="filter" type="String"></public><public name="limit" type="Integer"></public><public name="offset" type="Integer"></public><public name="orderBy" type="String"></public><public name="variables" type="Object"></public></action><action xmlns="http://www.w3.org/1999/xhtml" name="saveJiashuidetail" impl="action:common/CRUD/save"><private name="db" type="String">CopyTD_OA</private><private name="permissions" type="Object"><![CDATA[{"jiashuidetail":""}]]></private><public name="tables" type="List"></public></action></model>

正确的是localjsdetail.service.m
<?xml version="1.0" encoding="UTF-8"?><model xmlns="http://www.justep.com/model"><action xmlns="http://www.w3.org/1999/xhtml" name="queryJiashuidetail" impl="action:common/CRUD/query"><private name="condition" type="String"></private><private name="db" type="String">test</private><private name="tableName" type="String">jiashuidetail</private><public name="columns" type="Object"></public><public name="filter" type="String"></public><public name="limit" type="Integer"></public><public name="offset" type="Integer"></public><public name="orderBy" type="String"></public><public name="variables" type="Object"></public></action><action xmlns="http://www.w3.org/1999/xhtml" name="saveJiashuidetail" impl="action:common/CRUD/save"><private name="db" type="String">test</private><private name="permissions" type="Object"><![CDATA[{"jiashuidetail":""}]]></private><public name="tables" type="List"></public></action></model>

tubairabbit

dbconfig.m文件

<?xml version="1.0" encoding="utf-8"?><model><datasource xmlns="http://www.w3.org/1999/xhtml" name="takeout" value="java:comp/env/takeout"></datasource><datasource xmlns="http://www.w3.org/1999/xhtml" name="account" value="java:comp/env/account"></datasource><datasource xmlns="http://www.w3.org/1999/xhtml" name="demo" value="java:comp/env/demo"></datasource><datasource xmlns="http://www.w3.org/1999/xhtml" name="wex5test" value="java:comp/env/wex5test"></datasource><datasource xmlns="http://www.w3.org/1999/xhtml" name="test" value="java:comp/env/test"></datasource><datasource xmlns="http://www.w3.org/1999/xhtml" name="CopyTD_OA" value="java:comp/env/CopyTD_OA"></datasource></model>

tubairabbit

lishuai2018 发表于 2016-9-21 16:56
贴一下你后台和dbconfig.m文件

贴后台是指哪里？出错的数据源在局域网另一台服务器MySQL数据库（数据库视图能连上并编辑该数据库），能操作成功的数据源是本机的MySQL数据库