db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <kristian.waa...@oracle.com>
Subject Re: Cannot setup in-memory embedded derby
Date Thu, 15 Jul 2010 10:47:54 GMT
On 15.07.10 11:37, Sergey Ponomarev wrote:
> Hi, help please.
>
> I'm trying to use in-memory derby, but get "database 'login' not 
> found" error (java.sql.SQLException: Error in allocating a connection. 
> Cause: Connection could not be allocated because: База данных 'login' 
> не найдена.)
>
> I've included derby,jar to classpath, specified connection URL 
> "jdbc:derby:memory:login;create=true", can't understand what am i 
> doing wrong.
>
> create=true, so i suggest it should create and find it, but it 
> doesn't. Did not find anything useful in google.

Hi Sergey,

I'm not sure, but I think your data source definition is invalid.
Probably DatabaseName takes precedence over URL (I'm not even sure Derby 
will use the URL property?).
If you remove URL, you should be able to add the following:

<property name="Create" value="create" />
<property name="DatabaseName" value="memory:login" />

Alternatively, if the create property doesn't work, you can maybe use 
this instead:
<property name="ConnectionAttributes" value="create=true" />


Hope this helps,
-- 
Kristian

>
> Here is the configuration:
> domain.xml
> =======================
> <jdbc-connection-pool 
> datasource-classname="org.apache.derby.jdbc.EmbeddedDataSource" 
> res-type="javax.sql.DataSource" name="TestPool">
> <property name="URL" value="jdbc:derby:memory:login;create=true" />
> <property name="driverClass" 
> value="org.apache.derby.jdbc.EmbeddedDriver" />
> <property name="DatabaseName" value="login" />
> <property name="User" value="" />
> <property name="Password" value="" />
> </jdbc-connection-pool>
> <jdbc-resource pool-name="TestPool" jndi-name="jdbc/loginService" />
> =========================
>
> persistence.xml
> =================================
> <?xml version="1.0" encoding="UTF-8"?>
> <persistence version="2.0" 
> xmlns="http://java.sun.com/xml/ns/persistence" 
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence 
> http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
> <persistence-unit name="LoginServicePU" transaction-type="JTA">
> <provider>org.hibernate.ejb.HibernatePersistence</provider>
> <jta-data-source>jdbc/loginService</jta-data-source>
> <exclude-unlisted-classes>false</exclude-unlisted-classes>
> <properties>
> <property name="hibernate.hbm2ddl.auto" value="update"/>
> </properties>
> </persistence-unit>
> </persistence>
> ===================================
>
> I'm a newbie, please don't blame me, any help is very appreciated. 
> Thank you.
>


Mime
View raw message