Mailing-List: contact jdo-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: jdo-user@db.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Date: Fri, 12 Dec 2008 10:19:41 -0800
From: Craig L Russell <Craig.Russell@Sun.COM>
Subject: Re: Strange problem: timeout first time, then ok
In-reply-to: <20922247.post@talk.nabble.com>
Sender: Craig.Russell@Sun.COM
To: Apache JDO project <jdo-dev@db.apache.org>, jdo-user@db.apache.org
Message-id: <52C6C5F2-AD0E-4057-A0B8-6AFA53A1E4E6@SUN.com>
MIME-version: 1.0
Content-type: text/plain; delsp=yes; format=flowed; charset=US-ASCII
Content-transfer-encoding: 7BIT
References: <20922247.post@talk.nabble.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!