🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Remote data - local Datastore problem

#353
From: Steve
Date: Sun, 08 Oct 2006 18:37
66 lines
3078 bytes
Two questions.

Is there an error?  If so, can you paste the stack trace?

Is the table "resolvable".  DataStore will only track edits to a table if 
its resolvable property is set to true.

Use the following steps to quickly find out if a DataStore table is 
resolvable:

Open the local database in the JdsExplorer.

Select your table in the tree.

Select the structure tab.

Is the "Resolvable" checkbox set?

-Steve

"Mark Rafn" <mrafn@stanleyworks.com> wrote in message 
news:45265ad2@newsgroups.borland.com...
>
> 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: <4529456d$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <45265ad2@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 1073da,6323f2820d3981a6
X-Google-Attributes: gid1073da,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Steve" <sshaughnessy@b.com>
From: "Steve" <sshaughnessy@b.com>
Newsgroups: borland.public.jbuilder.database
References: <45265ad2@newsgroups.borland.com>
Subject: Re: Remote data - local Datastore problem
Date: Sun, 8 Oct 2006 11:37:52 -0700
Lines: 68
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: 71.146.15.74
Message-ID: <4529456d$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1160332653 71.146.15.74 (8 Oct 2006 11:37:33 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail