sqlrelay-discussion Mailing List for SQL Relay (Page 45)
Brought to you by:
mused
Menu
▾
▴
sqlrelay-discussion — Discussion of topics related to SQL Relay
You can subscribe to this list here.
| 2005 |
Jan
|
Feb
(20) |
Mar
(27) |
Apr
(17) |
May
(32) |
Jun
(45) |
Jul
(49) |
Aug
(68) |
Sep
(44) |
Oct
(29) |
Nov
(64) |
Dec
(25) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2006 |
Jan
(61) |
Feb
(22) |
Mar
(25) |
Apr
(31) |
May
(18) |
Jun
(28) |
Jul
(19) |
Aug
(16) |
Sep
(8) |
Oct
(17) |
Nov
(32) |
Dec
(4) |
| 2007 |
Jan
(20) |
Feb
(25) |
Mar
(5) |
Apr
(12) |
May
(11) |
Jun
(18) |
Jul
(16) |
Aug
(22) |
Sep
(37) |
Oct
(20) |
Nov
(11) |
Dec
(2) |
| 2008 |
Jan
(11) |
Feb
(33) |
Mar
(12) |
Apr
(18) |
May
(22) |
Jun
(31) |
Jul
(23) |
Aug
(6) |
Sep
|
Oct
(10) |
Nov
(22) |
Dec
|
| 2009 |
Jan
(12) |
Feb
(8) |
Mar
(11) |
Apr
(20) |
May
(18) |
Jun
(7) |
Jul
(27) |
Aug
(2) |
Sep
(10) |
Oct
(5) |
Nov
(2) |
Dec
(1) |
| 2010 |
Jan
(11) |
Feb
(18) |
Mar
(10) |
Apr
(28) |
May
(28) |
Jun
|
Jul
(27) |
Aug
(9) |
Sep
(21) |
Oct
(2) |
Nov
(2) |
Dec
(11) |
| 2011 |
Jan
|
Feb
(2) |
Mar
(4) |
Apr
(2) |
May
(2) |
Jun
(44) |
Jul
(9) |
Aug
(2) |
Sep
(12) |
Oct
(7) |
Nov
(11) |
Dec
(7) |
| 2012 |
Jan
(5) |
Feb
|
Mar
(9) |
Apr
(9) |
May
(12) |
Jun
|
Jul
(13) |
Aug
(3) |
Sep
(3) |
Oct
(1) |
Nov
(1) |
Dec
(10) |
| 2013 |
Jan
(21) |
Feb
(3) |
Mar
(4) |
Apr
|
May
(3) |
Jun
(2) |
Jul
(3) |
Aug
(3) |
Sep
(3) |
Oct
|
Nov
|
Dec
(4) |
| 2014 |
Jan
(7) |
Feb
|
Mar
(1) |
Apr
|
May
(2) |
Jun
|
Jul
(4) |
Aug
(2) |
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2016 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2017 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2022 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Dave S. <dsu...@co...> - 2006-03-02 04:20:05
|
I have an interesting situation that I'm looking for a solution. I'm wondering if SQLRealy will be able to solve my problem. Please let me know what you think. I have a client with the following setup. 1) Back end database running Oracle 9i - running on Solaris 2) 4 front end web servers running Linux RedHat Enterprise, Apache, PHP 4, etc... 3) between the database server and the web servers is a firewall Now - the problem The firewall is setup in such a way that it will disconnect idle connections between the web server and oracle server after 30 minutes. For efficiency reasons the connection created from PHP to Oracle is a persistent connection (oci_pconnect). The obvious solution is to get rid of the firewall or at least reconfigure it to not drop these connections. I have been asking for this for about 2 years now and my client is not willing to make this change for whatever reason. But, now they are asking me to look into other solutions. SQLRelay was suggested to me as a possible solution and while it looks like it might work. It looks like it might silently reconnect the connection to Oracle if the firewall has decided to drop the connection. I'm just trying to see if anyone has any sort of experience of this or a similar situation and can let me know if they have had success in solving such a situation. The real test is of course to give it a try and see. But, before I go through the setup and modifying code to use SQLRelay, I was hoping for some more info from other users. Thanks, Dave Sugar dsu...@co... |
|
From: Dario L. <dl...@ti...> - 2006-02-28 13:20:31
|
Hi, do you have sysliblist in some other directory? Basicaly it is just text file with gcc options for linking libriaries, in my case: -ldl -lm -lpthread -lnsl Maybe you havent installed OCI development files? You should have oci.h somwhere otherwise if configure can't find oci.h it would not work. If it doesn't help try editing configure script to find out what configure is checking (which files, linking against what, ...) and adjust accordingly to your settings. BR Dario On Uto, 2006-02-28 at 15:06 +0200, Lauris Buk=C5=A1is-Haberkorns wrote: > Hi, >=20 > I get such error: >=20 > ***** Oracle ***************** > checking for oracle includes and libraries... cat: > /usr/lib/oracle/10.2.0.1/client/lib/sysliblist: No such file or directory > no > configure: WARNING: Oracle support will not be built. > ****************************** >=20 > I have installed oracle oci files from oracle rpm files, ORACLE_HOME is > set to /usr/lib/oracle/10.2.0.1/client >=20 > # ls /usr/lib/oracle/10.2.0.1/client/lib/ > classes12.jar libclntsh.so.10.1* libocci.so.10.1* libsqlplusic.so* > glogin.sql libnnz10.so* libociei.so* libsqlplus.so* > libclntsh.so@ libocci.so@ libocijdbc10.so* ojdbc14.jar >=20 > I think that all needed files is here so that shouldn't be the problem. > Any ideas how to fix that? >=20 > Lauris >=20 >=20 >=20 >=20 > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting langua= ge > that extends applications into web and mobile media. Attend the live webc= ast > and join the prime developer group breaking into this new coding territor= y! > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat= =3D121642 > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion -- 85. Though the Chinese should adore APL, it's FORTRAN they put their mone on |
|
From: <la...@he...> - 2006-02-28 13:06:45
|
Hi, I get such error: ***** Oracle ***************** checking for oracle includes and libraries... cat: /usr/lib/oracle/10.2.0.1/client/lib/sysliblist: No such file or directory no configure: WARNING: Oracle support will not be built. ****************************** I have installed oracle oci files from oracle rpm files, ORACLE_HOME is set to /usr/lib/oracle/10.2.0.1/client # ls /usr/lib/oracle/10.2.0.1/client/lib/ classes12.jar libclntsh.so.10.1* libocci.so.10.1* libsqlplusic.so* glogin.sql libnnz10.so* libociei.so* libsqlplus.so* libclntsh.so@ libocci.so@ libocijdbc10.so* ojdbc14.jar I think that all needed files is here so that shouldn't be the problem. Any ideas how to fix that? Lauris |
|
From: Ady W. <ady...@re...> - 2006-02-24 15:31:43
|
SQLRelay is a great job Congratulation David :) I have a case when i have a heavy load on php page, PHP is able to handle it, but not MySQL.... 10000 php access could be feasible, but not MySQL :D when i found this tools.... i found a great database pooling engine :D Again congratulation Arnaud Connois wrote: > > David, > > I don't know which one of thoses enhancements get that result, but I > use now half the mysql db connexions with 0.37 than the ones I was > using with 0.37pre3. Client connexions are handled much much faster > now... wahooo... > > Congratulations... and thanks for the great work you do ;) > > Arnaud Connois > > > > David Muse wrote: > >> Hello All, >> >> SQL Relay version 0.37 is out! Check it out at >> http://sqlrelay.sourceforge.net >> >> Notable features of this release: >> 64/32bit host/clients can talk to each other now >> single-quotes and backslashes are escaped by db connections >> that use fake binds now >> removed lago support >> fixed lots of tcl bugs >> fixed lots of php and php pear db bugs >> supports postgresql 8 native binds >> binary data gets returned properly now >> max query/string/lob/clob sizes are configurable for now >> added a configurable idle client timeout >> initscript prefix is configurable now >> added "loadbalanced" connection parameter >> fixed a bug where bind cursors weren't getting cleaned up >> oracle 8's fetch-at-once, max select list size and >> max item buffer size are configurable now >> DB2 connections detect a downed database now and recover >> fixed a bug where DB2 update/delete with no affected rows >> was returning an error >> added nls_lang connect string option for oracle >> fixed utf8/clob related crash >> there are now string, integer, float, clob and blob output >> binds, and you can now use them with sybase without >> having to cast output bind values to strings >> and probably lots of other stuff... >> >>> From a development perspective, some of the C, C++ and Java api's use >> >> different datatypes than 0.36.4. So, some of your code that compiled >> before may require some modifications. The modifications stemmed from >> changes to support x86_64 platforms. I don't imagine they'll change >> again before 1.0. >> >> Give it a try, report any bugs you find. Woohoo! >> >> David Muse >> dav...@fi... >> >> >> >> ------------------------------------------------------- >> This SF.net email is sponsored by: Splunk Inc. Do you grep through >> log files >> for problems? Stop! Download the new AJAX search engine that makes >> searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 >> _______________________________________________ >> Sqlrelay-discussion mailing list >> Sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >> >> > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log > files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > |
|
From: Arnaud C. <arn...@co...> - 2006-02-24 13:52:10
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content=3D"text/html;charset=3DUTF-8" http-equiv=3D"Content-Type"=
>
</head>
<body bgcolor=3D"#ffffff" text=3D"#000000">
<br>
Stupid me... You were right !!! It wasn't on my machine...<br>
I installed the package using pkg-get install binutils<br>
and it compiled fine :-)<br>
<br>
Thanks for the help.<br>
<br>
Arnaud<br>
<br>
<br>
Dario Lah wrote:
<blockquote cite=3D"mid1140764058.8136.1.camel@laki" type=3D"cite">
<pre wrap=3D"">Hi,
i look to me like you are missing ar utility. It is usually located
in /usr/ccs/bin. If you have it there add it to your PATH.
BR,
Dario
On =C4=8Cet, 2006-02-23 at 17:34 +0100, Arnaud Connois wrote:
</pre>
<blockquote type=3D"cite">
<pre wrap=3D"">Hi all,
I had no troubles on Linux, but today I'm trying to install Rudiment /=20
SQLRelay on Solaris 10 Sparc, and I can't get rudiment to compile...
The make step finishes like this (see below)
Does somebody had similar troubles in Solaris ?
Any help would be greatly apreciated...
Thanks
Arnaud
--
make[1]: Entering directory `/opt/packages/rudiments-0.29/src'
/bin/sh ../libtool --mode=3Dlink g++ -o librudiments.la namevaluepairs.lo=
=20
client.lo commandline.lo parameterstring.lo daemonprocess.lo process.lo=20
datetime.lo timezonefile.lo dtd.lo environment.lo filedescriptor.lo=20
file.lo shmfile.lo device.lo filesystem.lo directory.lo groupentry.lo=20
hostentry.lo inetclientsocket.lo inetserversocket.lo listener.lo=20
logger.lo memorypool.lo passwdentry.lo permissions.lo protocolentry.lo=20
randomnumber.lo regularexpression.lo rpcentry.lo semaphoreset.lo=20
server.lo serviceentry.lo shadowentry.lo sharedmemory.lo=20
signalclasses.lo charstring.lo character.lo stringbuffer.lo=20
unixclientsocket.lo modemclient.lo modemserver.lo unixserversocket.lo=20
variablebuffer.lo xmldom.lo xmldomnode.lo xmlsax.lo intervaltimer.lo=20
snooze.lo dynamiclib.lo crypt.lo rawbuffer.lo memorymap.lo mutex.lo=20
serialportprofile.lo serialport.lo chat.lo error.lo modemutil.lo=20
inetsocketutil.lo unixsocketutil.lo serversocket.lo clientsocket.lo=20
clientserverfactory.lo -lsocket -lnsl -lpthread -R/usr/sfw/lib=20
-L/usr/sfw/lib -lssl -lcrypto -lsocket -lnsl -ldl -lrt -lrt -lrt =20
-lresolv -ldl -rpath /usr/local/firstworks/lib -release 0.29=20
-version-info 1:0:0 -no-undefined
rm -fr .libs/librudiments-0.29.so.1 .libs/librudiments-0.29.so.1.0.0=20
.libs/librudiments.so
g++ -shared -Wl,-h -Wl,librudiments-0.29.so.1 -o=20
.libs/librudiments-0.29.so.1.0.0 .libs/namevaluepairs.o .libs/client.o=20
.libs/commandline.o .libs/parameterstring.o .libs/daemonprocess.o=20
.libs/process.o .libs/datetime.o .libs/timezonefile.o .libs/dtd.o=20
.libs/environment.o .libs/filedescriptor.o .libs/file.o .libs/shmfile.o=20
.libs/device.o .libs/filesystem.o .libs/directory.o .libs/groupentry.o=20
.libs/hostentry.o .libs/inetclientsocket.o .libs/inetserversocket.o=20
.libs/listener.o .libs/logger.o .libs/memorypool.o .libs/passwdentry.o=20
.libs/permissions.o .libs/protocolentry.o .libs/randomnumber.o=20
.libs/regularexpression.o .libs/rpcentry.o .libs/semaphoreset.o=20
.libs/server.o .libs/serviceentry.o .libs/shadowentry.o=20
.libs/sharedmemory.o .libs/signalclasses.o .libs/charstring.o=20
.libs/character.o .libs/stringbuffer.o .libs/unixclientsocket.o=20
.libs/modemclient.o .libs/modemserver.o .libs/unixserversocket.o=20
.libs/variablebuffer.o .libs/xmldom.o .libs/xmldomnode.o .libs/xmlsax.o=20
.libs/intervaltimer.o .libs/snooze.o .libs/dynamiclib.o .libs/crypt.o=20
.libs/rawbuffer.o .libs/memorymap.o .libs/mutex.o=20
.libs/serialportprofile.o .libs/serialport.o .libs/chat.o .libs/error.o=20
.libs/modemutil.o .libs/inetsocketutil.o .libs/unixsocketutil.o=20
.libs/serversocket.o .libs/clientsocket.o .libs/clientserverfactory.o =20
-R/usr/sfw/lib -lpthread -L/usr/sfw/lib -lssl -lcrypto -lsocket -lnsl=20
-lrt -lresolv -ldl -lc
(cd .libs && rm -f librudiments-0.29.so.1 && ln -s=20
librudiments-0.29.so.1.0.0 librudiments-0.29.so.1)
(cd .libs && rm -f librudiments.so && ln -s librudiments-=
0.29.so.1.0.0=20
librudiments.so)
false cru .libs/librudiments.a namevaluepairs.o client.o commandline.o=20
parameterstring.o daemonprocess.o process.o datetime.o timezonefile.o=20
dtd.o environment.o filedescriptor.o file.o shmfile.o device.o=20
filesystem.o directory.o groupentry.o hostentry.o inetclientsocket.o=20
inetserversocket.o listener.o logger.o memorypool.o passwdentry.o=20
permissions.o protocolentry.o randomnumber.o regularexpression.o=20
rpcentry.o semaphoreset.o server.o serviceentry.o shadowentry.o=20
sharedmemory.o signalclasses.o charstring.o character.o stringbuffer.o=20
unixclientsocket.o modemclient.o modemserver.o unixserversocket.o=20
variablebuffer.o xmldom.o xmldomnode.o xmlsax.o intervaltimer.o snooze.o=20
dynamiclib.o crypt.o rawbuffer.o memorymap.o mutex.o serialportprofile.o=20
serialport.o chat.o error.o modemutil.o inetsocketutil.o=20
unixsocketutil.o serversocket.o clientsocket.o clientserverfactory.o
make[1]: *** [librudiments.la] Error 1
make[1]: Leaving directory `/opt/packages/rudiments-0.29/src'
make: *** [all] Error 2
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
that extends applications into web and mobile media. Attend the live webc=
ast
and join the prime developer group breaking into this new coding territor=
y!
<a class=3D"moz-txt-link-freetext" href=3D"http://sel.as-us.falkag.net/se=
l?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=3D121642">http://sel.as-us.falk=
ag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=3D121642</=
a>
_______________________________________________
Sqlrelay-discussion mailing list
<a class=3D"moz-txt-link-abbreviated" href=3D"mailto:Sqlrelay-discussion@=
lists.sourceforge.net">Sql...@li...</a>
<a class=3D"moz-txt-link-freetext" href=3D"https://lists.sourceforge.net/=
lists/listinfo/sqlrelay-discussion">https://lists.sourceforge.net/lists/l=
istinfo/sqlrelay-discussion</a>
</pre>
</blockquote>
<pre wrap=3D""><!---->--
68. If we believe in data structures, we must believe in independent
(henc
simultaneous) processing. For why else would we collect items within=20
structure? Why do we tolerate languages that give us the one without th
other
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
that extends applications into web and mobile media. Attend the live webc=
ast
and join the prime developer group breaking into this new coding territor=
y!
<a class=3D"moz-txt-link-freetext" href=3D"http://sel.as-us.falkag.net/se=
l?cmd=3Dk&kid=110944&bid$1720&dat=121642">http://sel.as-us.falkag.net/sel=
?cmd=3Dk&kid=110944&bid$1720&dat=121642</a>
_______________________________________________
Sqlrelay-discussion mailing list
<a class=3D"moz-txt-link-abbreviated" href=3D"mailto:Sqlrelay-discussion@=
lists.sourceforge.net">Sql...@li...</a>
<a class=3D"moz-txt-link-freetext" href=3D"https://lists.sourceforge.net/=
lists/listinfo/sqlrelay-discussion">https://lists.sourceforge.net/lists/l=
istinfo/sqlrelay-discussion</a>
</pre>
</blockquote>
</body>
</html>
|
|
From: Dario L. <dl...@ti...> - 2006-02-24 07:10:12
|
Hi, i look to me like you are missing ar utility. It is usually located in /usr/ccs/bin. If you have it there add it to your PATH. BR, Dario On =C4=8Cet, 2006-02-23 at 17:34 +0100, Arnaud Connois wrote: > Hi all, >=20 > I had no troubles on Linux, but today I'm trying to install Rudiment /=20 > SQLRelay on Solaris 10 Sparc, and I can't get rudiment to compile... >=20 > The make step finishes like this (see below) >=20 > Does somebody had similar troubles in Solaris ? >=20 > Any help would be greatly apreciated... >=20 > Thanks >=20 > Arnaud >=20 > -- >=20 > make[1]: Entering directory `/opt/packages/rudiments-0.29/src' > /bin/sh ../libtool --mode=3Dlink g++ -o librudiments.la namevaluepairs.lo= =20 > client.lo commandline.lo parameterstring.lo daemonprocess.lo process.lo=20 > datetime.lo timezonefile.lo dtd.lo environment.lo filedescriptor.lo=20 > file.lo shmfile.lo device.lo filesystem.lo directory.lo groupentry.lo=20 > hostentry.lo inetclientsocket.lo inetserversocket.lo listener.lo=20 > logger.lo memorypool.lo passwdentry.lo permissions.lo protocolentry.lo=20 > randomnumber.lo regularexpression.lo rpcentry.lo semaphoreset.lo=20 > server.lo serviceentry.lo shadowentry.lo sharedmemory.lo=20 > signalclasses.lo charstring.lo character.lo stringbuffer.lo=20 > unixclientsocket.lo modemclient.lo modemserver.lo unixserversocket.lo=20 > variablebuffer.lo xmldom.lo xmldomnode.lo xmlsax.lo intervaltimer.lo=20 > snooze.lo dynamiclib.lo crypt.lo rawbuffer.lo memorymap.lo mutex.lo=20 > serialportprofile.lo serialport.lo chat.lo error.lo modemutil.lo=20 > inetsocketutil.lo unixsocketutil.lo serversocket.lo clientsocket.lo=20 > clientserverfactory.lo -lsocket -lnsl -lpthread -R/usr/sfw/lib=20 > -L/usr/sfw/lib -lssl -lcrypto -lsocket -lnsl -ldl -lrt -lrt -lrt =20 > -lresolv -ldl -rpath /usr/local/firstworks/lib -release 0.29=20 > -version-info 1:0:0 -no-undefined > rm -fr .libs/librudiments-0.29.so.1 .libs/librudiments-0.29.so.1.0.0=20 > .libs/librudiments.so > g++ -shared -Wl,-h -Wl,librudiments-0.29.so.1 -o=20 > .libs/librudiments-0.29.so.1.0.0 .libs/namevaluepairs.o .libs/client.o=20 > .libs/commandline.o .libs/parameterstring.o .libs/daemonprocess.o=20 > .libs/process.o .libs/datetime.o .libs/timezonefile.o .libs/dtd.o=20 > .libs/environment.o .libs/filedescriptor.o .libs/file.o .libs/shmfile.o=20 > .libs/device.o .libs/filesystem.o .libs/directory.o .libs/groupentry.o=20 > .libs/hostentry.o .libs/inetclientsocket.o .libs/inetserversocket.o=20 > .libs/listener.o .libs/logger.o .libs/memorypool.o .libs/passwdentry.o=20 > .libs/permissions.o .libs/protocolentry.o .libs/randomnumber.o=20 > .libs/regularexpression.o .libs/rpcentry.o .libs/semaphoreset.o=20 > .libs/server.o .libs/serviceentry.o .libs/shadowentry.o=20 > .libs/sharedmemory.o .libs/signalclasses.o .libs/charstring.o=20 > .libs/character.o .libs/stringbuffer.o .libs/unixclientsocket.o=20 > .libs/modemclient.o .libs/modemserver.o .libs/unixserversocket.o=20 > .libs/variablebuffer.o .libs/xmldom.o .libs/xmldomnode.o .libs/xmlsax.o=20 > .libs/intervaltimer.o .libs/snooze.o .libs/dynamiclib.o .libs/crypt.o=20 > .libs/rawbuffer.o .libs/memorymap.o .libs/mutex.o=20 > .libs/serialportprofile.o .libs/serialport.o .libs/chat.o .libs/error.o=20 > .libs/modemutil.o .libs/inetsocketutil.o .libs/unixsocketutil.o=20 > .libs/serversocket.o .libs/clientsocket.o .libs/clientserverfactory.o =20 > -R/usr/sfw/lib -lpthread -L/usr/sfw/lib -lssl -lcrypto -lsocket -lnsl=20 > -lrt -lresolv -ldl -lc > (cd .libs && rm -f librudiments-0.29.so.1 && ln -s=20 > librudiments-0.29.so.1.0.0 librudiments-0.29.so.1) > (cd .libs && rm -f librudiments.so && ln -s librudiments-0.29.so.1.0.0=20 > librudiments.so) > false cru .libs/librudiments.a namevaluepairs.o client.o commandline.o=20 > parameterstring.o daemonprocess.o process.o datetime.o timezonefile.o=20 > dtd.o environment.o filedescriptor.o file.o shmfile.o device.o=20 > filesystem.o directory.o groupentry.o hostentry.o inetclientsocket.o=20 > inetserversocket.o listener.o logger.o memorypool.o passwdentry.o=20 > permissions.o protocolentry.o randomnumber.o regularexpression.o=20 > rpcentry.o semaphoreset.o server.o serviceentry.o shadowentry.o=20 > sharedmemory.o signalclasses.o charstring.o character.o stringbuffer.o=20 > unixclientsocket.o modemclient.o modemserver.o unixserversocket.o=20 > variablebuffer.o xmldom.o xmldomnode.o xmlsax.o intervaltimer.o snooze.o=20 > dynamiclib.o crypt.o rawbuffer.o memorymap.o mutex.o serialportprofile.o=20 > serialport.o chat.o error.o modemutil.o inetsocketutil.o=20 > unixsocketutil.o serversocket.o clientsocket.o clientserverfactory.o > make[1]: *** [librudiments.la] Error 1 > make[1]: Leaving directory `/opt/packages/rudiments-0.29/src' > make: *** [all] Error 2 >=20 >=20 >=20 > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting langua= ge > that extends applications into web and mobile media. Attend the live webc= ast > and join the prime developer group breaking into this new coding territor= y! > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat= =3D121642 > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion -- 68. If we believe in data structures, we must believe in independent (henc simultaneous) processing. For why else would we collect items within=20 structure? Why do we tolerate languages that give us the one without th other |
|
From: Arnaud C. <arn...@co...> - 2006-02-23 16:34:53
|
Hi all, I had no troubles on Linux, but today I'm trying to install Rudiment / SQLRelay on Solaris 10 Sparc, and I can't get rudiment to compile... The make step finishes like this (see below) Does somebody had similar troubles in Solaris ? Any help would be greatly apreciated... Thanks Arnaud -- make[1]: Entering directory `/opt/packages/rudiments-0.29/src' /bin/sh ../libtool --mode=link g++ -o librudiments.la namevaluepairs.lo client.lo commandline.lo parameterstring.lo daemonprocess.lo process.lo datetime.lo timezonefile.lo dtd.lo environment.lo filedescriptor.lo file.lo shmfile.lo device.lo filesystem.lo directory.lo groupentry.lo hostentry.lo inetclientsocket.lo inetserversocket.lo listener.lo logger.lo memorypool.lo passwdentry.lo permissions.lo protocolentry.lo randomnumber.lo regularexpression.lo rpcentry.lo semaphoreset.lo server.lo serviceentry.lo shadowentry.lo sharedmemory.lo signalclasses.lo charstring.lo character.lo stringbuffer.lo unixclientsocket.lo modemclient.lo modemserver.lo unixserversocket.lo variablebuffer.lo xmldom.lo xmldomnode.lo xmlsax.lo intervaltimer.lo snooze.lo dynamiclib.lo crypt.lo rawbuffer.lo memorymap.lo mutex.lo serialportprofile.lo serialport.lo chat.lo error.lo modemutil.lo inetsocketutil.lo unixsocketutil.lo serversocket.lo clientsocket.lo clientserverfactory.lo -lsocket -lnsl -lpthread -R/usr/sfw/lib -L/usr/sfw/lib -lssl -lcrypto -lsocket -lnsl -ldl -lrt -lrt -lrt -lresolv -ldl -rpath /usr/local/firstworks/lib -release 0.29 -version-info 1:0:0 -no-undefined rm -fr .libs/librudiments-0.29.so.1 .libs/librudiments-0.29.so.1.0.0 .libs/librudiments.so g++ -shared -Wl,-h -Wl,librudiments-0.29.so.1 -o .libs/librudiments-0.29.so.1.0.0 .libs/namevaluepairs.o .libs/client.o .libs/commandline.o .libs/parameterstring.o .libs/daemonprocess.o .libs/process.o .libs/datetime.o .libs/timezonefile.o .libs/dtd.o .libs/environment.o .libs/filedescriptor.o .libs/file.o .libs/shmfile.o .libs/device.o .libs/filesystem.o .libs/directory.o .libs/groupentry.o .libs/hostentry.o .libs/inetclientsocket.o .libs/inetserversocket.o .libs/listener.o .libs/logger.o .libs/memorypool.o .libs/passwdentry.o .libs/permissions.o .libs/protocolentry.o .libs/randomnumber.o .libs/regularexpression.o .libs/rpcentry.o .libs/semaphoreset.o .libs/server.o .libs/serviceentry.o .libs/shadowentry.o .libs/sharedmemory.o .libs/signalclasses.o .libs/charstring.o .libs/character.o .libs/stringbuffer.o .libs/unixclientsocket.o .libs/modemclient.o .libs/modemserver.o .libs/unixserversocket.o .libs/variablebuffer.o .libs/xmldom.o .libs/xmldomnode.o .libs/xmlsax.o .libs/intervaltimer.o .libs/snooze.o .libs/dynamiclib.o .libs/crypt.o .libs/rawbuffer.o .libs/memorymap.o .libs/mutex.o .libs/serialportprofile.o .libs/serialport.o .libs/chat.o .libs/error.o .libs/modemutil.o .libs/inetsocketutil.o .libs/unixsocketutil.o .libs/serversocket.o .libs/clientsocket.o .libs/clientserverfactory.o -R/usr/sfw/lib -lpthread -L/usr/sfw/lib -lssl -lcrypto -lsocket -lnsl -lrt -lresolv -ldl -lc (cd .libs && rm -f librudiments-0.29.so.1 && ln -s librudiments-0.29.so.1.0.0 librudiments-0.29.so.1) (cd .libs && rm -f librudiments.so && ln -s librudiments-0.29.so.1.0.0 librudiments.so) false cru .libs/librudiments.a namevaluepairs.o client.o commandline.o parameterstring.o daemonprocess.o process.o datetime.o timezonefile.o dtd.o environment.o filedescriptor.o file.o shmfile.o device.o filesystem.o directory.o groupentry.o hostentry.o inetclientsocket.o inetserversocket.o listener.o logger.o memorypool.o passwdentry.o permissions.o protocolentry.o randomnumber.o regularexpression.o rpcentry.o semaphoreset.o server.o serviceentry.o shadowentry.o sharedmemory.o signalclasses.o charstring.o character.o stringbuffer.o unixclientsocket.o modemclient.o modemserver.o unixserversocket.o variablebuffer.o xmldom.o xmldomnode.o xmlsax.o intervaltimer.o snooze.o dynamiclib.o crypt.o rawbuffer.o memorymap.o mutex.o serialportprofile.o serialport.o chat.o error.o modemutil.o inetsocketutil.o unixsocketutil.o serversocket.o clientsocket.o clientserverfactory.o make[1]: *** [librudiments.la] Error 1 make[1]: Leaving directory `/opt/packages/rudiments-0.29/src' make: *** [all] Error 2 |
|
From: Maciej W. <mac...@co...> - 2006-02-22 07:32:23
|
Hi, thanks for the answer. >FYI, I replaced defineOutputBind (which defined a string output bind) >with defineOutputBindInteger, defineOutputBindDouble and >defineOutputBindString. > > I've already used these new functions - they're working correcly :) -- Maciej Wisniowski |
|
From: David M. <dav...@fi...> - 2006-02-22 02:56:07
|
Thanks, I'll update the java doc and add an entry to the faq about the defineOutputBind/getOutputBind change. FYI, I replaced defineOutputBind (which defined a string output bind) with defineOutputBindInteger, defineOutputBindDouble and defineOutputBindString. And similar for getOutputBind. The new functions handle string, integer and double binds rather than just string binds. Dave dav...@fi... On Mon, 2006-02-06 at 13:26 +0100, Maciej Wisniowski wrote: > Documentation should be updated. > Two things I've found that are wrong: > In Java API - port number is short not int in constructor so it can't be: > > new SQLRConnection(host, 9002, socket, user, pwd, 0, 1); > > but 9002 has to be casted to short > > > Second thing are changes in Python API :/ > Methods: defineOutputBind and getOutputBind no longer exists. > > These changes in Python are not mentioned in the release info > too (or I can't figure them out). > |
|
From: David M. <dav...@fi...> - 2006-02-22 02:31:47
|
Hey Maciej, For now, that's what you have to do. It would be nice to be able to bind a date object. Most languages have some kind of date class. I'll add it to the TODO list and see what I can do. Dave On Tue, 2006-02-07 at 09:47 +0100, Maciej Wisniowski wrote: > Hi > > I wonder how should I bind to oracle procedure which has DATE parameter. > > Suppose this is OUT parameter, then, in Python API, I have only: > defineOutputBindInt > defineOutputBindDouble > defineOutputBindString > > what should I do with date? > > Now I simply write: > begin > :func_ret:=BLA_PROC(to_date(:A_DATA_X,'YYYY-MM-DD'), :A_OPIS); > end; > > and I bind to string A_DATA. Is this a correct way? > |
|
From: David M. <dav...@fi...> - 2006-02-22 02:26:27
|
Looks like re-libtoolizing fixed it. It'll be in the next release. Thanks for finding that. Dave dav...@fi... On Fri, 2006-02-17 at 15:44 +0100, Arnaud Connois wrote: > David, > > This has still to be corrected manually in libtool to compiled correctly > in x86_64 environment (in both rudiments-0.29 & sqlrelay-0.37)... It's > no big deal and far from being critical, but if you have the time to > integrate it in a future release, would be great ;) > > Thanks > > Arnaud Connois > > > Arnaud Connois wrote: > > > > > Hi all, > > > > A compilation tip for people using x86_64 Linux machines (In my case > > Fedora Core 4 on AMD Operon) : > > > > Rudiment and SqlRelay "configure" seems to incorrectly detect the > > locations of the 64 bits libraries... > > > > To get compilation to work do (for both rudiment and sqlrelay) : > > > > - ./configure (with your favorites parameters) > > > > - Edit the "libtool" file and add locate the "sys_lib_search_path_spec" > > and "sys_lib_dlsearch_path_spec" lines... Add to the existing value : > > "/lib64 /usr/lib64 /usr/local/lib64" > > > > Should look like this : > > > > # Compile-time system search path for libraries > > sys_lib_search_path_spec=" (...lots of paths here...) /lib64 /usr/lib64 > > /usr/local/lib64" > > > > # Run-time system search path for libraries > > sys_lib_dlsearch_path_spec="(...some paths here...) /lib64 /usr/lib64 > > /usr/local/lib64" > > > > - Then run make and make install > > > > Maybe this is a little crude but it works. > > > > There was exactly the same problem in PHP 4.3.9... They fixed it in > > 4.4.1. > > > > Maybe we could have this fixed in Final 0.37 of Sqlrelay, even if it > > is far from critical... (This was the RFE part of the mail, hehehe) > > > > Cheers > > > > Arnaud > > > > > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by the JBoss Inc. Get Certified Today > > Register for a JBoss Training Course. Free Certification Exam > > for All Training Attendees Through End of 2005. For more info visit: > > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click > > _______________________________________________ > > Sqlrelay-discussion mailing list > > Sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: Arnaud C. <arn...@co...> - 2006-02-17 14:44:34
|
David, This has still to be corrected manually in libtool to compiled correctly in x86_64 environment (in both rudiments-0.29 & sqlrelay-0.37)... It's no big deal and far from being critical, but if you have the time to integrate it in a future release, would be great ;) Thanks Arnaud Connois Arnaud Connois wrote: > > Hi all, > > A compilation tip for people using x86_64 Linux machines (In my case > Fedora Core 4 on AMD Operon) : > > Rudiment and SqlRelay "configure" seems to incorrectly detect the > locations of the 64 bits libraries... > > To get compilation to work do (for both rudiment and sqlrelay) : > > - ./configure (with your favorites parameters) > > - Edit the "libtool" file and add locate the "sys_lib_search_path_spec" > and "sys_lib_dlsearch_path_spec" lines... Add to the existing value : > "/lib64 /usr/lib64 /usr/local/lib64" > > Should look like this : > > # Compile-time system search path for libraries > sys_lib_search_path_spec=" (...lots of paths here...) /lib64 /usr/lib64 > /usr/local/lib64" > > # Run-time system search path for libraries > sys_lib_dlsearch_path_spec="(...some paths here...) /lib64 /usr/lib64 > /usr/local/lib64" > > - Then run make and make install > > Maybe this is a little crude but it works. > > There was exactly the same problem in PHP 4.3.9... They fixed it in > 4.4.1. > > Maybe we could have this fixed in Final 0.37 of Sqlrelay, even if it > is far from critical... (This was the RFE part of the mail, hehehe) > > Cheers > > Arnaud > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by the JBoss Inc. Get Certified Today > Register for a JBoss Training Course. Free Certification Exam > for All Training Attendees Through End of 2005. For more info visit: > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&op=click > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion |
|
From: Arnaud C. <arn...@co...> - 2006-02-17 14:38:50
|
David, I don't know which one of thoses enhancements get that result, but I use now half the mysql db connexions with 0.37 than the ones I was using with 0.37pre3. Client connexions are handled much much faster now... wahooo... Congratulations... and thanks for the great work you do ;) Arnaud Connois David Muse wrote: >Hello All, > >SQL Relay version 0.37 is out! Check it out at >http://sqlrelay.sourceforge.net > >Notable features of this release: > 64/32bit host/clients can talk to each other now > single-quotes and backslashes are escaped by db connections > that use fake binds now > removed lago support > fixed lots of tcl bugs > fixed lots of php and php pear db bugs > supports postgresql 8 native binds > binary data gets returned properly now > max query/string/lob/clob sizes are configurable for now > added a configurable idle client timeout > initscript prefix is configurable now > added "loadbalanced" connection parameter > fixed a bug where bind cursors weren't getting cleaned up > oracle 8's fetch-at-once, max select list size and > max item buffer size are configurable now > DB2 connections detect a downed database now and recover > fixed a bug where DB2 update/delete with no affected rows > was returning an error > added nls_lang connect string option for oracle > fixed utf8/clob related crash > there are now string, integer, float, clob and blob output > binds, and you can now use them with sybase without > having to cast output bind values to strings > and probably lots of other stuff... > >>From a development perspective, some of the C, C++ and Java api's use >different datatypes than 0.36.4. So, some of your code that compiled >before may require some modifications. The modifications stemmed from >changes to support x86_64 platforms. I don't imagine they'll change >again before 1.0. > >Give it a try, report any bugs you find. Woohoo! > >David Muse >dav...@fi... > > > >------------------------------------------------------- >This SF.net email is sponsored by: Splunk Inc. Do you grep through log files >for problems? Stop! Download the new AJAX search engine that makes >searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 >_______________________________________________ >Sqlrelay-discussion mailing list >Sql...@li... >https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > |
|
From: Felipe C. <fel...@te...> - 2006-02-15 21:55:20
|
Hello,
I am trying to compile it on a linux machine, and I have some error related
to postgres.
I would be very thankful if someone could help me.
./configure \
--disable-oracle --disable-msql \
--disable-sqlite \
--disable-freetds \
--disable-sybase \
--disable-odbc \
--disable-db2 \
--disable-interbase \
--disable-mdbtools \
--with-postgresql-prefix=3D/var/lib/pgsql
***** PostgreSQL *************
checking if PostgreSQL can be dynamically linked without -lcrypt... yes
checking if PostgreSQL has PQfmod... yes
checking if PostgreSQL has PQsetNoticeProcessor... yes
checking if PostgreSQL has PQexecParams... yes
postgresql libs... -lpq
******************************
***** Summary ***********************************************
Version : 0.37
API's : C++ C Perl Python PHP
Connections : Oracle7 no Oracle8 no
MySQL dynamic mSQL no
PostgreSQL dynamic SQLite no
FreeTDS no Sybase no
ODBC no DB2 no
Interbase no MDB Tools no
*************************************************************
make -C postgresql all
make[3]: Entrando no diret=F3rio `/usr/local/src/sqlrelay-0.37
/src/connections/postgresql'
/bin/sh ../../../libtool --mode=3Dcompile g++ -Wall -pipe -pthread -I./
-I../../../ -I../../../src/common -I../../../src/util
-I../../../src/connection -I/usr/local/firstworks/include -pthread
-I../../../src/api/c++/include -c postgresqlconnection.C -o
postgresqlconnection.lo
g++ -Wall -pipe -pthread -I./ -I../../../ -I../../../src/common
-I../../../src/util -I../../../src/connection
-I/usr/local/firstworks/include -pthread -I../../../src/api/c++/include -c
postgresqlconnection.C -fPIC -DPIC -o .libs/postgresqlconnection.o
postgresqlconnection.C: In member function `virtual bool
postgresqlcursor::prepareQuery(const char*, unsigned int)':
postgresqlconnection.C:236: `PQprepare' undeclared (first use this function=
)
postgresqlconnection.C:236: (Each undeclared identifier is reported only
once
for each function it appears in.)
make[3]: ** [postgresqlconnection.lo] Erro 1
make[3]: Saindo do diret=F3rio `/usr/local/src/sqlrelay-0.37
/src/connections/postgresql'
make[2]: ** [all] Erro 2
make[2]: Saindo do diret=F3rio `/usr/local/src/sqlrelay-0.37/src/connection=
s'
make[1]: ** [all] Erro 2
make[1]: Saindo do diret=F3rio `/usr/local/src/sqlrelay-0.37/src'
make: ** [all] Erro 2
|
|
From: Jason H. <ja...@ey...> - 2006-02-09 15:01:31
|
I have a clean copy of cywin to which I d/l &installed the latest rudiments, sqlrelay and sqlite (3.3.3). This is on Cygwin Built sqlrelay as static with sqlite in it - and that is all (aside from language bindings) I made a database with one test table and one row in SQLite. I started up sqlrelay (following all the instructions including CYGWIN=server and handoff=reconnect) Every query (select * from testable) returns : Database is locked The same is true for every insert. I've restarted sqlrelay several times via sqlr-stop. Any ideas? --- Regards, Jason Hihn Eyemaginations, Inc. 8600 LaSalle Road Chester Building, Suite #300 Towson, MD 21286 Domestic: 877.321.5481 ext. 117 International: 410.321.5481 ext. 117 Fax: 443.946.0203 ja...@ey... www.eyemaginations.com www.3d-eye.com ================================================= The information transmitted within this email document or fax is intended only for the person(s) or entity to which it is specifically addressed and may contain confidential and/or privileged material of Eyemaginations. Any re-creation, review, distribution, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended parties is completely prohibited. If you have received this email in error, please contact the sender or author and permanently delete and destroy the email from any computer which houses its contents. ================================================= |
|
From: Maciej W. <mac...@co...> - 2006-02-07 08:48:10
|
Hi
I wonder how should I bind to oracle procedure which has DATE parameter.
Suppose this is OUT parameter, then, in Python API, I have only:
defineOutputBindInt
defineOutputBindDouble
defineOutputBindString
what should I do with date?
Now I simply write:
begin
:func_ret:=BLA_PROC(to_date(:A_DATA_X,'YYYY-MM-DD'), :A_OPIS);
end;
and I bind to string A_DATA. Is this a correct way?
--
Maciej Wisniowski
|
|
From: Maciej W. <mac...@co...> - 2006-02-06 12:26:56
|
Documentation should be updated. Two things I've found that are wrong: In Java API - port number is short not int in constructor so it can't be: new SQLRConnection(host, 9002, socket, user, pwd, 0, 1); but 9002 has to be casted to short Second thing are changes in Python API :/ Methods: defineOutputBind and getOutputBind no longer exists. These changes in Python are not mentioned in the release info too (or I can't figure them out). -- Maciej Wisniowski |
|
From: Deepak M. <dee...@ma...> - 2006-02-03 12:30:14
|
please unsubscribe me from this list --=20 ___________________________________________________ Play 100s of games for FREE! http://games.mail.com/ |
|
From: Rodney H. <rh...@et...> - 2006-02-02 14:52:59
|
updating rudiments resolved the compile error. thanks rodney David Muse wrote: > What version of rudiments are you compiling against? I failed to > mention, but I also just released a new version of rudiments, 0.29. > It's required for sqlrelay-0.37 > > Dave > dav...@fi... > > On Wed, 2006-02-01 at 09:17 -0700, Rodney Holm wrote: > >>Thanks David, >> >>got the error below when trying to compile 0.37 on Suse 9.2 >> >>thanks >>rodney >> >> >> >>In file included from debugfile.C:4: >>debugfile.h:22: error: type specifier omitted for parameter `uint32_t' >>debugfile.h:22: error: syntax error before `)' token >>debugfile.h:25: error: type specifier omitted for parameter `uint32_t' >>debugfile.h:25: error: syntax error before `)' token >>debugfile.h:26: error: type specifier omitted for parameter `uint32_t' >>debugfile.h:26: error: syntax error before `)' token >>debugfile.C: In member function `void debugfile::debugPrint(const char*, >>int, int)': >>debugfile.C:79: error: call of overloaded `write(char*&, int32_t&, >>int32_t&)' is ambiguous >> >> >>David Muse wrote: >> >>>Hello All, >>> >>>SQL Relay version 0.37 is out! Check it out at >>>http://sqlrelay.sourceforge.net >>> >>>Notable features of this release: >>> 64/32bit host/clients can talk to each other now >>> single-quotes and backslashes are escaped by db connections >>> that use fake binds now >>> removed lago support >>> fixed lots of tcl bugs >>> fixed lots of php and php pear db bugs >>> supports postgresql 8 native binds >>> binary data gets returned properly now >>> max query/string/lob/clob sizes are configurable for now >>> added a configurable idle client timeout >>> initscript prefix is configurable now >>> added "loadbalanced" connection parameter >>> fixed a bug where bind cursors weren't getting cleaned up >>> oracle 8's fetch-at-once, max select list size and >>> max item buffer size are configurable now >>> DB2 connections detect a downed database now and recover >>> fixed a bug where DB2 update/delete with no affected rows >>> was returning an error >>> added nls_lang connect string option for oracle >>> fixed utf8/clob related crash >>> there are now string, integer, float, clob and blob output >>> binds, and you can now use them with sybase without >>> having to cast output bind values to strings >>> and probably lots of other stuff... >>> >>>>From a development perspective, some of the C, C++ and Java api's use >>>different datatypes than 0.36.4. So, some of your code that compiled >>>before may require some modifications. The modifications stemmed from >>>changes to support x86_64 platforms. I don't imagine they'll change >>>again before 1.0. >>> >>>Give it a try, report any bugs you find. Woohoo! >>> >>>David Muse >>>dav...@fi... >>> >>> >>> >>>------------------------------------------------------- >>>This SF.net email is sponsored by: Splunk Inc. Do you grep through log files >>>for problems? Stop! Download the new AJAX search engine that makes >>>searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 >>>_______________________________________________ >>>Sqlrelay-discussion mailing list >>>Sql...@li... >>>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >> >> >>------------------------------------------------------- >>This SF.net email is sponsored by: Splunk Inc. Do you grep through log files >>for problems? Stop! Download the new AJAX search engine that makes >>searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! >>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 >>_______________________________________________ >>Sqlrelay-discussion mailing list >>Sql...@li... >>https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion >> > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion |
|
From: David M. <dav...@fi...> - 2006-02-01 20:17:25
|
Sorry, it's not currently possible to get live statistics. It's on the TODO list, but I haven't implemented it yet. Dave dav...@fi... On Tue, 2006-01-31 at 11:43 -0700, Rodney Holm wrote: > Greetings. > > Is it currently possible to obtain live statistics for the defined > instances? > > What I would like to see is things like: > # of active connections > # of queries sent > # of rows returned > # of ORA errors > # of requests handled by the listener > > Is that information stored somewhere currently and just not accessible > or would the storage mechanisms need to be built into the objects? > > thanks > rodney > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: David M. <dav...@fi...> - 2006-02-01 20:13:24
|
What version of rudiments are you compiling against? I failed to mention, but I also just released a new version of rudiments, 0.29. It's required for sqlrelay-0.37 Dave dav...@fi... On Wed, 2006-02-01 at 09:17 -0700, Rodney Holm wrote: > Thanks David, > > got the error below when trying to compile 0.37 on Suse 9.2 > > thanks > rodney > > > > In file included from debugfile.C:4: > debugfile.h:22: error: type specifier omitted for parameter `uint32_t' > debugfile.h:22: error: syntax error before `)' token > debugfile.h:25: error: type specifier omitted for parameter `uint32_t' > debugfile.h:25: error: syntax error before `)' token > debugfile.h:26: error: type specifier omitted for parameter `uint32_t' > debugfile.h:26: error: syntax error before `)' token > debugfile.C: In member function `void debugfile::debugPrint(const char*, > int, int)': > debugfile.C:79: error: call of overloaded `write(char*&, int32_t&, > int32_t&)' is ambiguous > > > David Muse wrote: > > Hello All, > > > > SQL Relay version 0.37 is out! Check it out at > > http://sqlrelay.sourceforge.net > > > > Notable features of this release: > > 64/32bit host/clients can talk to each other now > > single-quotes and backslashes are escaped by db connections > > that use fake binds now > > removed lago support > > fixed lots of tcl bugs > > fixed lots of php and php pear db bugs > > supports postgresql 8 native binds > > binary data gets returned properly now > > max query/string/lob/clob sizes are configurable for now > > added a configurable idle client timeout > > initscript prefix is configurable now > > added "loadbalanced" connection parameter > > fixed a bug where bind cursors weren't getting cleaned up > > oracle 8's fetch-at-once, max select list size and > > max item buffer size are configurable now > > DB2 connections detect a downed database now and recover > > fixed a bug where DB2 update/delete with no affected rows > > was returning an error > > added nls_lang connect string option for oracle > > fixed utf8/clob related crash > > there are now string, integer, float, clob and blob output > > binds, and you can now use them with sybase without > > having to cast output bind values to strings > > and probably lots of other stuff... > > > >>From a development perspective, some of the C, C++ and Java api's use > > different datatypes than 0.36.4. So, some of your code that compiled > > before may require some modifications. The modifications stemmed from > > changes to support x86_64 platforms. I don't imagine they'll change > > again before 1.0. > > > > Give it a try, report any bugs you find. Woohoo! > > > > David Muse > > dav...@fi... > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > > for problems? Stop! Download the new AJAX search engine that makes > > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > > _______________________________________________ > > Sqlrelay-discussion mailing list > > Sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: Rodney H. <rh...@et...> - 2006-02-01 16:07:29
|
Thanks David, got the error below when trying to compile 0.37 on Suse 9.2 thanks rodney In file included from debugfile.C:4: debugfile.h:22: error: type specifier omitted for parameter `uint32_t' debugfile.h:22: error: syntax error before `)' token debugfile.h:25: error: type specifier omitted for parameter `uint32_t' debugfile.h:25: error: syntax error before `)' token debugfile.h:26: error: type specifier omitted for parameter `uint32_t' debugfile.h:26: error: syntax error before `)' token debugfile.C: In member function `void debugfile::debugPrint(const char*, int, int)': debugfile.C:79: error: call of overloaded `write(char*&, int32_t&, int32_t&)' is ambiguous David Muse wrote: > Hello All, > > SQL Relay version 0.37 is out! Check it out at > http://sqlrelay.sourceforge.net > > Notable features of this release: > 64/32bit host/clients can talk to each other now > single-quotes and backslashes are escaped by db connections > that use fake binds now > removed lago support > fixed lots of tcl bugs > fixed lots of php and php pear db bugs > supports postgresql 8 native binds > binary data gets returned properly now > max query/string/lob/clob sizes are configurable for now > added a configurable idle client timeout > initscript prefix is configurable now > added "loadbalanced" connection parameter > fixed a bug where bind cursors weren't getting cleaned up > oracle 8's fetch-at-once, max select list size and > max item buffer size are configurable now > DB2 connections detect a downed database now and recover > fixed a bug where DB2 update/delete with no affected rows > was returning an error > added nls_lang connect string option for oracle > fixed utf8/clob related crash > there are now string, integer, float, clob and blob output > binds, and you can now use them with sybase without > having to cast output bind values to strings > and probably lots of other stuff... > >>From a development perspective, some of the C, C++ and Java api's use > different datatypes than 0.36.4. So, some of your code that compiled > before may require some modifications. The modifications stemmed from > changes to support x86_64 platforms. I don't imagine they'll change > again before 1.0. > > Give it a try, report any bugs you find. Woohoo! > > David Muse > dav...@fi... > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion |
|
From: David M. <dav...@fi...> - 2006-02-01 05:59:36
|
Hello All, SQL Relay version 0.37 is out! Check it out at http://sqlrelay.sourceforge.net Notable features of this release: 64/32bit host/clients can talk to each other now single-quotes and backslashes are escaped by db connections that use fake binds now removed lago support fixed lots of tcl bugs fixed lots of php and php pear db bugs supports postgresql 8 native binds binary data gets returned properly now max query/string/lob/clob sizes are configurable for now added a configurable idle client timeout initscript prefix is configurable now added "loadbalanced" connection parameter fixed a bug where bind cursors weren't getting cleaned up oracle 8's fetch-at-once, max select list size and max item buffer size are configurable now DB2 connections detect a downed database now and recover fixed a bug where DB2 update/delete with no affected rows was returning an error added nls_lang connect string option for oracle fixed utf8/clob related crash there are now string, integer, float, clob and blob output binds, and you can now use them with sybase without having to cast output bind values to strings and probably lots of other stuff... >From a development perspective, some of the C, C++ and Java api's use different datatypes than 0.36.4. So, some of your code that compiled before may require some modifications. The modifications stemmed from changes to support x86_64 platforms. I don't imagine they'll change again before 1.0. Give it a try, report any bugs you find. Woohoo! David Muse dav...@fi... |
|
From: Maciej W. <mac...@co...> - 2006-01-31 18:47:35
|
> Yeah, there's just the one line: > uses (u)int[16|32]_t instead of short/long, etc. I've seen this but I was not sure if it is this thing. I agree that the change was necessary but it was a bit surprising :) > And there isn't a line about changing rowCount to a 64 bit > integer from a 32 bit. I'll add some lines like that. It would be nice to have it in change log. Thanks -- Maciej Wisniowski |
|
From: Rodney H. <rh...@et...> - 2006-01-31 18:33:37
|
Greetings. Is it currently possible to obtain live statistics for the defined instances? What I would like to see is things like: # of active connections # of queries sent # of rows returned # of ORA errors # of requests handled by the listener Is that information stored somewhere currently and just not accessible or would the storage mechanisms need to be built into the objects? thanks rodney |
16 messages has been excluded from this view by a project administrator.
