Strange timeout problem

[jamh <ja...@bccampus.ca>]

Hello,

I am running into something quite odd, and wanted to see if anyone could
shed light on this.  I have defined two persistence beans as:

<spring:bean id="certPersistFactory" scope="singleton"
class="org.springframework.orm.jdo.LocalPersistenceManagerFactoryBean">
          <spring:property name="jdoProperties">
            <spring:props>
                <spring:prop
key="javax.jdo.PersistenceManagerFactoryClass">org.jpox.jdo.JDOPersistenceManagerFactory
</spring:prop>
                <spring:prop
key="javax.jdo.option.ConnectionURL">jdbc:sqlserver://1.2.3.4:1433;DatabaseName=dbcert;SelectMethod=cursor</spring:prop>
                <spring:prop
key="javax.jdo.option.ConnectionUserName">user1</spring:prop>
                <spring:prop
key="javax.jdo.option.ConnectionPassword">passwd1</spring:prop>
                <spring:prop
key="javax.jdo.option.ConnectionDriverName">com.microsoft.sqlserver.jdbc.SQLServerDriver
</spring:prop>
                <spring:prop
key="javax.jdo.option.NontransactionalWrite">true</spring:prop>
                <spring:prop
key="org.jpox.identifier.case">PreserveCase</spring:prop>
                <spring:prop
key="org.jpox.fixedDatastore">true</spring:prop>
                <spring:prop
key="org.jpox.validateTables">false</spring:prop>
            </spring:props>
          </spring:property>
        </spring:bean>

<spring:bean id="prodPersistFactory" scope="singleton"
class="org.springframework.orm.jdo.LocalPersistenceManagerFactoryBean">
          <spring:property name="jdoProperties">
            <spring:props>
                <spring:prop
key="javax.jdo.PersistenceManagerFactoryClass">org.jpox.jdo.JDOPersistenceManagerFactory
</spring:prop>
                <spring:prop
key="javax.jdo.option.ConnectionURL">jdbc:sqlserver://1.2.3.4:9546;DatabaseName=dbcert;SelectMethod=cursor</spring:prop>
                <spring:prop
key="javax.jdo.option.ConnectionUserName">user2</spring:prop>
                <spring:prop
key="javax.jdo.option.ConnectionPassword">passwd2</spring:prop>
                <spring:prop
key="javax.jdo.option.ConnectionDriverName">com.microsoft.sqlserver.jdbc.SQLServerDriver
</spring:prop>
                <spring:prop
key="javax.jdo.option.NontransactionalWrite">true</spring:prop>
                <spring:prop
key="org.jpox.identifier.case">PreserveCase</spring:prop>
                <spring:prop
key="org.jpox.fixedDatastore">true</spring:prop>
                <spring:prop
key="org.jpox.validateTables">false</spring:prop>
            </spring:props>
          </spring:property>
        </spring:bean>

So the first strange thing is that if I reverse their order, ie. if I have
the prod bean precede the cert bean, the app won't start, ie. it gives me a
socket error.

The second strange thing is that with the above, all operations to the cert
bean work flawlessly, but operations to the prod bean give me a timeout the
first time, but then after that, they work ever after.

If I restart the app, again the first operation on the prod bean times out,
and after that it works.

PS: if I have two beans that both run on the same port but different hosts,
everything works fine.  The two databases are set up identically.

What is going on?
Any help is appreciated.
-- 
View this message in context: http://www.nabble.com/Strange-timeout-problem-tp20923897p20923897.html
Sent from the JDO - User mailing list archive at Nabble.com.

Re: Strange timeout problem

[jamh <ja...@bccampus.ca>]

jamh wrote:
> 
> Hello,
> 
> I am running into something quite odd, and wanted to see if anyone could
> shed light on this.  I have defined two persistence beans as:
> [...]
> 
> 

Issue solved.  Sqlserver's mirroring setup was responsible for the strange
behavior.

-- 
View this message in context: http://www.nabble.com/Strange-timeout-problem-tp20923897p20983415.html
Sent from the JDO - User mailing list archive at Nabble.com.