Distribute a database made with JavaDB with Java program -

-

i'm creating program in java in have use lot of tables. made decision create tables in javadb file.

however, want distribute filled javadb file jar file distribution, since connecting server not option.

in past distribute empty database jar using derby package.

any ideas?

thank much!

i'm not sure understood question possible package read-only database inside jar. derby documentation:

accessing databases-in-a-jar in class path

once archive containing 1 or more derby databases has been created can placed in class path. allows access database within application without application's knowing path of archive. when jar or zip files part of class path, not have specify jar subsubprotocol connect them.

to access database in zip or jar file in class path:

  1. set class path include jar or zip file before starting derby:

    classpath="c:\dbs.jar;%classpath%"

  2. connect database within jar or zip file 1 of following connection urls:

    jdbc:derby:/databasepathwithinarchive  (standard syntax)  jdbc:derby:classpath:/databasepathwithinarchive  (syntax subsubprotocol)

for example:

jdbc:derby:/products/boiledfood jdbc:derby:classpath:/products/boiledfood

if doesn't answer question, please clarify.


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more