Deleting a bad changelog in Liquibase

1 – Identify the change set you need to remove (to run again) <changeSet author=“me” id=“2.1.0-x-table”> <sqlFile path=“/mycustomsql.sql” relativeToChangelogFile=“false” stripComments=“true” /> </changeSet> 2 – As your db instance owner, remove the change log entry [db2inst1@db myfolder]$ db2 “DELETE from myschema.DATABASECHANGELOG WHERE ID = ‘2.1.0-x-table’” DB20000I The SQL command completed successfully. 3 – Confirm the change […]

Automating Integration Tests with WebSphere Liberty and Maven

I spent some hours to figure out how to deploy my webapp to the Liberty from my Maven project. I looked into the feature restConnector-1.0 . restConnector provides a REST based JMX MBeans interface to WebSphere Liberty.  You add  <feature>restConnector-1.0</feature> to your server, and make sure you have a user set in the admin role. […]

JAX-RS Mapping All ClientExceptions with ExceptionMappers

As many of you know, I have been working with JAX-RS and WebSphere Liberty for a few years now. Somehow, after this time has passed, I still seem to uncover new JAX-RS capabilities. For those familiar with JAX-RS, you know it generates some funky errors. I wanted to control the data in the response. I […]

Mysterious Entry in my Swagger Doc

Recently, I’ve been working with Swagger to document my team’s APIs, and had a mysterious entry popup (default/entity). It looks something like this: I threw some tracing into action: (io.swagger.*=ALL:*=INFO) [6/7/16 7:51:24:912 EDT] 00000039 id= io.swagger.jaxrs.utils.ReaderUtils < collectParameters Exit [] [6/7/16 7:51:24:912 EDT] 00000039 id= io.swagger.jaxrs.utils.ReaderUtils < collectFieldParameters Exit [] [6/7/16 7:51:24:912 EDT] 00000039 id= […]

Localized Maven Repositories – A Hot Tip

I’ve been building a Maven Project that uses some jar files which are not in Maven Central (or any repository). I ran across this article – Local Maven Dependencies. I found it very helpful. Simply, do the following: create a directory (d:/folder/repo) Run a maven deploy to url (it’ll create the repository details based on […]

IBM Integration Broker with ODBC and ESQL

To setup ODBC bridge from IBM Integration Broker to DB2, download and install the ODBC bridge from the IBM Data Server Runtime Clients.  It’s a 1.3 G download, and you only need about a 40M file for your system. The installation is straight foward.  Be prepared to click Next, and Finish. Setup the ODBC bridge […]

IBM Integration Broker – Setting up DB2 JDBC Access

I have been working IBM Integration Broker I found it hard to find concise documentation (read as fast) on setting up/creating a new provider mqsicreateconfigurableservice TESTNODE_cheetah -c JDBCProviders -o DB2Two -n connectionUrlFormat -v “jdbc:db2://[serverName]:[portNumber]/[databaseName]:user=[user];password=[password];” mqsisetdbparms TESTNODE_cheetah -n jdbc::employeeIdentity -u db2admin -p passw0rd1940! mqsichangeproperties TESTNODE_cheetah -c JDBCProviders -o DB2Two -n securityIdentity -v employeeIdentity mqsichangeproperties TESTNODE_cheetah […]

Maven Tips

Here are some tips for Maven Java Projects in Eclipse. #1 If you pom.xml is missing maven-compiler-plugin, Eclipse (when you do Maven > Update Project), defaults the compiler level for the project to 1.5. <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>2.0.2</version> <configuration> <source>1.7</source> <target>1.7</target> </configuration> </plugin> Now, it gets even more tricky… if your project has defined features […]