/collection/{slug}: EmptyResultDataAccessException with not existing id

[php-coder]

When I open not existing collection /collection/10/foo I should get 404 error, but currently I see 500:

Aug 18 23:56:04 my-stamps.ru java[21650]: Caused by: org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0
Aug 18 23:56:04 my-stamps.ru java[21650]:         at org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:71)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:212)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForObject(NamedParameterJdbcTemplate.java:219)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at ru.mystamps.web.dao.impl.JdbcCollectionDao.findCollectionInfoById(JdbcCollectionDao.java:176)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at ru.mystamps.web.service.CollectionServiceImpl.findById(CollectionServiceImpl.java:153)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at java.lang.reflect.Method.invoke(Method.java:498)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at com.sun.proxy.$Proxy57.findById(Unknown Source)
Aug 18 23:56:04 my-stamps.ru java[21650]:         at ru.mystamps.web.controller.CollectionController.showInfo(CollectionController.java:66)

[php-coder]

In addition to the fix I would like to have an integration test for that case.

Hints:

• we can use WhenAnonymousUserOpenNotExistingCategoryPage test as example
• we have to add InfoCollectionPage (and use InfoSeriesPage as example)

[php-coder]

@bodom91 This will be your next task.

[bodom91]

My Solution bodom91@d2f0d9b

But im not sure about InfoCollectionPage and now i dont have idea, sorry ...((

[php-coder]

But im not sure about InfoCollectionPage and now i dont have idea, sorry ...((

Ah, I see now that we don't need it. I'm sorry, I've updated the description.