Posted by smoscar on 12/12/06 23:09

I received a few cd's from a client, with a .bak MS-SQL database
backup, installs for tomcat, and java. Everything was provided via an
altered webapps folder tomcat, which holds an almost all JSP setup.

I figured out the login issue I was having, was able to correct, and
properly view the tables in SQL Management Studio. For a long time
when trying to run the DB, we received countless HTTP 500 exception
reports. When checking the logs one things stands out
"net.sf.hibernate.exception.SQLGrammarException: could not load:
[com.micropact.product.brac.bo.State#11] & Caused by:
java.sql.SQLException: Invalid object name 'State'."


State is a field in one of the tables. and value #11 denotes a valid
state, GA.... we went on like this for hours, until I decided to clear
out an entry in a table that made reference to GA. At this point all
the bells and whistles started working(the page came up right) Clicked
on one of the links and got a " [ServletException
in:/fieldOffice/view/content.jsp] Failed to lazily initialize a
collection' "

The point of this database is to be a record of addresses, and
installations, when I add a new address it takes it properly, except
that the drop down for state does not work at all, there are no drop
down entries, and nothing can be manually typed. which is where I think
all our problems are.

If anyone would like to take a stab here, let me know and we can figure
where the issue is. I'm sorry if I sound a little scatterbrained , but
I have been trying to get this to properly work for 2 days.

-GLW

[Back to original message]