Regarding hibernate dialect in Presence and XDM server

aayush

unread,

Feb 12, 2009, 4:47:06 AM2/12/09

to mobicents-public

Hello,

I had a doubt...

If i try and connect the PS+XDM servers to a MySQL database, will i
also need to change the hibernate dialect property in each of the
persistence.xml files of the server..........or will the changing of
the dialect in the persistence.properties of /deploy/ejb3.deployer
package be sufficient?

I plan to use DefaultDS for the rest of JBOSS, while using MySqlDS for
PS+XDMS.

Thanks

aayush

Eduardo Martins

unread,

Feb 12, 2009, 4:53:25 AM2/12/09

to mobicent...@googlegroups.com

I guess the easiest way is to create another data source and change
the persistence.xml files for the presence servers. Can you share with
us a wiki page, an "how to" for such change later?

-- Eduardo

aayush

unread,

Feb 12, 2009, 5:08:51 AM2/12/09

to mobicents-public

Okay..Thats exactly what i plan to do. First i will try it out on my
end..and then make a wiki for it.

Thanks :)
aayush

aayush bhatnagar

unread,

Feb 13, 2009, 4:53:00 AM2/13/09

to mobicents-public

Hi Eduardo,

Connecting to MySQL was not a problem...the data source was located
and the tables were created successfully. Queries will also work. I
can create a wiki if you wish, listing the general steps.

However, there seems to be a problem in executing an UPDATE query on
the XDM_DATASOURCE_DOCUMENTS table for xcap-caps app usage document.
The data meant to be updated in the XML column is too big for it..and
hence gives a Data Truncation error. I believe the xcap-caps global
document goes in the XML column.

Class where it is traced to:
org.mobicents.slee.xdm.server.datasource.jpa.Document JPA entity class
representing the table mentioned above.

DEBUG log trace:
-----------------------------

