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

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

Relative Path to JDBC-Url [message #721772]

Fri, 02 September 2011 16:18

Eclipse User

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

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

Tue, 06 September 2011 10:25

Eclipse User

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

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

Tue, 06 September 2011 10:25

Eclipse User

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

Mon, 13 February 2012 08:17

Eclipse User

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

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

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 08:55:54 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter