8:00 – 12:30 CSIP

• Started the day trying to hook up hibernate to the information_instance.TABLES table and got the following error:
• 
• This is attempting to use the following class

  package com.sample.information_schema;
  
  import java.math.BigInteger;
  import java.util.Date;
  
  import javax.persistence.Column;
  import javax.persistence.Entity;
  import javax.persistence.Table;
  import javax.persistence.Temporal;
  import javax.persistence.TemporalType;
  
  @Entity
  @Table(name = "TABLES")
  public class TableMySql {
  	@Column(name = "version")
  	private BigInteger version;
  
  	@Column(name = "table_rows")
  	private BigInteger table_rows;
  
  	@Column(name = "avg_row_length")
  	private BigInteger avg_row_length;
  
  	@Column(name = "data_length")
  	private BigInteger data_length;
  
  	@Column(name = "max_data_length")
  	private BigInteger max_data_length;
  
  	@Column(name = "index_length")
  	private BigInteger index_length;
  
  	@Column(name = "data_free")
  	private BigInteger data_free;
  
  	@Column(name = "auto_increment")
  	private BigInteger auto_increment;
  
  	@Column(name = "checksum")
  	private BigInteger checksum;
  
  	@Temporal(TemporalType.DATE)
  	@Column(name = "create_time")
  	private Date create_time;
  
  	@Temporal(TemporalType.DATE)
  	@Column(name = "update_time")
  	private Date update_time;
  
  	@Temporal(TemporalType.DATE)
  	@Column(name = "check_time")
  	private Date check_time;
  
  	@Column(name = "table_catalog")
  	private String table_catalog;
  
  	@Column(name = "table_schema")
  	private String table_schema;
  
  	@Column(name = "table_name")
  	private String table_name;
  
  	@Column(name = "table_type")
  	private String table_type;
  
  	@Column(name = "engine")
  	private String engine;
  
  	@Column(name = "row_format")
  	private String row_format;
  
  	@Column(name = "table_collation")
  	private String table_collation;
  
  	@Column(name = "create_options")
  	private String create_options;
  
  	@Column(name = "table_comment")
  	private String table_comment;
  
  	public BigInteger getVersion() {
  		return version;
  	}
  
  	public BigInteger getTable_rows() {
  		return table_rows;
  	}
  
  	public BigInteger getAvg_row_length() {
  		return avg_row_length;
  	}
  
  	public BigInteger getData_length() {
  		return data_length;
  	}
  
  	public BigInteger getMax_data_length() {
  		return max_data_length;
  	}
  
  	public BigInteger getIndex_length() {
  		return index_length;
  	}
  
  	public BigInteger getData_free() {
  		return data_free;
  	}
  
  	public BigInteger getAuto_increment() {
  		return auto_increment;
  	}
  
  	public BigInteger getChecksum() {
  		return checksum;
  	}
  
  	public Date getCreate_time() {
  		return create_time;
  	}
  
  	public Date getUpdate_time() {
  		return update_time;
  	}
  
  	public Date getCheck_time() {
  		return check_time;
  	}
  
  	public String getTable_catalog() {
  		return table_catalog;
  	}
  
  	public String getTable_schema() {
  		return table_schema;
  	}
  
  	public String getTable_name() {
  		return table_name;
  	}
  
  	public String getTable_type() {
  		return table_type;
  	}
  
  	public String getEngine() {
  		return engine;
  	}
  
  	public String getRow_format() {
  		return row_format;
  	}
  
  	public String getTable_collation() {
  		return table_collation;
  	}
  
  	public String getCreate_options() {
  		return create_options;
  	}
  
  	public String getTable_comment() {
  		return table_comment;
  	}
  }

• to talk to hibernate using the following configuration 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 name="MySqlInformationSchema">
  <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/information_schema</property>
  <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
  <property name="hibernate.connection.password">edge</property>
  <property name="hibernate.connection.username">root</property>
  <property name="hibernate.default_schema">information_schema</property>
  <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
  <property name="hbm2ddl.auto">update</property>
  <property name="show_sql">true</property>
  <property name="connection.pool_size">1</property>
  
  <!-- List all the annotated classes we're using -->
  <mapping class="com.sample.information_schema.tableMySql"/>
  
  </session-factory>
  </hibernate-configuration>

