db-jdo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Craig L Russell <Craig.Russ...@Sun.COM>
Subject Re: Strange problem: timeout first time, then ok
Date Fri, 12 Dec 2008 18:19:41 GMT
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!


Mime
View raw message