To study artificially produced and actively controlled water hammer wave caused by hydraulic vibration exciter, a mathematical model was established and an experimental system was designed to verify it. Through the given partial differential equations, a computer code based on the method of characteristics was developed to calculate transient pressure distributed along the pipe under different rotational frequency of vibration exciter. The numerical simulation indicates that there is a simple harmonic vibration rising at the cross sections along the pipe, corresponding to different excitation pressure at every cross section. In addition, the excitation pressure can also be adjusted by system pressure via overflow valve. So, this work is expected to serve for the optimum design of the hydraulic excitation system and play a theoretical guiding role to experimental research in future.