Z
Z
zugzug2015-09-10 19:37:21
Java
zugzug, 2015-09-10 19:37:21

How to connect to H2/SQLite DB in Play! Framework?

Hello. I'm trying to use persistent storage in the project, as a database - H2 in a file or SQLite. With the following settings:

db.default.driver=org.h2.Driver
db.default.url="jdbc:h2:tcp://localhost/d:/play-1.2.7/samples-and-tests/zencontact/db.sqlite"

And also such
db.default.driver=org.h2.Driver
db.default.url="jdbc:h2:db.sqlite"

And even such
db.default.driver=org.h2.Driver
db.default.url="jdbc:h2:/d:/play-1.2.7/samples-and-tests/zencontact/db.sqlite"

The result is the same:
JPA error

A JPA error occurred (Cannot start a JPA manager without a properly configured database): No datasource configured

At the same time, there is a file, it is an empty db.sqlite file, located along the path:
d:/play-1.2.7/samples-and-tests/zencontact/db.sqlite

The database file is empty - 0 bytes. Those. I don't even know how it belongs to one or another DBMS. Do I need to create a file with some structure before doing this? And how is it done?
I did not find similar instructions on how to correctly connect all the same SQLite / H2 database to Play! Framework versions 1.x in a Windows environment.
OS: Windows 7.
JDK: 1.7_079
Play! versions: 1.2.7
Question: what am I doing wrong, and how to connect any of the two databases: sqlite or H2 persistent (file)? Thank you!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Artem, 2015-09-11
@mrRontgen

One and two . For your version of the play, everything is described in detail and should work. If you still can't find the datasource, then
And if it doesn’t work in this case either (which I doubt very much, since all this worked for me a long time ago), then stack traces to the studio!

Similar questions
K
KhanTengri2011-06-17 23:56:41
Get from a remote web page?</a> <a class="content__item-button" href="/q/get-title-from-a-remote-web-page"> <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewBox="0 0 16 16" class=""> <path fill-rule="evenodd" d="M15 14a1.002 1.002 0 01-1.703.71h-.004l-.003-.01-1.704-1.7H3c-1.104 0-2-.9-2-2V3c0-1.1.896-2 2-2h10c1.104 0 2 .9 2 2v11zM5 6c.552 0 1 .45 1 1s-.448 1-1 1-1-.45-1-1 .448-1 1-1zm3 0c.552 0 1 .45 1 1s-.448 1-1 1-1-.45-1-1 .448-1 1-1zm3 0c.552 0 1 .45 1 1s-.448 1-1 1-1-.45-1-1 .448-1 1-1z"></path> </svg> <span class="dark">6</span><span class="dn">Reply</span> </a> </div> </div><div class="content__item"> <div class="content__item-img name-color-M"> <span>M</span></div> <div class="content__item-content"> <div class="content__item-row"> <a href="/q/why-are-android-apps-written-in-java">Mark Rosenthal</a><span>2015-10-14 12:43:46</span></div> <a class="content__item-title similar" href="/q/why-are-android-apps-written-in-java">Why are Android apps written in Java?</a> <a class="content__item-button" href="/q/why-are-android-apps-written-in-java"> <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewBox="0 0 16 16" class=""> <path fill-rule="evenodd" d="M15 14a1.002 1.002 0 01-1.703.71h-.004l-.003-.01-1.704-1.7H3c-1.104 0-2-.9-2-2V3c0-1.1.896-2 2-2h10c1.104 0 2 .9 2 2v11zM5 6c.552 0 1 .45 1 1s-.448 1-1 1-1-.45-1-1 .448-1 1-1zm3 0c.552 0 1 .45 1 1s-.448 1-1 1-1-.45-1-1 .448-1 1-1zm3 0c.552 0 1 .45 1 1s-.448 1-1 1-1-.45-1-1 .448-1 1-1z"></path> </svg> <span class="dark">8</span><span class="dn">Reply</span> </a> </div> </div> </div> </div> </div> <div class="content find"> <p class="find__p">Didn't find what you were looking for?</p><a class="find__btn" href="#!">Ask your question</a> </div> <div class="find sm"> <p class="find__title">Ask a Question </p> <form class="find__form" action="#!"> <input class="find__input" type="text" placeholder="Ask your question here"> <button class="find__btn" type="submit"> <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 16 16" class="nBqR1"><path fill-rule="evenodd" d="M12.696 7.256L9.657 4.217a1 1 0 00-1.415 1.414l1.344 1.344H3.949a1.001 1.001 0 000 2h5.637l-1.344 1.343a1.002 1.002 0 000 1.415c.391.39 1.024.39 1.415 0l3.039-3.04A.993.993 0 0013 7.975a.997.997 0 00-.293-.708l-.011-.011z"></path></svg></button> </form> <p class="find__span">731 491 924 answers to any question</p> </div> </div> <aside class="banners"> <p>banners </p> </aside> </div> </main> </div> <script src="/assets/theme/js/highlight/highlight.min.js"></script> <script src="/assets/theme/js/app.min.js?_v=20220404145216"> </script> <script>hljs.highlightAll();</script> </body> </html>