Article View: borland.public.jbuilder.database
Article #352Remote data - local Datastore problem
From: Mark Rafn
Date: Fri, 06 Oct 2006 13:32
Date: Fri, 06 Oct 2006 13:32
36 lines
2263 bytes
2263 bytes
Hi all,
Hopefully someone can help me, I have exhausted Help and newsgroup searhes...
JBuilderX
Following Borland's tutorial for creating persistant offline editing using DataExpress and Datastore components--I can get the binding between dataset and datastore, the offline stuff works great. But no matter what I do I cannot save the datastore changes back to the server database.
Here's the code:
private static final String connectType = "jdbc:borland:dsremote:";
private static final String driverName = "com.borland.datastore.jdbc.DataStoreDriver";
private static String hostName = "//TWOENP08/";
private static String remoteFilename = "g:\\jds\\jds_remote";
private static String storeFilename = "D:\\db\\jds_offline";
Database db = new Database();
DataStore dataStore = new DataStore();
QueryDataSet query = new QueryDataSet();
<snip>
jdbNavToolBar1.setDataSet(query);
dataStore.setFileName(storeFilename);
dataStore.setUserName(user);
dataStore.setPassword(password);
db.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor(
connectType + hostName + remoteFilename,
user, password, false, driverName));
query.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(db, "SELECT * FROM TABLE", null, true, Load.ALL));
query.setStoreName(partnumbers);
query.setStore(dataStore);
<snip>
What am I missing here to get the navbar to Save changes back to the server database?
tia
-mark
Technical Details
Message-ID:
<45265ad2@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news.glorb.com!news2.volia.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 1073da,6323f2820d3981a6,start X-Google-Attributes: gid1073da,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Mark Rafn" <mrafn@stanleyworks.com> Sender: "Mark Rafn" <mrafn@stanleyworks.com> Reply-To: "Mark Rafn" <mrafn@stanleyworks.com> Subject: Remote data - local Datastore problem Newsgroups: borland.public.jbuilder.database X-User-Info: 12.116.61.42 NNTP-Posting-Host: 207.105.83.66 Message-ID: <45265ad2@newsgroups.borland.com> Date: 6 Oct 2006 06:32:02 -0700 X-Trace: newsgroups.borland.com 1160141522 207.105.83.66 (6 Oct 2006 06:32:02 -0700) Lines: 37 Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news.glorb.com!news2.volia.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail