Guest User

Untitled

a guest
Jan 15th, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.24 KB | None | 0 0
  1. CREATE SEQUENCE "MODEL_C_MODEL_seq"
  2. INCREMENT 1
  3. MINVALUE 1
  4. MAXVALUE 9223372036854775807
  5. START 93
  6. CACHE 1;
  7. ALTER TABLE "MODEL_C_MODEL_seq"
  8.  
  9. CREATE TABLE "MODEL"
  10. (
  11. "C_USER" character varying(10) NOT NULL,
  12. "C_MODEL" serial NOT NULL,
  13. "TP_MODEL" character(5) NOT NULL,
  14. "NM_MODEL" character varying(20) NOT NULL,
  15. CONSTRAINT "MODEL_PK" PRIMARY KEY ("C_MODEL" ),
  16. CONSTRAINT "MODEL_CUSER_FK" FOREIGN KEY ("C_USER")
  17. REFERENCES "USER" ("C_USER") MATCH SIMPLE
  18. ON UPDATE NO ACTION ON DELETE NO ACTION,
  19. CONSTRAINT "MODEL_TPMODEL_FK" FOREIGN KEY ("TP_MODEL")
  20. REFERENCES "ADM_TYPES" ("C_TYPE") MATCH SIMPLE
  21. ON UPDATE NO ACTION ON DELETE NO ACTION,
  22. CONSTRAINT "MODEL_CUSER_NMNAME_UNIQUE" UNIQUE ("C_USER" , "NM_MODEL" )
  23. )
  24. WITH (
  25. OIDS=FALSE
  26. );
  27.  
  28. public class Model implements Serializable {
  29. private static final long serialVersionUID = 1L;
  30.  
  31. **@Id
  32. @SequenceGenerator(name="modelPKgen", sequenceName="MODEL_C_MODEL_seq")
  33. @GeneratedValue(generator="modelPKgen", strategy= GenerationType.IDENTITY)
  34. @Column(name = ""C_MODEL"", unique=true, insertable=false)
  35. private int cModel;**
  36.  
  37. @OneToMany(cascade = CascadeType.ALL, fetch= FetchType.EAGER)//, mappedBy = "model", fetch= FetchType.EAGER)
  38. @JoinColumn(name= "`C_MODEL`")
  39. private Collection<State> stateCollection;
  40.  
  41. @JoinColumn(name = "`C_USER`", referencedColumnName ="`C_USER`", updatable = false)
  42. @ManyToOne(optional = false)
  43. private User user;
  44.  
  45. @Basic(optional = false)
  46. @NotNull
  47. @Size(min = 1, max = 20)
  48. @Column(name = ""NM_MODEL"")
  49. private String nmModel;
  50.  
  51. @JoinColumn(name = ""TP_MODEL"")
  52. @ManyToOne(optional = false)
  53. private AdmTypes admTypes;
  54. ...
  55.  
  56. Model dbModel = new Model(user.getCUser(), simModel.getName());
  57. AdmTypes dbAdm = new AdmTypes(simModel.getType());
  58. dbModel.setAdmTypes(dbAdm);
  59.  
  60. **em.persist(dbModel);**
  61. em.flush();
  62.  
  63. Caused by: org.hibernate.exception.SQLGrammarException: The column name "C_MODEL" was not found in this ResultSet.
  64.  
  65. insert
  66. into
  67. "MODEL"
  68. ("TP_MODEL", "NM_MODEL", "C_USER")
  69. values
  70. (?, ?, ?)
  71.  
  72. javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: The column name "C_MODEL" was not found in this ResultSet.
  73. at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1367)
  74. at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1295)
  75. at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1301)
  76. at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:866)
  77. at com.sun.enterprise.container.common.impl.EntityManagerWrapper.persist(EntityManagerWrapper.java:269)
  78. at com.librethinking.simmodsys.persistence.adapters.ModelConverter.SIMModelToModel(ModelConverter.java:65)
  79. at com.librethinking.simmodsys.ejb.ModelBean.saveSIMModel(ModelBean.java:72)
  80. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  81. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  82. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  83. at java.lang.reflect.Method.invoke(Method.java:601)
  84. at org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1052)
  85. at org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1124)
  86. at com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:5366)
  87. at com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:619)
  88. at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:800)
  89. at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:571)
  90. at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doAround(SystemInterceptorProxy.java:162)
  91. at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:144)
  92. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  93. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  94. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  95. at java.lang.reflect.Method.invoke(Method.java:601)
  96. at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:861)
  97. at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:800)
  98. at com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:370)
  99. at com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:5338)
  100. at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:5326)
  101. at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:214)
  102. at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:88)
  103. at $Proxy186.saveSIMModel(Unknown Source)
  104. at com.librethinking.simmodsys.ejb.__EJB31_Generated__ModelBean__Intf____Bean__.saveSIMModel(Unknown Source)
  105. at com.librethinking.simmodsys.web.ModelsController.saveModel(ModelsController.java:366)
  106. at com.librethinking.simmodsys.web.ModelsController.processRequest(ModelsController.java:104)
  107. at com.librethinking.simmodsys.web.ModelsController.doPost(ModelsController.java:181)
  108. at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
  109. at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
  110. at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1539)
  111. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:281)
  112. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
  113. at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
  114. at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
  115. at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:98)
  116. at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:91)
  117. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:162)
  118. at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:330)
  119. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231)
  120. at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:174)
  121. at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:828)
  122. at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:725)
  123. at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1019)
  124. at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:225)
  125. at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
  126. at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
  127. at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
  128. at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
  129. at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
  130. at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
  131. at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
  132. at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
  133. at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
  134. at java.lang.Thread.run(Thread.java:722)
  135. Caused by: org.hibernate.exception.SQLGrammarException: The column name "C_MODEL" was not found in this ResultSet.
  136. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
  137. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
  138. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
  139. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
  140. at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:108)
  141. at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
  142. at $Proxy189.getInt(Unknown Source)
  143. at org.hibernate.id.IdentifierGeneratorHelper.get(IdentifierGeneratorHelper.java:152)
  144. at org.hibernate.id.IdentifierGeneratorHelper.getGeneratedIdentity(IdentifierGeneratorHelper.java:92)
  145. at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:100)
  146. at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
  147. at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2767)
  148. at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3278)
  149. at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
  150. at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
  151. at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:203)
  152. at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:183)
  153. at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167)
  154. at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:320)
  155. at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:287)
  156. at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:193)
  157. at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126)
  158. at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78)
  159. at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208)
  160. at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151)
  161. at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78)
  162. at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:844)
  163. at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:819)
  164. at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:823)
  165. at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:860)
  166. ... 58 more
  167. Caused by: org.postgresql.util.PSQLException: The column name "C_MODEL" was not found in this ResultSet.
  168. at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2550)
  169. at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.java:2414)
  170. at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source)
  171. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  172. at java.lang.reflect.Method.invoke(Method.java:601)
  173. at org.hibernate.engine.jdbc.internal.proxy.AbstractResultSetProxyHandler.continueInvocation(AbstractResultSetProxyHandler.java:104)
  174. ... 83 more
Add Comment
Please, Sign In to add comment