Article View: borland.public.jbuilder.database
Article #353Re: Remote data - local Datastore problem
From: Steve
Date: Sun, 08 Oct 2006 18:37
Date: Sun, 08 Oct 2006 18:37
66 lines
3078 bytes
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-mailReferences:
<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