2009-02-13 14:45:17,008 DEBUG [org.hibernate.impl.SessionImpl] opened
session at timestamp: 12345165170
2009-02-13 14:45:17,008 DEBUG
[org.hibernate.ejb.AbstractEntityManagerImpl] Looking for a JTA
transaction to join
2009-02-13 14:45:17,008 DEBUG [org.hibernate.jdbc.JDBCContext]
successfully registered Synchronization
2009-02-13 14:45:17,008 DEBUG [org.hibernate.jdbc.AbstractBatcher]
about to open PreparedStatement (open PreparedStatements: 0, globally:
0)
2009-02-13 14:45:17,008 DEBUG [org.hibernate.jdbc.ConnectionManager]
opening JDBC connection
2009-02-13 14:45:17,008 DEBUG [org.hibernate.SQL] update
XDM_DATASOURCE_DOCUMENTS set XML=?, ETAG=? where APPUSAGE_ID=? and
COLLECTION_NAME=? and DOCUMENT_NAME=?
2009-02-13 14:45:17,008 DEBUG [org.hibernate.jdbc.AbstractBatcher]
about to close PreparedStatement (open PreparedStatements: 1,
globally: 1)
2009-02-13 14:45:17,008 DEBUG [org.hibernate.jdbc.ConnectionManager]
aggressively releasing JDBC connection
2009-02-13 14:45:17,008 DEBUG [org.hibernate.jdbc.ConnectionManager]
releasing JDBC connection [ (open PreparedStatements: 0, globally: 0)
(open ResultSets: 0, globally: 0)]
2009-02-13 14:45:17,008 DEBUG
[org.hibernate.util.JDBCExceptionReporter] could not execute update
query [update XDM_DATASOURCE_DOCUMENTS set XML=?, ETAG=? where
APPUSAGE_ID=? and COLLECTION_NAME=? and DOCUMENT_NAME=?]
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
column 'XML' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2939)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1541)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1455)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1440)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:75)
at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:396)
at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:259)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1141)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)
at org.hibernate.ejb.QueryImpl.executeUpdate(QueryImpl.java:48)
at org.mobicents.slee.xdm.server.datasource.jpa.JPADataSource.updateDocument(JPADataSource.java:100)
at org.openxdm.xcap.server.slee.resource.datasource.DataSourceSbbInterface.updateDocument(DataSourceSbbInterface.java:114)
at org.openxdm.xcap.server.slee.RequestProcessorSbb.put(RequestProcessorSbb.java:1420)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.mobicents.slee.container.deployment.interceptors.SbbLocalObjectInterceptor.invokeAndReturnObject(SbbLocalObjectInterceptor.java:72)
at org.openxdm.xcap.server.slee.RequestProcessorSbbLocalObjectImpl.put(RequestProcessorSbbLocalObjectImpl.java)
at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.updateXCAPCapsGlobalDoc(AbstractAppUsageSbb.java:202)
at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.onServiceStartedEvent(AbstractAppUsageSbb.java:252)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.mobicents.slee.runtime.sbbentity.SbbEntity.invokeEventHandler(SbbEntity.java:871)
at org.mobicents.slee.runtime.EventRouterImpl.routeQueuedEvent(EventRouterImpl.java:892)
at org.mobicents.slee.runtime.EventRouterImpl.access$100(EventRouterImpl.java:64)
at org.mobicents.slee.runtime.EventRouterImpl$EventExecutor.run(EventRouterImpl.java:121)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
2009-02-13 14:45:17,008 WARN
[org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState:
01004
2009-02-13 14:45:17,008 ERROR
[org.hibernate.util.JDBCExceptionReporter] Data truncation: Data too
long for column 'XML' at row 1
2009-02-13 14:45:17,008 DEBUG
[org.hibernate.ejb.AbstractEntityManagerImpl] mark transaction for
rollback
2009-02-13 14:45:17,008 ERROR
[org.openxdm.xcap.server.slee.RequestProcessorSbb]
javax.persistence.PersistenceException:
org.hibernate.exception.GenericJDBCException: could not execute update
query
2009-02-13 14:45:17,008 DEBUG
[org.openxdm.xcap.server.slee.resource.appusagecache.AppUsageCacheResourceAdaptorSbbInterface]
release(auid=xcap-caps)
2009-02-13 14:45:17,008 DEBUG
[org.mobicents.slee.container.deployment.interceptors.SbbLocalObjectInterceptor]
Invocation resulted in exception: null
2009-02-13 14:45:17,023 ERROR [STDERR]
org.openxdm.xcap.common.error.InternalServerErrorException: Failed to
serialize resulting dom document to string
2009-02-13 14:45:17,023 ERROR [STDERR] at
org.openxdm.xcap.server.slee.RequestProcessorSbb.put(RequestProcessorSbb.java:1428)
2009-02-13 14:45:17,023 ERROR [STDERR] at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2009-02-13 14:45:17,023 ERROR [STDERR] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2009-02-13 14:45:17,023 ERROR [STDERR] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2009-02-13 14:45:17,023 ERROR [STDERR] at
java.lang.reflect.Method.invoke(Method.java:585)
2009-02-13 14:45:17,023 ERROR [STDERR] at
org.mobicents.slee.container.deployment.interceptors.SbbLocalObjectInterceptor.invokeAndReturnObject(SbbLocalObjectInterceptor.java:72)
2009-02-13 14:45:17,023 ERROR [STDERR] at
org.openxdm.xcap.server.slee.RequestProcessorSbbLocalObjectImpl.put(RequestProcessorSbbLocalObjectImpl.java)
2009-02-13 14:45:17,023 ERROR [STDERR] at
org.openxdm.xcap.server.slee.AbstractAppUsageSbb.updateXCAPCapsGlobalDoc(AbstractAppUsageSbb.java:202)
2009-02-13 14:45:17,023 ERROR [STDERR] at
org.openxdm.xcap.server.slee.AbstractAppUsageSbb.onServiceStartedEvent(AbstractAppUsageSbb.java:252)
2009-02-13 14:45:17,023 ERROR [STDERR] at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2009-02-13 14:45:17,023 ERROR [STDERR] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2009-02-13 14:45:17,023 ERROR [STDERR] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2009-02-13 14:45:17,023 ERROR [STDERR] at
java.lang.reflect.Method.invoke(Method.java:585)
2009-02-13 14:45:17,023 ERROR [STDERR] at
org.mobicents.slee.runtime.sbbentity.SbbEntity.invokeEventHandler(SbbEntity.java:871)
2009-02-13 14:45:17,023 ERROR [STDERR] at
org.mobicents.slee.runtime.EventRouterImpl.routeQueuedEvent(EventRouterImpl.java:892)
2009-02-13 14:45:17,023 ERROR [STDERR] at
org.mobicents.slee.runtime.EventRouterImpl.access$100(EventRouterImpl.java:64)
2009-02-13 14:45:17,023 ERROR [STDERR] at
org.mobicents.slee.runtime.EventRouterImpl$EventExecutor.run(EventRouterImpl.java:121)
2009-02-13 14:45:17,023 ERROR [STDERR] at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
2009-02-13 14:45:17,023 ERROR [STDERR] at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
2009-02-13 14:45:17,023 ERROR [STDERR] at
java.lang.Thread.run(Thread.java:595)

Appreciate some help :)

