#67 Windows authentification on SQL Server causes a JVM crash

open
nobody
None
5
2008-06-11
2008-06-11
mathig
No

We use c3p0 with hibernate and spring on MS SQL Server 2005. All was right with default hibernate pool datasource, but since we tried c3p0 we can't use windows authentification (empty user and password).

Running in Tomcat, the JVM crashes :

#
# An unexpected error has been detected by Java Runtime Environment:
#
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x100016c9, pid=3768, tid=1848
#
# Java VM: Java HotSpot(TM) Client VM (10.0-b22 mixed mode windows-x86)
# Problematic frame:
# C [ntlmauth.dll+0x16c9]
#

Here is my c3p0 hibernate config :

<prop key="hibernate.c3p0.acquire_increment">1</prop>
<prop key="hibernate.c3p0.minPoolSize">2</prop>
<prop key="hibernate.c3p0.maxPoolSize">50</prop>
<prop key="hibernate.c3p0.timeout">1800</prop>
<prop key="hibernate.c3p0.max_statement">0</prop>
<prop key="hibernate.c3p0.idle_test_period">30</prop>

Discussion

  • Logged In: NO

    Hi, I put this settings:

    <property name="c3p0.min_size">10</property>
    <property name="c3p0.max_size">100</property>
    <property name="c3p0.timeout">18000</property>
    <property name="c3p0.acquireRetryAttempts">30</property>

    <property name="c3p0.acquireIncrement">5</property>
    <property name="c3p0.automaticTestTable">C3P0TestTable</property>

    <property name="c3p0.idleConnectionTestPeriod">36000</property>

    <property name="c3p0.initialPoolSize">20</property>
    <property name="c3p0.maxPoolSize">100</property>
    <property name="c3p0.maxIdleTime">1200</property>
    <property name="c3p0.maxStatements">50</property>
    <property name="c3p0.minPoolSize">10</property>

    and over sql server is ok, Test

    Atte Edward Ramirez

     
  • Edward Ramirez
    Edward Ramirez
    2008-07-21

    Logged In: YES
    user_id=2154619
    Originator: NO

    Hi, I put this settings:

    <property name="c3p0.min_size">10</property>
    <property name="c3p0.max_size">100</property>
    <property name="c3p0.timeout">18000</property>
    <property name="c3p0.acquireRetryAttempts">30</property>

    <property name="c3p0.acquireIncrement">5</property>
    <property name="c3p0.automaticTestTable">C3P0TestTable</property>

    <property name="c3p0.idleConnectionTestPeriod">36000</property>

    <property name="c3p0.initialPoolSize">20</property>
    <property name="c3p0.maxPoolSize">100</property>
    <property name="c3p0.maxIdleTime">1200</property>
    <property name="c3p0.maxStatements">50</property>
    <property name="c3p0.minPoolSize">10</property>

    and over sql server is ok, Test

    Atte Edward Ramirez

    I remember saying that the test table may be omitted