Remote data - local Datastore problem - Thread - go-pugleaf

Thread View: borland.public.jbuilder.database

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Mark Rafn Fri, 06 Oct 2006 13:32

Remote data - local Datastore problem

#352

Author: 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

Re: Remote data - local Datastore problem

#353

Author: 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
>

Re: Remote data - local Datastore problem

#354

Author: 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
>> 
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads