sqlrelay-discussion — Discussion of topics related to SQL Relay

[Sqlrelay-discussion] Rudiments update

[David M. <dav...@fi...>]

Hello group,

I just uploaded a new version of Rudiments (the low-level library that
SQL Relay depends on) to rudiments.sourceforge.net and new SQL Relay
tarballs (which include sqlrelay and rudiments RPM's) to
sqlrelay.sourceforge.net.  This release fixes a critical bug that
caused large queries to crash client programs.

You'll almost certainly want to upgrade, even if you haven't run into
the problem yet.

Take care,

David Muse
dav...@fi...

[Sqlrelay-discussion] Memory leak in the listener ?

[laurent c. <lau...@gr...>]

Dear Sir,

We hae a serious problem with sqlrelay 0.36 with PHP. The sqlrelay 
listener grows dangerously. The among of memory never decrease. Any idea ?

Cheer,
L. Cresp

[Sqlrelay-discussion] describe inner structure of sql-relay

[zhu s. s. <zhu...@ya...>]

Dear sir,
  Who can describe the inner structure of sql-relay
and the relations between different components such as
sql-listener,sql-connection,sql-cachemanager?
  tks
  zhu



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Re: [Sqlrelay-discussion] sqlrelay-0.36

[David M. <dav...@fi...>]

Chris,

PHP provides a resource list and cleanup framework.  The new
sqlrelay PHP API uses it.

Whenever sqlrcon_alloc or sqlrcur_alloc is called, it creates an
instance of the sqlrconnection or sqlrcursor C++ class and puts it in
the resource list for the PHP module.  Those functions return a list id
rather than returning the instance itself now.

Each of the sqlrelay functions take the id, look up the instance in the
"resource list" and use it.

The sqlrcon_free and sqlrcur_free functions look up the instance in the
list, remove it from the "resource list" and delete it.

When a page is done (either aborted or terminated normally) PHP runs
through a cleanup process where it goes through it's resource list,
calling whatever cleanup function is registered for each item in the
list.  The sqlrelay module registers cleanup functions that delete the
sqlrconnection or sqlrcursor instances now.

So, you can use the sqlrcon_free or sqlrcur_free methods, you can
register shutdown handlers that use them.  All that will still work,
but you don't have to anymore.

I need to update the docs :)

Dave
dav...@fi...


On Thu, 31 Mar 2005 15:46:28 -0800
"Chris Falk" <Ch...@si...> wrote:

> Hi David,
> 
>  
> 
> I'm just going through the changelog for 0.36.  Two of the points are
> great news for us!  The 0 connections fix and the change to the php
> API for sqlrcon/cur_free.  I understand the 0 connections issue, as it
> was a constant problem for us with our firewalls killing the initial
> connection during periods of inactivity.
> 
>  
> 
> However, could you elaborate on why we no longer need to call
> sqlrcon/cur_free anymore?  How are the connections and cursors cleaned
> up automatically now?  It looks like the docs still state that these
> functions must be called to ensure resources are freed up.  We have a
> php function that we register for shutdown that cleans up all
> resources at the end of the php request processing.  Do we still need
> this function with 0.36?
> 
>  
> 
> Thanks!
> 
> Chris
> 
>  
> 
> Chris Falk
> Senior Software Engineer
> siberra
> DIGITAL MEDIA SYSTEMS
> Tel:   604-696-3224
> Fax:  604-696-3201
> ch...@si... <mailto:ch...@si...> 
> www.siberra.com <http://www.siberra.com/> 
> 
>  
> 
> 
> The information in this e-mail message including any attachments is
> intended only for the named recipients above and may contain
> confidential or privileged information. If you have received this
> message in error, or are not the named recipient(s), please
> immediately notify the sender by replying to the message and deleting
> all copies of it from your computer. 
> 
> Ce courriel de meme que toute piece jointe s'adresse seulement au(x)
> destinataire(s) designe(s) et peut contenir des renseignements
> confidentiels ou privilegies. Si vous avez recu ce message par erreur
> ou que vous n'etes pas un destinataire designe, veuillez avertir
> immediatement l'expediteur en repondant au message et effacez-en
> toutes les copies dans votre ordinateur. 
> 

[Sqlrelay-discussion] sqlrelay-0.36

[Chris F. <Ch...@si...>]

Hi David,

=20

I'm just going through the changelog for 0.36.  Two of the points are
great news for us!  The 0 connections fix and the change to the php API
for sqlrcon/cur_free.  I understand the 0 connections issue, as it was a
constant problem for us with our firewalls killing the initial
connection during periods of inactivity.

=20

