ourownjava.com | Java | JEE | ATG | Solr | Endeca | JSP | UML | TDD

How to write contains/suggestion/match query using ATG RQL?

There are times when you may have to write contains query to support a suggestion drop-down or standard search functionality. ATG Object Oriented Query Language (RQL) supports contains query with the help of simple RQL API. QueryBuilder.createPatternMatchQuery(QueryExpression, QueryExpression, Integer) would help you fire a contains query against your relational data store.

package com.ourownjava.atg.repository;
import atg.adapter.gsa.GSARepository;
import atg.repository.Query;
import atg.repository.QueryBuilder;
import atg.repository.QueryExpression;
import atg.repository.RepositoryException;
import atg.repository.RepositoryItem;
import atg.repository.RepositoryView;
/**
*
* @author ourownjava.com
*/
public class EmployeeTool {
private GSARepository gsaRepository;
public void setGsaRepository(final GSARepository gsaRepository) {
this.gsaRepository = gsaRepository;
}
public RepositoryItem[] findSuggestions(final String name)
throws RepositoryException {
final RepositoryView employeeView = gsaRepository.getView("EMPLOYEE");
final QueryBuilder queryBuilder = employeeView.getQueryBuilder();
final QueryExpression propertyExpression = queryBuilder
.createPropertyQueryExpression("name");
final QueryExpression valueExpression = queryBuilder
.createConstantQueryExpression(name);
final Query accountQuery = queryBuilder.createPatternMatchQuery(
propertyExpression, valueExpression, QueryBuilder.CONTAINS);
final RepositoryItem[] repositoryItems = employeeView
.executeQuery(accountQuery);
return repositoryItems;
}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

package com.ourownjava.atg.repository;

import atg.adapter.gsa.GSARepository;

import atg.repository.Query;

import atg.repository.QueryBuilder;

import atg.repository.QueryExpression;

import atg.repository.RepositoryException;

import atg.repository.RepositoryItem;

import atg.repository.RepositoryView;

/**

*

* @author ourownjava.com

*/

public class EmployeeTool {

private GSARepository gsaRepository;

public void setGsaRepository(final GSARepository gsaRepository) {

this.gsaRepository = gsaRepository;

}

public RepositoryItem[] findSuggestions(final String name)

throws RepositoryException {

final RepositoryView employeeView = gsaRepository.getView("EMPLOYEE");

final QueryBuilder queryBuilder = employeeView.getQueryBuilder();

final QueryExpression propertyExpression = queryBuilder

.createPropertyQueryExpression("name");

final QueryExpression valueExpression = queryBuilder

.createConstantQueryExpression(name);

final Query accountQuery = queryBuilder.createPatternMatchQuery(

propertyExpression, valueExpression, QueryBuilder.CONTAINS);

final RepositoryItem[] repositoryItems = employeeView

.executeQuery(accountQuery);

return repositoryItems;

}

BlockingQueue in Java – How to implement producer-consumer design using BlockingQueue?

Java 5 util.concurrent package provides a very useful class named “BlockingQueue” to implement producer-consumer design. In java 1.4 world developers used to use wait and notify mechanism to implement the same design. BlockingQueue class made code more readable and reduced the chances of bug in the code. In the below given example, we have a […]
Continue reading…

Oracle Endeca – Keyword search in Endeca using presentation API.

Sample client which connect to an Oracle Endeca MDEX server and make keyword search. Query will be applied with nid zero and the search term will be searched against all searchable keys in the index. This client connect to MDEX installed in localhost at default port 15000.

package com.ourownjava.search.endeca;
import com.endeca.navigation.DimValIdList;
import com.endeca.navigation.ENEConnection;
import com.endeca.navigation.ENEQuery;
import com.endeca.navigation.ENEQueryException;
import com.endeca.navigation.ENEQueryResults;
import com.endeca.navigation.ERec;
import com.endeca.navigation.ERecSearch;
import com.endeca.navigation.ERecSearchList;
import com.endeca.navigation.HttpENEConnection;
/**
* @author ourownjava.com
*
* Example program to do keyword search using Endeca presentation API.
*
*/
public class KeywordSearchClient {
private static final String MDEX_HOST = "localhost";
private static final Integer MDEX_PORT = 15000;
/**
* @param args
* @throws ENEQueryException
*/
public static void main(final String[] args) throws ENEQueryException {
final ENEQueryResults results = createConnection().query(
createKeywordQuery("shirt"));
final StringBuilder builder = new StringBuilder();
builder.append("Found ");
builder.append(results.getNavigation().getERecs().size());
builder.append(" results.\n");
for (Object result : results.getNavigation().getERecs()) {
final ERec eRec = (ERec) result;
for (Object key : eRec.getProperties().keySet()) {
builder.append(key);
builder.append(" >> ");
builder.append(eRec.getProperties().get(key));
}
}
System.out.println(builder.toString());
}
@SuppressWarnings("unchecked")
private static ENEQuery createKeywordQuery(final String searchTerm) {
final ENEQuery query = new ENEQuery();
final DimValIdList dimValIdList = new DimValIdList("0");
query.setNavDescriptors(dimValIdList);
final ERecSearchList searches = new ERecSearchList();
final ERecSearch eRecSearch = new ERecSearch("All", searchTerm);
searches.add(eRecSearch);
query.setNavERecSearches(searches);
return query;
}
/**
* @return
*/
private static ENEConnection createConnection() {
return new HttpENEConnection(MDEX_HOST, MDEX_PORT);
}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

package com.ourownjava.search.endeca;

import com.endeca.navigation.DimValIdList;

import com.endeca.navigation.ENEConnection;

import com.endeca.navigation.ENEQuery;

import com.endeca.navigation.ENEQueryException;

import com.endeca.navigation.ENEQueryResults;

import com.endeca.navigation.ERec;

import com.endeca.navigation.ERecSearch;

import com.endeca.navigation.ERecSearchList;

import com.endeca.navigation.HttpENEConnection;

/**

* @author ourownjava.com

*

* Example program to do keyword search using Endeca presentation API.

*

*/

public class KeywordSearchClient {

private static final String MDEX_HOST = "localhost";

private static final Integer MDEX_PORT = 15000;

/**

* @param args

* @throws ENEQueryException

*/

public static void main(final String[] args) throws ENEQueryException {

final ENEQueryResults results = createConnection().query(

createKeywordQuery("shirt"));

final StringBuilder builder = new StringBuilder();

builder.append("Found ");

builder.append(results.getNavigation().getERecs().size());

builder.append(" results.\n");

for (Object result : results.getNavigation().getERecs()) {

final ERec eRec = (ERec) result;

for (Object key : eRec.getProperties().keySet()) {

builder.append(key);

builder.append(" >> ");

builder.append(eRec.getProperties().get(key));

}

System.out.println(builder.toString());

}

@SuppressWarnings("unchecked")

private static ENEQuery createKeywordQuery(final String searchTerm) {

final ENEQuery query = new ENEQuery();

final DimValIdList dimValIdList = new DimValIdList("0");

query.setNavDescriptors(dimValIdList);

final ERecSearchList searches = new ERecSearchList();

final ERecSearch eRecSearch = new ERecSearch("All", searchTerm);

searches.add(eRecSearch);

query.setNavERecSearches(searches);

return query;

}

/**

* @return

*/

private static ENEConnection createConnection() {

return new HttpENEConnection(MDEX_HOST, MDEX_PORT);

}

PipedReader and PipedWriter in java.

You know the power of pipe (“|”) operator in Unix. It helps you to redirect output from one command to another. PipedReader and PipedWriter classes in java.io package helps you to do the same. It helps you to redirect the read input into writer seamlessly. In unix, two process on different address space can communicate […]
Continue reading…

How to print the JBoss JNDI tree?

Even though JBoss comes with JMX console which gives you the graphical view of JNDI tree sometime you might need to print the JNDI tree to look at the absolute path of your boud resources. Here is an example program that can be used to print JBoss JNDI tree.

package com.ourownjava.corejava.jboss;
import java.util.Properties;
import javax.naming.*;
/**
* @author ourownjava.com
* @date May 3rd, 2011
*
* Example program to print JBoss JNDI tree
*
*/public class JNDIClientExample {
public static void main(String args[]) throws Exception {
final Properties props = new Properties();
//create the initial context.
//change the IP address as per your environment
props.put(InitialContext.INITIAL_CONTEXT_FACTORY,
"org.jnp.interfaces.NamingContextFactory");
props.put(InitialContext.PROVIDER_URL, "jnp://127.0.0.1:1099");
final Context context = new InitialContext(props);
final NamingEnumeration<?> enumeration = context.list("/");
while (enumeration.hasMore()) {
System.out.println(enumeration.next());
}
}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

package com.ourownjava.corejava.jboss;

import java.util.Properties;

import javax.naming.*;

/**

* @author ourownjava.com

* @date May 3rd, 2011

*

* Example program to print JBoss JNDI tree

*

*/public class JNDIClientExample {

public static void main(String args[]) throws Exception {

final Properties props = new Properties();

//create the initial context.

//change the IP address as per your environment

props.put(InitialContext.INITIAL_CONTEXT_FACTORY,

"org.jnp.interfaces.NamingContextFactory");

props.put(InitialContext.PROVIDER_URL, "jnp://127.0.0.1:1099");

final Context context = new InitialContext(props);

final NamingEnumeration<?> enumeration = context.list("/");

while (enumeration.hasMore()) {

System.out.println(enumeration.next());

}

Java String immutability and intern method.

All of you would be knowing the fact that String is immutable in java, which means once constructed can not be altered. This allows the jvm to have a literal pool, literal pool will be helpful to reduce the memory usage and to increase the performance. Each time when a String is created JVM check […]
Continue reading…

Use of UncaughtExceptionHandler in java.

Since every thread runs in it’s own stack in java the main thread will not come to know the status of Thread started by it. Programmer can implement an interface named UncaughtExceptionHandler to get a call back from JVM if an Exception occurs in a given thread and its not handled properly. A simple implementation […]
Continue reading…

How to convert native character to unicode and unicode to native?

Java provides a simple tool named native2ascii to convert native to ASCII and ASCII to native. Native characters are represented in ASCII using its Unicode equivalent. You can find the native2ascii tool in the JAVA_HOME/bin To convert native to ascii you can use the below given command. /local/opt/java/bin/native2ascii -encoding utf8 source-file target-file source file should […]
Continue reading…

How to create java maven project in Eclipse?

In this post we will talk about creating java maven project. Steps involved in creating java maven project. 1. Lunch eclipse. Click “File->New->Maven Project” menu item. 2. In the new maven project dialog, select “create a simple project” check box and click “Next” button. 3. Give appropriate “Group Id”, “Artifact Id”, “Version” and “Packaging Type”. […]
Continue reading…

How to create a data source/connection pool in JBoss?

Today we shall talk about creating data source in JBoss. You can create a data source in JBoss for any RDBMS in five simple steps. 1. Find your RDBM’s data source xml from JBOSS_HOME\docs\examples\jca, for example if you wanted to create a data source for DB2 then pick db2-ds.xml. 2. Edit the db2-ds.xml file and […]
Continue reading…