|
Home > Archive > SQL Anywhere Feedback > August 2005 > ulinit .NET-ized
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| We have a huge need for using ulinit functionality from .NET assemblies
rather than calling it from the command line. Is this in the plans at all?
Thanks.
| |
| Greg Fenton 2005-08-11, 3:24 am |
| Jim wrote:
> We have a huge need for using ulinit functionality from .NET assemblies
> rather than calling it from the command line. Is this in the plans at all?
>
Can you describe what you mean by "ulinit functionality" ?
Would calling out to the shell and executing ulinit that way be a solution?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| We are currently calling out to shell to run ulinit to create a USM file
from a publication in an ASA database. I believe there is overhead in
starting ulinit (java related??) and connecting to the database. Then we
not only have to wait for the process to terminate, but also have to wait an
extra bit of time (500-1000 ms) for some reason before we can access the
file. If we only wait for the process to end without that extra buffer of
time, we run into problems. So creating the USMs via ulinit is a
significant bottleneck for us (the biggest one for us currently).
Thank you.
Jim
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:42faafea$1@foru
ms-2-dub...
> Jim wrote:
all?[color=darkred]
>
> Can you describe what you mean by "ulinit functionality" ?
>
> Would calling out to the shell and executing ulinit that way be a
solution?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
| Michael Thode 2005-08-11, 1:25 pm |
| There are no plans for this. Why do you need this?
Mike
"Jim" <jimsjbox@yahoo.com> wrote in message news:42fa7b6f$1@foru
ms-2-dub...
> We have a huge need for using ulinit functionality from .NET assemblies
> rather than calling it from the command line. Is this in the plans at
all?
>
> Thanks.
>
>
| |
|
| We call (shell) ulinit to create a USM file from a publication in an ASA
database. This allows us to create a new or upgrade schema for a CE device
based on configurations the user sets. Since we're working in .NET, it
would be nice to have a synchronous method to call so that we wouldn't have
to wait a buffer period in order for the shelled process to end and clean up
(see reply to Greg's post).
Thanks.
Jim
"Michael Thode" < mthode_no_spam@sybas
e.com> wrote in message
news:42fb6aa4$1@foru
ms-1-dub...
> There are no plans for this. Why do you need this?
>
> Mike
>
> "Jim" <jimsjbox@yahoo.com> wrote in message
news:42fa7b6f$1@foru
ms-2-dub...
> all?
>
>
| |
| Philippe Bertrand 2005-08-15, 8:23 pm |
| Would having an empty database (collation and charset preset), and the
ability to create tables dynamically be sufficient?
You would copy the template empty database and then execute customized sql
DDL to create the database for the user.
--
- Philippe Bertrand
iAnywhere Solutions, Inc.
Please include in your subject line what UltraLite API are you using
(I.E. UltraLite.NET, Native UltraLite for Java, Embedded SQL, C++,
(pure) Static Java UltraLite, etc.). Please include version and BUILD
numbers in your post.
| |
|
| I apologize Philippe--I'm not sure I understand. But this issue is
important enough to us that I'd really like to keep a dialogue going on it.
Our end goal is to have a Ultralite Schema (USM) file that can be copied to
a CE device. From what I understand, the only way to create that USM in an
automated process is to use ulinit. Ulinit takes an existing publication
and generates the USM file. We've already created tables and publications
in order to run ulinit on these publications.
What we're running into is that we're having to wait in our code for ulinit
for an unknown amount of time so that it can let go of the generated USM
file. This adds many seconds to our deployment time. With many devices to
deploy to, this can become a serious issue.
If we had a .NET assembly that had a syncronous method called BuildUSM that
did the same thing as ulinit, we would theoretically not have the problem of
the process latching onto the file for some amount of time that probably
varies from system to system. Currently if we make our delay shorter than
the slowest system can handle, we have a bug, because the file is locked or
something by ulinit.
I don't know if that answers what you were asking...
Thank You
Jim
"Philippe Bertrand" <my.name@ianywhere.com> wrote in message
news:4300dc68$1@foru
ms-2-dub...
> Would having an empty database (collation and charset preset), and the
> ability to create tables dynamically be sufficient?
>
> You would copy the template empty database and then execute customized sql
> DDL to create the database for the user.
>
> --
> - Philippe Bertrand
> iAnywhere Solutions, Inc.
>
> Please include in your subject line what UltraLite API are you using
> (I.E. UltraLite.NET, Native UltraLite for Java, Embedded SQL, C++,
> (pure) Static Java UltraLite, etc.). Please include version and BUILD
> numbers in your post.
>
>
| |
| Greg Fenton 2005-08-16, 8:23 pm |
| Jim wrote:
>
> What we're running into is that we're having to wait in our code for ulinit
> for an unknown amount of time so that it can let go of the generated USM
> file. This adds many seconds to our deployment time. With many devices to
> deploy to, this can become a serious issue.
>
In most customer scenarios, the USM is generated once and is deployed as
part of the application deployment process.
Can you explain why you cannot simply re-use the USM file that you
generate once?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
|
| For us the customer is able to select which application(s) to use. These
apps have to use the same database, since they share (potentially) common
data. For example if they update the cust table in one app and then open a
second app that also accesses the cust table, the updated data needs to be
seen by the second app. So we don't build our USM files until the customer
has selected the apps that go to a device.
Jim
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:43023a6a$1@foru
ms-1-dub...
> Jim wrote:
ulinit[color=darkred
]
to[color=darkred]
>
> In most customer scenarios, the USM is generated once and is deployed as
> part of the application deployment process.
>
> Can you explain why you cannot simply re-use the USM file that you
> generate once?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
| |
| Michael Thode 2005-08-17, 1:23 pm |
| You could also try ulxml if that helps.
Why do you need a delay after invoking ulinit? We run ulinit in automated
scripts all the time and I've never heard of needing to delay afterwards.
Are you confident that you're waiting for ulinit to exit?
Your work around seems like a good one to me. I don't know of any reason
why your invokation of ulinit can't be made synchronous. If you access the
generated usm file before delaying what happens?
Mike
"Jim" <jimsjbox@yahoo.com> wrote in message news:430248cd@forums
-1-dub...
> For us the customer is able to select which application(s) to use. These
> apps have to use the same database, since they share (potentially) common
> data. For example if they update the cust table in one app and then open
a
> second app that also accesses the cust table, the updated data needs to be
> seen by the second app. So we don't build our USM files until the
customer
> has selected the apps that go to a device.
>
> Jim
>
> "Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
> news:43023a6a$1@foru
ms-1-dub...
> ulinit
USM[color=darkred]
devices[color=darkre
d]
> to
>
>
|
|
|
|
|