🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.jbuilder.database
Article #352

Remote data - local Datastore problem

#352
From: Mark Rafn
Date: Fri, 06 Oct 2006 13:32
36 lines
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-mail

Show 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