[JBoss Seam] - Re: Transaction Exception with Seam and EJB3
by nloomis
Thanks! I took your advice and researched the forums and tried handling the transaction several different ways to see if I could find the error behind the error. I see this one debug statement about 1000 times in my debugger. It starts during the JBpm deploy and seems directly related to my problem. Any help with this??
Here's where the message starts in my log...
-------------------------------------------------------------------------------
2007-02-06 16:29:10,102 DEBUG [org.hibernate.hql.ast.AST] --- SQL AST ---
\-[DELETE] DeleteStatement: 'delete' querySpaces (JBPM_MESSAGE)
+-[FROM] FromClause: 'FROM' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[m], fromElementByTableAlias=[message0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'JBPM_MESSAGE' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=m,role=null,tableName=JBPM_MESSAGE,tableAlias=message0_,origin=null,colums={,className=org.jbpm.msg.Message}}
\-[WHERE] SqlNode: 'where'
\-[EQ] BinaryLogicOperatorNode: '='
+-[DOT] DotNode: 'TOKEN_' {propertyName=token,dereferenceType=ROOT_LEVEL,propertyPath=token,path=m.token,tableAlias=message0_,className=org.jbpm.msg.Message,classAlias=m}
| +-[ALIAS_REF] IdentNode: 'ID_' {alias=m, className=org.jbpm.msg.Message, tableAlias=message0_}
| \-[IDENT] IdentNode: 'token' {originalText=token}
\-[NAMED_PARAM] ParameterNode: '?' {name=token, expectedType=org.hibernate.type.ManyToOneType(org.jbpm.graph.exe.Token)}
2007-02-06 16:29:10,102 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2007-02-06 16:29:10,102 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2007-02-06 16:29:10,102 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 0 named SQL queries
2007-02-06 16:29:10,102 DEBUG [org.jbpm.persistence.db.DbPersistenceService] creating hibernate session
2007-02-06 16:29:10,790 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4795585946083328
2007-02-06 16:29:10,790 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3@a1ee92, cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader@395626{ url=null ,addedOrder=0}
2007-02-06 16:29:10,790 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3@a1ee92, cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader@46f28c{ url=null ,addedOrder=0}
2007-02-06 16:29:10,837 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,837 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,852 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3@a1ee92, cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader@7958ef{ url=null ,addedOrder=0}
2007-02-06 16:29:10,852 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2007-02-06 16:29:10,915 DEBUG [org.hibernate.SQL] select * from ( select processdef0_.ID_ as ID1_31_, processdef0_.NAME_ as NAME2_31_, processdef0_.VERSION_ as VERSION3_31_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_31_, processdef0_.STARTSTATE_ as STARTSTATE5_31_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc ) where rownum <= ?
2007-02-06 16:29:11,227 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() RequestNewAccess -> name [1]
2007-02-06 16:29:11,243 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,321 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2007-02-06 16:29:11,321 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,337 DEBUG [org.hibernate.loader.Loader] result row: EntityKey[org.jbpm.graph.def.ProcessDefinition#24811]
2007-02-06 16:29:11,337 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,337 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,352 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,352 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
...
I'm curious whether we have the right properties set in the jbm-hibernate.cfg.xml. I don't have the following properties set for the JTATransaction,
hibernate.jndi.url JNDI initial context URL
hibernate.jndi.class JNDI provider class
jta.UserTransaction JNDI name
I plan to plug these in and try it. I might also try the CMTTransactionFactory insteand of the JTATransactionFactory. Again, I have checked the forums and can't find any advice so help is definitely appreciated.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4012437#4012437
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4012437
19Â years, 2Â months
[JBoss Seam] - Re: Transaction Exception with Seam and EJB3
by nloomis
Thanks! I took your advice and researched the forums and tried handling the transaction several different ways to see if I could find the error behind the error. I see this one debug statement about 1000 times in my debugger. It starts during the JBpm deploy and seems directly related to my problem. Any help with this??
Here's where the message starts in my log...
-------------------------------------------------------------------------------
2007-02-06 16:29:10,102 DEBUG [org.hibernate.hql.ast.AST] --- SQL AST ---
\-[DELETE] DeleteStatement: 'delete' querySpaces (JBPM_MESSAGE)
+-[FROM] FromClause: 'FROM' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[m], fromElementByTableAlias=[message0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'JBPM_MESSAGE' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=m,role=null,tableName=JBPM_MESSAGE,tableAlias=message0_,origin=null,colums={,className=org.jbpm.msg.Message}}
\-[WHERE] SqlNode: 'where'
\-[EQ] BinaryLogicOperatorNode: '='
+-[DOT] DotNode: 'TOKEN_' {propertyName=token,dereferenceType=ROOT_LEVEL,propertyPath=token,path=m.token,tableAlias=message0_,className=org.jbpm.msg.Message,classAlias=m}
| +-[ALIAS_REF] IdentNode: 'ID_' {alias=m, className=org.jbpm.msg.Message, tableAlias=message0_}
| \-[IDENT] IdentNode: 'token' {originalText=token}
\-[NAMED_PARAM] ParameterNode: '?' {name=token, expectedType=org.hibernate.type.ManyToOneType(org.jbpm.graph.exe.Token)}
2007-02-06 16:29:10,102 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2007-02-06 16:29:10,102 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2007-02-06 16:29:10,102 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 0 named SQL queries
2007-02-06 16:29:10,102 DEBUG [org.jbpm.persistence.db.DbPersistenceService] creating hibernate session
2007-02-06 16:29:10,790 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4795585946083328
2007-02-06 16:29:10,790 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3@a1ee92, cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader@395626{ url=null ,addedOrder=0}
2007-02-06 16:29:10,790 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3@a1ee92, cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader@46f28c{ url=null ,addedOrder=0}
2007-02-06 16:29:10,837 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,837 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,852 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3@a1ee92, cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader@7958ef{ url=null ,addedOrder=0}
2007-02-06 16:29:10,852 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2007-02-06 16:29:10,915 DEBUG [org.hibernate.SQL] select * from ( select processdef0_.ID_ as ID1_31_, processdef0_.NAME_ as NAME2_31_, processdef0_.VERSION_ as VERSION3_31_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_31_, processdef0_.STARTSTATE_ as STARTSTATE5_31_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc ) where rownum <= ?
2007-02-06 16:29:11,227 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() RequestNewAccess -> name [1]
2007-02-06 16:29:11,243 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,321 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2007-02-06 16:29:11,321 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,337 DEBUG [org.hibernate.loader.Loader] result row: EntityKey[org.jbpm.graph.def.ProcessDefinition#24811]
2007-02-06 16:29:11,337 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,337 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,352 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,352 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
...
We have copied the configuration of Gavin's project exactly per his request to Brad. However, I'm curious whether we have the right properties set in the jbm-hibernate.cfg.xml. I don't have the following properties set for the JTATransaction,
hibernate.jndi.url JNDI initial context URL
hibernate.jndi.class JNDI provider class
jta.UserTransaction JNDI name
I plan to plug these in and try it. I might also try the CMTTransactionFactory insteand of the JTATransactionFactory. Again, I have checked the forums and can't find any advice so help is definitely appreciated.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4012435#4012435
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4012435
19Â years, 2Â months
[Installation, Configuration & Deployment] - Problem with the valve configuration
by maulikshah
Hi All,
In our production we want Sun One Web server 6.1 and JBoss App server combination. Almost all things are done.
But I got one problem which i want to discuss.
Basically, I have enabled Single Sign On for web server and through webserver App server got connected. The problem is if i know the ip and port on which App server running, i can able to connect directly on app server. I don't want to do that. Let only the request comes from web server (sun one- 6.1) and have the access on app server. So nobody can directly able to connect to app server.
I have setup valve in the server.xml and allow only certain ip,but as this picks the client ip.(users who access it through internet obviously are not allowed with this configuration). But I want even those users also should able to connect from internet but only restriction is the request should come from web server only.
I have use - className="org.apache.catalina.valves.RemoteAddrValve. I think I should have to provide different valve value than "RemoteAddrValve".
we have 3 machines(load balancing) for web server,so we want only 3 IP should be allowd by Tomcat.
Any expert? I am sure there is someone who had done this thing. please let me know the solution.
Your suggestion would be appreciated.
Thanks
Maulik
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4012425#4012425
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4012425
19Â years, 2Â months