How to import Database connections into Oracle SQL Developer from XML

1. R-click on Connection root, a small context menu appears

2.Click on "Import Connections"

How to export Database connections from Oracle SQL Developer to XML

This article shows how to export the configured database connections in Oracle SQL Developer so that it is easily share the connections with other team members. 

1. R-click on Connections root, a small context menu appears.

2. click on "Export Connections".

Eclipselink Cache Coordination with JBoss and JMS

Agenda:
  1. Creating JPA project and generating entities.
  2. Configuring persistence properties and JPA project
  3. Testing the JPA project
  4. Update database when entity changed.
  5. Setting up load balance database connection.
  6. Setting Cache Coordination in Eclipselink

Cache Coordination enables EclipseLink to synchronize data changes in a distributed environment. for more information about cache coordination in EclipseLink, click here.

Following are the steps to enable Cache Coordination in JBoss AS7 / JBoss EAP6.
1. create JMS topic

2. creaet JMS connection factory

3. add the cache coordination properties into persistence.xml

<property name="eclipselink.cache.coordination.protocol" value="jms" />

<property name="eclipselink.cache.coordination.jms.topic" value="jms/EclipseLinkTopic" />

<property name="eclipselink.cache.coordination.jms.factory" value="jms/EclipseLinkTopicConnectionFactory" />

<property name="eclipselink.cache.coordination.jms.reuse-topic-publisher" value="true" />

<property name="eclipselink.cache.coordination.jms.host" value="remote://HOST:PORT" />

4. in eclipseLink module.xml, add the following into <dependencies />

<module name="javax.jms.api"/>

5. in hornetq module.xml, add the following into <dependencies />
<module name="org.eclipse.persistence"/>


Done!!

Putting and getting data to/from infinispan

Example shown below is applicable and tested working in JBoss EAP 6.x and JBoss AS 7.x

1. Inject the cache container with @resouce annotation.

    a) name, inject with the container name

    b) lookup, inject with the jndi name configured in the cache container.

code below is presented with method (a)

@Resource(name = "java:jboss/infinispan/container/CACHE-CONTAINER-NAME-IN-STANDALONE.XML")
private CacheContainer container;

make sure the cache container name exist in standalone.xml 
else there will be NullPointerException when getting the cache from the cache container.

Add and remove JMS queue in JBoss admin console

1. navigate to JBoss Console login page and login as admin

2. navigate JMS Messaging Provider
    Profile > Messaging > Messaging Provider, click View

3. Click JMS Destination

4. under Queues tab, click add

5. fill in the form, click Save

6. Review the Queue summary

Done!!