🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Remote data - local Datastore problem

#354
From: Mark Rafn
Date: Mon, 09 Oct 2006 11:30
74 lines
3204 bytes
That's it!  (Resolvable...)
thanks Steve!  ~finally I can move on...
-mark

"Steve" <sshaughnessy@b.com> wrote:
>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: <452a32d5$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.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> <4529456d$1@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
From: "Mark Rafn" <mrafn@stanleyworks.com>
Sender: "Mark Rafn" <mrafn@stanleyworks.com>
Reply-To: "Mark Rafn" <mrafn@stanleyworks.com>
Subject: Re: Remote data - local Datastore problem
Newsgroups: borland.public.jbuilder.database
X-User-Info: 12.116.61.42     
References: <45265ad2@newsgroups.borland.com> <4529456d$1@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.66
Message-ID: <452a32d5$1@newsgroups.borland.com>
Date: 9 Oct 2006 04:30:29 -0700
X-Trace: newsgroups.borland.com 1160393429 207.105.83.66 (9 Oct 2006 04:30:29 -0700)
Lines: 75
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.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