[Messaging, JMS & JBossMQ] - How to persist JMS message in the Oracle Database
by ajayks
I want to know about the configuration in JBOSS which allow me to store JMS message sent to a Queue in the Oracle database.
I want to following information with regard to this:-
1. What configuration I need to do in JBOSS 4.2.2.GA for persisting JMS message in the oaracke Database
2. How can I view persisted message in the Database /what is the name of table in which message would be stored by the JBOSS AS.
3. When I configure message to be persisted, is every JMS message would be stored in the database.
4. My requirement is that all JMS message should be persisted in database before it is delivered to Queue and after successfully delivering message to the Queue it should be removed from the database. Only those message which are not delivered to Queue due to any reason for example system crash etc, should be made stored in the database. Can is it possible in JBOSS 4.2.2.GA
Thanks to help me out in clarifying my all above doubt .
with best regards.
Ajay
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4134766#4134766
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4134766
18 years, 1 month
[JBoss Messaging] - How to persist JMS message in the Oracle Database
by ajayks
I want to know about the configuration in JBOSS which allow me to store JMS message sent to Queue in Oracle database.
I want to following information with regard to this:-
1. What configuration I need to do in JBOSS 4.2.2.GA for persisting message in Database
2. How can I view persisted message in the Database /what is the name of table in which message would be stored by JBOSS.
3. When I configure message to be persisted, is every JMS message would be stored n database.
4. My requirement is that all JMS message should be persisted in database before it is delivered to a Queue and after successfully delivering message to the Queue it should be removed from the database. Only those message which are not delivered due to any reason for example system crash etc, should be made stored in the database. Can is it possible in JBOSS 4.2.2.GA
Thanks to help me out to remove my doubt.
with best regards,
Ajay
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4134760#4134760
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4134760
18 years, 1 month
[JBoss jBPM] - Re: Table not found in statement. While deloying a Process D
by chrisrjcox
Thanks for the short but sweet reply Ronald :)
I have the following config files.
jbpm.cfg.xml
| <jbpm-configuration>
|
| <jbpm-context>
| <service name='persistence' factory='org.jbpm.persistence.db.DbPersistenceServiceFactory' />
| <service name='message' factory='org.jbpm.msg.db.DbMessageServiceFactory' />
| <service name='scheduler' factory='org.jbpm.scheduler.db.DbSchedulerServiceFactory' />
| <service name='logging' factory='org.jbpm.logging.db.DbLoggingServiceFactory' />
| <service name='authentication' factory='org.jbpm.security.authentication.DefaultAuthenticationServiceFactory' />
| </jbpm-context>
|
| <!-- configuration resource files pointing to default configuration files in jbpm-{version}.jar -->
| <string name='resource.hibernate.cfg.xml' value='hibernate.cfg.xml' />
| <!-- <string name='resource.hibernate.properties' value='hibernate.properties' /> -->
| <string name='resource.business.calendar' value='org/jbpm/calendar/jbpm.business.calendar.properties' />
| <string name='resource.default.modules' value='org/jbpm/graph/def/jbpm.default.modules.properties' />
| <string name='resource.converter' value='org/jbpm/db/hibernate/jbpm.converter.properties' />
| <string name='resource.action.types' value='org/jbpm/graph/action/action.types.xml' />
| <string name='resource.node.types' value='org/jbpm/graph/node/node.types.xml' />
| <string name='resource.parsers' value='org/jbpm/jpdl/par/jbpm.parsers.xml' />
| <string name='resource.varmapping' value='org/jbpm/context/exe/jbpm.varmapping.xml' />
|
| <int name='jbpm.byte.block.size' value="1024" singleton="true" />
| <bean name='jbpm.task.instance.factory' class='org.jbpm.taskmgmt.impl.DefaultTaskInstanceFactoryImpl' singleton='true' />
| <bean name='jbpm.variable.resolver' class='org.jbpm.jpdl.el.impl.JbpmVariableResolver' singleton='true' />
|
| </jbpm-configuration>
|
Hybernate.cfg.xml file.
| <?xml version='1.0' encoding='utf-8'?>
|
|
|
| <!DOCTYPE hibernate-configuration PUBLIC
|
| "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
|
| "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
|
|
|
| <hibernate-configuration>
|
| <session-factory>
|
|
|
| <!-- hibernate dialect -->
|
| <property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>
|
|
|
| <!-- JDBC connection properties (begin) -->
|
| <property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>
|
| <property name="hibernate.connection.url">jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}jbpmDB</property>
|
| <property name="hibernate.connection.username">sa</property>
|
| <property name="hibernate.connection.password"></property>
|
| <!-- JDBC connection properties (end) -->
|
|
|
| <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
|
|
|
| <!-- DataSource properties (begin) ===
|
| <property name="hibernate.connection.datasource">java:/JbpmDS</property>
|
| ==== DataSource properties (end) -->
|
| etc.............
|
and the jbpm-ds.xml file
| <?xml version="1.0" encoding="UTF-8"?>
|
|
|
| <datasources>
|
|
|
| <local-tx-datasource>
|
| <jndi-name>JbpmDS</jndi-name>
|
| <connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}jbpmDB</connection-url>
|
| <driver-class>org.hsqldb.jdbcDriver</driver-class>
|
| <user-name>sa</user-name>
|
| <password></password>
|
| <min-pool-size>1</min-pool-size>
|
| <max-pool-size>5</max-pool-size>
|
| <idle-timeout-minutes>0</idle-timeout-minutes>
|
| <track-statements/>
|
| <!--
|
| <security-domain>HsqlDbRealm</security-domain>
|
| -->
|
| <prepared-statement-cache-size>32</prepared-statement-cache-size>
|
| <metadata><type-mapping>Hypersonic SQL</type-mapping></metadata>
|
| <depends>jboss:service=Hypersonic,database=jbpmDB</depends>
|
| </local-tx-datasource>
|
|
|
| <mbean code="org.jboss.jdbc.HypersonicDatabase"
|
| name="jboss:service=Hypersonic,database=jbpmDB">
|
| <attribute name="Database">jbpmDB</attribute>
|
| <attribute name="InProcessMode">true</attribute>
|
| </mbean>
|
|
|
| </datasources>
|
I can't see what could be wrong? The files are the standard ones from the jBPM package, and there is no assistance within the jBPM jPDL User Guide to reflect having to change the config file to get this to work.
Does anyone see anything incorrect within the above files?
Thanks
Chris
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4134759#4134759
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4134759
18 years, 1 month