However, could you elaborate on why we no longer need to call
sqlrcon/cur_free anymore?  How are the connections and cursors cleaned
up automatically now?  It looks like the docs still state that these
functions must be called to ensure resources are freed up.  We have a
php function that we register for shutdown that cleans up all resources
at the end of the php request processing.  Do we still need this
function with 0.36?

=20

Thanks!

Chris

=20

Chris Falk
Senior Software Engineer
siberra
DIGITAL MEDIA SYSTEMS
Tel:   604-696-3224
Fax:  604-696-3201
ch...@si... <mailto:ch...@si...>=20
www.siberra.com <http://www.siberra.com/>=20

=20


The information in this e-mail message including any attachments is =
intended only for the named recipients above and may contain =
confidential or privileged information. If you have received this =
message in error, or are not the named recipient(s), please immediately =
notify the sender by replying to the message and deleting all copies of =
it from your computer.=20

Ce courriel de meme que toute piece jointe s'adresse seulement au(x) =
destinataire(s) designe(s) et peut contenir des renseignements =
confidentiels ou privilegies. Si vous avez recu ce message par erreur ou =
que vous n'etes pas un destinataire designe, veuillez avertir =
immediatement l'expediteur en repondant au message et effacez-en toutes =
les copies dans votre ordinateur.=20

Re: [Sqlrelay-discussion] Install under Windows

[David M. <dav...@fi...>]

It will build and install under Cygwin.  Whether it works or not is
another issue.  I've had success with SQL Relay client programs
running against remote SQL Relay servers running on Linux, but when
running the SQL Relay server components on Windows, the sqlr-connection
programs tend to crash when connecting to databases and sometimes when
forking.

To really get it working on Windows, I need to port Rudiments to
mingw and get everything on the SQL Relay server side working as a
single multi-threaded application rather than multi-process like it
currently is.

Dave
dav...@fi...

On Tue, 29 Mar 2005 18:13:03 +0100
Lorenzo Bolognini <lbo...@gm...> wrote:

> Hi all,
> 
> had a look at the website and it mentioned that SQLRelay would
> install under Windwos. Did u mean cygwin?
> 
> Otherwise how do u do that? Would the standard free MS compiler do
> the job?
> 
> Thanks,
> Lorenzo
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real
> users. Discover which products truly live up to the hype. Start
> reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

[Sqlrelay-discussion] Install under Windows

[Lorenzo B. <lbo...@gm...>]

Hi all,

had a look at the website and it mentioned that SQLRelay would install 
under Windwos. Did u mean cygwin?

Otherwise how do u do that? Would the standard free MS compiler do the job?

Thanks,
Lorenzo

Re: [Sqlrelay-discussion] SQL Relay 0.36

[vieonet f. <df...@vi...>]

NOT BAD at All

Ill test it too

thanks for improvment

livingdead


----- Original Message ----- 
From: "Dario Lah" <dl...@ti...>
To: <sql...@li...>
Sent: Tuesday, March 29, 2005 12:51 PM
Subject: Re: [Sqlrelay-discussion] SQL Relay 0.36


> Regarding speed improvement for large inserts: 
> v0.35   4090 seconds
> v0.36        70 seconds
> 
> Not bed :)
> 
> Dario Lah
> 
> On Tuesday 29 March 2005 04:03, David Muse wrote:
>> Hello group,
>>
>> SQL Relay version 0.36 and Rudiments 0.28 are out.
>>
>> Notable features of this release:
>> * MDBTools backend for accessing Microsoft Access Databases.
>> * The PHP API cleans up connections and cursors so you don't have to
>> register a shutdown handler anymore.
>> * Significant performance improvements for queries which return small
>> (or no) result sets.
>> * Fixed a race condition that could hang everything when dynamic
>> scaling is used.
>> * Fixed some python threading problems.
>> * Improved Cygwin and Mac OS X support.
>> * Lots of more obscure bugfixes and improvements.
>>
>> This release does not include full x86_64 support.  It compiles now, but
>> doesn't run correctly unless both client and server are x86_64
>> machines.  Sorry about that :)  Look for it in 0.37 though.
>>
>> Take a look, report any problems you run in to.
>>
>> Thanks,
>> David Muse
>> dav...@fi...
>>
>>
>> -------------------------------------------------------
>> SF email is sponsored by - The IT Product Guide
>> Read honest & candid reviews on hundreds of IT Products from real users.
>> Discover which products truly live up to the hype. Start reading now.
>> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>> _______________________________________________
>> Sqlrelay-discussion mailing list
>> Sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 
> -- 
> Marge: Name one of your child's friends.
> 
> Homer: Uh, let's see, Bart's friends ... Well, there's the fat kid
> with the thing; uh, the little wiener whose always got his
> hands in his pockets.
> 
>    Saturdays of Thunder
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>

Re: [Sqlrelay-discussion] SQL Relay 0.36