aayush

Eduardo Martins

unread,

Feb 13, 2009, 5:19:20 AM2/13/09

to mobicent...@googlegroups.com

Perhaps you need to define a "larger" data type for the columns? I'm
not really an expert with MySQL :-)

-- Eduardo

aayush bhatnagar

unread,

Feb 13, 2009, 5:26:51 AM2/13/09

to mobicent...@googlegroups.com

Hi :)

I think i found an alternative solution.....i will need to test it out
though !!

Refer to this message---> This guy was getting this error with JBOSS
Portals+ MySQL combo:

http://www.mail-archive.com/jboss...@lists.sourceforge.net/msg112526.html

He added jdbcCompliantTruncation=false property to the connection URL
and it worked for him.

There is also a bugsy entry on this issue on JBOSS lists:
https://jira.jboss.org/jira/browse/JBPORTAL-533

Will keep you posted..

aayush

aayush bhatnagar

unread,

Feb 14, 2009, 2:21:22 AM2/14/09

to mobicent...@googlegroups.com

Hi Ed,

After a long fight..I have been able to squeeze past the hibernate errors by tweaking the MySQL DB config (my.ini file) and the msps-ds.xml descriptor in JBOSS.

However, I am getting these exceptions that i have traced to the XYZ-AppUsageSbb classes, which extend the AbstractAppUsageSbb class.

These errors are not coming in the OMAPresRulesAppUsageService and XCAPCapsAppUsageService.

They are only coming in the PresRulesAppUsageService,ResourceListsAppUsageService and RLSServicesAppUsageService services.

The error is traced to AbstractAppUsageSbb, which tries to update the xcap caps global document in its onServiceStarted() event handler. It delegates to RequestProcessorSbb (for put( ) operation), that talks to the DataSource RA by invoking dataSourceSbbInterface.updateDocument( ). This operation fails and the InternalServerErrorException is propogated upstream.

In all three errors below, there is a common point:

The element type "namespace" must be terminated by the matching end-tag "</namespace>".

I tried testing the server with X-lite..simple Subscriptions and publications are working well though.

#####################################################
PresRulesAppUsageService
#####################################################

11:16:53,398 INFO [SleeContainer] Activated ServiceID[PresRulesAppUsageService#org.openxdm#1.0]
11:16:53,398 INFO [PresRulesAppUsageSbb] Application usage activated
11:16:53,414 INFO [PresRulesAppUsageSbb] Loading schemas from file system...
11:16:53,461 INFO [PresRulesAppUsageSbb] Schemas loaded.
11:16:53,492 ERROR [STDERR] [Fatal Error] :1:248: The element type "namespace" must be terminated by the matching end-tag "</namespace>".
11:16:53,492 ERROR [STDERR] org.openxdm.xcap.common.error.InternalServerErrorException
11:16:53,492 ERROR [STDERR] at org.mobicents.slee.xdm.server.datasource.jpa.Document.getAsDOMDocument(Document.java:112)
11:16:53,492 ERROR [STDERR] at org.openxdm.xcap.server.slee.RequestProcessorSbb.put(RequestProcessorSbb.java:898)
11:16:53,492 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:16:53,492 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:16:53,492 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:16:53,492 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
11:16:53,492 ERROR [STDERR] at org.mobicents.slee.container.deployment.interceptors.SbbLocalObjectInterceptor.invokeAndReturnObject(SbbLocalObjectInterceptor.java:72)
11:16:53,492 ERROR [STDERR] at org.openxdm.xcap.server.slee.RequestProcessorSbbLocalObjectImpl.put(RequestProcessorSbbLocalObjectImpl.java)
11:16:53,492 ERROR [STDERR] at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.updateXCAPCapsGlobalDoc(AbstractAppUsageSbb.java:202)
11:16:53,492 ERROR [STDERR] at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.onServiceStartedEvent(AbstractAppUsageSbb.java:252)
11:16:53,492 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:16:53,492 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:16:53,492 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:16:53,492 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
11:16:53,492 ERROR [STDERR] at org.mobicents.slee.runtime.sbbentity.SbbEntity.invokeEventHandler(SbbEntity.java:871)
11:16:53,492 ERROR [STDERR] at org.mobicents.slee.runtime.EventRouterImpl.routeQueuedEvent(EventRouterImpl.java:892)
11:16:53,492 ERROR [STDERR] at org.mobicents.slee.runtime.EventRouterImpl.access$100(EventRouterImpl.java:64)
11:16:53,492 ERROR [STDERR] at org.mobicents.slee.runtime.EventRouterImpl$EventExecutor.run(EventRouterImpl.java:121)
11:16:53,492 ERROR [STDERR] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
11:16:53,492 ERROR [STDERR] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
11:16:53,492 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
11:16:53,492 ERROR [PresRulesAppUsageSbb] failed to update xcap caps global doc
org.openxdm.xcap.common.error.InternalServerErrorException: Failed to put xcap-caps global document. Cause: null Message:null
at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.updateXCAPCapsGlobalDoc(AbstractAppUsageSbb.java:211)
at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.onServiceStartedEvent(AbstractAppUsageSbb.java:252)

#####################################################
ResourceListsAppUsageService
#####################################################

11:16:54,008 INFO [SleeContainer] Activated ServiceID[ResourceListsAppUsageService#org.openxdm#1.0]
11:16:54,008 INFO [ResourceListsAppUsageSbb] Application usage activated
11:16:54,008 INFO [ResourceListsAppUsageSbb] Loading schemas from file system...
11:16:54,039 INFO [ResourceListsAppUsageSbb] Schemas loaded.
11:16:54,086 ERROR [STDERR] [Fatal Error] :1:248: The element type "namespace" must be terminated by the matching end-tag "</namespace>".
11:16:54,086 ERROR [STDERR] org.openxdm.xcap.common.error.InternalServerErrorException
11:16:54,086 ERROR [STDERR] at org.mobicents.slee.xdm.server.datasource.jpa.Document.getAsDOMDocument(Document.java:112)
11:16:54,086 ERROR [STDERR] at org.openxdm.xcap.server.slee.RequestProcessorSbb.put(RequestProcessorSbb.java:898)
11:16:54,086 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:16:54,086 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:16:54,086 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:16:54,086 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
11:16:54,086 ERROR [STDERR] at org.mobicents.slee.container.deployment.interceptors.SbbLocalObjectInterceptor.invokeAndReturnObject(SbbLocalObjectInterceptor.java:72)
11:16:54,086 ERROR [STDERR] at org.openxdm.xcap.server.slee.RequestProcessorSbbLocalObjectImpl.put(RequestProcessorSbbLocalObjectImpl.java)
11:16:54,086 ERROR [STDERR] at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.updateXCAPCapsGlobalDoc(AbstractAppUsageSbb.java:202)
11:16:54,086 ERROR [STDERR] at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.onServiceStartedEvent(AbstractAppUsageSbb.java:252)
11:16:54,086 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:16:54,086 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:16:54,086 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:16:54,086 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
11:16:54,086 ERROR [STDERR] at org.mobicents.slee.runtime.sbbentity.SbbEntity.invokeEventHandler(SbbEntity.java:871)
11:16:54,086 ERROR [STDERR] at org.mobicents.slee.runtime.EventRouterImpl.routeQueuedEvent(EventRouterImpl.java:892)
11:16:54,086 ERROR [STDERR] at org.mobicents.slee.runtime.EventRouterImpl.access$100(EventRouterImpl.java:64)
11:16:54,086 ERROR [STDERR] at org.mobicents.slee.runtime.EventRouterImpl$EventExecutor.run(EventRouterImpl.java:121)
11:16:54,086 ERROR [STDERR] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
11:16:54,086 ERROR [STDERR] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
11:16:54,086 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
11:16:54,086 ERROR [ResourceListsAppUsageSbb] failed to update xcap caps global doc
org.openxdm.xcap.common.error.InternalServerErrorException: Failed to put xcap-caps global document. Cause: null Message:null
at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.updateXCAPCapsGlobalDoc(AbstractAppUsageSbb.java:211)
at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.onServiceStartedEvent(AbstractAppUsageSbb.java:252)

#####################################################
RLSServicesAppUsageService
#####################################################

11:17:37,617 INFO [SleeContainer] Activated ServiceID[RLSServicesAppUsageService#org.openxdm#1.0]
11:17:37,632 INFO [RLSServicesAppUsageSbb] Application usage activated
11:17:37,632 INFO [RLSServicesAppUsageSbb] Loading schemas from file system...
11:17:37,679 INFO [RLSServicesAppUsageSbb] Schemas loaded.
11:17:37,820 ERROR [STDERR] [Fatal Error] :1:248: The element type "namespace" must be terminated by the matching end-tag "</namespace>".
11:17:37,820 ERROR [STDERR] org.openxdm.xcap.common.error.InternalServerErrorException
11:17:37,820 ERROR [STDERR] at org.mobicents.slee.xdm.server.datasource.jpa.Document.getAsDOMDocument(Document.java:112)
11:17:37,820 ERROR [STDERR] at org.openxdm.xcap.server.slee.RequestProcessorSbb.put(RequestProcessorSbb.java:898)
11:17:37,820 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:17:37,820 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:17:37,820 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:17:37,820 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
11:17:37,820 ERROR [STDERR] at org.mobicents.slee.container.deployment.interceptors.SbbLocalObjectInterceptor.invokeAndReturnObject(SbbLocalObjectInterceptor.java:72)
11:17:37,835 ERROR [STDERR] at org.openxdm.xcap.server.slee.RequestProcessorSbbLocalObjectImpl.put(RequestProcessorSbbLocalObjectImpl.java)
11:17:37,835 ERROR [STDERR] at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.updateXCAPCapsGlobalDoc(AbstractAppUsageSbb.java:202)
11:17:37,835 ERROR [STDERR] at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.onServiceStartedEvent(AbstractAppUsageSbb.java:252)
11:17:37,835 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11:17:37,835 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
11:17:37,835 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
11:17:37,835 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
11:17:37,835 ERROR [STDERR] at org.mobicents.slee.runtime.sbbentity.SbbEntity.invokeEventHandler(SbbEntity.java:871)
11:17:37,835 ERROR [STDERR] at org.mobicents.slee.runtime.EventRouterImpl.routeQueuedEvent(EventRouterImpl.java:892)
11:17:37,835 ERROR [STDERR] at org.mobicents.slee.runtime.EventRouterImpl.access$100(EventRouterImpl.java:64)
11:17:37,835 ERROR [STDERR] at org.mobicents.slee.runtime.EventRouterImpl$EventExecutor.run(EventRouterImpl.java:121)
11:17:37,835 ERROR [STDERR] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
11:17:37,835 ERROR [STDERR] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
11:17:37,835 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
11:17:37,835 ERROR [RLSServicesAppUsageSbb] failed to update xcap caps global doc
org.openxdm.xcap.common.error.InternalServerErrorException: Failed to put xcap-caps global document. Cause: null Message:null
at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.updateXCAPCapsGlobalDoc(AbstractAppUsageSbb.java:211)
at org.openxdm.xcap.server.slee.AbstractAppUsageSbb.onServiceStartedEvent(AbstractAppUsageSbb.java:252)

#####################################################

aayush

aayush bhatnagar

unread,

Feb 16, 2009, 2:30:21 AM2/16/09

to mobicent...@googlegroups.com

Okay :)

Good news !

I have been able to squeeze past all errors and problems now. Also tested using a soft phone.

I have migrated the database completely from Hypersonic to MySQL. There were certain data type mismatches and storage engine issues. Moreover there were certain configuration problems with MySQL DB itself (relating to a long standing MySQL bug).

For the benefit of others, i am attaching the MySQL DB script for Presence and XDM servers and a msps-ds.xml file that needs to be dropped into the /deploy directory in addition to the hypersonic db config.

Others can also try it out and confirm my results.

Thanks for the help :)

aayush

PRESENCE-XDMS-MOBICENTS.txt

msps-ds.xml

aayush

unread,

Feb 16, 2009, 6:33:37 AM2/16/09

to mobicents-public

I am currently running a very moderate load test with the PS+XDM using
MySQL DB.

1) There are 10 user agents each one having subscribed to each other's
presence event package (in addition to the presence.winfo event
package for their own info).

