Using Simian with Maven

The Simian documentation is a little brief, so here is how I got Simian integrated into our build.

As we already use Checkstyle, I integrated using the CheckStyle plugin.  Add the following to your Checkstyle xml configuration file, inside the Checker module tag:

<module name="com.harukizaemon.simian.SimianCheck"/>

Then I altered my Checkstyle Maven plugin:

            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-checkstyle-plugin</artifactId>
                <version>2.5</version>
                <dependencies>
                      <dependency>
                        <groupId>com.harukizaemon</groupId>
                        <artifactId>simian</artifactId>
                        <version>2.3.33</version>
                      </dependency>
                </dependencies>
                <configuration>
                    <configLocation>${user.home}/checkstyle.xml</configLocation>
                </configuration>
            </plugin>

Finally I uploaded the Simian jar to our Maven repository.

Simian warnings are now outputted as part of the Checkstyle warnings.

[Note there is a very old Maven 1 Simian plugin kicking around on the internet, but this is unlikely to be of any use to you]

Microsoft SQL Server 2000 Desktop Engine (MSDE) port number

We have to interface with a legacy MSDE database.  I cannot install the database on Windows 7, so for development I installed the database in a VM.  To detect port number:

Run C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe
Select General Tab, highlight TCP/IP, click Properties.. button

Make an exception on the firewall for this port and then, from Windows 7 client connect using Studio Express with the following server name:

tcp:<ip address>,<port number>\<db name>