Re: [Sqlrelay-discussion] SQLRelay in CVS is broken?

[Gena01 <ge...@gm...>]

Ok. I just did a full uninstall. Then pulled the new rudiments from CVS.
installed that and got SQLRelay to compile.  Now something that is a bit
strange to me is that I set it up to connect to Oracle and when I do ps aux
I get:
nobody   20157  0.0  0.2  5088 2004 pts/42   S    15:48   0:00
sqlr-listener-debug -id pdl1x-greg -config /usr/local/firstwork
nobody   20159  0.0  1.8 846544 17024 pts/42 S    15:48   0:00
sqlr-connection-oracle8-debug -id pdl1x-greg -connectionid db1
nobody   20161  0.0  1.8 846552 16768 pts/42 S    15:48   0:00
sqlr-connection-oracle8-debug -id pdl1x-greg -connectionid db1
nobody   20163  0.0  1.7 846364 16040 pts/42 S    15:48   0:00
sqlr-connection-oracle8-debug -id pdl1x-greg -connectionid db1
nobody   20165  0.0  0.2  5044 1924 ?        S    15:48   0:00 sqlr-scaler
-id pdl1x-greg -debug -config /usr/local/firstworks

The thing that throws me off is that when I configured the instance to use
10 cursors each connection to oracle thread is taking up 846,544 kb. (Yes I
know it's virtual, but it does seem quite large) I think that number was a
bit lower with the last stable release. Anything responsible for this?
Somehow when using Oracle client directly I don't think we are limited to
the number of cursors we can have and I don't think it's using that much
memory, but maybe I need to check this myself.

P.S. It also seems that according to documentation that sqlrelay when going
through Pear DB interface ignores the database parameter. I know it should
be possible to use a different database other than default. Is it possible
to make use of this parameter? So if I am connecting as another user
(possibly with lower privileges) I could use a different database for the
lifetime of my script.

Thank you,

Gena01

On 12/13/05, David Muse <dav...@fi...> wrote:
>
> Looks like you have an old version of SQL Relay and/or rudiments lying
> around in /usr/local/firstworks.  Make sure to delete that before trying
> to build a new version.
>
> Dave
>
> On Fri, 2005-12-09 at 16:08 -0500, Gena01 wrote:
> > I just pulled the latest CVS code as anonymous user and tried
> > compiling and it's breaking for me. The first thing was changes to
> > rudiments, which I pulled separately. Now I am stuck. I am getting:
> >
> > g++ -Wall -pipe -o .libs/query .libs/query.o
> > -L/home/gennady/sqlrelay-cvs/sqlrelay/src/util
> /home/gennady/sqlrelay-cvs/sqlrelay/src/util/.libs/libsqlrutil.so
> -L/usr/local/firstworks/lib -L/usr/kerberos/lib
> -L/home/gennady/sqlrelay-cvs/sqlrelay/src/api/c++/src
> /usr/local/firstworks/lib/libsqlrclient.so
> /usr/local/firstworks/lib/librudiments.so -lpthread -lssl -lcrypto
> -lgssapi_krb5 -lkrb5 -lcom_err -lk5crypto -lresolv -lz -lrt -lcrypt
> -ldl  -Wl,--rpath -Wl,/usr/local/firstworks/lib
> > .libs/query.o(.text+0x3a3): In function `main':
> > : undefined reference to
> > `sqlrconnection::sqlrconnection[in-charge](char const*, unsigned
> > short, char const*, char const*, char const*, int, int)'
> > .libs/query.o(.text+0x3ff): In function `main':
> > : undefined reference to `sqlrcursor::setResultSetBufferSize(unsigned
> > long long)'
> > .libs/query.o(.text+0x4b0): In function `main':
> > : undefined reference to `sqlrcursor::getField(unsigned long long,
> > unsigned)'
> > collect2: ld returned 1 exit status
> > make[2]: *** [query] Error 1
> >
> > Gena01
>
>
>
> -------------------------------------------------------
> 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://ads.osdn.com/?ad_id=3D7637&alloc_id=3D16865&op=3Dclick
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>