2) The subscription is refreshed every 60 seconds, and each User agent
publishes their presence once every 60 seconds.

3) In between there are sporadic presence publications by one user
agent that trigger off many NOTIFY messages to all subscribers.

The test has been running well for over 2 hours now.

aayush

On Feb 16, 12:30 pm, aayush bhatnagar <abhatnagar192...@gmail.com>
wrote:

> Okay :) Good news !
> I have been able to squeeze past all errors and problems now. Also tested
> using a soft phone.
>
> I have migrated the database completely from Hypersonic to MySQL. There were
> certain data type mismatches and storage engine issues. Moreover there were
> certain configuration problems with MySQL DB itself (relating to a long
> standing MySQL bug).
>
> For the benefit of others, i am attaching the MySQL DB script for Presence
> and XDM servers and a msps-ds.xml file that needs to be dropped into the
> /deploy directory in addition to the hypersonic db config.
>
> Others can also try it out and confirm my results.
>
> Thanks for the help :)
>
> aayush
>
> On Sat, Feb 14, 2009 at 12:51 PM, aayush bhatnagar <
>

> ...
>
> read more »
>
> PRESENCE-XDMS-MOBICENTS.txt
> 10KViewDownload
>
> msps-ds.xml
> < 1KViewDownload

rajat

unread,

Feb 16, 2009, 10:45:29 AM2/16/09

to mobicents-public

hi aayush.I am also trying what you just tried to do.I am getting
hundreds of errors about access denied and more.How did you manage to
connect SQL to jboss?In my case jboss cannot connect to SQL server.can
you tell me each and every details about the process you followed?

rajat.

> > > org.mobicents.slee.xdm.server.datasource.jpa.Document.getAsDOMDocument(Docu ment.java:112)