[Dario L. <dl...@ti...>]

Regarding speed improvement for large inserts: 
v0.35   4090 seconds
v0.36        70 seconds

Not bed :)

Dario Lah

On Tuesday 29 March 2005 04:03, David Muse wrote:
> Hello group,
>
> SQL Relay version 0.36 and Rudiments 0.28 are out.
>
> Notable features of this release:
> * MDBTools backend for accessing Microsoft Access Databases.
> * The PHP API cleans up connections and cursors so you don't have to
> register a shutdown handler anymore.
> * Significant performance improvements for queries which return small
> (or no) result sets.
> * Fixed a race condition that could hang everything when dynamic
> scaling is used.
> * Fixed some python threading problems.
> * Improved Cygwin and Mac OS X support.
> * Lots of more obscure bugfixes and improvements.
>
> This release does not include full x86_64 support.  It compiles now, but
> doesn't run correctly unless both client and server are x86_64
> machines.  Sorry about that :)  Look for it in 0.37 though.
>
> Take a look, report any problems you run in to.
>
> Thanks,
> David Muse
> dav...@fi...
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

-- 
Marge:	Name one of your child's friends.

Homer:	Uh, let's see, Bart's friends ... Well, there's the fat kid
	with the thing; uh, the little wiener whose always got his
	hands in his pockets.

		   Saturdays of Thunder

[Sqlrelay-discussion] SQL Relay 0.36

[David M. <dav...@fi...>]

Hello group,

SQL Relay version 0.36 and Rudiments 0.28 are out.

Notable features of this release:
* MDBTools backend for accessing Microsoft Access Databases.
* The PHP API cleans up connections and cursors so you don't have to
register a shutdown handler anymore.
* Significant performance improvements for queries which return small
(or no) result sets.
* Fixed a race condition that could hang everything when dynamic
scaling is used.
* Fixed some python threading problems.
* Improved Cygwin and Mac OS X support.
* Lots of more obscure bugfixes and improvements.

This release does not include full x86_64 support.  It compiles now, but
doesn't run correctly unless both client and server are x86_64
machines.  Sorry about that :)  Look for it in 0.37 though.

Take a look, report any problems you run in to.

Thanks,
David Muse
dav...@fi...

Re: [Sqlrelay-discussion] McAffee filtering email messages

[David M. <dav...@fi...>]

Thanks for the heads-up.  This is good to know.

Dave

On Thu, 17 Mar 2005 11:16:58 -0800
"Chris Falk" <Ch...@si...> wrote:

> Howdy,
> 
>  
> 
> David: our upgrade of McAffee Security started filtering all sqlrelay
> discussion emails.  Apparently, the cause is related to the encoding
> format of the emails.  Here is the message I get:
> 
>  
> 
> ========================================================================
> =============
> 
>  
> 
> 
> CORRUPT CONTENT ALERT
> 
> 
> The content this replaces was found to be corrupt.
> 
> Cause of corruption: Invalid character set or encoding. 
> 
> See your system administrator for further information.
> 
> Copyright (c) 1993-2004 Networks Associates Technology, Inc.
> All Rights Reserved.
> http://www.mcafeesecurity <http://www.mcafeesecurity.com> 
> 
>  
> 
>  
> 
> Don't worry... I don't expect anything to happen on your side.  I'll
> just have to read the lists at home instead of at work.  I just
> thought you would like to know that there is some commercial email
> security software out there that filters the discussion forum emails.
> 
>  
> 
> Chris Falk
> Senior Software Engineer
> siberra
> DIGITAL MEDIA SYSTEMS
> Tel:   604-696-3224
> Fax:  604-696-3201
> ch...@si... <mailto:ch...@si...> 
> www.siberra.com <http://www.siberra.com/> 
> 
>  
> 
> 
> The information in this e-mail message including any attachments is
> intended only for the named recipients above and may contain
> confidential or privileged information. If you have received this
> message in error, or are not the named recipient(s), please
> immediately notify the sender by replying to the message and deleting
> all copies of it from your computer. 
> 
> Ce courriel de meme que toute piece jointe s'adresse seulement au(x)
> destinataire(s) designe(s) et peut contenir des renseignements
> confidentiels ou privilegies. Si vous avez recu ce message par erreur
> ou que vous n'etes pas un destinataire designe, veuillez avertir
> immediatement l'expediteur en repondant au message et effacez-en
> toutes les copies dans votre ordinateur. 
> 

Re: [Sqlrelay-discussion] Please help

[Dario L. <dl...@ti...>]

Possibly, both of you are missing nobody user in passwd, or you are not 
starting it as root user.

Dario

