reset password
Author Message
JHautzinger
Posts: 14
Posted 03:22 May 23, 2010 |

So I must have done something tonight because my project looks like it isnt reading my build.properties file anymore.

 

In my logs it says:

2010-05-23 03:13:09,085 ERROR ExceptionResolver: Exception caused by user guest
2010-05-23 03:13:09,087 ERROR ExceptionResolver: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query

 

It looks like it is trying to log in my database as 'guest.'  Anything I can do to fix this?

cysun
Posts: 2935
Posted 07:47 May 23, 2010 |

The error message simply says the CSNS user "guest" (i.e. an anonymous user) caused an exception. It has nothing to do with logging into your database. The reason for the exception should be in the rest of the stack trace. My guess is it has something to do with your DAO.

JHautzinger
Posts: 14
Posted 14:27 May 23, 2010 |

Well, it seems to be cause by not being able to access the database.

Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for relation news

 

It is a Runtime Error whenever the database needs to be accessed.  The thing is, I have tried multiple Log in Roles on the database, rebuilding it each time so that the current log-in role owns the entire database, but it keeps getting these errors.

cysun
Posts: 2935
Posted 14:34 May 23, 2010 |

Delete csns-*.xml under /WEB-INF and try again.

JHautzinger
Posts: 14
Posted 14:37 May 23, 2010 |

This solved it, but I swear I tried that before I posted this last night.

 

Thank you.