db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@gmail.com>
Subject Re: Is create=true thread-safe?
Date Fri, 20 Mar 2020 12:39:41 GMT
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.
>


Mime
View raw message