templates/default/conf/server.xml (the working one)

    <Resource name="${nuxeo.db.commonds}" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="1" maxWait="10000" driverClassName="${nuxeo.db.driver}"
        url="${nuxeo.db.jdbc.url}?tcpKeepAlive=true" validationQuery="${nuxeo.db.validationQuery}"
        username="${nuxeo.db.user}" password="${nuxeo.db.password}" />

templates/postgresql/nxserver/config/default-repository-config.xml (not working)

        <xa-datasource>org.postgresql.xa.PGXADataSource</xa-datasource>
        <property name="ServerName">${nuxeo.db.host}</property>
        <property name="PortNumber">${nuxeo.db.port}</property>
        <property name="DatabaseName">${nuxeo.db.name}</property>
        <property name="User">${nuxeo.db.user}</property>
        <property name="Password">${nuxeo.db.password}</property>
        <property name="TcpKeepAlive">true</property>
        <check-valid-connection-sql>;</check-valid-connection-sql>
        <track-connection-by-tx/>


As we can see by tcp dump the only keep alive packet is referred only to the server.xml datasource. For the repository datasource TcpKeepAlive property has no effect.

[root@prmpas10 ~]# netstat -ntp | grep 5432
tcp        0      0 213.175.5.78:58346          213.175.5.104:5432          ESTABLISHED 32476/java    default-repository-config datasource
tcp        0      0 213.175.5.78:58336          213.175.5.104:5432          ESTABLISHED 32476/java    server.xml datasource
tcp        0      0 213.175.5.78:58343          213.175.5.104:5432          ESTABLISHED 32476/java    default-repository-config datasource

the only keepalive packet (set to 30 seconds) is from 213.175.5.78 (this host) port 58336 and 213.175.5.106 port 5432 (postgres host)

# tcpdump -i eth0 port 5432 -nn
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on eth0, link-type EN10MB (Ethernet), capture size 65535 bytes
11:43:38.450021 IP 213.175.5.78.58336 > 213.175.5.104.5432: Flags [.], ack 715944432, win 501, options [nop,nop,TS val 3095301429 ecr 1315924691], length 0
11:43:38.452905 IP 213.175.5.104.5432 > 213.175.5.78.58336: Flags [.], ack 1, win 501, options [nop,nop,TS val 1315954693 ecr 3095241467], length 0
11:44:08.452023 IP 213.175.5.78.58336 > 213.175.5.104.5432: Flags [.], ack 1, win 501, options [nop,nop,TS val 3095331431 ecr 1315954693], length 0
11:44:08.454896 IP 213.175.5.104.5432 > 213.175.5.78.58336: Flags [.], ack 1, win 501, options [nop,nop,TS val 1315984694 ecr 3095241467], length 0
11:44:38.454018 IP 213.175.5.78.58336 > 213.175.5.104.5432: Flags [.], ack 1, win 501, options [nop,nop,TS val 3095361433 ecr 1315984694], length 0
11:44:38.456866 IP 213.175.5.104.5432 > 213.175.5.78.58336: Flags [.], ack 1, win 501, options [nop,nop,TS val 1316014696 ecr 3095241467], length 0
11:45:08.456019 IP 213.175.5.78.58336 > 213.175.5.104.5432: Flags [.], ack 1, win 501, options [nop,nop,TS val 3095391435 ecr 1316014696], length 0
11:45:08.458886 IP 213.175.5.104.5432 > 213.175.5.78.58336: Flags [.], ack 1, win 501, options [nop,nop,TS val 1316044698 ecr 3095241467], length 0
^C
8 packets captured
8 packets received by filter
0 packets dropped by kernel