The Java DB 10.5.3.0 maintenance release is now available for download. Java DB is a free, fast, robust, full-featured pure Java database that fits in a 2.5MB JAR file.
Active5 years, 4 months ago
I downloaded the jar of Core Apache Derby database engine, which also includes the embedded JDBC driver (10.9.1.0). But that jar doesn't include the
.class file of ClientDriver in the jdbc package. Why is that ? Where can i find this class file ? I need this file to connect to derby database from tomcat as the server.
Please provide the download link of the complete jar so that i get the required saplingProsaplingPro
.class file.
7,8674949 gold badges119119 silver badges178178 bronze badges
2 Answers
OK: have you looked on the Apache Derby page:
Download db-derby-10.9.1.0-bin.zip
It contains many files, including
derby.jar and derbyclient.jar (along with much documentation). https://kiteclever232.weebly.com/idm-with-crack-zip-free-download.html.
derbyclient.jar contains our friend org.apache.derby.jdbc.ClientDriver.class
12.6k99 gold badges5252 silver badges9090 bronze badges
paulsm4paulsm4
83.9k1010 gold badges111111 silver badges138138 bronze badges
@Paulsm4 is correct.
But please keep in mind also that:
org.apache.derby.jdbc.ClientDriver
which can be found inside derbyclient.jar is enough to just obtain connection to the running Derby DB server.
![]()
But if you would like to create embedded (in memory) database when obtaining connection, then you have to use different jdbc driver:
org.apache.derby.jdbc.EmbeddedDriver
which can be found inside derby.jar. Moreover, additional parameter
create=true has to be passed. For example:
Hope it helps somebody.
G. DemeckiG. Demecki
7,15922 gold badges4141 silver badges4949 bronze badges
Not the answer you're looking for? Browse other questions tagged javajava-eetomcatjdbcderby or ask your own question.
Active8 months ago
I intend to develop a small (Java) application for managing my finances. I believe I need to use an embedded database, but I have no experience regarding this issue. I tried to look at some of the available products, but I can't decide which one would be more suitable for me. H2, HSQLDB, Derby and Berkeley DB seem to be good candidates, but I still don't see how they compare to each other. I appreciate your help comparing them and helping me decide which one to use.
I intend to use Hibernate for my application (unless you would recommend using DBMS-provided API), but I also want to have the ability to edit the database easily using a SQL browsing tool (modifying schema and changing data).
Thank you.
Hosam AlyHosam Aly
25.8k3434 gold badges124124 silver badges175175 bronze badges
closed as off-topic by kleopatra, Robin Green, Unsigned, Anatoliy Nikolaev, Jeremy SmythJan 12 '14 at 11:13
This question appears to be off-topic. The users who voted to close gave this specific reason:
18 Answers
Either
or
Which one you use is up to you, depending how much performance and how much stability you need.
The developer of H2 has put up a nice performance evaluation: Sven LilienthalSven Lilienthal
http://www.h2database.com/html/performance.html
4,91844 gold badges2525 silver badges2525 bronze badges
I use Apache Derby for pretty much all of my embedded database needs. You can also use Sun's Java DB that is based on Derby but the latest version of Derby is much newer. It supports a lot of options that commercial, native databases support but is much smaller and easier to embed. I've had some database tables with more than a million records with no issues.
I used to use HSQLDB and Hypersonic about 3 years ago. It has some major performance issues at the time and I switch to Derby from it because of those issues. Derby has been solid even when it was in incubator at Apache.
Chris DailChris Dail
21.2k99 gold badges5858 silver badges7272 bronze badges
I needed to use Java embedded database in one of my projects and I did lot of research understanding pros and cons of each database. I wrote a blog listing pros and cons of popular embedded java databases (H2, HSQLDB, Derby, ObjectDB, Neo4j, OrientDB), you can have a look at it. I chose H2 as I thought it best suited my requirements.Link for the blog: http://sayrohan.blogspot.in/2012/12/choosing-light-weight-java-database.htmlHope it helps!
Rohan KarwaRohan Karwa
I'd go with H2, the performance is meant to much better than Derby. Read http://www.h2database.com/html/performance.html for more info.
K2JK2J
1,20344 gold badges1616 silver badges2828 bronze badges
HSQLDB is a good candidate (the fact that it is used in OpenOffice may convinced some of you), but for such a small personnal application, why not using an object database (instead of a classic relationnal database) ?
I used DB4O in one of my projects, and I'm very satisfied with it. Being object-oriented, you don't need the whole Hibernate layer, and can directly insert/update/delete/query objects ! Moreover, you don't need to worry about the schema, you directly work with the objects and DB4O does the rest !
Java Db Embedded Driver Download
I agree that it may take some time to get used to this new type of database, but check the DB40 tutorial to see how easy it makes working with the DB !
EDIT: As said in the comments, DB4O handles automatically the newer versions of the classes. Moreover, a tool for browsing and updating the database outside of the application is available here : http://code.google.com/p/db4o-om/
WookaiWookai
13.5k1313 gold badges6666 silver badges8383 bronze badges
Java DB (Sun's distribution of Apache Derby) now ships in JDK 6!
I've been wanted to do something like Jason Cohen and have been thinking this looks like the easiest way being in the JDK distro (which of last week is now a requirement for my app). Or maybe I am just lazy that way.
Dan Halbert
2,10522 gold badges2121 silver badges2222 bronze badges
Stu ThompsonStu Thompson
31.1k1818 gold badges101101 silver badges150150 bronze badges
We use HSQLDB in production as a 'no-configuration' option for our application. It allows people to trial without the hassle of setting up a real database.
However we do not support it for normal use. The reasons are several:
For at least (2) and (3), there are ways around it but it's difficult; it's much easier to e.g. install MySQL.
Jason CohenJason Cohen
60.8k2626 gold badges102102 silver badges110110 bronze badges
neo4j is:
an embedded, disk-based, fully transactional Java persistence engine that stores data structured in graphs rather than in tables
I haven't had a chance to try it yet - but it looks very promising. Note this is not an SQL database - your object graph is persisted for you - so it might not be appropriate for your existing app.
devstopfixdevstopfix
5,62044 gold badges2525 silver badges3030 bronze badges
Good comparison tool can be found here: http://www.jpab.org/All/All/All.html
Notice also the Head to Head DBMS/JPA Comparisons
Mongo Db Embedded Documents
Uros MajericUros Majeric
I am a big fan of DB4O for both .Net and Java.
Performance has become much better since the early releases. The licensing model isnt too bad, either. I particularly like the options available for querying your objects. Query by example is very powerful and easy to get used to.
Kilhoffer
Java DbKilhofferJava Db Sign
21.5k2020 gold badges9090 silver badges121121 bronze badges
What criteria will you use to evaluate these ? If you don't know yet, then you don't need to decide right now. Try to make your application as database-implementation-agnostic as you can - providing the appropriate wrappers, data access objects etc., and make this decision when you have all the facts to hand and you have to decide.
If you're using relational databases and SQL then the above shouldn't be too hard (using JDBC etc). Make sure you have plenty of surrounding tests so that when you want to switch between databases, you can determine that your application's functionality remains the same.
I ran into the same issue some time ago. I didn't know which database to go for, so my first solution used Derby (or HSQLDB?), and I was later able to switch to HSQLDB (or Derby ? Can't remember which solution worked) once I'd determined where I had issues (relating to performance) and which solution would really work for me.
Brian AgnewBrian Agnew
236k3434 gold badges294294 silver badges406406 bronze badges
Most things have been said already, but I can just add that I've used HSQL, Derby and Berkely DB in a few of my pet projects and they all worked just fine. So I don't think it really matters much to be honest. One thing worth mentioning is that HSQL saves itself as a text file with SQL statements which is quite good. Makes it really easy for when you are developing to do tests and setup data quickly. Can also do quick edits if needed. Guess you could easily transfer all that to any database if you ever need to change as well :)
willcodejavaforfoodwillcodejavaforfood
31.1k1717 gold badges7575 silver badges103103 bronze badges
HSQLDB may cause problems for large applications, its not quite that stable.
The best I've heard (not first hand experience however) is berkleyDB. But unless you opensource it, it will cost you an arm and a leg to use due to licensing..see this http://www.oracle.com/technology/software/products/berkeley-db/htdocs/licensing.html for details.
ps. berkleyDB is not a relational database in case you didnt know.
ChiiChii
12.1k22 gold badges2929 silver badges4444 bronze badges
I have used Derby and i really hate it's data type conversion functions, especially date/time functions. (Number Type)<--> Varchar conversion it's a pain.
So that if you plan use data type conversions in your DB statements consider the use of othe embedded DB, i learn it too late.
TelcontarTelcontar
3,41566 gold badges2626 silver badges3838 bronze badges
I personally favor HSQLDB, but mostly because it was the first I tried. All drivers for windows 7 free download.
H2 is said to be faster and provides a nicer GUI frontend (which is generic and works with any JDBC driver, by the way).
At least HSQLDB, H2 and Derby provide server modes which is great for development, because you can access the DB with your application and some tool at the same time (which embedded mode usually doesn't allow).
Joachim SauerJoachim Sauer
246k5050 gold badges494494 silver badges568568 bronze badges
I guess I'm a little late (a lot late;-)) to this post, but I'd like to add Perst, an open source, object-oriented embedded database for Java &.NET. for your consideration. Perst is an open source / dual license embedded database for Java. The distribution is compatible with Google's Android platform, and also includes Perst Lite for Java ME. We've even built an Android benchmark and produced a whitepaper on the subject..you can take a look here: http://www.mcobject.com/index.cfm?fuseaction=download&pageid=581§ionid=133
All the best,Chris
Chris Mureen
If I am correct H2 is from the same guys who wrote HSQLDB. Its a lot better if you trust the benchmarks on their site. Also, there is some notion that sun community jumped too quickly into Derby.
smartnut007smartnut007
3,34133 gold badges3737 silver badges4848 bronze badges
I realize you mentioned SQL browsing, but everything else in your question makes me want to suggest you also consider DB4O, which is a great, simple object DB.
Fabian SteegFabian Steeg
40.2k66 gold badges7575 silver badges109109 bronze badges
Mongo Db Embedded Documents InsertNot the answer you're looking for? Browse other questions tagged javadatabasecomparisonembedded-database or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |