是的,Apache Derby自带了SAMP示例数据。您可以通过以下步骤访问:
java -jar $DERBY_HOME/lib/derbyrun.jar server start
mkdir samp-data cd samp-data
java -cp $DERBY_HOME/lib/derbyrun.jar org.apache.derby.samples.SampUtil install
java -jar $DERBY_HOME/lib/derbyrun.jar ij
将会看到Derby连接提示符:
ij>
connect 'jdbc:derby://localhost:1527/samp';
select * from samp.observation fetch first 5 rows only;
输出将类似于以下内容:
1 |2001-07-04
2 |2000-02-29
3 |2002-01-01
4 |2002-04-02
5 |2001-01-01
此时您就可以在Apache Derby的SAM模式中访问示例数据。