我想在网络服务器模式下使用Derby,并遵循他们网站上的说明。
启动derby:
/opt/glassfish/4.0/javadb/bin/NetworkServerControl start -noSecurityManager
Sun Apr 13 23:47:57 CEST 2014 : Apache Derby Network Server - 10.9.1.0 - (1344872) started and ready to accept connections on port 1527
使用ij进行连接
$ /opt/glassfish/4.0/javadb/bin/ij
ij
我有一个查询,连接3个表(响应者、救护车和cads*)。我试图为每个电话显示最快的响应时间:
*民航处是指紧急召唤
SELECT cads.date, cads.cad_id, LEAST(TIMESTAMPDIFF(SECOND,cads.date, responders.arrival_time),TIMESTAMPDIFF(SECOND,cads.date,ambulances.incident_arrival_time)) AS time
FROM cads
LEFT OUTER JOIN responders ON cads.cad_id = responders.cad_id
LE