You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-dev@db.apache.org by jamh <ja...@bccampus.ca> on 2008/12/09 21:11:01 UTC
Strange problem: timeout first time, then ok
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-problem%3A-timeout-first-time%2C-then-ok-tp20922247p20922247.html
Sent from the JDO - Development mailing list archive at Nabble.com.
Re: Strange problem: timeout first time, then ok
Posted by jamh <ja...@bccampus.ca>.
Thank you, issue is solved. SQLserver's mirroring was responsible for the
behavior.
Craig L Russell wrote:
>
> Hi,
>
> This is probably the wrong forum for this issue. You might try the
> datanucleus forum at http://www.jpox.org/servlet/forum/index
>
> Regards,
>
> Craig
>
> On Dec 9, 2008, at 12:11 PM, 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:
>>
>> <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-problem%3A-timeout-first-time%2C-then-ok-tp20922247p20922247.html
>> Sent from the JDO - Development mailing list archive at Nabble.com.
>>
>
> Craig L Russell
> Architect, Sun Java Enterprise System http://db.apache.org/jdo
> 408 276-5638 mailto:Craig.Russell@sun.com
> P.S. A good JDO? O, Gasp!
>
>
>
--
View this message in context: http://www.nabble.com/Re%3A-Strange-problem%3A-timeout-first-time%2C-then-ok-tp20980900p20983445.html
Sent from the JDO - User mailing list archive at Nabble.com.
Re: Strange problem: timeout first time, then ok
Posted by Craig L Russell <Cr...@Sun.COM>.
Hi,
This is probably the wrong forum for this issue. You might try the
datanucleus forum at http://www.jpox.org/servlet/forum/index
Regards,
Craig
On Dec 9, 2008, at 12:11 PM, 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:
>
> <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-problem%3A-timeout-first-time%2C-then-ok-tp20922247p20922247.html
> Sent from the JDO - Development mailing list archive at Nabble.com.
>
Craig L Russell
Architect, Sun Java Enterprise System http://db.apache.org/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!
Re: Strange problem: timeout first time, then ok
Posted by 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 is solved. The sqlserver's mirroring software was incorrectly set up.
--
View this message in context: http://www.nabble.com/Strange-problem%3A-timeout-first-time%2C-then-ok-tp20922247p20983392.html
Sent from the JDO - Development mailing list archive at Nabble.com.
Re: Strange problem: timeout first time, then ok
Posted by Craig L Russell <Cr...@Sun.COM>.
Hi,
This is probably the wrong forum for this issue. You might try the
datanucleus forum at http://www.jpox.org/servlet/forum/index
Regards,
Craig
On Dec 9, 2008, at 12:11 PM, 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:
>
> <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-problem%3A-timeout-first-time%2C-then-ok-tp20922247p20922247.html
> Sent from the JDO - Development mailing list archive at Nabble.com.
>
Craig L Russell
Architect, Sun Java Enterprise System http://db.apache.org/jdo
408 276-5638 mailto:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!