• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

OC4J deploment problem Leaked Connection Related

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 1143
1
Eclipse IDE Oracle Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic