[JBoss Seam] - Inserting value in primary and secondry table
by kaviarasu
Hi
i have two tables one have primary key and the secondry table has foreign key.
i generate a autoId increment which want to inserted in primary and secondary table when the user enters the register button
hw to do the exercise
can any one give the solution
@Name("user3")
| @Table(name = "TBL_REVIEWS")
|
| @SecondaryTable(name="TBL_USER_REVIEWS", pkJoinColumns={ @PrimaryKeyJoinColumn(name="REVIEW_ENTRY_ID")})
|
|
| public class TblWriteReviews implements Serializable {
| @Id
| @GeneratedValue(generator="IdSeq")
| @SequenceGenerator(name="IdSeq",sequenceName="REVIEW_ENTRY_ID_SEQ", allocationSize=1)
| @Column(name = "REVIEW_ENTRY_ID")
where the reviewEntryId is auto generated and want to be entered when the register button is entered
can any one help me
thank u regards
kavi
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064930#4064930
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4064930
18Â years, 11Â months
[JCA/JBoss] - Re: 2 PersistenceUnits: Adding multiple last resources is di
by baz
Sorry, The exception is this
"baz" wrote : Thanks for the answer.
| After setting pad= true, ithe same(?) exception is raised:
| 08:59:38,133 INFO [ExperimentSiteList] ExperimentSiteList instantiated by SEAM
| | 08:59:38,508 INFO [STDOUT] Hibernate: select experiment0_.ExperimentID as Experime1_76_, experiment0_.Size as Size76_, experiment0_.SowingYear as SowingYear76_, experiment0_.Description as Descript4_76_, experiment0_.HarvestYear as HarvestY5_76_, experiment0_.SowingDate as SowingDate76_, experiment0_.AddressCode as AddressC7_76_, experiment0_.AddressFAOCode as AddressF8_76_, experiment0_.PartnerCode as PartnerC9_76_, experiment0_.ProjectCode as Project10_76_, experiment0_.ExperimentCode as Experim11_76_, experiment0_.ExperimentName as Experim12_76_, experiment0_.SiteID as SiteID76_, experiment0_.HarvestDate as Harvest14_76_, experiment0_.Design as Design76_, experiment0_.Samples as Samples76_, experiment0_.Replications as Replica17_76_ from EXPERIMENT experiment0_ limit ?
| | 08:59:38,680 ERROR [XAManagedConnectionFactory] Start transaction failed for org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@14c9bfb
| | 08:59:38,680 WARN [TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@13a7cd4[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@14c9bfb handles=0 lastUse=1184655578649 permit=true trackByTx=true mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@94a25c context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@2f4f8b xaResource=org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper@d9794b txSync=null]
| | oracle.jdbc.xa.OracleXAException
| | at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1157)
| | at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:295)
| | at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:121)
| | at org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper.start(JcaXAResourceWrapper.java:113)
| | at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:701)
| | at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.enlistResource(TransactionImple.java:446)
| | at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener$TransactionSynchronization.enlist(TxConnectionManager.java:773)
| | at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:564)
| | at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:337)
| | at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnectManagedConnection(BaseConnectionManager2.java:518)
| | at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:399)
| | at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
| | at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
| | at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)
| | at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
| | at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
| | at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
| |
When i understand it correctly, the connection is reused and should be enlisted in a transaction. This step fails. But why?
The sentence you quote belongs to 1.) sorry for the fault:-(
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064926#4064926
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4064926
18Â years, 11Â months
[JBoss Seam] - Re: bug in exception handling ?
by Kruno
I've encountered similar problem, even with latest version from cvs.
I tried to handle exception from pages.xml
| <exception class="orka.RollBackException">
| <end-conversation/>
| <redirect view-id="/error/Error.jsp">
| <message severity="FATAL">#{org.jboss.seam.handledException.message}</message>
| </redirect>
| </exception>
|
It redirects to Error.jsp but I do not get message and in console I get IllegalStateException
|
| 11:52:15,380 ERROR [SeamPhaseListener] swallowing exception
| java.lang.IllegalStateException: pageflow is not currently at a <page> or <start-page> node (note that pageflows that begin during the RENDER_RESPONSE phase should use <start-page> instead of <start-state>)
| at org.jboss.seam.pageflow.Pageflow.getPage(Pageflow.java:227)
| at org.jboss.seam.pageflow.Pageflow.validatePageflow(Pageflow.java:105)
| at org.jboss.seam.jsf.SeamPhaseListener.afterRestoreView(SeamPhaseListener.java:381)
| at org.jboss.seam.jsf.SeamPhaseListener.afterServletPhase(SeamPhaseListener.java:211)
| at org.jboss.seam.jsf.SeamPhaseListener.afterPhase(SeamPhaseListener.java:184)
| at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:280)
| at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)
| at javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:147)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
| at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:87)
| at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
| at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:63)
| at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
| at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:46)
| at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:127)
| at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:277)
| at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:45)
| at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
| at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
| at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
| at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:140)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
| at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
| at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
| at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
| at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
| at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
| at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
| at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
| at java.lang.Thread.run(Thread.java:595)
|
Thanks in advance Kruno.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4064923#4064923
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4064923
18Â years, 11Â months