Java Beans Connectivity > Java Beans Classes Drop Down Menu is BLANK!

[Former Member]

CR support suggested I crosspost from SAP Crystal Reports in hopes I get better feedback..

I'm trying to add data elements to my report based on my java objects (POJO). I cannot seem to get the Java Beans Classes drop down menu to populate despite following the CRConfig.XML tutorial I found on the SAP site.

http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/90f892e8-931e-2b10-81a8-9154b9ee7...

1. I pointed my <JavaDir64> to my sdk/bin
   <JavaDir64>C:\Program Files\Java\jdk1.8.0_31\bin</JavaDir64>
2. <JavaDir32></JavaDir32>  !-- set to blank--
3. Added my <JavaBeansClassPath>
   <JavaBeansClassPath>C:\Users\_username_\git\_app_\target\classes\com\company\project\domain</JavaBeansClassPath>
   
   This folder contains my compiled java classes ie. person.java > person.class
4. Opened CR 2013 (trial version) expecting to see the java beans classes populated but it's still blank.

Additionally, I also tried right clicking my request.java file > export > jar and added the request.jar file to my <JavaBeansClassPath>.. Did not work.

I see this int he drop down menu JavaServerType=JavaBeans JavaBeanName= but I receive "unknown database connector error error details: [database vendor code: 7171939]"

My java class implements serializable and contains a builder pattern

Has anyone ran into this issue?

[Former Member · Accepted solution]

Resolved...

I should have read the Java Beans Connectivity pdf more carefully. Crystal Reports Designer expects to see a method return a ResultSet.

It does not work like CR4E where you can simply right click the class and add a POJO to a new report.

Using the com.businessobjects.samples.pojo.* pojo api provided by SAP this worked..

public class MonsterService {

  public ResultSet getAllMonsters() {

  List<Monster> monsters = new ArrayList<Monster>();

  monsters.add(new Monster("Bill", 3l, true));

  monsters.add(new Monster("Ralph", 5l, false));

  monsters.add(new Monster("Cory", null, true));

  monsters.add(new Monster("Stan", 3l, false));

  monsters.add(new Monster("Steve", 5l, false));

  POJOResultSet resultSet = getResultSet(monsters);

  return resultSet;

  }

  private POJOResultSet getResultSet(List<Monster> monsters)

  throws POJOException {

  POJOResultSetFactory factory = new POJOResultSetFactory(

  Monster.class);

  POJOResultSet resultSet = factory.createResultSet(monsters);

  return resultSet;

  }

}