Re: How to do a Pick/DataBASIC http server service?

Out of interest, I have used message queueing to perform connection pooling
to the database by running a service (windows) on the server which spawns a
number of processes that access the message queue and then call the
subroutines on the server (using jrcs) returning any result back through the
message queue.

This means you limit the no of simulataneuos connections to the server, and
control licence usage without getting http failures (it just slows down!).

I think that MSMQ can be transported between machines automatically over
http.

This also gives you security of delivery of message as well..

and it works!

Regards
Simon
--
================================
Simon Verona
Dealer Management Service Ltd
Stewart House
Centurion Business Park
Julian Way
Sheffield
S9 1GD

Tel: 0870 080 2300
Fax: 0870 735 0011

"Symeon" <symeonb@xxxxxxxxx> wrote in message
news:1153899547.554471.86530@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Dawn - I have a number of live websites out there, they all run on
iis, using ASP or ASP.NET and connect to u2 using uniobjects (or
uniobjects.net). Works fine even without connection pooling. Down the
line connection pooling is what we shall be putting into place, either
using the new offering from IBM (+ maybe the U2 Soap Server), or
MV.NET.

I have also done sites in the java realm, on tomcat/jboss etc with
connections to U2 using our bespoke socket interface.

I think really the options are quite large, but more so on the choice
of web/application server, to actually get into MV data you either need
a bespoke interface (sockets etc) or use one of the tools like
uniobjects.

I would like to see a better way of getting from php on linux into U2.
I know some people have done some work on this using UCI and extensions
to php in C, but a nice packaged, documented offering would be pretty
cool.

rgds
Symeon.






Simon Verona wrote:
I've used dotnet web services, which access the database (jBASE) using
jRCS...

Like others, the web service can exist publically on the internet, but
the
database can be stored elesewhere behind a firewall that only allows the
web
server's IP through on the jRCS port.

Regards
Simon

--
================================
Simon Verona
Dealer Management Service Ltd
Stewart House
Centurion Business Park
Julian Way
Sheffield
S9 1GD

Tel: 0870 080 2300
Fax: 0870 735 0011

"dawn" <dawnwolthuis@xxxxxxxxx> wrote in message
news:1153848732.918131.205900@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am wondering how many ways there are to write a Pick/DataBASIC
service that takes in a parameter from a URL and returns (via http) a
result.

Let's say that there is JavaScript in a browser that is doing an
XMLHttpRequest (or ActiveX), aka AJAX, request to a URL such as
www.mydomain.com/myservice.whatever?this=that

What all is behind this URL? It might be enlightening (to me at least)
to inventory the ways to accomplish this feat.

1. PHP + OpenQM client/server library + OpenQM
In a non-transaction processing environment (in fact doing only
read-only right now), I have done this with a PHP wrapper that Tom D
wrote for OpenQM, which uses the OpenQM client/server interface written
in C (IIRC).

2. Tomcat + Java + UOJ library + UniData
I have also done this using a tomcat app server (either in addition to
or instead of another web server), Java, and UniObjects for Java (UOJ)
with UniData. I had to add in home-grown connection pooling at the
time, but UOJ now comes with it (for a price).

Please add to this list. Thanks. --dawn




.

Relevant Pages

  • Re: How to do a Pick/DataBASIC http server service?
    ... PHP + OpenQM client/server library + OpenQM ... I have also done this using a tomcat app server (either in addition to ... Note that Tomcat is not the only servlet container out there. ...
    (comp.databases.pick)
  • Re: How to do a Pick/DataBASIC http server service?
    ... using ASP or ASP.NET and connect to u2 using uniobjects (or ... of web/application server, to actually get into MV data you either need ... I would like to see a better way of getting from php on linux into U2. ... PHP + OpenQM client/server library + OpenQM ...
    (comp.databases.pick)
  • Re: E_UNEXPECTED(0x8000FFFF) Problem with OraOleDB.Oracle
    ... migration from Windows 2000 Server to Windows 2003 Server I have ... It comes from Oracle and not from Microsoft. ... Try disabling connection pooling to see if the ...
    (comp.databases.oracle.misc)
  • Re: Connection Pooling and low use web site
    ... I apologize for not putting more information in here. ... know for sure that it is connection pooling. ... application with SQL server on the backend using ADO.NET. ... I close the browser, open a new browser, then ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Application Role
    ... eavesdrop on the actual conversation Access is having with the SQL ... >While performance is not an issue so far with some 25 users and a big server ... >> more info on the connection pooling issue. ...
    (microsoft.public.sqlserver.security)