NPE running 2.1.7-b3 on Caucho Resin 3.0.22

[Migrated From Jforum.net]

After a successful installation (well, not very successful, have to get the __index.redirect from 2.1.6, but that's beside the point).

While trying to access /forums/list.page, anyone can help me with this?

java.lang.NullPointerException
	at com.caucho.sql.UserStatement.clearWarnings(Unknown Source)
	at net.jforum.util.DbUtils.close(DbUtils.java:89)
	at net.jforum.dao.generic.GenericUserDAO.getTotalUsers(GenericUserDAO.java:605)
	at net.jforum.repository.ForumRepository.loadUsersInfo(ForumRepository.java:773)
	at net.jforum.repository.ForumRepository.start(ForumRepository.java:131)
	at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:100)
	at net.jforum.JForum.init(JForum.java:114)
	at com.caucho.server.dispatch.ServletConfigImpl.createServletImpl(Unknown Source)
	at com.caucho.server.dispatch.ServletConfigImpl.createServlet(Unknown Source)
	at com.caucho.server.dispatch.ServletFilterChain.doFilter(Unknown Source)
	at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
	at com.caucho.server.dispatch.FilterFilterChain.doFilter(Unknown Source)
	at com.caucho.server.webapp.WebAppFilterChain.doFilter(Unknown Source)
	at com.caucho.server.dispatch.ServletInvocation.service(Unknown Source)
	at com.caucho.server.http.HttpRequest.handleRequest(Unknown Source)
	at com.caucho.server.port.TcpConnection.run(Unknown Source)
	at com.caucho.util.ThreadPool.runTasks(Unknown Source)
	at com.caucho.util.ThreadPool.run(Unknown Source)
	at java.lang.Thread.run(Thread.java:619)

Thanks
[originally posted on jforum.net by ajiaojr]

[Migrated From Jforum.net]

Hmm, a quick look at the DbUtils code shows that this is occuring in the following area at the st.clearWarnings() line:

		if (st != null) {
			try {
				st.clearWarnings();
				st.close();
			}
			catch (SQLException e) { }
		}

Since st can't be null, it must be coming from the resin code.

Back tracking the trace some more, this is coming from a "finally" clause that may be triggered by a SQLException (which the resin bug is masking).

Before beating up on the Resin developers, I'd look closely at all your DB settings. This is one of the first DB calls and so the mask error could be an DB connection issue like the user not having rights to the tables or that your DAO implimentation does not match your DB (SQL Syntax error).
[originally posted on jforum.net by monroe]