jdbcConnection

Top  Previous  Next

  <jdbcConnection name="SuperStore">
    <jndids></jndids>
    <driver>org.gjt.mm.mysql.Driver</driver>
    <dburl>jdbc:mysql://localhost:3306/superstore</dburl>
    <user>root</user>
    <password>mmsa</password>
    <autoCommit>true</autoCommit>
    <firstSQL></firstSQL>
    <lastSQL></lastSQL>
  </jdbcConnection>

 

Parameters

Parameter

MScript

Description

jndids

ü

The name of the JNDI data source name

driver

ü

The name of the JDBC driver class

dburl

ü

Database connection url string

user

ü

The name of a data base user with a sufficient authority.

password

ü

The password of the data base user.

autoCommit

ü

Flag to set auto commit to on (true) of off (false).

firstSQL

ü

The first SQL statement to be executed as soon as the connection is established

lastSQL

ü

The last SQL statement to be executed before the connection is closed