Is it possible to write some custom SQL for a CMP Bean?
Something along the lines of:
public void setCompanyStakeholders (ArrayList a,
long firstIdBlockNum)
throws RemoteException
{
final String query = "INSERT INTO Stakeholder (id, companyId,
firstName, lastName, email, dateCreated, lastModified, createdBy,
mimeTypePreference, modifiedBy, source, neverContact, validEmail,
optIntype, optInVerification) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)";
Connection connection = null;
PreparedStatement prepStmt = null;
try {
connection = this.dataSource.getConnection();
prepStmt = connection.prepareStatement (query);
long id = firstIdBlockNum;
int size = a.size();
for (int i = 0; i < size; i++) {
StakeholderData data = (StakeholderData) a.get (i);
Timestamp timestamp = JDBCHelper.getTimestamp();
id = id++;
prepStmt.setLong (1, id);
prepStmt.setLong (2, data.companyId);
prepStmt.setString (3, data.firstName);
prepStmt.setString (4, data.lastName);
prepStmt.setString (5, data.email);
prepStmt.setTimestamp (6, timestamp);
prepStmt.setTimestamp (7, timestamp);
prepStmt.setString (8, data.createdBy);
prepStmt.setString (9, data.mimeTypePreference);
prepStmt.setString (10, data.modifiedBy);
prepStmt.setString (11, data.source);
prepStmt.setBoolean (12, data.neverContact);
prepStmt.setBoolean (13, data.validEmail);
prepStmt.setInt (14, data.optInType);
prepStmt.setInt (15, data.optInVerification);
prepStmt.executeUpdate();
prepStmt.clearParameters();
Log.debug (this, "setCompanyStakeholders: " + data.email);
}
etc.... ???
I don't think it would be possible since I tried deploying this and got
the following back:
[Container factory] org.jboss.ejb.DeploymentException: CAMS not bound
[Container factory] at
org.jboss.ejb.plugins.jaws.metadata.JawsApplicationMetaData.init(JawsApplicationMetaData.java:120)
[Container factory] at
org.jboss.ejb.plugins.jaws.metadata.JawsXmlFileLoader.load(JawsXmlFileLoader.java:75)
[Container factory] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommandFactory.<init>(JDBCCommandFactory.java:133)
[Container factory] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.init(JAWSPersistenceManager.java:83)
[Container factory] at
org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersistenceManager.java:110)
[Container factory] at
org.jboss.ejb.EntityContainer.init(EntityContainer.java:221)
Note that previous deployments always worked.
--
Nicolai P Guba http://www.gnu.org http://www.frontwire.com
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
GSM: +44 (0)7909 960 751 DDI: +44 (0)20 7368 9708
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
