Pattern for creating a database schema using JDBC

Posted by Space_C0wb0y on Stack Overflow See other posts from Stack Overflow or by Space_C0wb0y
Published on 2010-05-26T09:50:21Z Indexed on 2010/05/26 10:11 UTC
Read the original article Hit count: 203

Filed under:
|
|
|

I have a Java-application that loads data from a legacy file format into an SQLite-Database using JDBC. If the database file specified does not exist, it is supposed to create a new one. Currently the schema for the database is hardcoded in the application. I would much rather have it in a separate file as an SQL-Script, but apparently there is now easy way to execute an SQL-Script though JDBC. Is there any other way or a pattern to achieve something like this?

© Stack Overflow or respective owner

Related posts about java

Related posts about sql