In Progress

JDBC DDL Abstraction Layer

Hi freelancers,

Imagine there is a Java database application utilizing a JDBC Connection to connect to following databases:

- H2 Embedded

- H2 Server

- MySQL

- MS SQL Server.

and more to come.

When it comes to database schema creation we have unique scripts in place. One for each database. Since we have to support more databases in time,

the SQL DDL script must be rewritten for each no database.

It's mandataory to have following features implemented:

- Create table

- drop table

- alter table

- referential integrity - foreign key constraints (on delete cascade, on update cascade)

- create indices

- drop indices

My research brought some approaches to light which may do the job:

- ddlutils: seems to be buggy and under low development

- liquibase. supports all mandatory features

- hibernate. might do it at well: [url removed, login to view]

Due to performance reasons and current design we can't switch to an O/R Mapper like JPA2 / Hibernate. But what I need is to have

the DB Schema properly created for most of the common databases.

For you as freelancers I want you to tell me the most convenient solution for my problem. I.e. which approach to take.

Thanks Hannes

Skills: Java

See more: jdbc ddl, ddl abstraction layer, java jdbc ddl, tutorial solution, solution tutorial, schema update, problem approach, mapper java, java mapper, freelancers sql server, freelancers job support, freelancers ch, development tutorial, design one cascade, database design tutorial, database creation freelancers, connect freelancers, common tutorial, cascade design, approach problem, application development freelancers, ddl abstraction, jdbc abstraction layer, sql r, r sql

About the Employer:
( 9 reviews ) Schwoich, Austria

Project ID: #2540136

Awarded to:

poornachand

Please check PM

€150 EUR in 7 days
(26 Reviews)
5.1

4 freelancers are bidding on average €170 for this job

buzzcoder

Please check your pm.

€250 EUR in 5 days
(40 Reviews)
5.4
DoaaAbdElHady

Hi Dear, My technical skills in java : 1- j2EE "JSP , Servlet , JSF, Hibernate " 2- j2SE 3- MySQL 4- Groovy 5- Ajax I Know the concepts of object oriented I can work on UML mod More

€30 EUR in 5 days
(0 Reviews)
0.0
rbollu

Hi,i am pure java guy. I have 10 years of experience on java,jdbc,jsp,j2ee,hibernate,springs,ect.. i am ready to do your project

€250 EUR in 10 days
(0 Reviews)
0.0