Meaningless Drivel is fun!*
The moose likes Oracle/OAS and the fly likes OC4J deploment problem Leaked Connection Related Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "OC4J deploment problem Leaked Connection Related" Watch "OC4J deploment problem Leaked Connection Related" New topic
Author

OC4J deploment problem Leaked Connection Related

Sean Nell
Greenhorn

Joined: Feb 03, 2005
Posts: 6
Hi guys,

Can someone please help out?

I'm having problems trying to get an application deployed on my test OC4J application server. Running SQL server 2000.

Keep getting : Marked rollback from enlistresource after it initializes Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)

Then it says : LogicalDriverManagerXAConnection not closed, check code!

I've tried a few things from google searches but still no luck.

Thanking you in anticipation
Sean
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1131

Sean,
Launch OC4J (stand-alone) like so:

Good Luck,
Avi.
Sean Nell
Greenhorn

Joined: Feb 03, 2005
Posts: 6
Hi Avi,

Thanks for your suggestion. I tried it and obviously had a lot work information to work with.

I have now finally discovered that there is a serious TCP/IP problem on my notebook. SQL Server 2000 is running with the correct drivers installed and changing the TCP/IP port in the network utility doesn't help either. On doing a port scan i found that only the application server as well as the windows default ones that get used gets displayed. SQL Server as well as a few other applications that open ports don't get listed under TCP/IP. Reinstalling it and resetting the TCP/IP stack did not fix the problem either.

Datasource
==========

<data-source
class="com.evermind.sql.DriverManagerDataSource"
name="jdbc/Sonora"
location="jdbc/Sonora"
xa-location="jdbc/xa/SonoraXADS"
pooled-location="jdbc/Sonora"
ejb-location="jdbc/Sonora"
connection-driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
username="sa"
password="sa"
url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=SONORA;selectMethod=cursor"
inactivity-timeout="30"
max-connections="200"
min-connections="3"
wait-timeout="10"
max-connect-attempts="10"
/>

Trace Debug Console
===================

Created new physical connection: com.evermind.sql.DriverManagerXAConnection@f864fe
null: Connection com.evermind.sql.DriverManagerXAConnection@f864fe allocated (Pool size: 0)
06/04/14 07:36:34 new DebugConnection(2)
jdbc:microsoft:sqlserver://localhost:1433;databaseName=SONORA;selectMethod=cursor: Opened connection
06/04/14 07:36:35 Error connecting to database:
06/04/14 07:36:35 Retrying 2 times more...
jdbc:microsoft:sqlserver://localhost:1433;databaseName=SONORA;selectMethod=cursor: Opened connection
06/04/14 07:36:37 Error connecting to database:
06/04/14 07:36:37 Retrying 1 times more...
jdbc:microsoft:sqlserver://localhost:1433;databaseName=SONORA;selectMethod=cursor: Opened connection
06/04/14 07:36:39 Error connecting to database:
jdbc:microsoft:sqlserver://localhost:1433;databaseName=SONORA;selectMethod=cursor: Opened connection
06/04/14 07:36:41 Error connecting to database:
06/04/14 07:36:41 Marked rollback from enlistresource
06/04/14 07:36:41 closing DebugConnection(1)
06/04/14 07:36:42 Oracle Application Server Containers for J2EE 10g (9.0.4.0.0) initialized

Thanks and Regards
Sean
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: OC4J deploment problem Leaked Connection Related