On Thursday 24 March 2005 13:28, simon martin wrote:
> I originally had this problem on Debian (Ubuntu is derived from Debian).
> I solved it by changing the sqlrelay.conf file. Change the
> runasuser="nobody" to runasuser="" and runasgroup="nobody" to
> runasgroup="". This means that the sqlrelay daemons will run as root,
> but hell, it works.
>
> On Wed, 2005-03-23 at 14:42 -0800, jo Maquiling wrote:
> > I'm using ubuntu linux and activated the sqlrelay -
> > freetds support..Ive followed the manual and see to it
> > that all of my configuration follows what has been
> > stated in manual.
> >
> >
> > But the problem is i cant make it work.
> > Here it the error message whenever i want to start a
> > particular instance.
> >
> > <i>
> > Starting listener:
> >   sqlr-listener -id mysqltest -config
> > /etc/sqlrelay/sqlrelay.conf
> > Warning: could not change user to nobody
> > Could not open: /var/cache/sqlrelay/tmp/mysqltest
> > Make sure that the file and directory are readable and
> > writable.
> >
> >
> > sqlr-listener failed to start.
> >
> >
> > Thanks to MP3.com for sponsoring:
> >         Clustered/Replicated database support.
> >         Perl API.
> > </i>
> >
> >
> > Please help..
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Small Business - Try our new resources site!
> > http://smallbusiness.yahoo.com/resources/
> >
> >
> > -------------------------------------------------------
> > This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
> > Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
> > Embedded(r) & Windows Mobile(tm) platforms, applications & content. 
> > Register by 3/29 & save $300
> > http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
> > _______________________________________________
> > Sqlrelay-discussion mailing list
> > Sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

-- 
 Fry: You gotta help me, Bender. How can I prove I'm human?
 Bender: You could drop dead. That'd show 'em. 
 Fry: I don't wanna. 

Re: [Sqlrelay-discussion] Please help

[simon m. <sm...@mi...>]

I originally had this problem on Debian (Ubuntu is derived from Debian).
I solved it by changing the sqlrelay.conf file. Change the
runasuser=3D"nobody" to runasuser=3D"" and runasgroup=3D"nobody" to
runasgroup=3D"". This means that the sqlrelay daemons will run as root,
but hell, it works.

On Wed, 2005-03-23 at 14:42 -0800, jo Maquiling wrote:
> I'm using ubuntu linux and activated the sqlrelay -
> freetds support..Ive followed the manual and see to it
> that all of my configuration follows what has been
> stated in manual.=20
>=20
>=20
> But the problem is i cant make it work.
> Here it the error message whenever i want to start a
> particular instance.
>=20
> <i>
> Starting listener:
>   sqlr-listener -id mysqltest -config
> /etc/sqlrelay/sqlrelay.conf
> Warning: could not change user to nobody
> Could not open: /var/cache/sqlrelay/tmp/mysqltest
> Make sure that the file and directory are readable and
> writable.
>=20
>=20
> sqlr-listener failed to start.
>=20
>=20
> Thanks to MP3.com for sponsoring:
>         Clustered/Replicated database support.
>         Perl API.
> </i>
>=20
>=20
> Please help..
>=20
>=20
> 	=09
> __________________________________=20
> Do you Yahoo!?=20
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/=20
>=20
>=20
> -------------------------------------------------------
> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
> Embedded(r) & Windows Mobile(tm) platforms, applications & content.  Regi=
ster
> by 3/29 & save $300 http://ads.osdn.com/?ad_id=3D6883&alloc_id=3D15149&op=
=3Dclick
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>=20
>=20
--=20
    __ _   Debian GNU User   Simon Martin
   / /(_)_ __  _   ___  __   Project Manager
  / / | | '_ \| | | \ \/ /   Milliways=20
 / /__| | | | | |_| |>  <    mailto: sm...@mi...
 \____/_|_| |_|\__,_/_/\_\   ICQ: 81183862

[Sqlrelay-discussion] Please help

[jo M. <jo...@ya...>]

I'm using ubuntu linux and activated the sqlrelay -
freetds support..Ive followed the manual and see to it
that all of my configuration follows what has been
stated in manual. 


But the problem is i cant make it work.
Here it the error message whenever i want to start a
particular instance.

<i>
Starting listener:
  sqlr-listener -id mysqltest -config
/etc/sqlrelay/sqlrelay.conf
Warning: could not change user to nobody
Could not open: /var/cache/sqlrelay/tmp/mysqltest
Make sure that the file and directory are readable and
writable.


sqlr-listener failed to start.


Thanks to MP3.com for sponsoring:
        Clustered/Replicated database support.
        Perl API.
</i>


Please help..


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

RE: [Sqlrelay-discussion] RE: [sqlrelay] sqlrelay-0.36pre4

[Samuel Luxford-W. <sl...@wi...>]

Ok - silly question I know - How do I run a trace?

 

