Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

OC4J deploment problem Leaked Connection Related

 
Sean Nell
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sean,
Launch OC4J (stand-alone) like so:

Good Luck,
Avi.
 
Sean Nell
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic