sql update of existing table
Hello.
I am using Tapestry 5.0.18 framework with Netbeans 6.8, MS Sqlexpress 2005
and using hibernate support for accessing database.
One page is crated for data input. Other one will display data from table.
Input is performed using t:beaneditform and display via t:grid. Whatever
data I enter, it will be successfuly stored in database. Grid component will
display it all. So, this basic part is functioning ok.
Main entity, Class Servis has 3 attributes : servisid, InvNo, Vendor and
Status.
Servisid is generated value:
@Id
@GeneratedValue
private Long servisid;
so it is incremented for every new row and is unique.
To store data after clicking on submit/update in beaneditform, I use the
following code:
@CommitAfter
public Object onSuccess(){
Servis temp = new Servis();
temp.setInvno(servis.getInvno());
temp.setVendor(servis.getVendor());
temp.setStatus(servis.getStatus());
session.save(temp);
return start;
}
I have customized grid component to display additional column which would be
used to change status attribute.
Tml file :
t:grid source=list row=servis add=change
t:parameter name=changeCell
t:actionlink t:id=change context=servis.servisidSet
TRUE/t:actionlink
/t:parameter
/t:grid
Java class. I use following method to display only rows with status = FALSE
public List getList() {
Criteria crit = getSession().createCriteria(Servis.class);
crit.add(Restrictions.eq(status, Status.FALSE));
return crit.list();
}
Now, I want to update value of status by clicking on Set TRUE in grid
component. I tried with several variants like this:
Object onActionFromChange(long id) {
SQLQuery query = getSession().createSQLQuery(UPDATE tblServis SET
status = 'TRUE' WHERE servisid = +id);
query.executeUpdate();
return start;
}
It won't update table. I also get no exception. Clicking on Set TRUE will
drive me to start page. I tested and I definitely get appropriate id from
grid.
Can somebody suggest me what should I do to accomplish table update?
Thanks in advance.
--
View this message in context:
http://old.nabble.com/sql-update-of-existing-table-tp27667156p27667156.html
Sent from the Tapestry - User mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org
For additional commands, e-mail: users-h...@tapestry.apache.org
Re: sql update of existing table
After the update, try calling commit. If you are using
HibernateSessionManager from
http://tapestry.apache.org/tapestry5.1/tapestry-hibernate/
call HibernateSessionManager.commit().
Shing
Home page : http://www.lombok.demon.co.uk/
--- On Sun, 21/2/10, toejoe to...@hotmail.com wrote:
From: toejoe to...@hotmail.com
Subject: sql update of existing table
To: users@tapestry.apache.org
Date: Sunday, 21 February, 2010, 0:44
Hello.
I am using Tapestry 5.0.18 framework with Netbeans 6.8, MS
Sqlexpress 2005
and using hibernate support for accessing database.
One page is crated for data input. Other one will display
data from table.
Input is performed using t:beaneditform and display via
t:grid. Whatever
data I enter, it will be successfuly stored in database.
Grid component will
display it all. So, this basic part is functioning ok.
Main entity, Class Servis has 3 attributes : servisid,
InvNo, Vendor and
Status.
Servisid is generated value:
�...@id
�...@generatedvalue
private Long servisid;
so it is incremented for every new row and is unique.
To store data after clicking on submit/update in
beaneditform, I use the
following code:
@CommitAfter
public Object onSuccess(){
Servis temp = new Servis();
temp.setInvno(servis.getInvno());
temp.setVendor(servis.getVendor());
temp.setStatus(servis.getStatus());
session.save(temp);
return start;
}
I have customized grid component to display additional
column which would be
used to change status attribute.
Tml file :
t:grid source=list
row=servis add=change
t:parameter
name=changeCell
t:actionlink t:id=change
context=servis.servisidSet
TRUE/t:actionlink
/t:parameter
/t:grid
Java class. I use following method to display only rows
with status = FALSE
public List getList() {
Criteria crit =
getSession().createCriteria(Servis.class);
crit.add(Restrictions.eq(status,
Status.FALSE));
return crit.list();
}
Now, I want to update value of status by clicking on Set
TRUE in grid
component. I tried with several variants like this:
Object onActionFromChange(long id) {
SQLQuery query =
getSession().createSQLQuery(UPDATE tblServis SET
status = 'TRUE' WHERE servisid = +id);
query.executeUpdate();
return start;
}
It won't update table. I also get no exception. Clicking on
Set TRUE will
drive me to start page. I tested and I definitely get
appropriate id from
grid.
Can somebody suggest me what should I do to accomplish
table update?
Thanks in advance.
--
View this message in context:
http://old.nabble.com/sql-update-of-existing-table-tp27667156p27667156.html
Sent from the Tapestry - User mailing list archive at
Nabble.com.
-
To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org
For additional commands, e-mail: users-h...@tapestry.apache.org
-
To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org
For additional commands, e-mail: users-h...@tapestry.apache.org
Re: sql update of existing table
Thank You for quick reply. I followed Your advice and added annotation
@CommitAfter. It is working now.
Shing Hing Man wrote:
After the update, try calling commit. If you are using
HibernateSessionManager from
http://tapestry.apache.org/tapestry5.1/tapestry-hibernate/
call HibernateSessionManager.commit().
Shing
Home page : http://www.lombok.demon.co.uk/
--- On Sun, 21/2/10, toejoe to...@hotmail.com wrote:
From: toejoe to...@hotmail.com
Subject: sql update of existing table
To: users@tapestry.apache.org
Date: Sunday, 21 February, 2010, 0:44
Hello.
I am using Tapestry 5.0.18 framework with Netbeans 6.8, MS
Sqlexpress 2005
and using hibernate support for accessing database.
One page is crated for data input. Other one will display
data from table.
Input is performed using t:beaneditform and display via
t:grid. Whatever
data I enter, it will be successfuly stored in database.
Grid component will
display it all. So, this basic part is functioning ok.
Main entity, Class Servis has 3 attributes : servisid,
InvNo, Vendor and
Status.
Servisid is generated value:
�...@id
�...@generatedvalue
private Long servisid;
so it is incremented for every new row and is unique.
To store data after clicking on submit/update in
beaneditform, I use the
following code:
@CommitAfter
public Object onSuccess(){
Servis temp = new Servis();
temp.setInvno(servis.getInvno());
temp.setVendor(servis.getVendor());
temp.setStatus(servis.getStatus());
session.save(temp);
return start;
}
I have customized grid component to display additional
column which would be
used to change status attribute.
Tml file :
t:grid source=list
row=servis add=change
t:parameter
name=changeCell
t:actionlink t:id=change
context=servis.servisidSet
TRUE/t:actionlink
/t:parameter
/t:grid
Java class. I use following method to display only rows
with status = FALSE
public List getList() {
Criteria crit =
getSession().createCriteria(Servis.class);
crit.add(Restrictions.eq(status,
Status.FALSE));
return crit.list();
}
Now, I want to update value of status by clicking on Set
TRUE in grid
component. I tried with several variants like this:
Object onActionFromChange(long id) {
SQLQuery query =
getSession().createSQLQuery(UPDATE tblServis SET
status = 'TRUE' WHERE servisid = +id);
query.executeUpdate();
return start;
}
It won't update table. I also get no exception. Clicking on
Set TRUE will
drive me to start page. I tested and I definitely get
appropriate id from
grid.
Can somebody suggest me what should I do to accomplish
table update?
Thanks in advance.
--
View this message in context:
http://old.nabble.com/sql-update-of-existing-table-tp27667156p27667156.html
Sent from the Tapestry - User mailing list archive at
Nabble.com.
-
To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org
For additional commands, e-mail: users-h...@tapestry.apache.org
-
To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org
For additional commands, e-mail: users-h...@tapestry.apache.org
--
View this message in context:
http://old.nabble.com/sql-update-of-existing-table-tp27667156p27670925.html
Sent from the Tapestry - User mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org
For additional commands, e-mail: users-h...@tapestry.apache.org
