Skip to Main Content

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[JBossManagedConnectionPool] Exception destroying ManagedConnection

527078Sep 14 2006 — edited Jan 17 2007
Hi,

I'm working on JE/JCA. When i commit the Transaction i got the following exception.

In JCA Enviornment which transaction should i commit or abort?

17:46:28,155 WARN [JBossManagedConnectionPool] Destroying connection that could not be successfully matched: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@10713e3[state=NORMAL mc=com.sleepycat.je.jca.ra.JEManagedConnection@11357e9 handles=0 lastUse=1158236185532 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@f09710 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@14db697 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@10e838f txSync=null]
17:46:28,245 WARN [JBossManagedConnectionPool] Exception destroying ManagedConnection org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@10713e3[state=DESTROYED mc=com.sleepycat.je.jca.ra.JEManagedConnection@11357e9 handles=0 lastUse=1158236185532 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@f09710 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@14db697 xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@10e838f txSync=null]
javax.resource.ResourceException: com.sleepycat.je.DatabaseException: (JE 3.0.12) There is 1 existing transaction opened against the Environment.
Aborting open transactions ...

at com.sleepycat.je.jca.ra.JEManagedConnection.destroy(JEManagedConnection.java:190)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.java:570)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:207)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:454)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:324)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:301)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:379)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:812)
at com.sleepycat.je.jca.ra.JEConnectionFactoryImpl.getConnection(JEConnectionFactoryImpl.java:56)
at com.sleepycat.je.jca.ra.JEConnectionFactoryImpl.getConnection(JEConnectionFactoryImpl.java:43)
at com.tka.util.BerkelyDBUtil.getConnection(BerkelyDBUtil.java:203)
at com.tka.command.admin.BuildLuceneIndexCommand.executeRequest(BuildLuceneIndexCommand.java:106)
at com.tka.command.BaseCommand.execute(BaseCommand.java:82)
at com.tka.services.lucene.IndexControllerEJB.processRequest(IndexControllerEJB.java:102)


Thanks for any help.

reddy

Message was edited by:
user524075

Comments

Evandro Lima-Oracle

Hello, as you did not specify much, I leave here a link hint that can at least give you an idea of the options you have to upload files to the Database, hope it helps.

https://blogs.oracle.com/searchtech/loading-documents-and-other-file-data-into-the-oracle-database

Regards

CJ Bell

I am using the file browser item on a form as below

pastedImage_0.png

When the user selects the file I want the file to be uploaded to my table

The table i want the file to be uploaded to is not the table the form is based on I want to use the KEY field on the form to link to the other table

I also want to be able to load multiple files

I used to have a working version that used www_flow_files table then we copied the file from there - but this table doesn't exist now

I see that it uploads to APEX_APPLICATION_TEMP_FILES but when I check that table there is nothing there

hopefully thats a bit more detail

fac586

CJ Bell wrote:

I am using the file browser item on a form as below

pastedImage_0.png

When the user selects the file I want the file to be uploaded to my table

The table i want the file to be uploaded to is not the table the form is based on I want to use the KEY field on the form to link to the other table

I also want to be able to load multiple files

I used to have a working version that used www_flow_files table then we copied the file from there - but this table doesn't exist now

I see that it uploads to APEX_APPLICATION_TEMP_FILES but when I check that table there is nothing there

Note the "TEMP" in that table name. Files are only stored in APEX_APPLICATION_TEMP_FILES temporarily, with their lifetime being determined by setting the file browse item Purge File at property. The default option is End of Session, which stores the file until the end of the current APEX session. The other option is End of Request, which only holds the file for the duration of accept processing for the current page submission.

When are you checking for the files and what did the previously working version actually do? There is no reason why this shouldn't work if the file is copied to the target table at the appropriate time.

CJ Bell

I had something like this example previously

Use APEX to Create the File Browse Item - Create Upload Button

I set the purge file setting at session level then checked the table in SQLDeveloper after clicking apply changes and nothing was in there

fac586
Answer

CJ Bell wrote:

I had something like this example previously

Use APEX to Create the File Browse Item - Create Upload Button

Now very out of date (and not a source that I would recommend anyway).

I set the purge file setting at session level then checked the table in SQLDeveloper after clicking apply changes and nothing was in there

How were you connected to SQL Developer? APEX_APPLICATION_TEMP_FILES is a synonym for WWV_FLOW_TEMP_FILES, which is actually a session-dependent view. You would only see any data from within the same APEX session or when connected with elevated DBA or APEX_ADMINISTRATOR_ROLE privileges.

Marked as Answer by CJ Bell · Sep 27 2020
CJ Bell

I was in SQLDeveloper connected as The schema owner

I see what you mean , I will try and copy from that table to my local table using a process on the form thats in the session

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 12 2006
Added on Sep 14 2006
1 comment
3,940 views