mysql错误-UncategorizedSQLException 1449
来源:互联网 发布:mac系统c语言编程软件 编辑:程序博客网 时间:2024/06/10 13:34
错误:
UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1449];
解决:
出错的意思是数据库访问时没有‘@’这个用户.这主要是在新建视图和存储过程时,我直截在mysql可视图形工具里copy代码到服务器上去运行,mysql里会自动生成一些代码,比如copy出来的视图语句:
DROP VIEW IF EXISTS `testdb`.`v4bbs`;
CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=``@`` SQL SECURITY DEFINER VIEW `v4bbs` AS select `a`.`topic_id` AS `did`,`a`.`topic_type` AS `topic_type`,`a`.`especial_flag` AS `topic_level`,`a`.`title` AS `title`,`a`.`url` AS `url`,`a`.`content` AS `content`,concat(`b`.`chinese_name`,_utf8' ',`c`.`chinese_name`,_utf8' ',`d`.`chinese_name`) AS `addr`,`a`.`author_id` AS `author_id`,`e`.`nikename` AS `author_nick`,`a`.`appear_date` AS `pub_time`,`a`.`restor_count` AS `reply`,`a`.`last_restor_user_id` AS `last_reply_id`,`a`.`last_restor_nickName` AS `last_reply_nick`,`a`.`last_restor_date` AS `last_reply_time`,`a`.`last_update_date` AS `last_modify_time`,`a`.`fingerprint` AS `fp` from ((((`tb4topic` `a` join `tb4position` `b`) join `tb4position` `c`) join `tb4position` `d`) join `tb4user` `e`) where ((`a`.`pos_id_1` = `b`.`position_id`) and (`a`.`pos_id_2` = `c`.`position_id`) and (`a`.`pos_id_3` = `d`.`position_id`) and (`a`.`author_id` = `e`.`user_id`) and ((`a`.`state` = 1) or (`a`.`state` = 2)));
应该改成:
DROP VIEW IF EXISTS `testdb`.`v4bbs`;
CREATE VIEW `v4bbs` AS select `a`.`topic_id` AS `did`,`a`.`topic_type` AS `topic_type`,`a`.`especial_flag` AS `topic_level`,`a`.`title` AS `title`,`a`.`url` AS `url`,`a`.`content` AS `content`,concat(`b`.`chinese_name`,_utf8' ',`c`.`chinese_name`,_utf8' ',`d`.`chinese_name`) AS `addr`,`a`.`author_id` AS `author_id`,`e`.`nikename` AS `author_nick`,`a`.`appear_date` AS `pub_time`,`a`.`restor_count` AS `reply`,`a`.`last_restor_user_id` AS `last_reply_id`,`a`.`last_restor_nickName` AS `last_reply_nick`,`a`.`last_restor_date` AS `last_reply_time`,`a`.`last_update_date` AS `last_modify_time`,`a`.`fingerprint` AS `fp` from ((((`tb4topic` `a` join `tb4position` `b`) join `tb4position` `c`) join `tb4position` `d`) join `tb4user` `e`) where ((`a`.`pos_id_1` = `b`.`position_id`) and (`a`.`pos_id_2` = `c`.`position_id`) and (`a`.`pos_id_3` = `d`.`position_id`) and (`a`.`author_id`
- mysql错误-UncategorizedSQLException 1449
- org.springframework.jdbc.UncategorizedSQLException 错误解决
- mysql 保存手机输入法的数据报错org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback
- org.springframework.jdbc.UncategorizedSQLException
- org.springframework.jdbc.UncategorizedSQLException
- org.springframework.jdbc.UncategorizedSQLException:
- org.springframework.jdbc.UncategorizedSQLException:
- org.springframework.jdbc.UncategorizedSQLException
- org.springframework.jdbc.UncategorizedSQLException
- UncategorizedSQLException异常处理办法
- mysql 1449错误
- mysql 错误1449
- mysql 视图1449错误
- mysql 错误
- MYSQL 错误
- mysql 错误
- mysql 错误
- mysql 错误
- Protobuf 3.0.0 下载地址
- Target runtime Apache Tomcat v6.0 is not defined.
- java 运行shell 得到 linux cpu的使用率
- 跟java配合
- 【读书】吴恩达:成功之前,先快速、廉价地失败
- mysql错误-UncategorizedSQLException 1449
- 编辑tableView 多选删除 全选删除 修改系统默认删除图片
- linux下防火墙 开启某个端口
- TCP的三次握手(建立连接)和四次挥手(关闭连接)
- 随机森林-思想
- 页面浏览本地文件--type=file
- 《Python科学计算》Part1 WinPython之mayavi画图-显式函数与隐式函数
- c语言中的符号优先级问题
- eclipse 3.7 安装 svn插件 subclipse