The first thread which gets through will create the database and the
others will block until the first thread finishes. I am not aware of any
thead safety issues here. Do you have a test case which suggests otherwise?
Thanks,
-Rick
On 3/19/20 10:24 PM, Behrang Saeedzadeh wrote:
Hi,
Is the create=true attribute
<https://db.apache.org/derby/docs/10.12/ref/rrefattrib26867.html>
thread-safe?
In particular, what would happen if 10 threads at the same time try to
obtain this connection:
DriverManager.getConnection("jdbc:derby:mydb;create=true);
(when Derby is used as an embedded database)? Is this safe?
The docs say:
If the database already exists, the attribute creates a connection to the
existing database, and an *SQLWarning* is issued.
But it is not clear if that implies `create=true` is thread safe.
