Re: Warning when using Apache Derby

[Kristian Waagan <kr...@oracle.com>]

On 24.03.11 14:49, Pavel Bernshtam wrote:
> Hi, I have a number of unit tests, which use Apache Derby in memory.
> My connection url is: jdbc:derby:memory:srf.derby;create=true
>
> I discovered that each time, when a method marked as @Transactional is
> finishing, I receive a Derby warning
>
> 12:53:28:5328 [org.hibernate.util.JDBCExceptionReporter] [main] WARN
> - SQL Warning: 10000, SQLState: 01J01
> 12:53:28:5328 [org.hibernate.util.JDBCExceptionReporter] [main] WARN
> - Database 'memory:srf.derby' not created, connection made to existing
> database instead.
>
> Why is it? What I'm doing wrong?

Hello Pavel,

You get this warning because you have specified "create=true" in the 
connection URL when connecting to an existing database.
You can:
  a) Ignore the warning.
  b) Create the database once, and then have the unit tests connect to 
the existing database without specifying "create=true".
  c) Delete the in-memory database and re-create it for each unit test. 
Deleting it is done by specifying "drop=true".

See also http://wiki.apache.org/db-derby/InMemoryBackEndPrimer [1].


Regards,
-- 
Kristian

[1] May be down at the moment, but will hopefully be back online any time.

> Thank you
>