Hello,
My problem seems similar to this recent post from Eduardo, however I am not savvy enough to say for sure:
http://www.jivesoftware.org/community/thread.jspa?threadID=16635&tstart=0
Just upgraded from asterisk-im 1.0b2 to 1.0, jive messenger 2.2.1 to 2.3.0
Cannot save Phone Mappings, recieve the “operation completed succesfully” when creating a new mapping.
However, when I go into ‘‘Phone Mappings’’ there are no entries listed.
Some things to note:
-
This all worked fine with my previous versions
-
I’'m using the embedded database
-
I included my Error Log for examination
Seems as though there is a difference in the way the 1.0 plugin requires you to enter the details of the phone mapping, or for some reason it cannot save it to the database. This is how I entered the information, which again, worked before:
Username: ryan
Phone: SIP/20 (from the drop down menu)
Extension: 20
My Error Log:
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.jivesoftware.phone.database.HibernatePhoneDAO.getALL(HibernatePhoneDAO.java :132)
at org.jivesoftware.phone.BasePhoneManager.getAll(BasePhoneManager.java:34)
at org.jivesoftware.messenger.plugin.phone.phone_002dusers_jsp._jspService(phone_0 02dusers_jsp.java:287)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.jivesoftware.messenger.container.PluginServlet.handleJSP(PluginServlet.java :227)
at org.jivesoftware.messenger.container.PluginServlet.service(PluginServlet.java:9 1)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:427)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:822)
at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)
at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:43)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)
at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)
at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:494)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:624)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)
at org.mortbay.http.HttpServer.service(HttpServer.java:896)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Caused by: java.sql.SQLException: Column not found: DEVICES0_.ISMONITORED in statement
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at org.jivesoftware.database.AbstractConnection.prepareStatement(AbstractConnectio n.java:36)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:38 3)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:32 1)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:8 6)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1129)
at org.hibernate.loader.Loader.doQuery(Loader.java:373)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java: 210)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1401)
… 46 more