Entering this for external customer from the Sun Developer Expert Assistance 
program:

The customer is following tutorial on Storing data with the BPEL 2.0 process.
https://open-esb.dev.java.net/60mintutorial/exercise2.html

However, customer continue to get Errors when he tried to run both the Insert & Select Test Cases, which both returns an
ERROR :Reason: No value specified for parameter 1 SQLState: 07001 ErrorCode: 0
 
Created a MySQL Database called SelfServiceTicket with the Schema ( See SQL Folder of BPEL )  of...
 
CREATE DATABASE `selfserviceticket` /*!40100 DEFAULT CHARACTER SET latin1 */;
DROP TABLE IF EXISTS `selfserviceticket`.`users`;
CREATE TABLE  `selfserviceticket`.`users` (
  `UserID` int(11) NOT NULL,
  `UserEmail` varchar(50) NOT NULL,
  `UserName` varchar(50) NOT NULL,
  `Password` varchar(50) DEFAULT NULL,
  `UserType` varchar(50) NOT NULL,
  `UserAccount` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`UserID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
Configured  the Connection Pool and JINI Name ( jdbc/mysqlSelfServiceTicket ) on Glassfish.
 
Deployed the CASA project and ran the 2 TestCases ( See CASA Project ) and got both returns an ERROR :
Reason: No value specified for parameter 1 SQLState: 07001 ErrorCode: 0
 
Note: same Error for both MySQL & Microsoft SQL Server 2005.

Attached the Project and Server Log file.