[Datasource Configuration] - New-connection-sql Jboss
by Thiago Nascimento
Thiago Nascimento [https://community.jboss.org/people/tnas] created the discussion
"New-connection-sql Jboss"
To view the discussion, visit: https://community.jboss.org/message/818284#818284
--------------------------------------------------------------
Hi,
I'm trying to use the <new-connection-sql> tag in the Datasource to Oracle. I want to execute this query:
SET ROLE RL_USER_SELECT IDENTIFIED BY RL_USER_SELECT, RL_ACCESS_CONSULT IDENTIFIED BY RL_ACCESS_CONSULT;
before to return the connection to the user.
The problem is that Jbos doesn't execute this query! My datasource is:
<datasources>
<local-tx-datasource>
<jndi-name>MyAppDs</jndi-name>
<connection-url>jdbc:oracle:thin:@dbtest.org:1521:dadm</connection-url>
<user-name>usr</user-name>
<password>pass</password>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<min-pool-size>5</min-pool-size>
<max-pool-size>15</max-pool-size>
<idle-timeout-minutes>5</idle-timeout-minutes>
<track-statements/>
<prepared-statement-cache-size>100</prepared-statement-cache-size>
<new-connection-sql>
SET ROLE RL_USER_SELECT IDENTIFIED BY RL_USER_SELECT, RL_ACCESS_CONSULT IDENTIFIED BY RL_ACCESS_CONSULT;
</new-connection-sql>
</local-tx-datasource>
</datasources>
What am I doing wrong?
Thanks.
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/818284#818284]
Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 5 months
[EJB3] - Re: EJB 2.1 BMP with CMT and RequiresNew in JBoss AS 7.1.0 Final
by Daniel Zhelyazkov
Daniel Zhelyazkov [https://community.jboss.org/people/dzhelyazkov] created the discussion
"Re: EJB 2.1 BMP with CMT and RequiresNew in JBoss AS 7.1.0 Final"
To view the discussion, visit: https://community.jboss.org/message/728546#728546
--------------------------------------------------------------
Fixed my problem, after debug session of JBoss code it turned out that the code that parses TX attributes produces wrong info.
we had the folowing in ejb-jar.xml
<method>
<ejb-name>SomeEjb</ejb-name>
<method-name>*</method-name>
</method>
...
<trans-attribute>RequiresNew</trans-attribute>
Specified like that JBoss set default TX attribute Required to all LOCAL_HOME methods (ejbCreate/Find/Select/Home)
and RequiresNew to all Bean methods such as toString(), hashCode()...
by adding <method-intf>LocalHome</method-intf>
<method>
<ejb-name>SomeEjb</ejb-name>
<method-intf>LocalHome</method-intf>
<method-name>*</method-name>
</method>
all went to normal, my ejbCreate() started new transaction, and getProperties() method did not use TX interceptor.
So it looks like different or wrong loginc in JBoss, the code itself states it has some problems, and it looks targeted at EJB 3.x, it is not a separate code for 2.x
daniel
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/728546#728546]
Start a new discussion in EJB3 at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 5 months
[jBPM] - Error: APPLICATION ERROR: transaction still active in request with status 0
by alvinuw
alvinuw [https://community.jboss.org/people/alvinuw] created the discussion
"Error: APPLICATION ERROR: transaction still active in request with status 0"
To view the discussion, visit: https://community.jboss.org/message/820178#820178
--------------------------------------------------------------
Hello,
I am trying to deploy my jbpm5.4 process in console.
The process is very simple, which contains a start -> the first workItem(EmailSender)->the first workItem(EmailReceiver)->an end
For some reason, I have to write the custom workitemhandlers for the two workItems, EWSHandler and EWSHandler2.
*Please note:* I also have two variables(MsgId, Checker) for the com.sample.bpmn.EmailApps process.
And I used eclipse plugin to develop it, it works well on eclipse.
In EWSHandler.java, I have:
Map<String, Object> results = new HashMap<String, Object>();
results.put("MsgId", id);
results.put("Checker", recipient);
manager.completeWorkItem(workItem.getId(), results);
I followed the below steps to deploy the process in console.
*1*. modify $jbpm_installer/conf/META-INF/CustomWorkItemHandlers.conf
[
"Log": new org.jbpm.process.instance.impl.demo.SystemOutWorkItemHandler(),
"EmailSender": new com.sample.EWSHandler(),
"EmailReceiver": new com.sample.EWSHandler2(),
]
*2.* put both com.sample.EWSHandler.jar and com.sample.EWSHandler2.jar in $jbpm_installer/dependencies folder.
*3.* Run commands
ant clean.demo
ant install.demo
ant start.demo
*4.* Upload EmailApps-image.png and EmailApps.bpmn to Guvnor's defaultPackge, then build package.
*5.* login Console, check Process Overview.
https://community.jboss.org/servlet/JiveServlet/showImage/2-820178-20884/... https://community.jboss.org/servlet/JiveServlet/downloadImage/2-820178-20...
*6. I don't know why it shows "Process1" instead of "EmailApps" in my process list. How to change the process name?*
When I checked the server.log, it gave me the following error*.
*
12:24:37,529 WARN [org.drools.guvnor.server.repository.RulesRepositoryManager] (http-localhost-127.0.0.1-8080-14) Creating RulesRepository with default username.
12:24:37,529 INFO [stdout] (http-localhost-127.0.0.1-8080-14) =============== session-guest-33
12:24:37,529 INFO [stdout] (http-localhost-127.0.0.1-8080-14) =============== session-guest-33
12:24:45,407 ERROR [org.jboss.as.txn] (http-localhost-127.0.0.1-8080-6) *JBAS010152:* *APPLICATION ERROR: transaction still active in request with status 0*
12:24:47,513 WARN [org.drools.guvnor.server.repository.RulesRepositoryManager] (http-localhost-127.0.0.1-8080-14) Creating RulesRepository with default username.
12:24:47,513 INFO [stdout] (http-localhost-127.0.0.1-8080-14) =============== session-guest-34
I searched this error in both google and our community, but didn't get a proper answer.
If you need me to provide more details, please let me know.
Thank you very much.
Alvin
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/820178#820178]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 5 months
[JBoss AOP] - Re: ConcurrentModificationException during JBoss 5.0.1.GA st
by Andrew Boyd
Andrew Boyd [https://community.jboss.org/people/AndrewBoyd] created the discussion
"Re: ConcurrentModificationException during JBoss 5.0.1.GA st"
To view the discussion, visit: https://community.jboss.org/message/759599#759599
--------------------------------------------------------------
Hi All,
It is now 2013 and I'm running jboss-5.1.0.GA and I am getting the same exception with the same line numbers:
2012-09-13 16:53:24,379 ERROR [STDERR] (AOPListner) Exception in thread "AOPListner"
2012-09-13 16:53:24,409 ERROR [STDERR] (AOPListner) java.util.ConcurrentModificationException
2012-09-13 16:53:24,409 ERROR [STDERR] (AOPListner) at java.util.WeakHashMap$HashIterator.nextEntry(WeakHashMap.java:762)
2012-09-13 16:53:24,409 ERROR [STDERR] (AOPListner) at java.util.WeakHashMap$KeyIterator.next(WeakHashMap.java:795)
2012-09-13 16:53:24,409 ERROR [STDERR] (AOPListner) at org.jboss.aop.AspectManager.getAdvisors(AspectManager.java:537)
2012-09-13 16:53:24,409 ERROR [STDERR] (AOPListner) at org.jboss.console.plugins.AOPLister$RefreshPoller.run(AOPLister.java:891)
If anyone knows a work around that would be helpful.
Thanks,
Andrew
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/759599#759599]
Start a new discussion in JBoss AOP at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&con...]
12 years, 5 months
