I follow JBoss documentation and setup JBoss 2.4.1 and SQLServerPool (see below). In ejb-jar.xml, I set the value of trans-attribute to "Required". When I run the java code (see below), it seems that the record is inserted successfully. However, when I open the table and the record is not there. Thus, I think the transaction is not committed when the connection is closed (see the JBoss log below). What do I need to do to set the database tranaction right? Please help. Thanks.
SQLServerPool setup:
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
SQLServerPool
jdbc:odbc:odbcname
username
password
true
TRANSACTION_SERIALIZABLE
Java Code:
public boolean insertData()
{
boolean isInserted = true;
Connection conn = null;
Statement stmt = null;
try {
InitialContext context = new InitialContext();
DataSource ds = (DataSource) context.lookup("java:/SQLServerPool");
conn = ds.getConnection();
stmt = conn.createStatement();
String sqlString = "insert into staff(firstname, lastname) values ('Jason', 'Smith')";
int status = stmt.executeUpdate(sqlString);
System.out.println(status);
} catch (NamingException ex) {
System.out.println("NamingException caught when trying to get data source from JNDI");
ex.printStackTrace();
isInserted = false;
} catch (SQLException ex) {
ex.printStackTrace();
isInserted = false;
} catch (Exception ex) {
ex.printStackTrace();
isInserted = false;
} finally {
try {
if (stmt!=null) stmt.close();
if (conn!=null) conn.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}
return isInserted;
}
JBoss Log: [SQLServerPool] No transaction right now.
[SQLServerPool] Pool SQLServerPool [1/1/Unlimited] gave out pooled object: org.j
boss.pool.jdbc.xa.wrapper.XAConnectionImpl@1b42e6
[Default] 1
[Default]
[SQLServerPool] Pool SQLServerPool [0/1/Unlimited] returned object org.jboss.poo
l.jdbc.xa.wrapper.XAConnectionImpl@1b42e6 to the pool.
