StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POoracle db id column auto generate JPA JSF
text
Body
copied!<p>I have a basic problem with my oracle database table whereas I use JPA.</p> <p>My problem is, I create the table in the database by adding it an ID column. When I turn back to my JPA project, and when I try to create new entry it doesn't create ID for the new one. It always says: An error occurred attempting to roll back the transaction.</p> <p>I search about the issue. It basically doesn't auto-generate the ID value. Here is my JPA controller class:</p> <pre><code>@Entity @Table(name = "PROJECTS", catalog = "", schema = "PROJETAKIP") @XmlRootElement @NamedQueries({ @NamedQuery(name = "Projects.findAll", query = "SELECT p FROM Projects p"), @NamedQuery(name = "Projects.findById", query = "SELECT p FROM Projects p WHERE p.id = :id"), @NamedQuery(name = "Projects.findByProject", query = "SELECT p FROM Projects p WHERE p.project = :project")}) public class Projects implements Serializable { private static final long serialVersionUID = 1L; // @Max(value=?) @Min(value=?)//if you know range of your decimal fields consider using these annotations to enforce field validation @Id @Basic(optional = false) @Column(name = "ID", nullable = false, precision = 0, scale = -127) @GeneratedValue(strategy= GenerationType.SEQUENCE) private BigDecimal id; @Column(name = "PROJECT", length = 255) private String project; public Projects() { } public Projects(BigDecimal id) { this.id = id; } public BigDecimal getId() { return id; } public void setId(BigDecimal id) { this.id = id; } public String getProject() { return project; } public void setProject(String project) { this.project = project; } @Override public int hashCode() { int hash = 0; hash += (id != null ? id.hashCode() : 0); return hash; } @Override public boolean equals(Object object) { // TODO: Warning - this method won't work in the case the id fields are not set if (!(object instanceof Projects)) { return false; } Projects other = (Projects) object; if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id))) { return false; } return true; } @Override public String toString() { return "com.ibb.souce.Projects[ id=" + id + " ]"; } } </code></pre> <p>and here is my JSFClass:</p> <pre><code>@ManagedBean(name = "projectsController") @SessionScoped public class ProjectsController implements Serializable { @Resource private UserTransaction utx = null; @PersistenceUnit(unitName = "DenemelerPU") private EntityManagerFactory emf = null; private Projects current; private DataModel items = null; private ProjectsJpaController jpaController = null; private PaginationHelper pagination; private int selectedItemIndex; public ProjectsController() { } public Projects getSelected() { if (current == null) { current = new Projects(); selectedItemIndex = -1; } return current; } private ProjectsJpaController getJpaController() { if (jpaController == null) { jpaController = new ProjectsJpaController(utx, emf); } return jpaController; } public PaginationHelper getPagination() { if (pagination == null) { pagination = new PaginationHelper(10) { @Override public int getItemsCount() { return getJpaController().getProjectsCount(); } @Override public DataModel createPageDataModel() { return new ListDataModel(getJpaController().findProjectsEntities(getPageSize(), getPageFirstItem())); } }; } return pagination; } public String prepareList() { recreateModel(); return "List"; } public String prepareView() { current = (Projects) getItems().getRowData(); selectedItemIndex = pagination.getPageFirstItem() + getItems().getRowIndex(); return "View"; } public String prepareCreate() { current = new Projects(); selectedItemIndex = -1; return "Create"; } public String create() { try { getJpaController().create(current); JsfUtil.addSuccessMessage(ResourceBundle.getBundle("/Bundle").getString("ProjectsCreated")); return prepareCreate(); } catch (Exception e) { JsfUtil.addErrorMessage(e, ResourceBundle.getBundle("/Bundle").getString("PersistenceErrorOccured")); return null; } } public String prepareEdit() { current = (Projects) getItems().getRowData(); selectedItemIndex = pagination.getPageFirstItem() + getItems().getRowIndex(); return "Edit"; } public String update() { try { getJpaController().edit(current); JsfUtil.addSuccessMessage(ResourceBundle.getBundle("/Bundle").getString("ProjectsUpdated")); return "View"; } catch (Exception e) { JsfUtil.addErrorMessage(e, ResourceBundle.getBundle("/Bundle").getString("PersistenceErrorOccured")); return null; } } public String destroy() { current = (Projects) getItems().getRowData(); selectedItemIndex = pagination.getPageFirstItem() + getItems().getRowIndex(); performDestroy(); recreatePagination(); recreateModel(); return "List"; } public String destroyAndView() { performDestroy(); recreateModel(); updateCurrentItem(); if (selectedItemIndex >= 0) { return "View"; } else { // all items were removed - go back to list recreateModel(); return "List"; } } private void performDestroy() { try { getJpaController().destroy(current.getId()); JsfUtil.addSuccessMessage(ResourceBundle.getBundle("/Bundle").getString("ProjectsDeleted")); } catch (Exception e) { JsfUtil.addErrorMessage(e, ResourceBundle.getBundle("/Bundle").getString("PersistenceErrorOccured")); } } private void updateCurrentItem() { int count = getJpaController().getProjectsCount(); if (selectedItemIndex >= count) { // selected index cannot be bigger than number of items: selectedItemIndex = count - 1; // go to previous page if last page disappeared: if (pagination.getPageFirstItem() >= count) { pagination.previousPage(); } } if (selectedItemIndex >= 0) { current = getJpaController().findProjectsEntities(1, selectedItemIndex).get(0); } } public DataModel getItems() { if (items == null) { items = getPagination().createPageDataModel(); } return items; } private void recreateModel() { items = null; } private void recreatePagination() { pagination = null; } public String next() { getPagination().nextPage(); recreateModel(); return "List"; } public String previous() { getPagination().previousPage(); recreateModel(); return "List"; } public SelectItem[] getItemsAvailableSelectMany() { return JsfUtil.getSelectItems(getJpaController().findProjectsEntities(), false); } public SelectItem[] getItemsAvailableSelectOne() { return JsfUtil.getSelectItems(getJpaController().findProjectsEntities(), true); } @FacesConverter(forClass = Projects.class) public static class ProjectsControllerConverter implements Converter { public Object getAsObject(FacesContext facesContext, UIComponent component, String value) { if (value == null || value.length() == 0) { return null; } ProjectsController controller = (ProjectsController) facesContext.getApplication().getELResolver(). getValue(facesContext.getELContext(), null, "projectsController"); return controller.getJpaController().findProjects(getKey(value)); } java.math.BigDecimal getKey(String value) { java.math.BigDecimal key; key = new java.math.BigDecimal(value); return key; } String getStringKey(java.math.BigDecimal value) { StringBuffer sb = new StringBuffer(); sb.append(value); return sb.toString(); } public String getAsString(FacesContext facesContext, UIComponent component, Object object) { if (object == null) { return null; } if (object instanceof Projects) { Projects o = (Projects) object; return getStringKey(o.getId()); } else { throw new IllegalArgumentException("object " + object + " is of type " + object.getClass().getName() + "; expected type: " + Projects.class.getName()); } } } } </code></pre> <p>When I assign the ID manually it works perfectly. But what I want is, it has to auto-generate the value. How to overcome this?</p> <p>my trigger: <code>DELIMITER @@ CREATE OR REPLACE TRIGGER PROJETAKIP.PROJECTS_TRIGGER BEFORE INSERT ON PROJECTS REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT PROJECTS_SEQUENCE.nextval INTO :NEW.ID FROM dual;END; @@ DELIMITER ; </code></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload