Hi Sahuly,
I'll try to answer your question about transactions and the JDBC control.
In the code you posted, the JDBC control will acquire a connection the
first time it is used in a page flow action. So in the case of the
addUserInfo() action, the following line will cause the control to
acquire a JDBC connection:
userControl.addUserInfo(userDTO.getUserName(),userDTO.getAge());
The JDBC control will hold the connection until the addUserInfo()
action is no longer on the call stack, then the connection will be
released.
If you want to wrap the connection in a transaction, you can use the
JDBC system control's getConnection() API. You could make this the
first line of your addUserInfo() action:
java.sql.Connection conn = userControl.getConnection();
Once you have the connection you can then use JTA to start a
transaction and either commit or roll it back after you have completed
the work for the transaction.
If you are not getting forwarded from this action there must be an
exception during the call to the JDBC control. Have you seen anything
in your server logs?
- Chad
On 1/17/07, sahuly <[EMAIL PROTECTED]> wrote:
hai,
I am telling my problem in the below program in the bold letters
please some one tell me a solution for this....
Controller class:-----------------------
@Jpf.Controller (
simpleActions = {
@Jpf.SimpleAction(name = "begin", path =
"/com/ofs/jdbccontrol/beehive/pageflow/index.jsp")
},
sharedFlowRefs = {
@Jpf.SharedFlowRef(name = "shared" , type =
com.ofs.jdbccontrol.beehive.sharedflow.SharedFlow.class)
}
)
public class Controller
extends PageFlowController {
@Control()
private UserBOControl userControl;
public UserDTO[] getUser;
@Jpf.Action (
forwards = {
@Jpf.Forward(name = "success", path = "index.jsp"),
@Jpf.Forward(name = "failure", path =
"/com/ofs/jdbccontrol/beehive/pageflow/error.jsp")
}
)
public Forward addUserInfo(UserDTO userDTO) {
try {
userControl.addUserInfo(userDTO.getUserName(),
userDTO.getAge());
------> This statement is not executed i.e control is not returned back to
here ...my webpage idle but data is
getting inserted into the DB...
------> at the same time i dont know whether connection is released or not
and also
don't know where to maintain the transaction and how??????????????
return new Forward("success");
} catch (Exception e) {
e.printStackTrace(System.err);
}
return new Forward("success");
}
@Jpf.Action (
forwards = {
@Jpf.Forward(name = "success", path =
"/com/ofs/jdbccontrol/beehive/pageflow/listUser.jsp"),
@Jpf.Forward(name = "failure", path =
"/com/ofs/jdbccontrol/beehive/pageflow/error.jsp")
}
)
public Forward getUserInfo() {
Forward fwd = new Forward("success");
try {
getUser = userControl.getUserInfo("sachin");
fwd.addActionOutput("list", getUser);
} catch (Exception e) {
e.printStackTrace(System.err);
return new Forward("failure");
}
return fwd;
}
}
UserBOControl class :----------
@org.apache.beehive.controls.api.bean.ControlExtension
@JdbcControl.ConnectionDriver(
databaseDriverClass = "oracle.jdbc.driver.OracleDriver",
databaseURL = "jdbc:oracle:thin:@192.54.45.251:1521:ORCL",
userName = "t01",
password = "t012006"
)
public interface UserBOControl
extends JdbcControl {
@JdbcControl.SQL(statement = "INSERT into useraccess values({userName},
{age})")
public void addUserInfo(String userName, int age)
throws SQLException;
@JdbcControl.SQL(statement = "SELECT * FROM userinfo WHERE userName =
{name}")
public UserDTO[] getUserInfo(String name)
throws SQLException;
}
thanks in advance
Regards,
sahuly
--
View this message in context:
http://www.nabble.com/JDBC-Control-tf3025805.html#a8406106
Sent from the Beehive - User mailing list archive at Nabble.com.
