Underneath The Covers

Post date: Jun 27, 2011 7:2:59 PM

SMCP uses the MySQL database engine to store and manage it's data, and the program uses internal SQL statements for selecting, inserting, and updating records.  Each company uses a single database with several dozen constituent tables.

Program code is written in the Java programming language, use java servlets running on Apache-Tomcat web servers.  In most cases, pages are created dynamically and use plain-vanilla HTML formatting, with very little scripting.  Exceptions are the 'date pickers' and a few cases where focus is set to initial fields on some screens.

Data connections are managed in a pool - when a new connection is called for in the program, the pool is checked for free connections, if one isn't available, a new connection is added to the pool, used, then left available in the pool.  The number of data connections is limited; normally there are more than enough, but if a crash, for example, causes connections to be requested in an endless loop, the program will throw an error.

Connections can be viewed, killed, and initiated using the 'Global Connection Status' function in SMCP.