Creating a database connection class java

Question

I am in process to create a Database connection class but having some doubts about implementation. Idea is to create a flexible and easy to use connection manager class and since it will be used in our own application at some specific points so at the moment not much concerned about multi-threading etc.

here are the few requirements

Configuring generic properties using a property file.
handling the dialect for different providers.

Please suggest some guidelines to make this class flexible and easy to enhance.Any link/resource of any good such implementation will be really helpful.

@GuillaumePolet: requirement is not so big, so using JPA means adding a lot of overhead.As of now its just a 2 tables — Umesh Awasthi
– Umesh Awasthi, Commented Feb 29, 2012 at 16:34
Even for two tables I would still do it. You get the dialect abstraction you are looking for and think about future extension — Guillaume Polet
– Guillaume Polet, Commented Feb 29, 2012 at 16:44

JProgrammer · Accepted Answer · 2012-02-29 16:47:33Z

1

I assume, you will be using JDBC. You can externalize all parameter that are required to create Connection object for particular database

1) Database connection URL (include port number) 2) Username 3) Password 4) Database driver

You can keep all these parameters in external properties file. You can use factory pattern (say DatabaseConnectionFactory) to create database connection so that if you decide to apply certain attributes while creating new instances of connection or reusing the connection instances, it will be easy to manage. You should make DatabaseConnectionFactory singleton.

What you need to take care of is the generation of SQL queries as it varies depending upon the Databases.

answered Feb 29, 2012 at 16:47

JProgrammer

1,1352 gold badges10 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Guillaume Polet · Accepted Answer · 2012-02-29 16:49:02Z

1

Use JPA then. You will thank me for choosing that in a few month and you will set this up as fast as if you try to do it yourself.

answered Feb 29, 2012 at 16:49

Guillaume Polet

47.7k5 gold badges86 silver badges118 bronze badges

1 Comment

Umesh Awasthi Over a year ago

agree with you but using JPA means adding a lot of extra dependencies.Thanks will consider your suggestion

ChadNC · Accepted Answer · 2012-02-29 18:29:36Z

0

If all you're asking for is relating to concerns about design then you might want to go read up on some common design patterns and choose one that is best for your situation.

Design Patterns

answered Feb 29, 2012 at 18:29

ChadNC

2,5034 gold badges25 silver badges40 bronze badges

Collectives™ on Stack Overflow

Creating a database connection class java

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related