jirkapinkas/java-blog-aggregator

Java Blog Aggregator

java-blog-aggregator's Issues

PSQLException unable to crackdown

Hi Jiri Pinkas,

First of all thank you so much for these tutorials. I am getting a PSQLException in PROD, tried to go through your github code too but does not seem to resolve. Can you please help?

I have bolded the reference that I found wrong.

root cause

Hibernate: select user0_.id as id1_0_0_, user0_.email as email2_0_0_, user0_.enabled as enabled3_0_0_, user0_.name as name4_0_0_, user0_.password as password5_0_0_ from app_user user0_ where user0_.id=?
2016-02-26T22:52:22.988346+00:00 app[web.1]: Hib
ernate: select item0_.id as id1_3_, item0_.blog_id as blog_id6_3_, item0_.description as descript2_3_, item0_.link as link3_3_, item0_.published_date as publishe4_3_, item0_.title as title5_3_ from Item item0_ left outer join Blog blog1_ on item0_.blog_id=blog1_.id where blog1_.id=? and item0_.link=?
2016-02-26T22:52:23.752140+00:00 app[web.1]: Feb 26, 2016 10:52:23 PM org.apache.coyote.AbstractProtocol start
2016-02-26T22:52:23.752148+00:00 app[web.1]: INFO: Starting ProtocolHandler ["http-nio-39649"]
2016-02-26T22:52:24.038480+00:00 app[web.1]: Hibernate: select count(item0_.id) as col_0_0_ from Item item0_
2016-02-26T22:52:24.064315+00:00 app[web.1]: Feb 26, 2016 10:52:24 PM org.apache.catalina.core.StandardWrapperValve invoke
2016-02-26T22:52:24.064329+00:00 app[web.1]: at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
2016-02-26T22:52:24.064330+00:00 app[web.1]: at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
2016-02-26T22:52:24.064333+00:00 app[web.1]: at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
2016-02-26T22:52:24.064333+00:00 app[web.1]: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
2016-02-26T22:52:24.064334+00:00 app[web.1]: at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
2016-02-26T22:52:24.064339+00:00 app[web.1]: at org.hibernate.loader.Loader.doList(Loader.java:2610)
2016-02-26T22:52:24.064340+00:00 app[web.1]: at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2422)
2016-02-26T22:52:24.064344+00:00 app[web.1]: at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1339)
2016-02-26T22:52:24.064325+00:00 app[web.1]: SEVERE: Servlet.service() for servlet [dispatcher] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet] with root cause
2016-02-26T22:52:24.064331+00:00 app[web.1]: at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
2016-02-26T22:52:24.064343+00:00 app[web.1]: at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
2016-02-26T22:52:24.064347+00:00 app[web.1]: at org.springframework.data.jpa.repository.support.SimpleJpaRepository.executeCountQuery(SimpleJpaRepository.java:623)
2016-02-26T22:52:24.064372+00:00 app[web.1]: at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
2016-02-26T22:52:24.064378+00:00 app[web.1]: at com.akash.blog.service.ItemService.getItems(ItemService.java:20)
2016-02-26T22:52:24.064382+00:00 app[web.1]: at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:222)
2016-02-26T22:52:24.064386+00:00 app[web.1]: at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
2016-02-26T22:52:24.064387+00:00 app[web.1]: at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:969)
2016-02-26T22:52:24.064327+00:00 app[web.1]: org.postgresql.util.PSQLException: ERROR: relation "item" does not exist
2016-02-26T22:52:24.064332+00:00 app[web.1]: at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
2016-02-26T22:52:24.064340+00:00 app[web.1]: at org.hibernate.loader.Loader.doList(Loader.java:2593)
2016-02-26T22:52:24.064356+00:00 app[web.1]: at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:371)
2016-02-26T22:52:24.064362+00:00 app[web.1]: at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:468)
2016-02-26T22:52:24.064368+00:00 app[web.1]: at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61)
2016-02-26T22:52:24.064376+00:00 app[web.1]: at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
2016-02-26T22:52:24.064380+00:00 app[web.1]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Thanks,
Akash

How can I add an image to my blog on topjavablogs.com?

Hi Jirka,

I didn't find any contact information on topjavablogs.com, so I'll open an issue to contact you. I've noticed that some blogs have an image - usually the headshot of the blogger. How can I add an image to my blog on topjavablogs.com?

Regards,
Stephan

The container 'Maven Dependencies' references non existing library

Hi Sir,
I cloned this repository from

java-blog-aggregator

and imported into STS, after import I got error

Description Resource    Path    Location    Type
The container 'Maven Dependencies' references non existing library 'C:\Users\my-workstation\.m2\repository\org\apache\httpcomponents\httpclient\4.3.6\httpclient-4.3.6.jar' java-blog-aggregator        Build path  Build Path Problem

and

Description Resource    Path    Location    Type
ArtifactTransferException: Failure to transfer org.apache.httpcomponents:httpclient:jar:4.3.6 from http://repo.maven.apache.org/maven2 was cached in the local repository, resolution will not be reattempted until the update interval of central has elapsed or updates are forced. Original error: Could not transfer artifact org.apache.httpcomponents:httpclient:jar:4.3.6 from/to central (http://repo.maven.apache.org/maven2): The operation was cancelled.    pom.xml /java-blog-aggregator   line 44 Maven Dependency Problem
Missing artifact org.apache.httpcomponents:httpclient:jar:4.3.6 pom.xml /java-blog-aggregator   line 1  Maven Dependency Problem.

Screenshot is

I removed

<dependency>
    <groupId>org.apache.httpcomponents</groupId>
    <artifactId>httpclient</artifactId>
    <version>4.3.6</version>
</dependency>

and added

<dependency>
    <groupId>org.apache.httpcomponents</groupId>
    <artifactId>httpclient</artifactId>
    <version>4.5.1</version>
</dependency> 

thus the issue was resolved.

Please check if it is there and my fix works?

Regards :
Arshad Ali Soomro.

Description Resource Path Location Type The container 'Maven Dependencies' references non existing library '/home/pulasthi/.m2/repository/com/sun/jersey/jersey-servlet/1.20-SNAPSHOT/jersey-servlet-1.20-SNAPSHOT.jar' testtwo Build path Build Path Problem

I am getting this error while trying to build a new project in maven with Jax RS on Tomcat server. I tried few options on the internet but nothing worked out.
Force update dependency
refreshing
Nothing worked.
Please someone help..!