• Well, connecting to the db with jdbc instead of running through Hibernate got things up to speed quite quickly. I am running arbitrary queries against the databases (including information_schema, which Hibernate chokes on). The results are wrapped in objects that rules can be run against.
•  Handle what happens when a null is returned by WrappedMap.getObjectByName().
• Determine primitive type and handle accordingly
• Looks like my ability to charge the CSIP contract ran out on the 9th. Need to figure out what to do with the 12 hours I charged since then. Jim is working on it. Ok. Charge half of today and all of yesterday and stop.

12:30 – 4:30 FP

• Worked on paper, then lost the ability to scroll past page one. Going to try this at home…

7:00 – 9:30 FP

• Finished incorporating paper changes and sent back to Dr. Kuber.

8:00 – 4:00 CSIP

• Working on building a Drools test case structured around wrapped Maps.
• Built the wrapped objects and Maps, and have the sandbox created
• And here’s how you do it. Probably not as efficient as it could be, but pretty general case.

  #created on: Apr 11, 2012
  package com.sample
  
  #list any import classes here.
  import com.sample.WrappedObject;
  import com.sample.WrappedMap;
  
  #declare any global variables here
  
  dialect "java"
  
  rule "rule Floats less than six"
  
      when
  
          WrappedMap($wo:getObjectByName("myFloat")) // condition
          eval($wo.NumericLessThan(6))
      then
          System.out.println("n--------------------------------n"+$wo.toString());
  
  end

• Need to add some methods for handling String compares and for other types of objects
• Working on getting Hibernate to talk to information_schema in mySql. I’m trying to use the eclipse tools, and I get this error:
• 
• Stopping for the day. Will talk to Dong about this tomorrow.

8:00 – 4:30 CSIP

• Now that I have my Hibernate Eclipse plugins working, back to chapter 9.
• Well, the plugins work fine, but when I tried to add an element to a query, the build broke and I was unable to get it to work again, even after restoring to the earliest version. Went on to chapter 12, but the DB appears to broken there too.
• According to Dong, this is because the HSQL instance is not persisted in the test, so all the data drops out. Switching the dialect to MySQL, which runs as a service on my box fixed all problems but one – an exception that said the DB couldn’t be reached. Which was odd, because it was accessed and the tables were created and populated. Go figure.
• Talked to Mike about his experience with dynamic object creation using Hibernate. It looks pretty straightforward, as long as you have a ‘generic’ object that is wrapped around Map(s) (Collections?) of some kind. Now I need to see if I can build a Drools engine that will reason over elements in a collection contained in an object.

8:00 – 3:30 CSIP

• Hibernate chapter 6
• Chapter 7. Learning about annotations like all the other cool kids. Done. Chapter 8 on Monday.

8:00 – 4:00 CSIP

• Hibernate Chapter 3. Working on getting to chapter 8, which covers dynamic creation. “Chapter 8 discusses criteria queries, an interesting mechanism that lets you express the constraints on the entities you want, using a natural Java API. This lets you build Java objects to represent the data you want to find, which is easier for people who aren’t database experts to understand; lets you leverage your IDE’s code completion as a memory aid; and even gives you compile-time checking of your syntax. It also supports a form of “query by example,” where you can supply objects that are similar to the ones you’re searching for, which is particularly handy for implementing search interfaces in an application.“
• Chapter 4
• Tried to change a query from foo = :upper(mySearchTerm) to foo like ‘%upper(mySearchTerm)%’ and failed completely. Dong suggested restrictions, but I don’t see how to do that in the hbm.xml <![CDATA[…]]> section.
• Chapter 5
• Chapter 6

8:00 – 4:30 CSIP

• Taking a small detour into Hibernate, to see if that can create a Java Object that Drools can operate on.
• Some relevant articles from 2008-2009, also here
• Installing hibernate eclipse plugins from here. Well I thought I was. It appears there is a conflict with Ant. Which is funny, because the book “Harnessing Hibernate” has all their examples built with Ant. It is to laugh.
• Hmm. Ant using Maven is kind of nice. Definitely more explicitly clear. it depends on maven-ant-tasks-2.0.6.jar that needs to reside in the Ant library. And if you add a link to that library as an external jar in the Ant preferences in Eclipse, it seems to work quite well.
• Well, not quite. The 2.0.6 jar only points to the default .m2/repository. You need the 2.1.3 jar if you want that to work. And that took 2 hours. Grr. Somebody should update the Safari book code repository.
• Chapter 1
• Chapter 2
• Chapter 3

8:00 – 1:30, 3:30 -6:00  CSIP

• Ok ,now that we have working(?) code, I have something to walk through while reading the book.
• The Drools team suggests that you use the joda DateTime library. It looks pretty nice, too – http://joda-time.sourceforge.net/. They also have a bunch of other interesting libraries at http://joda.sourceforge.net/
• Setting a global value in a rule
• Java

  // Import the class
  import droolsbook.bank.service.BankingInquiryService;
  
  // create the session
  static StatelessKnowledgeSession session;
  
  // create rule engine
  KnowledgeBaseConfiguration configuration = KnowledgeBaseFactory.newKnowledgeBaseConfiguration();
  KnowledgeBase knowledgeBase = KnowledgeBaseFactory.newKnowledgeBase(configuration);
  
  // declare our global
  BankingInquiryService inquiryService = new BankingInquiryServiceImpl();
  
  // make a session
  session = knowledgeBase.newStatelessKnowledgeSession();
  
  // add the global to the session
  session.setGlobal("inquiryService", inquiryService);

• Drools rule (.drl file)

  // import
  import droolsbook.bank.service.*;
  
  // declare
  global BankingInquiryService inquiryService;
  
  // use the global in a rule (note the surrounding eval(), which can evaluate any code that returns a TRUE or FALSE).
  rule "accountNumberUnique"
      when
          $account : Account(eval(!inquiryService.isAccountNumberUnique($account)))
      then
          error(kcontext, $account);
  end

• Chapter 4
• Hmm. com.ibatis.sqlmap.client.SqlMapClient looks interesting.
• After poking around, I think I found something better. Castor appears to do XML/SQL/other(?) data binding with Java. IBM appears to have a nice set of articles.
• And Hibernate may now be able to do this as well.
• Nice data visualization using webGL
• 

8:00 – 5:00 CSIP

• Went to the customer site to fill out paperwork
• Proceeding somewhat blindly is a somewhat Droolsy direction. Documentation is pretty sucky.
• Thinking about how to use rules against a database. This might require the creation of Java classes that have the structure of the table. It’s possible that this could be done with reflection, which I haven’t used since TUMMS. Here’s the Java trail just in case: http://docs.oracle.com/javase/tutorial/reflect/
• Found the source for the book: http://code.google.com/p/droolsbook/
• Reindexing maven repositories…
• had to add the following to the droolsBookParent/pom.xml in the <dependencyManagement><dependecies> section

  <dependency>
  <groupId>org.slf4j</groupId>
  <artifactId>jcl-over-slf4j</artifactId>
  <version>1.6.0</version>
  </dependency>

• had to add the JDK to the JRE section of Eclipse Java properties. It was overriding JAVA_HOME
• Better. Maybe even good enough. The banking example is working:

  [INFO] Reactor Summary:
  [INFO]
  [INFO] Drools Book Parent ................................ SUCCESS [0.694s]
  [INFO] Banking Core ...................................... SUCCESS [3.705s]
  [INFO] Validation ........................................ SUCCESS [7.324s]
  [INFO] ETL with iBatis ................................... SUCCESS [12.815s]
  [INFO] DSL ............................................... FAILURE [4.146s]
  [INFO] Decision Tables ................................... SKIPPED
  [INFO] Ruleflow .......................................... SKIPPED
  [INFO] Stateful Rules .................................... SKIPPED
  [INFO] Complex Event Processing .......................... SKIPPED
  [INFO] Drools Flow ....................................... SKIPPED
  [INFO] Testing ........................................... SKIPPED
  [INFO] Integration ....................................... SKIPPED
  [INFO] Performance ....................................... SKIPPED
  [INFO] Sample Application ................................ SKIPPED
  [INFO] ------------------------------------------------------------------------
  [INFO] BUILD FAILURE
  [INFO] ------------------------------------------------------------------------
  [INFO] Total time: 29.097s
  [INFO] Finished at: Mon Apr 02 16:58:52 EDT 2012
  [INFO] Final Memory: 32M/199M

  [ERROR] Failed to execute goal on project dsl: Could not resolve dependencies for project droolsbook:dsl:jar:1.1-SNAPSHOT: The following artifacts could not be resolved: droolsbook:etl_iBatis:jar:tests:1.1-SNAPSHOT, droolsbook:validation:jar:tests:1.1-SNAPSHOT: Failure to find droolsbook:etl_iBatis:jar:tests:1.1-SNAPSHOT in http://www.fgmdev.com:8081/nexus/content/groups/public/ was cached in the local repository, resolution will not be reattempted until the update interval of corprepo has elapsed or updates are forced -> [Help 1]