Apache Derby -它是否支持'WITH‘

WITH temp_table (column1, column2) AS (
  SELECT column1, column2 FROM your_table WHERE some_condition
)
SELECT * FROM temp_table WHERE another_condition;

Properties props = new Properties();
props.put("derby.experimental.xa", "true");
Connection conn = DriverManager.getConnection("jdbc:derby:your_database;create=true", props);