deployment - how to deploy javafx application with sqlite database(preferably using inno script) -
i want deploy javafx fxml application. have used sqlite3 database. tried deploying using inno script adding .db file, first login page shows after enter credentials , log-in window collapses. think because of exception have not programmed display in pop window. programs works fine when run in netbeans. please suggest best way deploy fxml application sqlite database.
the contents of project :
- main project files
- images in separate folder named images(background image displayed in login page)
- database file.
edit
i believe problem missing driver. not able connect .db file. added following lines code connecting database
stmt.executeupdate("create table if not exists admin_users (id primary key not null, username text unique not null,password text unique not null)");
and
stmt.executeupdate("insert admin_users (id,username,password) select * (select 1,'admin','xxxxx') tmp not exists (select username admin_users username= 'admin') limit 1");
now creating database file execute jar. going past login page , works fine. but, when deploy project using inno script. same problem persists , application force closes when click submit.
i think should provide more information, i.e. exception logs. based on screen shows , login fails, database error. created javafx application lately sqlite db, , used spring initialization of datasource object. bean definition(if don't use spring, still useful compare connection string).
<bean id="sqllitedatasource" class="org.apache.commons.dbcp.basicdatasource" destroy-method="close" lazy-init="true"> <property name="driverclassname" value="org.sqlite.jdbc" /> <property name="url" value="jdbc:sqlite:databasefile.db" /> <property name="initialsize" value="2" /> <property name="maxactive" value="20" /> <property name="maxidle" value="5" /> <property name="poolpreparedstatements" value="true" /> </bean>
i believe problem can either connection string or missing driver, without exception, can't tell that.
Comments
Post a Comment