Enabling the JDBC Driver
In order to use JDBC with the application or application server of your choice you need to configure the application to use the Mimer JDBC Driver. For most applications this means that the application should be started with the JDBC-driver in the classpath, and that the application should be made aware of the Mimer JDBC Class name.
The below sample command line statement starts your application with the correct classpath. If you chose to install Mimer in a non-default directory, you must replace the below path with the directory of your choice.
java -cp "%CLASSPATH%;c:\program files\mimer82 nt\mimjdbc-1_3.jar" MyApp
This is also covered in more detail in the Mimer JDBC User’s Guide, which comes with the product. Also, on this website, see specific instructions on how to enable your tool with Mimer SQL.
Silent Install for Value Added Resellers
Mimer SQL Engine for Windows makes it possible for you to distribute Mimer SQL Engine with your application, you probably want to install Mimer SQL silently with a predefined set of options. However, this is neither within the scope of the free developer license nor this article. Please contact Mimer SQL Support for a license and instructions.
Using the Named Pipes Network Protocol
Using the Microsoft specific Named Pipes protocol has several benefits. Some of the extra features provided the protocol are:
- The protocol takes advantage of the built in Windows NT security system. Clients connecting to a server must be approved by the Windows server security system.
- It makes it possible to automatically login to the database using the NT security system. Clients connecting to the server must be logged on to the Windows NT domain of the server.
- It is slightly faster than TCP on Windows.
Please note that Named Pipes is a Windows specific network protocol. A Mimer SQL server accepting only Names Pipes will only be able to accept connections from Windows clients.
To be able to rely entirely on the Windows NT security system, you may want to deny TCP-connections. You can configure this using the Mimer Administrator, which you will find in the Start-menu. Click the Communication tab to display the settings, for example:
The above example shows the dialog when TCP/IP connections are disabled, but Named Pipes and shared memory communication are enabled.