title: apache derby termporary table accessible to multiple connections?
body: <p>Apache derby allows the creation of global temporary tables, but it appears that these tables are only accessible to the connection/session which created the temporary table.  </p>
  
  <p>Our system uses connection pooling, and there is no guarantee the the next query will use the same connection.  Is there anyway to define a temporary table as "global" in the sense that it is accessible to all connections to that database?</p>
  
  <p>The docs state :  "The DECLARE GLOBAL TEMPORARY TABLE statement defines a temporary table for the current connection."</p>
  
  <p>It is not clear what "global" means in this context.  Link to docs : <a href="https://db.apache.org/derby/docs/10.2/ref/rrefdeclaretemptable.html" rel="nofollow noreferrer">https://db.apache.org/derby/docs/10.2/ref/rrefdeclaretemptable.html</a></p>