As for FreeTDS I am running the stable version 0.62.3. I compiled it from
source.

 

I downloaded 0.62.4 and 0.62.dev.20050321 and re-compiled both FreeTDS and
SQLRelay 0.36.pre4 and still I get the same errors when running queries from
Zope so maybe it's something I have misconfigured but I don't know what...
sqlrsh still hangs by the way - if you let me know how to do a trace I
will....

 

Thanks,

 

Sam

 

  _____  

From: David Muse [mailto:dav...@fi...] 
Sent: 17 March 2005 17:45
To: sql...@ya...
Subject: Re: [Sqlrelay-discussion] RE: [sqlrelay] sqlrelay-0.36pre4

 


On Tue, 15 Mar 2005 18:40:50 -0000
Samuel Luxford-Watts <sl...@wi...> wrote:


This one is really strange.  "help;" doesn't even work?  Could you
strace it and send me the result?

> 
>  
> 
> I am still getting the zope connections+1 freeze error, along with the
> following for every query that returns results:
> 
>  
> 
> Client Library error:
> 
>         severity(78)
> 
>         layer(0)
> 
>         origin(0)
> 
>         number(51)
> 
> Error:  Attempt to initiate a new SQL Server operation with results
> pending.

This one I think I understand.  For some reason, each time a query
is run, the sqlr-connection-freetds daemon that ran it is getting hung
up.  After "connections" queries have been run, there are no available
connection daemons to run another one.

I have gotten that error before with certain versions of freetds and
then it went away in newer (or even older) versions.  What version are
you using?

I'm using the "stable" version (0.62.4) and it works for me.  If you're
not using the stable version, you may want to give it a try and see
what happens.  If you didn't build SQL Relay from source, let me know
and I'll give you instructions for building freetds and SQL Relay
against it.

Web Bug from
http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=groups/S=:
HM/A=2593423/rand=225096455

 


--------------
Winckworth Sherwood Solicitors and Parliamentary Agents 
DX 148400 WESTMINSTER 5 : 35 Great Peter Street, London SW1P 3LR
Telephone 020 7593 5000 Fax 020 7593 5099

-Confidentiality- 
This email message and any attachments are confidential; they may be subject to legal professional privilege and are intended for the named recipient only. If you are not the named recipient, please return the message and enclosures immediately and delete them from your system.

-Caution- 
Before advice received only by email (whether by attachment or otherwise) may be relied on, the authenticity of the communication must be verified by means independent of email.

-Regulation- 
The firm is regulated by the Law Society. 

-Partners- 
A list of partners is available for inspection at each office of the firm and on the firm's website at http://www.winckworths.co.uk
 

Re: [Sqlrelay-discussion] Re: is sqlrelay faster than sqlnet

[David M. <dav...@fi...>]

SQL Relay provides a pooling mechanism that can be used by software
written in C, C++, Perl, Python, PHP, Java, Ruby and TCL.  Some of
those languages have no native database connection pooling system.  A
single pool can be used by programs written in any of those languages.
If you have a site that uses software written in more than 1 programming
language, all the software can share the same pool.

SQL Relay can distribute client sessions over a cluster or a set of
replicated databases and it can be used on a middle tier between
web servers and database servers.  As far as I know, JDBC or .net
providers can't do that, but maybe they can.

Also, SQL Relay can provide access to databases from platforms for
which there is no native database client and no (decent) JDBC or .net
support. This includes most of the BSD platforms, SCO Unix and most non-
x86 (including embedded) Linux platforms.

Dave
dav...@fi...

On Sun, 20 Mar 2005 00:28:23 -0800 (PST)
zhu shi song <zhu...@ya...> wrote:

> Dear Sir,
>   Now oracle JDBC or .net data provider for oracle
> provide database connection pool mechanism.  The
> method can be used to solve the problem getting
> database connection slowly.  So what's the fundamental
> purpose to develop the sqlrelay?  And how can it
> compete with other database access methods such as
> jdbc or ado.net etc?  
>   tks
>   zhu
>   
> 
> 
> 
> 		
> __________________________________ 
> Do you Yahoo!? 
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/ 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real
> users. Discover which products truly live up to the hype. Start
> reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

[Sqlrelay-discussion] Re: is sqlrelay faster than sqlnet

[zhu s. s. <zhu...@ya...>]

Dear Sir,
  Now oracle JDBC or .net data provider for oracle
provide database connection pool mechanism.  The
method can be used to solve the problem getting
database connection slowly.  So what's the fundamental
purpose to develop the sqlrelay?  And how can it
compete with other database access methods such as
jdbc or ado.net etc?  
  tks
  zhu
  



		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

Re: [Sqlrelay-discussion] is sqlrelay fasterhan sqlnet

[David M. <dav...@fi...>]

