Article View: borland.public.jbuilder.database
Article #354Re: Remote data - local Datastore problem
From: Mark Rafn
Date: Mon, 09 Oct 2006 11:30
Date: Mon, 09 Oct 2006 11:30
74 lines
3204 bytes
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-mailReferences:
<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