Configuring spring applications on nonstop systems, Spring framework configurations, Configuring jdbc driver for sql/mx database – HP Integrity NonStop J-Series User Manual
Page 34: Configurations in the jdbc.properties file, Defining jdbc driver class for sql/mx database, Defining the connection url, Establishing the connection, Spring
Configuring Spring Applications on NonStop Systems
This section provides information about configuring Spring applications on NonStop systems. To
configure spring applications, the following configurations are necessary:
•
“NonStop Platform Configurations” (page 320)
•
“Spring Framework Configurations” (page 34)
•
“Module File Caching Configurations” (page 330)
Spring Framework Configurations
This section discusses the following configurations for your Spring applications:
•
“Configuring JDBC Driver for SQL/MX Database” (page 34)
•
“Configuring TmfTransactionManager” (page 36)
JDBC configurations are done in applicationContext.xml and jdbc.properties files.
All the configurations for Transaction Management are configured in applicationContext.xml.
Configuring JDBC Driver for SQL/MX Database
The JDBC driver to be used when a Spring application (using Spring DAO) connects to the SQL/MX
database must be specified in the applicationContext.xml and jdbc.properties file
provided by the Spring framework. You can configure JDBC Type 2 or JDBC Type 4 Driver. The
following configurations are required:
Configurations in the jdbc.properties File
Defining JDBC Driver Class for SQL/MX Database
For Type 2 Driver:
Specify the JDBC Type 2 driver class com.tandem.sqlmx.SQLMXDriver for the SQL/MX
database.
jdbc.driverClassName=com.tandem.sqlmx.SQLMXDriver
For Type 4 Driver:
Specify the JDBC Type 4 driver class com.tandem.t4jdbc.SQLMXDriver for the SQL/MX
database.
jdbc.driverClassName=com.tandem.t4jdbc.SQLMXDriver
Defining the Connection URL
After you have set the JDBC driver, specify the location of the SQL/MX server. For URLs referring
to SQL/MX database, use the jdbc: protocol embedded within the URL. Specify the connection
URL as follows:
For Type 2 Driver:
jdbc.url=jdbc:sqlmx://
For Type 4 Driver:
jdbc.url=jdbc:t4sqlmx://<HP NonStop System IP Address>:<Port No.>
Establishing the Connection
For Type 2 Driver:
Specify the username and password with no values.
jdbc.username=
jdbc.password=
34
Spring Framework