[JCA/JBoss] - Re: Message DB + Oracle database connection count problems
by adrianï¼ jboss.org
Lots of random assertions with no real evidence.
If you really want some help, then use "READ THIS FIRST" to gather that evidence.
The only thing we know for certain is that something is marking a transaction
for rollback (this isn't necessarily a transaction timeout - but it is most likely)
and that your application is leaking connections probably when errors occur.
There hasn't been a single bug found in the JCA connection pooling code
since this horrible bug (3 years ago).
http://viewvc.jboss.org/cgi-bin/viewvc.cgi/jbossas?view=rev&revision=22057
(That's not say to one still doesn't exist, just nobody has been clever
enough or unlucky enough to find it :-)
In this case, your not in an EJB or servlet context, so you aren't going to
get much help from the appserver checking you closed things properly.
anonymous wrote :
| at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:103)
| at com.mobilgw.sam.common.cp.celcom.WFCelcomComponentFactory.(WFCelcomComponentFactory.java:120)
| at com.mobilgw.sam.plugin.celcom.CheckAllowBlacklist.checkSubscriberForAllowBlackList(CheckAllowBlacklist.java:159)
| at com.mobilgw.sam.plugin.celcom.CheckAllowBlacklist.execute(CheckAllowBlacklist.java:80)
| at com.mobilgw.sam.executionengine.adapter.JavaAdapterHandler.execute(JavaAdapterHandler.java:84)
| at com.mobilgw.sam.executionengine.ExecutionEngine.execute(ExecutionEngine.java:575)
| at com.mobilgw.sam.executionengine.ExecutionEngine.execute(ExecutionEngine.java:460)
| at com.mobilgw.sam.executionengine.ExecutionEngine.execute(ExecutionEngine.java:586)
| at com.mobilgw.sam.executionengine.ExecutionEngine.execute(ExecutionEngine.java:460)
| at com.mobilgw.sam.executionengine.ExecutionEngine.execute(ExecutionEngine.java:455)
| at com.mobilgw.sam.executionengine.ExecutionEngine.execute(ExecutionEngine.java:361)
| at com.mobilgw.sam.executionengine.queue.SmsService.run(SmsService.java:575)
| at java.lang.Thread.run(Thread.java:534)
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4066637#4066637
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4066637
18Â years, 9Â months
[JCA/JBoss] - JCA 1.5 deployment in JBOSS 4.0.0
by tpawankumar
Hi All,
I am trying to deploy JCA for infranet on JBOSS4.0.0. I am getting following error. Can anybody help?
anonymous wrote :
| infranet-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
<connection-factories>
<tx-connection-factory>
<jndi-name>Ombi.Infranet</jndi-name>
<rar-name>infranetconnector.rar</rar-name>
<connection-definition>
javax.resource.cci.ConnectionFactory
</connection-definition>
</tx-connection-factory>
</connection-factories>
anonymous wrote :
| ra.xml
<?xml version="1.0" encoding="UTF-8"?>
<connector id="Connector_ID" version="1.5" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/connector_1_5.xsd">
<display-name>InfranetConnector</display-name>
<vendor-name>Covad</vendor-name>
<eis-type>Infranet</eis-type>
<resourceadapter-version>1.0</resourceadapter-version>
<resourceadapter-class>
org.jboss.resource.deployment.DummyResourceAdapter
</resourceadapter-class>
<outbound-resourceadapter>
<connection-definition>
<managedconnectionfactory-class>com.covad.billing.framework.connector.InfLocalTxManagedConnectionFactory</managedconnectionfactory-class>
<config-property>
<config-property-name>BrandSwitch</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>switch</config-property-value>
</config-property>
<connectionfactory-interface>javax.resource.cci.ConnectionFactory</connectionfactory-interface>
<connectionfactory-impl-class>com.covad.billing.framework.connector.InfConnectionFactory</connectionfactory-impl-class>
<connection-interface>javax.resource.cci.Connection</connection-interface>
<connection-impl-class>
com.covad.billing.framework.connector.InfCciConnection
</connection-impl-class>
</connection-definition>
<transaction-support>LocalTransaction</transaction-support>
<authentication-mechanism>
<authentication-mechanism-type>BasicPassword</authentication-mechanism-type>
<credential-interface>javax.resource.spi.security.PasswordCredential</credential-interface>
</authentication-mechanism>
<reauthentication-support>false</reauthentication-support>
</outbound-resourceadapter>
Stack Trace on JBOSS console
16:35:02,952 INFO [EARDeployer] Init J2EE application: file:/E:/jboss-4.0.0[1]/jboss-4.0.0/server/a
ll/deploy/omBilling.ear
16:35:06,999 INFO [EjbModule] Deploying OMBillingInterface
16:35:07,046 INFO [EJBDeployer] Deployed: file:/E:/jboss-4.0.0[1]/jboss-4.0.0/server/all/tmp/deploy
/tmp22403omBilling.ear-contents/omBilling.jar
16:35:07,077 INFO [EARDeployer] Started J2EE application: file:/E:/jboss-4.0.0[1]/jboss-4.0.0/serve
r/all/deploy/omBilling.ear
16:35:07,187 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
MBeans waiting for other MBeans:
ObjectName: jboss.jca:service=TxCM,name=Ombi.Infranet
state: CONFIGURED
I Depend On: jboss.jca:service=ManagedConnectionPool,name=Ombi.Infranet
jboss.jca:service=CachedConnectionManager
jboss:service=TransactionManager
Depends On Me: jboss.jca:service=ConnectionFactoryBinding,name=Ombi.Infranet
ObjectName: jboss.jca:service=ManagedConnectionPool,name=Ombi.Infranet
state: CONFIGURED
I Depend On: jboss.jca:service=ManagedConnectionFactory,name=Ombi.Infranet
Depends On Me: jboss.jca:service=TxCM,name=Ombi.Infranet
ObjectName: jboss.jca:service=ManagedConnectionFactory,name=Ombi.Infranet
state: CONFIGURED
I Depend On: jboss.jca:service=RARDeployment,name='infranetconnector.rar'
Depends On Me: jboss.jca:service=ManagedConnectionPool,name=Ombi.Infranet
ObjectName: jboss.jca:service=ConnectionFactoryBinding,name=Ombi.Infranet
state: CONFIGURED
I Depend On: jboss.jca:service=TxCM,name=Ombi.Infranet
Depends On Me:
MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
ObjectName: jboss.jca:service=RARDeployment,name='infranetconnector.rar'
state: NOTYETINSTALLED
I Depend On:
Depends On Me: jboss.jca:service=ManagedConnectionFactory,name=Ombi.Infranet
thanks in advance
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4066636#4066636
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4066636
18Â years, 9Â months
[JBoss Seam] - ManyToOne relationship
by odupont
I want to create a ManyToOne relationship but I always receive an error from the import.sql.
I have one entity Application which is linked to a Category.
Application:
@Entity
@Table(name="APPLICATION")
public class Application
implements Serializable
...
Category category;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name="CATEGORY_ID")
public Category getCategory() {
return category;
}
public void setCategory(Category category) {
this.category = category;
}
}
Category:
@Entity
public class Category implements Serializable {
...
@Id @GeneratedValue
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
}
import.sql:
delete from APPLICATION
delete from CATEGORY
insert into CATEGORY (ID,NAME) values (1, 'CATEGORY 1')
insert into CATEGORY (ID,NAME) values (2, 'CATEGORY 2')
insert into APPLICATION (ID, CODE, NAME, DESCRIPTION, CATEGORY_ID) values (1, 'AP1', 'Application1', 'Test application which is represent the first application', 1)
insert into APPLICATION (ID, CODE, NAME, DESCRIPTION, CATEGORY_ID) values (2, 'AP2', 'Application2', 'Test application which is represent the second application', 2)
I received an error:
SQLException Column not found: CATEGORY_ID statement...
Can you help me?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4066633#4066633
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4066633
18Â years, 9Â months
[EJB/JBoss] - Flushing CMP 2.0 EntityBean updates before end of transactio
by reddy_123
I am using CMP 2.0 Entity Beans in JBoss v3.2.6
I am calling EntityBean from within a Stateless Session Bean method.
The stateless Session Bean method has transaction attribute set to TX_REQUIRED.
In the Stateless Session Bean method, I am doing a JDBC read after the
entity bean update, but the JDBC read is not picking up the updates done
by entity bean.
Is there any method available in the J2EE container in JBoss which will allow me to flush the entitybean updates, so that the subsequent JDBC read will pick up these updates.
I have seen that if I call any EntityBean finder (not necessarily the one that I updated) before doing a JDBC read, it seems to be doing the trick.
But I am just wondering if there is some API in JBoss container, which is allow me to do a flush of pending updates before the end of the transaction.
Thanks
Ram
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4066632#4066632
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4066632
18Â years, 9Â months