Distributed Java desktop app mySQL database -
i'm in process of learning java , swing , in doing trying create desktop app. part of app have set mysql database app connected to, i'm uncertain how work if distribute app other users, how create database able use on system if don't have mysql installed or database initiated. help appreciated. you should use embedded database. not recommend mysql commercial applications, because expensive. try use hsqldb - fast , not has memory leaks (at least didn't noticed). here implementation example: private static connection conn; /** * gets database connection. * * @return database connection. * @throws sqlexception if database error occurs. */ public static connection getconnection() throws sqlexception { if (conn == null || conn.isclosed()) { conn = drivermanager.getconnection("jdbc:hsqldb:file:data", "somedb", ""); // conn.setautocommit(false); } return conn; } make sure have added hsqldb.ja...
