Solaris: How To Download File In Command Prompt

wget command is used to download files in unix based operating systems. But in Solaris the command does not seem to exist:

# wget
wget: not found

Actually it exists in the file system. But it just isn't added into PATH by default. The location of command is /usr/sfw/bin/wget. Following is a usage example of wget in Solaris.

# /usr/sfw/bin/wget google.com
--2010-10-08 11:15:20--  http://google.com/
Resolving google.com... 74.125.87.99, 74.125.87.104
Connecting to google.com|74.125.87.99|:80... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: http://www.google.com/ [following]
--2010-10-08 11:15:20--  http://www.google.com/
Resolving www.google.com... 74.125.87.104, 74.125.87.99
Reusing existing connection to google.com:80.
HTTP request sent, awaiting response... 302 Found
Location: http://www.google.com.tr/ [following]
--2010-10-08 11:15:20--  http://www.google.com.tr/
Resolving www.google.com.tr... 74.125.87.104, 74.125.87.99
Reusing existing connection to google.com:80.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: `index.html.2'

    [ <=>                                                                                       ] 9,005       --.-K/s   in 0.01s  

2010-10-08 11:15:20 (685 KB/s) - `index.html.2' saved [9005]

Use DbUnit With Maven

dbunit is a useful tool for populating test data into databases on the fly.
It is also useful to use this tool to populate application configuration information.
This article demonstrates how to use dbunit with maven.

We require jdbc drivers for our database. Assuming we are using oracle, dbunit plugin's dependency configuration will be as follows:

<dependency>
   <groupId>com.oracle</groupId>
   <artifactId>ojdbc14</artifactId>
   <version>10.2.0.2.0</version> 
</dependency>
                  
We also need connection information for our database. We'll use following connection information in our dbunit configuration:

host: jdbc:oracle:thin:@localhost:1521:XE
username: hr
password: hr
driver: oracle.jdbc.driver.OracleDriver

Putting it all together, following is an example configuration for dbunit:

<plugin>
    <groupId>org.codehaus.mojo</groupId>
    <artifactId>dbunit-maven-plugin</artifactId>
    <version>1.0-beta-3</version>
    <configuration>
        <dataTypeFactoryName>org.dbunit.ext.oracle.OracleDataTypeFactory</dataTypeFactoryName>
        <driver>oracle.jdbc.driver.OracleDriver</driver>
        <username>hr</username>
        <password>hr</password>
        <url>jdbc:oracle:thin:@localhost:1521:XE</url>
        <src>src/test/resources/sample-data.xml</src>
        <type>CLEAN_INSERT</type>
        <schema>HR</schema>
        <skip>${skipTests}</skip>
        <transaction>true</transaction>
    </configuration>
    <dependencies>
        <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc14</artifactId>
            <version>10.2.0.2.0</version>
        </dependency>
    </dependencies>
</plugin>

Based on this configuration, our dataset file resides in src/test/resources/sample-data.xml file. This file contains our test data. Execute following command to persist the data inside sample-data.xml into the database.

> mvn dbunit:operation

Yet, we don't know how to prepare and/or what to put inside sample-data.xml. If you have a ready to use database, you may not need to prepare sample-data.xml file from scratch. There is another command to export database tables into a dataset file.

> mvn dbunit:export

Upon invoking this command, a new file will be generated under target/dbunit/export.xml which will contain all your test data. You can, later, use this file to reinitialize your test database using "mvn dbunit:operation" command.

Additional Resources:

Maven DBUnit Plugin Homepage:
http://mojo.codehaus.org/dbunit-maven-plugin

DBUnit Getting Started Guide:
http://www.dbunit.org/howto.html


DBUnit Best Practices:
http://www.dbunit.org/bestpractices.html