Eclipse Community Forums: EclipseLink » Relative Path to JDBC-Url

Help

Home

Home » Eclipse Projects » EclipseLink » Relative Path to JDBC-Url

Show: Today's Messages :: Show Polls :: Message Navigator

Relative Path to JDBC-Url [message #721772]

Fri, 02 September 2011 20:18

Matthias Wegner

Messages: 8
Registered: September 2011

Junior Member

Hi,

do you know how i can make

<property name="javax.persistence.jdbc.url" value="jdbc:derby:C:\Database\WikiDB;create=true"/>

to the database WikiDB relative? I want to create the database in the User.Dir of the application which should be placed on a usb-device, so i need a relative path to the database.

This is maybe a simple question to JPA, but i dont know how to solve it, so i just post it here because i use EclipseLink. Since two months i am new to JPA, so at the moment i am really happy that my Application is doing what i am expecting Wink

I bought books to learn it, but they are not answering all my questions.

Regards,
Matthias

Report message to a moderator

Re: Relative Path to JDBC-Url [message #722694 is a reply to message #721772]

Tue, 06 September 2011 14:25

Chris Delahunt

Messages: 1389
Registered: July 2009

Senior Member

Hello,

The connection information is used by the JDBC driver, so you need to look at your JDBC driver for how this is done. I've never tried it, but Derby says its possible here:
http://db.apache.org/derby/manuals/develop/develop14.html

Best Regards,
Chris

Report message to a moderator

(no subject) [message #722697 is a reply to message #721772]

Tue, 06 September 2011 14:25

Chris Delahunt

Messages: 1389
Registered: July 2009

Senior Member

Report message to a moderator

Re: Relative Path to JDBC-Url [message #797421 is a reply to message #721772]

Mon, 13 February 2012 13:17

Glenn Williams

Messages: 1
Registered: February 2012

Junior Member

This is what I use on Windows to accomplish something similar to what you are after:

persistence.xml
---------------
<properties>
<property name="javax.persistence.jdbc.driver" value="org.apache.derby.jdbc.EmbeddedDriver" />
<property name="javax.persistence.jdbc.url" value="jdbc:derby:myDB;create=true" />
<property name="javax.persistence.jdbc.user" value="user" />
<property name="javax.persistence.jdbc.password" value="password" />
<property name="eclipselink.logging.level" value="FINE"/>
</properties>

Java Code
---------
.
System.setProperty("derby.system.home", System.getProperty("user.home"));
.
database access code
.

The database access code will use the Derby database 'myDB' in the user's home directory.

Hope that helps!

Glenn

Report message to a moderator

Previous Topic:	Validation to DDL constraint
Next Topic:	EclipseLink JPA Multi-Tenancy - Bidirectional OneToOne - ArrayIndexOutOfBoundsException

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 04:07:46 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter