how do you handle connection pooling? I don't understand how to open and close connection, or reconnect.
I've referenced the manual here, but where does this go:
The <connection> element
<connection port="6136" max="100" />
The <connection> element specifies how clients can connect to the server:
The port attribute specifies a TPC port on which the server is listening for new connections. Usually the default port 6136 should be specified. If another port is specified it also has to be specified by clients in the url connection string when connecting to the database (as explained in the JPA Overview section in chapter 3).
The max attribute specifies the maximum number of simultaneous connections that are accepted by the server. A request for a connection that exceeds the maximum is blocked until another open connection is closed.