On Fri, 18 Mar 2005 00:52:20 -0800 (PST)
zhu shi song <zhu...@ya...> wrote:

> dear sir,
>   who know whether sqlrelay is faster than oracle
> sqlnet? And why?
> 
>   tks
>   zhu

SQL Relay is generally faster than sqlnet for applications which log
into and out of the database over and over such as CGI's or other web-
based applications.

In web-based applications, to display a page, it's common to log into
the database, run a query or two and log out.  It generally takes less
time for an application to connect to SQL Relay than it does for an
application to connect directly to Oracle.  Often, it takes longer
for an application to connect to Oracle than it takes to actually run
the queries. When using SQL Relay, the connect time is generally shorter
which generally makes the application faster.

Until very recently, SQL Relay suffered from some performance-degrading
oversights which caused short queries (such as single column or row
selects or inserts, updated, or deletes) to run very slowly.  I've
fixed several of the issues and the next release should perform much
better.  The most recent prerelease has a few fixes in it too and runs
much faster than the most current stable release.

Dave
dav...@fi...

[Sqlrelay-discussion] is sqlrelay fasterhan sqlnet

[zhu s. s. <zhu...@ya...>]

dear sir,
  who know whether sqlrelay is faster than oracle
sqlnet? And why?

  tks
  zhu


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

[Sqlrelay-discussion] McAffee filtering email messages

[Chris F. <Ch...@si...>]

Howdy,

=20

David: our upgrade of McAffee Security started filtering all sqlrelay
discussion emails.  Apparently, the cause is related to the encoding
format of the emails.  Here is the message I get:

=20

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

=20


CORRUPT CONTENT ALERT


The content this replaces was found to be corrupt.

Cause of corruption: Invalid character set or encoding.=20

See your system administrator for further information.

Copyright (c) 1993-2004 Networks Associates Technology, Inc.
All Rights Reserved.
http://www.mcafeesecurity <http://www.mcafeesecurity.com>=20

=20

=20

Don't worry... I don't expect anything to happen on your side.  I'll
just have to read the lists at home instead of at work.  I just thought
you would like to know that there is some commercial email security
software out there that filters the discussion forum emails.

=20

Chris Falk
Senior Software Engineer
siberra
DIGITAL MEDIA SYSTEMS
Tel:   604-696-3224
Fax:  604-696-3201
ch...@si... <mailto:ch...@si...>=20
www.siberra.com <http://www.siberra.com/>=20

=20


The information in this e-mail message including any attachments is =
intended only for the named recipients above and may contain =
confidential or privileged information. If you have received this =
message in error, or are not the named recipient(s), please immediately =
notify the sender by replying to the message and deleting all copies of =
it from your computer.=20

Ce courriel de meme que toute piece jointe s'adresse seulement au(x) =
destinataire(s) designe(s) et peut contenir des renseignements =
confidentiels ou privilegies. Si vous avez recu ce message par erreur ou =
que vous n'etes pas un destinataire designe, veuillez avertir =
immediatement l'expediteur en repondant au message et effacez-en toutes =
les copies dans votre ordinateur.=20

Re: [Sqlrelay-discussion] Couldn't find id postgresqltest.

[David M. <dav...@fi...>]

Laszlo,

Sorry I missed this message before.  Were you ever able to figure out
what was going on?  I tried copying that instance definition into my
sqlrelay.conf file and it worked for me.  Is it possible that the
sqlrelay.conf file is in the wrong directory?  Could you post the
entire sqlrelay.conf file?  Maybe there's an anomaly somewhere else in
the file that's making it unreadable.

David Muse
dav...@fi...


> Hi all,
>=20
> I installed sqlrelay on Sarge and I added a postgre instance to my
> sqlrelay.conf:
>=20
> <instance id=3D"postgresqltest"
>            port=3D"9000"
>            socket=3D"/tmp/postgresqltest.socket"
>            dbase=3D"postgresql"
>            connections=3D"3"
>            maxconnections=3D"5"
>            maxqueuelength=3D"0"
>            growby=3D"1"
>            ttl=3D"60"
>            endofsession=3D"commit"
>            sessiontimeout=3D"600"
>            runasuser=3D"nobody"
>            runasgroup=3D"nobody"
>            cursors=3D"5"
>            authtier=3D"listener"
>            handoff=3D"pass">
> 	<users>
> 		<user user=3D"postgresqltest" password=3D"postgresqltest"/
> > </users>
> 	<connections>
> 		<connection connectionid=3D"postgresqltest"
> 		            string=3D"host=3Dlocalhost;db=3Dtestdb;user=3Dtestuser;pass=
word=3Dtestpassword"
> 		            metric=3D"1"/>
> 	</connections>
> </instance>
>=20
> Issuing the command
>=20
> 		sqlr-start -id postgresqltest
>=20
> it returns
>=20
> 		Couldn't find id postgresqltest.
>=20
> Why? What is wrong there?
> --=20
> L=E1szl=F3 Graf

