Doorgaan naar hoofdcontent

Posts

Posts uit augustus, 2010 tonen

Cordys BOP4: Database connector

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