[EJB 3.0] - Executing a
by r.simoni
Hi, we have a problem:
we have a SQL Server DB with internally linked a remote oracle DB.
We have created views in out SQL Server DB to map remote oracle tables.
When we try an insert sql on the SQL Server Enterprise Manager on the views all run correctly.
When we use EJB 3.0 to execute the same insert (via persist method) we receive this error:
| Unable to start a nested transaction for OLE DB provider 'MSDAORA'. A nested transaction was required because the XACT_ABORT option was set to OFF"
|
we have read that linked server in sql server are provided by a Provider that if doesn't support nested transactions you have to explicitly execute a query:
| SET XACT_ABORT ON
|
How can we execute this statement in EJB 3.0?
createQuery, createNativeQuery doesn't seem to be the solution
How can I obtain the connection used in the "session" to run a simply JDBC statement?
Do you have another solution?
Thanks
Bye
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3987853#3987853
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3987853
19Â years, 5Â months
[JBossCache] - Re: Configuring JBossCluster
by urisherman
Thanks a lot!
Very helpfull.
If I may make a suggestion about the documentation -
Indeed when I took another look I saw in the docs references to JGroups, the thing is, the reference appears in the preface. When a new user that doesn't know what JGroups is just reads through the docs for the first time, he won't remeber a single sentence from the small introduction ;-)
When he plunges into the docs with numerous places showing xml files defining the ClusterConfig element, with no explanation whatsoever for what the elements represent (which would be ok if the fact that it is defined by JGroups was written there) it becomes really frasturating not understanding why in the name of god no one wrote somewhere what all this means ;-)
Then my next step was to try and look through the api docs, which describe the methods setClusterConfig() and setClusterProperties() which as well don't mention this information.
Anyway, there should be more references to JGroups, at least in the configuration section.....
Thank you very much for your reply,
Uri.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3987849#3987849
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3987849
19Â years, 5Â months
[Clustering/JBoss] - unable use attribute "bind_to_all_interfaces" in tc5-cluster
by yik_cheung
I am running two AP on a multi-IP WinxP machine. I tried to specified the IP address for each AP listening multicast.
According "JBoss 4 Application Server clustering Guide" page 38. their is an attribute "bind_to_all_interfaces" to disable or enable whether this node should listen on all interfaces for mulicasts. The default value is false. However, I found that it bind all interfaces when I ran those APs and caused the following error for one of my AP
2006-11-22 17:15:23,812 DEBUG [org.jboss.cache.aop.TreeCacheAop] Starting jboss.cache:service=TomcatClusteringCache
2006-11-22 17:15:23,921 ERROR [org.jgroups.JChannel] exception: java.lang.Exception: exception caused by UDP.start(): java.net.BindException: Address already in use: Cannot bind
2006-11-22 17:15:23,937 DEBUG [org.jboss.cache.aop.TreeCacheAop] Starting failed jboss.cache:service=TomcatClusteringCache
ChannelException: java.lang.Exception: exception caused by UDP.start(): java.net.BindException: Address already in use: Cannot bind
at org.jgroups.JChannel.connect(JChannel.java:328)
at org.jboss.cache.TreeCache.startService(TreeCache.java:1424)
at org.jboss.cache.aop.PojoCache.startService(PojoCache.java:94)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBean
Does anyone have an idea about it? I have tried to add bind_to_all_interfaces=false in jboss-service.xml under tc5-cluster.sar. However, this attribute seems not a recognized ..
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3987846#3987846
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3987846
19Â years, 5Â months
[EJB 3.0] - Re: JBoss Unified ClassLoader Hell? even with EJB3 ?
by skosonen
anonymous wrote : I am running 4.0.4GA with EJB3. Yes, I did get 2 archives running. And, I can hot-deploy either/both without issues (great for development).
I also managed to develop my EJB3 & Web -application without this hot-deploy problem when using JBoss 4.0.4.GA. When I upgraded to 4.0.5.GA, I started having these problems.
For both versions I did the same configuration changes:
- Running JBoss with parameter "-Djava.rmi.server.hostname=localhost"
- jbossweb-tomcat55.sar/META-INF/jboss-service.xml: UseJBossWebLoader=true
I tried also changing the context.xml under Tomcat, but didn't help:
<antiJARLocking>true</antiJARLocking>
| <antiResourceLocking>true</antiResourceLocking>
|
I have one EAR-file that has EJB and WAR modules in it. If I make changes only in EJB module, package the EAR and deploy it, I get these ClassCastExceptions while trying to get session beans from servlets.
In JBoss 4.0.5.GA hot-deploy works when I make changes to both modules (EJB & WAR). This is the best workaround I have found on my problem. For separate EAR and WAR it might also work if both are redeployed?
It would be nice to find some better solution for this, though...
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3987844#3987844
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3987844
19Â years, 5Â months