OC4J deploment problem Leaked Connection Related

[Sean Nell]

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]

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

java -Ddatasource.verbose=true -Djdbc.debug=true -jar oc4j.jar -verbosity 10

Good Luck,
Avi.

[Sean Nell]

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