Architect Consultant blog

When i installed Cordys Bop4.2 CU1 i ran into two problems which i wanted to share with you. My environment: Windows Server 8 R2, MySql 5.5, Java 1.7 I followed the installation documentation of Cordys:  https://wiki.cordys.com/display/bop42/Cordys+BOP+4.2+Documentation I was able to install CARS without any problems. The I installed BOP with default configurations. I had a clean database, so I let Cordys create the database, but then the installation failed with a "Could not execute database scripts". I contacted Cordys and this appeared to be a known bug. You have to create the database schema first: CREATE DATABASE %CordysDatabase% DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci; GRANT ALL ON Cordys.* TO root IDENTIFIED BY '%password%'; So happy that this worked, I installed it again and it went fine. Until the base packages had to be installed. It failed with a NULL pointer exception with an error message I did not understand.  It turned...

Introduction Just like any other Enterprise Service Bus, Cordys BOP4 also has connectors like file, ftp, mail and database. This blog item shows how a database connector is configured within the product. Note: Within a Service Oriented Architecture that must be flexible and product independant I would advise not to use product specific database connectors. I would recommend to implement an abstraction layer around the database with for instance Hibernate and expose it as a webservice. Ws-AppServer Within the Cordys BOP4 platform a database connector is implemented with a so-called Ws-AppServer. This is a java layer between the database and can be used to implement some business logic and/or the place to react on database events. For this example I have used a MySql database instance (Test) with an Employee table. DROP TABLE IF EXISTS test.Employee; CREATE TABLE test.Employee ( EmployeeNumber varchar(255) NOT NULL DEFAULT '', FirstName varchar(255) NOT NULL DEFAU...

Edwin Biemond wrote a great post on using the DB Adapter within OSB 10.3.1. You can find his article here and I followed the steps nicely. However I did not get it working. I made a mistake by giving the connection factory the same JNDI name as the JDBC Data Source! So please be aware of the JNDI traps.