首页 \ 问答 \ Spring Framework:根元素类型“beans”的文档类型声明必须以“>”结尾(Spring Framework: The document type declaration for root element type “beans” must end with '>')

Spring Framework:根元素类型“beans”的文档类型声明必须以“>”结尾(Spring Framework: The document type declaration for root element type “beans” must end with '>')

这是我的spring.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans SYSTEM "http://www.springframework.org/dtd/spring-beans-2.0.dtd" PUBLIC "-//SPRING//DTD BEAN 2.0//EN">
<beans>
    <bean id="data" class="com.blah.tests.DataProviderClass" />
    <bean id="wdcm" class="com.blah.tests.WebDriverCustomMethods"/>
</beans>

当我运行我的应用程序测试时,这是我得到的错误:

    Caused by: org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException:
 Line 2 in XML document from class path resource [spring.xml] is invalid; nested exception is org.xml.sax.SAXParseException;
 lineNumber: 2; columnNumber: 82; The document type declaration for root element type "beans" must end with '>'.

我使用Spring 3.0.7


This is my spring.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans SYSTEM "http://www.springframework.org/dtd/spring-beans-2.0.dtd" PUBLIC "-//SPRING//DTD BEAN 2.0//EN">
<beans>
    <bean id="data" class="com.blah.tests.DataProviderClass" />
    <bean id="wdcm" class="com.blah.tests.WebDriverCustomMethods"/>
</beans>

When I run my application test, this is the error I get:

    Caused by: org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException:
 Line 2 in XML document from class path resource [spring.xml] is invalid; nested exception is org.xml.sax.SAXParseException;
 lineNumber: 2; columnNumber: 82; The document type declaration for root element type "beans" must end with '>'.

Im using Spring 3.0.7


原文:
更新时间:2022-08-07 19:08

最满意答案

执行所需操作的一种方法是使用窗口函数:

SELECT *
FROM (SELECT et.*,
             MAX(TIMESTAMP_DATE) OVER (PARTITION BY EMPLOYEE_ID) as MAX_TIMESTAMP_DATE
      FROM EMPLOYEE_TIMESTAMPS
     ) et
WHERE TIMESTAMP_DATE >= MAX_TIMESTAMP_DATE - 365;

您的版本的问题是使用聚合函数MAX() 。 首先,查询中没有GROUP BY 。 其次, WHERE子句中不允许使用这些函数。

上述版本中的MAX()称为分析函数,因为它具有OVER子句。


One method of doing what you want uses window functions:

SELECT *
FROM (SELECT et.*,
             MAX(TIMESTAMP_DATE) OVER (PARTITION BY EMPLOYEE_ID) as MAX_TIMESTAMP_DATE
      FROM EMPLOYEE_TIMESTAMPS
     ) et
WHERE TIMESTAMP_DATE >= MAX_TIMESTAMP_DATE - 365;

The problem with your version is the use of the aggregation function MAX(). First, there is no GROUP BY in the query. And, second, these functions are not allowed in the WHERE clause.

The MAX() in the above version is called an analytic function, because it has the OVER clause.

相关问答

更多

相关文章

更多

最新问答

更多
  • 散列包括方法和/或嵌套属性(Hash include methods and/or nested attributes)
  • TensorFlow:基于索引列表创建新张量(TensorFlow: Create a new tensor based on list of indices)
  • 企业安全培训的各项内容
  • 错误:RPC失败;(error: RPC failed; curl transfer closed with outstanding read data remaining)
  • NumPy:将int64值存储在np.array中并使用dtype float64并将其转换回整数是否安全?(NumPy: Is it safe to store an int64 value in an np.array with dtype float64 and later convert it back to integer?)
  • 注销后如何隐藏导航portlet?(How to hide navigation portlet after logout?)
  • 将多个行和可变行移动到列(moving multiple and variable rows to columns)
  • 对setOnInfoWindowClickListener的意图(Intent on setOnInfoWindowClickListener)
  • Angular $资源不会改变方法(Angular $resource doesn't change method)
  • 如何配置Composite C1以将.m和桌面作为同一站点提供服务(How to configure Composite C1 to serve .m and desktop as the same site)
  • 不适用:悬停在悬停时:在元素之前[复制](Don't apply :hover when hovering on :before element [duplicate])
  • Mysql DB单个字段匹配多个其他字段(Mysql DB single field matching to multiple other fields)
  • 产品页面上的Magento Up出售对齐问题(Magento Up sell alignment issue on the products page)
  • 是否可以嵌套hazelcast IMaps?(Is it possible to nest hazelcast IMaps? And whick side effects can I expect? Is it a good Idea anyway?)
  • UIViewAnimationOptionRepeat在两个动画之间暂停(UIViewAnimationOptionRepeat pausing in between two animations)
  • 在x-kendo-template中使用Razor查询(Using Razor query within x-kendo-template)
  • 在BeautifulSoup中替换文本而不转义(Replace text without escaping in BeautifulSoup)
  • 如何在存根或模拟不存在的方法时配置Rspec以引发错误?(How can I configure Rspec to raise error when stubbing or mocking non-existing methods?)
  • asp用javascript(asp with javascript)
  • “%()s”在sql查询中的含义是什么?(What does “%()s” means in sql query?)
  • 如何为其编辑的内容提供自定义UITableViewCell上下文?(How to give a custom UITableViewCell context of what it is editing?)
  • c ++十进制到二进制,然后使用操作,然后回到十进制(c++ Decimal to binary, then use operation, then back to decimal)
  • 以编程方式创建视频?(Create videos programmatically?)
  • 无法在BeautifulSoup中正确解析数据(Unable to parse data correctly in BeautifulSoup)
  • webform和mvc的区别 知乎
  • 如何使用wadl2java生成REST服务模板,其中POST / PUT方法具有参数?(How do you generate REST service template with wadl2java where POST/PUT methods have parameters?)
  • 我无法理解我的travis构建有什么问题(I am having trouble understanding what is wrong with my travis build)
  • iOS9 Scope Bar出现在Search Bar后面或旁边(iOS9 Scope Bar appears either behind or beside Search Bar)
  • 为什么开机慢上面还显示;Inetrnet,Explorer
  • 有关调用远程WCF服务的超时问题(Timeout Question about Invoking a Remote WCF Service)