[JCA/JBoss] - Re: Message DB + Oracle database connection count problems
by adrianï¼ jboss.org
"sks4jboss" wrote :
| 19:39:12,435 ERROR [BeanLock] Saw rolled back tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=cmp2app01/47048457, BranchQual=, localId=47048457]
| 19:39:12,438 ERROR [LogInterceptor] TransactionRolledbackLocalException in method: public abstract com.mobilgw.sam.definition.cp.CPDetailsDef com.mobilgw.sam.definition.cp.CPDetailsDefLocalRemote.getData(), causedBy:
| java.lang.RuntimeException: Transaction marked for rollback, possibly a timeout
| at org.jboss.ejb.plugins.lock.QueuedPessimisticEJBLock.doSchedule(QueuedPessimisticEJBLock.java:228)
|
This adds no new information. It just says the transaction was marked
for rollback and guesses it was a tx timeout waiting for CMP pessimistic lock.
You don't show any associated WARN about a transaction timeout for that XI
which would mean it waited 5 minutes (the default).
anonymous wrote :
| Also we have observed that getting a queue receiver usually fails when we hit this kinda problem hits with DB. So was just thinking if it has some relation. Below is the error for queue receiver.
|
| anonymous wrote :
| | org.jboss.mq.SpyJMSException: Error creating connection to the database.; - nested throwable: (org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )))
| |
|
| So it waited 30 seconds for somebody to give up a connection before
| throwing that error.
|
| You really aren't showing us any useful information. These are just the symptoms.
| Both are just errors saying "I've given up waiting".
| The real question is why is it waiting?
|
| Use "READ THIS FIRST" (logging, thread dumps), the JMX Console (e.g. CachedConnectionManager and Pool to get real stats),
| and the docs! e.g. the EntityLockMonitor
|
| That's as far as I am going to in playing "20 questions" with you.
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4067085#4067085
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4067085
18Â years, 9Â months
[JBoss Seam] - Using Seam with eclipse
by richard_lavoie
Hi there,
I am a newbie and I would like to use seam with eclipse.
I checked it out and adopted my build.property file.
When I try to build I get the error below. I think I have to install maven-plugin. I only find org.maven.ide.eclipse_0.0.10.jar and installed it under plugins in eclipse. I changes the pom.xml file as:
| <plugin>
| <!--<groupId>org.apache.maven.plugins</groupId>-->
| <groupId>org.maven.ide.eclipse</groupId>
| <artifactId>maven-compiler-plugin</artifactId>
| <configuration>
| <source>1.5</source>
| <target>1.5</target>
| </configuration>
| </plugin>
|
refreshed, but I still become the same error below.
thanks a lot
Richy
Building JBoss Seam
[java] [INFO] task-segment: [package]
[java] [INFO] ----------------------------------------------------------------------------
[java] [INFO] ------------------------------------------------------------------------
[java] [ERROR] BUILD ERROR
[java] [INFO] ------------------------------------------------------------------------
[java] [INFO] The plugin 'org.apache.maven.plugins:maven-site-plugin' does not exist or no valid version could be found
[java] [INFO] ------------------------------------------------------------------------
[java] [INFO] For more information, run Maven with the -e switch
[java] [INFO] ------------------------------------------------------------------------
[java] [INFO] Total time: 1 second
[java] [INFO] Finished at: Tue Jul 24 17:44:44 CEST 2007
[java] [INFO] Final Memory: 1M/3M
[java] [INFO] ------------------------------------------------------------------------
[java] Java Result: 1
BUILD FAILED
D:\Programme\seam-workspace\jboss-seam\build.xml:621: Warning: Could not find file D:\Programme\seam-workspace\jboss-seam\ui\target\jboss-seam-ui.jar to copy.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4067084#4067084
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4067084
18Â years, 9Â months
[JBoss Portal] - using Ingres database as PortalDS
by advaittrivedi
Hi,
I am trying to use Ingres 2006 database as portalDS for JBoss Portal 2.4. I have setup necessary datasource. But when I start the portal server and when hibernate tries to create tables, following errors are coming.
-------------------------------------------
CMS failing to start:
org.apache.jackrabbit.core.fs.FileSystemException: failed to create folder entry: /
Caused by: com.ingres.gcf.util.SqlEx: Invalid datatype conversion.
Automatic creation of table JBP_OBJECT_NODE failing:
20:27:04,904 ERROR [SchemaUpdate] Unsuccessful: create table JBP_OBJECT_NODE (PK bigint not null, PATH varchar(255) with null unique, NAME varchar(255) with null, PARENT_KEY bigint with null, primary key (PK))
20:27:04,904 ERROR [SchemaUpdate] CREATE TABLE: A column in a UNIQUE constraint has been defined as WITH NULL (on table 'jbp_object_node').
All columns in a UNIQUE constraint MUST be created as NOT NULL.
20:26:44,810 ERROR [SchemaExport] Unsuccessful: create table jbp_roles (jbp_rid bigint not null, jbp_name varchar(255) with null unique, jbp_displayname varchar(255) with null unique, primary key (jbp_rid))
20:26:44,810 ERROR [SchemaExport] CREATE TABLE: A column in a UNIQUE constraint has been defined as WITH NULL (on table 'jbp_roles').
All columns in a UNIQUE constraint MUST be created as NOT NULL.
20:26:45,107 ERROR [SchemaExport] Unsuccessful: create table jbp_users (jbp_uid bigint not null, jbp_uname varchar(255) with null unique, jbp_givenname varchar(255) with null, jbp_familyname varchar(255) with null, jbp_password varchar(255) with null, jbp_realemail varchar(255) with null, jbp_fakeemail varchar(255) with null, jbp_regdate date with null, jbp_viewrealemail tinyint with null, jbp_enabled tinyint with null, primary key (jbp_uid))
20:26:45,107 ERROR [SchemaExport] CREATE TABLE: A column in a UNIQUE constraint has been defined as WITH NULL (on table 'jbp_users').
All columns in a UNIQUE constraint MUST be created as NOT NULL.
20:27:04,904 ERROR [SchemaUpdate] Unsuccessful: create table JBP_OBJECT_NODE (PK bigint not null, PATH varchar(255) with
null unique, NAME varchar(255) with null, PARENT_KEY bigint with null, primary key (PK))
20:27:04,904 ERROR [SchemaUpdate] CREATE TABLE: A column in a UNIQUE constraint has been
defined as WITH NULL (on table 'jbp_object_node').
20:27:04,904 ERROR [SchemaUpdate] Unsuccessful: alter table JBP_OBJECT_NODE add constraint FKCE6C8F5B8083A928 foreign ke
y (PARENT_KEY) references JBP_OBJECT_NODE
20:27:04,920 ERROR [SchemaUpdate] Unsuccessful: alter table JBP_OBJECT_NODE_SEC add constraint FK9CBBD94DD209E280 foreig
n key (NODE_KEY) references JBP_OBJECT_NODE
20:27:04,920 ERROR [SchemaUpdate] Unsuccessful: alter table JBP_PORTAL_OBJECT add constraint FKC8EFEC8B8F1445D9 foreign
key (PK) references JBP_OBJECT_NODE
-------------------------------------------
Almost all are related to: trying to create a table having a WITH NULL column definition and same column is part of UNIQUE constrain. What should be done? How does portal hibernate generate this CREATE TABLE commands? Is it from some mapping XML files?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4067073#4067073
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4067073
18Â years, 9Â months