Re: [Sqlrelay-discussion] Problems installing Rudiments 0.27 in Solaris 8.0

[David M. <dav...@fi...>]

Rudiments requires GNU make to build.  The default "make" that comes
with the solaris development kit won't work.  You probably need to
install GNU make and either put it ahead of the Sun make in your PATH
or run "gmake" instead of "make".

David Muse
dav...@fi...

On Mon, 14 Mar 2005 08:39:09 -0800 (PST)
Bernard Wu <eya...@ya...> wrote:

> Hi list members,
> Just trying to install rudiments-0.27 in Solaris 8.0.
> The configure runs fine.
> But when I try to run "make" I get the following
> errors :
> 
> panda:/tmp/rudiments-0.27 # make
> cd src; make all
> make: Fatal error in reader: ../features.mk, line 8:
> Unexpected end of line seen
> Current working directory /tmp/rudiments-0.27/src
> *** Error code 1
> make: Fatal error: Command failed for target `all'
> panda:/tmp/rudiments-0.27 #
> 
> I am using gcc 3.3.2.
> 
> Any help is much appreciated.
> TIA
> Benrie Wu
> 
> 
> 		
> __________________________________ 
> Do you Yahoo!? 
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/ 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real
> users. Discover which products truly live up to the hype. Start
> reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
> 

Re: [Sqlrelay-discussion] php, oracle & NVARCHAR

[David M. <dav...@fi...>]

Probably not.  SQL Relay translates all non-lob fields into strings
(ie. arrays of characters with NULL terminators).  There are plans for
better support of different column types but they have not been
implemented yet.

David Muse
dav...@fi...


On Wed, 16 Mar 2005 16:11:53 +0100
"ngl...@li..." <ngl...@li...> wrote:

> Hi, 
> 
> Php's oci implementation don't supports NVARCHAR columns type
> ( nvarchar columns are treated like varchar ).
> 
> Does sqlrelay php API provides better implementation to oracle data
> types?
> 
> Thank you.
> 
> =============
> php4 on IA64 
> oracle9i on IA64

[Sqlrelay-discussion] php, oracle & NVARCHAR

[nglrossi\@libero\.it <ngl...@li...>]

Hi, 

Php's oci implementation don't supports NVARCHAR columns type ( n=
varchar columns
are treated like varchar ).

Does sqlrelay php API pro=
vides better implementation to oracle data types?

Thank you.

=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
php4 on IA64 
oracle9i on IA64

=0A=
=0A=0A=0A____________________________________________________________=0AN=
avighi a 2 MEGA e i primi 3 mesi sono GRATIS. =0AScegli Libero Adsl Flat =
senza limiti su http://www.libero.it=0A

RE: [Sqlrelay-discussion] RE: [sqlrelay] sqlrelay-0.36pre4

[Samuel Luxford-W. <sl...@wi...>]

I am really sorry about the multiple posts on this - just figured out this
last issue was my fault! I didn't realize that it used the exact case typed
in the configuration file for dbase=. Oops

 

That aside - I cant seem to get sqlrsh working. I have made sure all is
configured right as far as I can see (honest). Sqlrsh runs and I get the 0>
prompt but when I type anything in - even 'help;' nothng is returned, not
even a prompt. I have to ctrl-c out.

 

I am still getting the zope connections+1 freeze error, along with the
following for every query that returns results:

 

Client Library error:

        severity(78)

        layer(0)

        origin(0)

        number(51)

Error:  Attempt to initiate a new SQL Server operation with results pending.

 

Cheers,


Sam

 

  _____  

From: Samuel Luxford-Watts [mailto:sl...@wi...] 
Sent: 15 March 2005 18:23
To: sql...@ya...; sql...@li...
Subject: [Sqlrelay-discussion] RE: [sqlrelay] sqlrelay-0.36pre4

 

Ok - found the problem with it not being able to start the connections
whilst running sqlr-start:

 

sqlr-start is looking for sqlr-connection-freeTDS yet 'make install'
installs it as sqlr-connection-freetds.

 

Sam

 

  _____  

From: Samuel Luxford-Watts [mailto:sl...@wi...] 
Sent: 15 March 2005 17:09
To: sql...@ya...; sql...@li...
Subject: RE: [sqlrelay] sqlrelay-0.36pre4

 

Hi,

 

I have downloaded and installed this version onto a new install of SuSE 9.2
and come across the following probe:

 

1.	For some reason when I run sql-start -id ID the listener starts then
it bonbs out saying sqlr-connection-freeTDS: command not found - I have
setup /etc/login.defs and /etc/profile.local with the correct paths I am
sure this is my fault - but I cant find what I should change at the moment
so...
2.	If I start everything manually I still get the same problem as
before when using ZOPE - it connects n times and n+1 query freezes zope
until I run sqlr-stop. n=connections

 

Cheers,


Sam

 

  _____  

From: David Muse [mailto:dav...@fi...] 
Sent: 10 March 2005 02:42
To: sql...@li...; sql...@ya...
Subject: [sqlrelay] sqlrelay-0.36pre4

 

Hello,

I just uploaded a new pre-release of SQL Relay to
http://www.firstworks.com/sqlrelay-0.36pre4.tar.gz
<http://www.firstworks.com/sqlrelay-0.36pre4.tar.gz> 

I shelled out some cash for a copy of Mac OS X 10.3 and though it won't
install on any of the 4 macs I have at my house, it will run (though
very slowly) under PearPC.  As a result, SQL Relay compiles much more
cleanly under OS X.  There are still a few wrinkles to iron out, but it
generally works.

Several people have recently pointed out some performance problems,
especially with insert/update/delete's or selects that return small
result sets.  I made some improvements that should help significantly in
that area and I have more planned for the 0.36 release.

sqlrsh can run scripts now.

There are a few more bug fixes that I don't remember offhand too.

Give it a try, let me know what you run into.

David Muse
dav...@fi...

Ps.  If you haven't switched, join the new mailing list at sourceforge. 
See http://sqlrelay.sourceforge.net/mailinglist.html
<http://sqlrelay.sourceforge.net/mailinglist.html> 

 


Yahoo! Groups Sponsor



ADVERTISEMENT
 
<http://us.ard.yahoo.com/SIG=12996q1sv/M=298184.6018725.7038619.3001176/D=gr
oups/S=1705007183:HM/EXP=1110992930/A=2593423/R=0/SIG=11el9gslf/*http:/www.n
etflix.com/Default?mqso=60190075> click here


Web Bug from MailScannerWebBug

 

  _____  

Yahoo! Groups Links

*	To visit your group on the web, go to:
http://groups.yahoo.com/group/sqlrelay/
<http://groups.yahoo.com/group/sqlrelay/> 
  
*	To unsubscribe from this group, send an email to:
sql...@ya...
<mailto:sql...@ya...?subject=Unsubscribe> 
  
*	Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/>  Terms of Service. 

Winckworth Sherwood Solicitors and Parliamentary Agents 
DX 148400 WESTMINSTER 5 : 35 Great Peter Street, London SW1P 3LR Telephone
020 7593 5000 Fax 020 7593 5099 

Confidentiality 
This email message and any attachments are confidential; they may be subject
to legal professional privilege and are intended for the named recipient
only. If you are not the named recipient, please return the message and
enclosures immediately and delete them from your system.

Caution 
Before advice received only by email (whether by attachment or otherwise)
may be relied on, the authenticity of the communication must be verified by
means independent of email. 


Regulation 
The firm is regulated by the Law Society. 

Partners 
A list of partners is available for inspection at each office of the firm
and on the firm's website at www.winckworths.co.uk
<http://www.winckworths.co.uk> 

Winckworth Sherwood Solicitors and Parliamentary Agents 
DX 148400 WESTMINSTER 5 : 35 Great Peter Street, London SW1P 3LR Telephone
020 7593 5000 Fax 020 7593 5099 

Confidentiality 
This email message and any attachments are confidential; they may be subject
to legal professional privilege and are intended for the named recipient
only. If you are not the named recipient, please return the message and
enclosures immediately and delete them from your system.

Caution 
Before advice received only by email (whether by attachment or otherwise)
may be relied on, the authenticity of the communication must be verified by
means independent of email. 


Regulation 
The firm is regulated by the Law Society. 

Partners 
A list of partners is available for inspection at each office of the firm
and on the firm's website at www.winckworths.co.uk
<http://www.winckworths.co.uk> 


--------------
Winckworth Sherwood Solicitors and Parliamentary Agents 
DX 148400 WESTMINSTER 5 : 35 Great Peter Street, London SW1P 3LR
Telephone 020 7593 5000 Fax 020 7593 5099

-Confidentiality- 
This email message and any attachments are confidential; they may be subject to legal professional privilege and are intended for the named recipient only. If you are not the named recipient, please return the message and enclosures immediately and delete them from your system.

-Caution- 
Before advice received only by email (whether by attachment or otherwise) may be relied on, the authenticity of the communication must be verified by means independent of email.

-Regulation- 
The firm is regulated by the Law Society. 

-Partners- 
A list of partners is available for inspection at each office of the firm and on the firm's website at http://www.winckworths.co.uk