No database selected

最新推荐文章于 2023-08-03 18:56:33 发布

嘿;-)翔�

最新推荐文章于 2023-08-03 18:56:33 发布

阅读量322

点赞数

分类专栏：解决方法文章标签：数据库 sql mybatis

本文链接：https://blog.csdn.net/cdliker/article/details/129494830

版权

解决方法专栏收录该内容

59 篇文章 0 订阅

订阅专栏

 The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: SELECT --         year (item.updated_at) `year`, --         month (item.updated_at) `month`,         os.s_company_id as factoryId,         os.p_company_id as distributeId,         os.p_company_name as distributeName,         item.product_line_code as productLineCode,         item.product_line_name as productLineName,         sum (item.detail_amount) as totalAmount,         sum (item.purchase_num ) as totalQuantity         from `guoke-deepexi-saas-order-center`.odc_purchase_order_os os         INNER JOIN `guoke-deepexi-saas-order-center`.odc_purchase_order_item_os item   on os.id = item.order_id and os.dr = 0 and item.dr = 0         INNER JOIN `guoke-deepexi-saas-order-center`.star_order_operator_log l on os.sale_order_code = l.order_no and l.dr = 0         where 1=1                  GROUP BY         os.p_company_id, os.p_company_name,         item.product_line_code, item.product_line_name,         year (item.updated_at)         order by os.created_at desc\r\n### Cause: java.sql.SQLException: No database selected\n; uncategorized SQLException; SQL state [3D000]; error code [1046]; No database selected; nested exception is java.sql.SQLException: No database selected

好一顿找，
1.检查 xml中末尾是否有 ‘；’号
2.检查是否有关键字 year，month 类似的字段
3.检查是否指定库表
4.检查函数后边是否使用有空格
我的报错原因就是函数sum后边有空格，删除之后就没问题了