Hello I work with JBoss + Eclispe + Firebird. I've written a ejbStore procedure like that:
public void ejbStore() { System.out.println("Project enter: ejbStore"); Connection connection = null; PreparedStatement ps = null; try { connection = getConnection(); String select = "update PROJECT set FK_LECTURER_ID = ?,FK_SUBJECT_ID = ?,"+ " PROJECT_DAY = ?,PROJECT_HOUR = ?,CLASS_NUMBER = ?, STUDENTS_IN_GROUP = ?," + " NUMBER_OF_GROUPS = ? where PROJECT_ID = ?"; ps = connection.prepareStatement(select); ps.setInt(1,this.getFk_lecturer_id()); ps.setInt(2,this.getFk_subject_id()); ps.setString(3,this.getProject_day()); ps.setInt(4,this.getProject_hour()); ps.setInt(5,this.getClass_number()); ps.setInt(6,this.getStudents_in_group()); ps.setInt(7,this.getNumber_of_groups()); ps.setInt(8,this.getProject_id()); ps.executeUpdate(); }//try catch (Exception e) { System.out.println("Project wyjatek: ejbStore"); e.printStackTrace(); } finally { try { if (ps != null ) ps.close(); } catch (Exception e) {} try { if (connection != null) connection.close(); } catch (Exception e) {} }//finally System.out.println ("Project exit: ejbStore"); }//ejbStore During testing no exception appears and it seems to work. When I call a get* method after a set* method a new value seems to be stored in the data base. But when I execute a sql query there are no changes in the table. Does anybody know what can be wrong. I think that a problem is somewhere else but I am not sure. One more thing, ejbCreate and ejbRemove method works properly. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3912713#3912713 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3912713 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user