sqlrelay-discussion Mailing List for SQL Relay (Page 50)
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: Guo, J. <Jin...@pa...> - 2005-11-17 16:58:41
|
Hi, I'm preparing to use SQLRelay in production. Now, I have one problem = though, when starting it with less than 20 connections to Oracle, = everything works fine. When I set up 40 connections, first query is OK, = but next client will time out. What limits the connection number? Thanks = in advance.=20 |
|
From: Cristian P. <cri...@cl...> - 2005-11-17 16:15:06
|
Hi, first at all I'm a new user of SQLRelay and I have a few questions: 1. Does SQLRelay keeps alive a PostgreSQL session? I say this cuz I have a very intensive web database application. I always use and do the same query in the database (just a call to a stored procedure as "select * from mysp()") This sp is written in plpgsql, and each time I have to execute it eats a lot of cpu. (mainly cuz I have to "recompile" the plpgsql, prepare the queries and so on). The first time I run it takes around 114ms, but the next time it would take just 15ms. I asked to the postgresql team and so on and I get the same answer, in a web application the performance could be so poor cuz there is no way to keep the same session alive for each web "consumer" process. I guess is so stupid, because I'm doing the same query everytime. 2. I've been using pgpool, and it doesn't help too much for me, certainly it keeps a set of connection alive, but it doesn't share the same session/connection between web consumers, so I just minimize the connection time, not the compile/prepare time of the plpgsql stored procedures. 3. I need to have 10M connections per day, is this possible with sqlrelay? Somebody has achieved similar performance? Thanks a lot for your answers, Thanks again. Cristian Prieto |
|
From: Firstworks/4access <dav...@fi...> - 2005-11-17 15:32:24
|
Yeah, I keep forgetting about that one, and it's pretty important. I'll add it to the list of features for 0.37. And here I was, about to start release testing, thinking 0.37 was feature complete... :) Dave dav...@fi... On Wed, 2005-11-16 at 13:46 +0800, Paul D. Walker wrote: > One feature that would be useful on a machine with multiple IPs would be the > ability to bind SQL Relay to a particular IP via the configuration file. > > > > ------------------------------------------------------- > 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: Firstworks/4access <dav...@fi...> - 2005-11-17 15:29:50
|
On Wed, 2005-11-16 at 10:13 +0100, Arnaud Connois wrote: > > Hehehe, it works :-) That's sooooo great... Thanks very much. > > I've been able to switch from each server running its sqlrelay to all > connected to the same sqlrelay... My mysql database thanks you > also :-) Yay! You and your database are welcome. > > This product is getting better and better. Thanks :) Feedback from the user community is large part of the reason it's getting better, so thank you too. > > Cheers > > Arnaud > > > > Firstworks/4access wrote: > > That bug will be fixed in 0.37. > > > > I was using "long" integers in 0.36 which are 4 bytes on x86 but 8 bytes > > in x86_64. 0.37 uses int32_t and the like which are more explict. Give > > http://www.firstworks.com/sqlrelay-0.37pre3.tar.gz a try. > > > > David Muse > > dav...@fi... > > > > On Mon, 2005-11-14 at 02:04 +0100, Arnaud Connois wrote: > > > > > Hi all, > > > > > > When I connect from php on a i386 machine to a sqlrelayd on a x86_64 > > > machines I get theses kind of messages in the debug logs : > > > > > > 11/14/2005 00:29:14 CET listener [3622] : > > > authentication failed: password size is wrong > > > > > > In a previous thread in the archives : > > > http://sourceforge.net/mailarchive/message.php?msg_id=12064055 > > > > > > I've seen that this is related to variable size between different OS. > > > > > > I'm using sqlrelay-0.36.4. Any idea if 0.37 will solves this ? > > > > > > Does somebody tried the pre versions of 0.37 and had some experience > > > connecting between 2 different OS like this and had it working ? > > > > > > So far this is the only dificulty I had to sqlrelay. This is a great > > > product. > > > > > > Thanks. > > > > > > Arnaud > > > > > > > > > > > > ------------------------------------------------------- > > > SF.Net email is sponsored by: > > > Tame your development challenges with Apache's Geronimo App Server. Download > > > it for free - -and be entered to win a 42" plasma tv or your very own > > > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > > > _______________________________________________ > > > Sqlrelay-discussion mailing list > > > Sql...@li... > > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > > > > > > > > > ------------------------------------------------------- > > SF.Net email is sponsored by: > > Tame your development challenges with Apache's Geronimo App Server. Download > > it for free - -and be entered to win a 42" plasma tv or your very own > > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > > _______________________________________________ > > Sqlrelay-discussion mailing list > > Sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > ------------------------------------------------------- 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: Firstworks/4access <dav...@fi...> - 2005-11-17 15:23:05
|
The fix will be in 0.37. I actually fixed it in 0.37 first and
backported the patch I sent you.
Dave
dav...@fi...
On Thu, 2005-11-17 at 12:25 +0000, Ville Silventoinen wrote:
> Hi Dave,
>
> sometime ago you fixed a problem in sqlrelay-0.36/src/api/python/CSQLRelay.C
> related to BLOBs and Python cPickle module.
>
> It looks like the same problem occurs in sqlrelay-0.36.4. I did a diff
> with the CSQLRelay.C fix you sent me and the one in sqlrelay-0.36.4:
>
> 788d787
> < long *row_lengths;
> 794d792
> < row_lengths=sqlrcur->getRowLengths(row);
> 811c809
> < PyList_SetItem(my_list, counter, Py_BuildValue("s#", row_data[counter], row_lengths[counter]));
> ---
> > PyList_SetItem(my_list, counter, Py_BuildValue("s", row_data[counter]));
>
>
> I copied the fixed version to sqlrelay-0.36.4 source tree, re-compiled and
> it looks like the old fix works. Could you include this fix in the next
> version?
>
>
> Thanks,
> Ville
>
>
>
> -------------------------------------------------------
> 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: Ville S. <vs...@eb...> - 2005-11-17 12:34:13
|
Hi Dave,
sometime ago you fixed a problem in sqlrelay-0.36/src/api/python/CSQLRelay.C
related to BLOBs and Python cPickle module.
It looks like the same problem occurs in sqlrelay-0.36.4. I did a diff
with the CSQLRelay.C fix you sent me and the one in sqlrelay-0.36.4:
788d787
< long *row_lengths;
794d792
< row_lengths=sqlrcur->getRowLengths(row);
811c809
< PyList_SetItem(my_list, counter, Py_BuildValue("s#", row_data[counter], row_lengths[counter]));
---
> PyList_SetItem(my_list, counter, Py_BuildValue("s", row_data[counter]));
I copied the fixed version to sqlrelay-0.36.4 source tree, re-compiled and
it looks like the old fix works. Could you include this fix in the next
version?
Thanks,
Ville
|
|
From: Deepak M. <dee...@ma...> - 2005-11-17 07:28:32
|
Hi, I have tried all you mentioned. I saw that sqlr-connection daemon is not running. Here is result of commands. The output of "sqlr-start -id MyID" is Starting listener: sqlr-listener-debug -id MyID -config /usr/local/firstworks/etc/sqlrelay.conf & Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9703 Starting 3 connections to MyID : sqlr-connection-freetds-debug -id MyID -connectionid MyID -config /usr/local/firstworks/etc/sqlrelay.conf & Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.9705 sqlr-connection-freetds-debug -id MyID -connectionid MyID -config /usr/local/firstworks/etc/sqlrelay.conf & Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.9707 sqlr-connection-freetds-debug -id MyID -connectionid MyID -config /usr/local/firstworks/etc/sqlrelay.conf & Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.9709 Starting scaler: sqlr-scaler -id MyID -debug -config /usr/local/firstworks/etc/sqlrelay.conf cache manager already running. Thanks to MP3.com for sponsoring: Clustered/Replicated database support. Perl API. ------------------------------------------------------- The output of "ps -efa | grep sqlr" is root 8116 1 0 10:29 ? 00:00:00 sqlr-cachemanager nobody 9703 1 0 12:13 pts/5 00:00:00 sqlr-listener-debug -id MyID -config /usr/local/firstworks/etc/sqlrelay.conf nobody 9711 1 0 12:13 ? 00:00:00 sqlr-scaler -id MyID -debug -config /usr/local/firstworks/etc/sqlrelay.conf root 9724 8755 0 12:14 pts/5 00:00:00 grep sqlr ------------------------------------------------------ The file "/usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9703" contains following: 11/17/2005 12:13:43 IST listener [9703] : creating shared memory and semaphores 11/17/2005 12:13:43 IST listener [9703] : id filename: 11/17/2005 12:13:43 IST listener [9703] : /usr/local/firstworks/var/sqlrelay/tmp/MyID 11/17/2005 12:13:43 IST listener [9703] : creating shared memory... 11/17/2005 12:13:43 IST listener [9703] : creating semaphores... 11/17/2005 12:13:43 IST listener [9703] : waiting for client connection... 11/17/2005 12:13:59 IST listener [9703] : done waiting for client connection 11/17/2005 12:13:59 IST listener [9703] : de-registering handoff... 11/17/2005 12:13:59 IST listener [9703] : done de-registering handoff... 11/17/2005 12:13:59 IST listener [9703] : waiting for client connection... --------------------------------------------------------- The file "/usr/local/firstworks/var/sqlrelay/debug/sqlr-connection.9705" and all other contains following with incremented sequence number : 11/17/2005 12:13:44 IST connection [9705] : getting unix socket... 11/17/2005 12:13:44 IST connection [9705] : opening /usr/local/firstworks/var/sqlrelay/tmp/sockseq 11/17/2005 12:13:44 IST connection [9705] : locking... 11/17/2005 12:13:44 IST connection [9705] : got sequence number: 34 11/17/2005 12:13:44 IST connection [9705] : writing new sequence number: 35 11/17/2005 12:13:44 IST connection [9705] : unlocking... 11/17/2005 12:13:44 IST connection [9705] : done getting unix socket 11/17/2005 12:13:44 IST connection [9705] : logging in... 11/17/2005 12:13:45 IST connection [9705] : done logging in 11/17/2005 12:13:45 IST connection [9705] : setting autocommit... 11/17/2005 12:13:45 IST connection [9705] : done setting autocommit 11/17/2005 12:13:45 IST connection [9705] : initializing cursors... 11/17/2005 12:13:45 IST connection [9705] : 0 ----- Original Message ----- From: "Firstworks/4access" To: sql...@li... Subject: Re: [Sqlrelay-discussion] Accessing SQL Server 2000 database using SQL Relay Date: Wed, 16 Nov 2005 11:43:11 -0500 What version of SQL Relay are you using? 0.36.4 should have printed out some more debug right after "incrementing session count". It's possible that the connection daemons didn't get started up properly. Either they shut down or hung at startup. They should have printed out an error at startup if there was a problem though. Do a ps -efa | grep sqlr-connection and see if they're running. If they're not running, the most common cause of a problem with the sqlr-connection daemons getting logged in is having the wrong tds version set in your freetds.conf file. I don't remember offhand what version you have to use with SQL Server 2000. I believe that valid versions are 4.2, 5.0, 7.0 and 8.0 though. You may want to try each of them. If you do all that and still have a problem, send me the output of the sqlr-start command and of "ps -efa | grep sqlr" and I'll see if I can spot the problem. Dave dav...@fi... On Mon, 2005-11-14 at 23:15 -0500, Deepak Mangal wrote: > > > > -- ___________________________________________________ > Play 100s of games for FREE! http://games.mail.com/ > > email message attachment > On Mon, 2005-11-14 at 23:15 -0500, Deepak Mangal wrote: > > Hi, > > > I am having problem to run queries to access SQL Server 2000 > database using SQL Relay. > -------------------------------------- > > I first started the SQL Relay as follows: > > > sqlr-start -id MyID > > > It worked fine. But when i tried to run the queries as follow: > > > sqlrsh -id MyID > > > SQLRShell - Version 0.22 > > Connected to: localhost:4000 as ele2006 > > > type help; for a help. > > > 0> select * from editorial_tempmaster; > > Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9475 > > > ---------------------------- > > No result was shown.The > /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9475 > contains: > > > 11/11/2005 16:39:10 IST listener [9475] : getting authentication... > > > 11/11/2005 16:39:10 IST listener [9475] : > listener-based authentication succeeded > > > 11/11/2005 16:39:10 IST listener [9475] : incrementing session count... > > > 11/11/2005 16:39:10 IST listener [9475] : 2 > > > ------------------ > > > Please help me!! > > > -- > > Deepak Mangal > > > ------------------------------------------------------- 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=3D7628&alloc_id=3D16845&op=3Dclick _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion --=20 ___________________________________________________ Play 100s of games for FREE! http://games.mail.com/ |
|
From: Rodrigo P. T. <te...@de...> - 2005-11-16 19:08:14
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi David, Firstworks/4access wrote: > Is it possible to reliably reproduce the problem with a particular > query, or is it kind of random? No it doesn't, it happens in a random fashion. Could happens twice in a week or once in a month. > > Offhand, it looks like java is trying to run (or return from) a native > C++ function and has the wrong address for the function (or wrong return > address) and it ends up jumping off into the weeds, possibly into a > non-executable page of memory. This typically happens when a buffer > overrun occurs and overwrites a jump address. > > Does this happen with really long queries? With No it doesn't. It happens in a simple query using INSERT or SELECT! > Java/Perl/PHP/Ruby/TCL/Python, SQL Relay makes a copy of the query. > It's possible that there's some kind of bug where the SQL Relay client > is copying too much data and overrunning it's buffer. If it's only long > queries, that would make sense and should be easy to patch. > > Let me know... Let me know if I can do any thing to "collect" more informations about that problem. Thanks for your answer. Telles > > David Muse > dav...@fi... > > On Fri, 2005-11-11 at 17:48 -0200, Rodrigo P. Telles wrote: > > Hi Guys, > > I've been experiencing some errors using JAVA with sqlrelay-0.35 API and MySQL > 4.1.7 as a DB backend. > > Some thimes when I'm doing a query the application failed with that output > exception: > ---------------------------------------------------------------------------------- > An unexpected exception has been detected in native code outside the VM. > Unexpected Signal : 11 occurred at PC=0x400C6C48 > Function=(null)+0x400C6C48 > Library=/lib/libc.so.6 > > NOTE: We are unable to locate the function name symbol for the error > just occurred. Please refer to release documentation for possible > reason and solutions. > > > Current Java thread: > at com.firstworks.sqlrelay.SQLRCursor.prepareQuery(Native Method) > at it.devel.Dao.getBean(Dao.java:185) > at it.devel.wiser.TerminadorDAO.calculaMinutagem(TerminadorDAO.java:131) > at it.devel.Bilhetagem.getTempoCorrigido(Bilhetagem.java:342) > at it.devel.Bilhetagem.bilhetaTerminador(Bilhetagem.java:320) > at it.devel.Bilhetagem.bilhetar(Bilhetagem.java:141) > at it.devel.Bilhetagem.main(Bilhetagem.java:693) > > Dynamic libraries: > 08048000-08056000 r-xp 00000000 08:06 246208 /usr/local/j2sdk1.4.2_06/bin/java > 08056000-08059000 rwxp 0000d000 08:06 246208 /usr/local/j2sdk1.4.2_06/bin/java > 40000000-40011000 r-xp 00000000 08:05 212994 /lib/ld-2.3.3.so > 40011000-40012000 rwxp 00011000 08:05 212994 /lib/ld-2.3.3.so > 40018000-40026000 r-xp 00000000 08:05 213024 /lib/libpthread-0.10.so > 40026000-40028000 rwxp 0000d000 08:05 213024 /lib/libpthread-0.10.so > 4006a000-4006c000 r-xp 00000000 08:05 213005 /lib/libdl-2.3.3.so > 4006c000-4006d000 rwxp 00001000 08:05 213005 /lib/libdl-2.3.3.so > 4006d000-40167000 r-xp 00000000 08:05 213001 /lib/libc-2.3.3.so > 40167000-40170000 rwxp 000fa000 08:05 213001 /lib/libc-2.3.3.so > 40173000-4056f000 r-xp 00000000 08:06 134540 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/client/libjvm.so > 4056f000-4058b000 rwxp 003fb000 08:06 134540 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/client/libjvm.so > 405a2000-405b1000 r-xp 00000000 08:05 213009 /lib/libnsl-2.3.3.so > 405b1000-405b2000 rwxp 0000f000 08:05 213009 /lib/libnsl-2.3.3.so > 405b4000-405d4000 r-xp 00000000 08:05 213007 /lib/libm-2.3.3.so > 405d4000-405d5000 rwxp 0001f000 08:05 213007 /lib/libm-2.3.3.so > 405d5000-405dd000 r-xp 00000000 08:06 101710 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/native_threads/libhpi.so > 405dd000-405de000 rwxp 00007000 08:06 101710 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/native_threads/libhpi.so > 405de000-405e2000 rwxs 00000000 08:09 14628 /tmp/hsperfdata_callstart/19866 > 405e3000-405ec000 r-xp 00000000 08:05 213015 /lib/libnss_files-2.3.3.so > 405ec000-405ed000 rwxp 00009000 08:05 213015 /lib/libnss_files-2.3.3.so > 405ed000-405fd000 r-xp 00000000 08:06 101717 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/libverify.so > 405fd000-405ff000 rwxp 0000f000 08:06 101717 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/libverify.so > 405ff000-4061f000 r-xp 00000000 08:06 101718 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/libjava.so > 4061f000-40621000 rwxp 0001f000 08:06 101718 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/libjava.so > 40621000-40635000 r-xp 00000000 08:06 101720 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/libzip.so > 40635000-40638000 rwxp 00013000 08:06 101720 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/libzip.so > 40638000-41fdf000 r-xs 00000000 08:06 101803 > /usr/local/j2sdk1.4.2_06/jre/lib/rt.jar > 42029000-4203f000 r-xs 00000000 08:06 101742 > /usr/local/j2sdk1.4.2_06/jre/lib/sunrsasign.jar > 4203f000-4211c000 r-xs 00000000 08:06 101787 > /usr/local/j2sdk1.4.2_06/jre/lib/jsse.jar > 4211c000-4212d000 r-xs 00000000 08:06 101743 > /usr/local/j2sdk1.4.2_06/jre/lib/jce.jar > 4212d000-42686000 r-xs 00000000 08:06 101788 > /usr/local/j2sdk1.4.2_06/jre/lib/charsets.jar > 4472e000-4472f000 r-xs 00000000 08:06 117021 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/Itau.jar > 4c7b0000-4c7cc000 r-xs 00000000 08:06 117679 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/sunjce_provider.jar > 4c7cc000-4c7cf000 r-xs 00000000 08:06 117680 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/dnsns.jar > 4c7cf000-4c7dc000 r-xs 00000000 08:06 117682 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/ldapsec.jar > 4c7dc000-4c898000 r-xs 00000000 08:06 117684 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/localedata.jar > 4c898000-4c8a6000 r-xs 00000000 08:06 117022 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/activation.jar > 4c8a6000-4c8d3000 r-xs 00000000 08:06 117023 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/mailapi.jar > 4c8d3000-4c92a000 r-xs 00000000 08:06 117024 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/mail.jar > 4c92a000-4c930000 r-xs 00000000 08:06 117025 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/pop3.jar > 4c930000-4c936000 r-xs 00000000 08:06 117026 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/smtp.jar > 4c936000-4c939000 r-xp 00000000 08:06 377923 > /usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRConnection.so > 4c939000-4c93a000 rwxp 00002000 08:06 377923 > /usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRConnection.so > 4c93a000-4c950000 r-xp 00000000 08:06 265533 > /usr/src/sqlrelay-0.35/src/api/c++/src/.libs/libsqlrclient-0.35.so.1.0.0 > 4c950000-4c953000 rwxp 00015000 08:06 265533 > /usr/src/sqlrelay-0.35/src/api/c++/src/.libs/libsqlrclient-0.35.so.1.0.0 > 4c953000-4c998000 r-xp 00000000 08:06 377564 > /usr/local/firstworks/lib/librudiments-0.27.so.1.0.0 > 4c998000-4c9a2000 rwxp 00044000 08:06 377564 > /usr/local/firstworks/lib/librudiments-0.27.so.1.0.0 > 4c9a7000-4c9d2000 r-xp 00000000 08:06 115308 /usr/lib/libssl.so.0.9.7 > 4c9d2000-4c9d5000 rwxp 0002a000 08:06 115308 /usr/lib/libssl.so.0.9.7 > 4c9d5000-4caab000 r-xp 00000000 08:06 115306 /usr/lib/libcrypto.so.0.9.7 > 4caab000-4cabc000 rwxp 000d6000 08:06 115306 /usr/lib/libcrypto.so.0.9.7 > 4cac0000-4cac4000 r-xp 00000000 08:05 213003 /lib/libcrypt-2.3.3.so > 4cac4000-4cac5000 rwxp 00003000 08:05 213003 /lib/libcrypt-2.3.3.so > 4caec000-4cb8a000 r-xp 00000000 08:06 114711 /usr/lib/libstdc++.so.5.0.5 > 4cb8a000-4cba0000 rwxp 0009d000 08:06 114711 /usr/lib/libstdc++.so.5.0.5 > 4cba5000-4cbac000 r-xp 00000000 08:06 114701 /usr/lib/libgcc_s.so.1 > 4cbac000-4cbad000 rwxp 00006000 08:06 114701 /usr/lib/libgcc_s.so.1 > 4cbad000-4cbb7000 r-xp 00000000 08:06 377924 > /usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRCursor.so > 4cbb7000-4cbb9000 rwxp 0000a000 08:06 377924 > /usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRCursor.so > > Heap at VM Abort: > Heap > def new generation total 576K, used 236K [0x44730000, 0x447d0000, 0x44c10000) > eden space 512K, 43% used [0x44730000, 0x44767248, 0x447b0000) > from space 64K, 24% used [0x447b0000, 0x447b3fa8, 0x447c0000) > to space 64K, 0% used [0x447c0000, 0x447c0000, 0x447d0000) > tenured generation total 1408K, used 339K [0x44c10000, 0x44d70000, 0x48730000) > the space 1408K, 24% used [0x44c10000, 0x44c64f58, 0x44c65000, 0x44d70000) > compacting perm gen total 4096K, used 1696K [0x48730000, 0x48b30000, 0x4c730000) > the space 4096K, 41% used [0x48730000, 0x488d8380, 0x488d8400, 0x48b30000) > > Local Time = Fri Nov 11 15:34:29 2005 > Elapsed Time = 771 > # > # The exception above was detected in native code outside the VM > # > # Java VM: Java HotSpot(TM) Client VM (1.4.2_06-b03 mixed mode) > - > -------------------------------------------------------------------------------------------------------- > > At the moment is not so easy for me to update to 0.36.x. > Does some one can help with that problem? > > Thanks in advance. > -- > ============================================ > Rodrigo P. Telles <te...@de...> > IT Manager > Devel-IT - http://www.devel.it > IVOZ # 1029 > +55 14 3324-1200 > Bestcom Group > ============================================ - ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > ------------------------------------------------------- > 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 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFDe4OHiLK8unYgEMQRAksXAJ9kfct6noDTfKlVkTYlHwPDn7Zv2QCfamh+ JdOQX8vda0hK+Z5Ma/PgFME= =7b3L -----END PGP SIGNATURE----- |
|
From: Firstworks/4access <dav...@fi...> - 2005-11-16 17:06:06
|
If I'm not mistaken, the MySQL DBI driver is written in C, while the SQL Relay DBI driver is written in perl. It's possible that could account for the difference. The DBI driver should use the socket parameter. What connect string are you using? Also, is SQL Relay running on the same machine as the database? If so, are you sure it's configured to use the unix socket? Dave dav...@fi... On Wed, 2005-11-09 at 10:07 +0000, David Edwards wrote: > Thanks, David. Looking forward to 0.37! > > On a slightly different topic, I have briefly tried benchmarking the SQL > Relay DBI driver against the standard MySQL DBI driver. Obviously there are > a huge number of variables involved - I am running SQL Relay locally on our > web server connecting to a DB on a different machine, for example - but I > was surprised to find SQL Relay marginally slower. On average, transactions > via SQL relay took 0.16 secs vs 0.13 secs direct. I was hoping for a slight > improvement through connection pooling. Are there any tweaks I could try not > listed on your performance tuning page? Does the socket parameter get used > by the DBI driver? Or would I be best off rewriting my DB wrapper to use the > SQL Relay API directly rather than via DBI? > > David > > -----Original Message----- > From: David Muse [mailto:dav...@fi...] > Sent: 08 November 2005 04:04 > To: sql...@li... > Subject: RE: [Sqlrelay-discussion] Perl compilation error with 0.36.4 > > > Hmmm, I'll have to look into that a bit deeper. Adding a $ in front > will have the effect of requiring the 3rd argument to be the string > "SQLRelay::SQL_CLOB" to bind a clob. I'm not sure that's right, but if > you don't use clob's then go with it :) > > I'll figure out what's what though and fix it in the 0.37 release. > > Dave > dav...@fi... > > On Fri, 2005-11-04 at 15:03 +0000, David Edwards wrote: > > Hi David, > > > > Thanks for replying. I've tried the replacement file, but still got the > same > > compilation error. I did try inserting a $ in front of > > DBD::SQLRelay::SQL_CLOB and DBD::SQLRelay::SQL_BLOB on lines 282 and 294, > > and this did get rid of the compilation error. However, I don't know > whether > > the resulting code does what it's supposed to do, because I'm not using > > CLOBs or BLOBs. > > > > Regards, > > > > David > > > > -----Original Message----- > > From: Firstworks/4access [mailto:dav...@fi...] > > Sent: 04 November 2005 14:48 > > To: sql...@li... > > Subject: Re: [Sqlrelay-discussion] Perl compilation error with 0.36.4 > > > > > > Hmm, looks like DBD::SQLReay::SQL_CLOB and SQL_BLOB aren't defined. Try > > replacing /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm with the > > attached file and see if it works. > > > > David Muse > > dav...@fi... > > > > On Thu, 2005-11-03 at 10:56 +0000, David Edwards wrote: > > > I am trying to use SQL Relay via the DBI driver from a simple Perl > script, > > > but have run into a problem. On our development environment - using SQL > > > Relay 0.33.1 - we have no problems. However, using SQL Relay 0.36.4 on > our > > > production environment, trying to run the same script results in the > > > following Perl error: > > > > > > install_driver(SQLRelay) failed: Bareword "DBD::SQLRelay::SQL_CLOB" not > > > allowed while "strict subs" in use at > > > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282. > > > Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in > use > > at > > > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 282. > > > Bareword "DBD::SQLRelay::SQL_CLOB" not allowed while "strict subs" in > use > > at > > > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294. > > > Bareword "DBD::SQLRelay::SQL_BLOB" not allowed while "strict subs" in > use > > at > > > /usr/lib/perl5/site_perl/5.6.1/DBD/SQLRelay.pm line 294. > > > Compilation failed in require at (eval 4) line 3. > > > > > > Is this an issue with our Perl, or a problem with the SQL Relay code? If > > the > > > former, does anyone have any suggestions as to how to solve the problem? > > > > > > Thanks, > > > > > > David > > > > > > > > > > > > ------------------------------------------------------- > > > SF.Net email is sponsored by: > > > Tame your development challenges with Apache's Geronimo App Server. > > Download > > > it for free - -and be entered to win a 42" plasma tv or your very own > > > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > > > _______________________________________________ > > > Sqlrelay-discussion mailing list > > > Sql...@li... > > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > > > > ------------------------------------------------------- > > SF.Net email is sponsored by: > > Tame your development challenges with Apache's Geronimo App Server. > Download > > it for free - -and be entered to win a 42" plasma tv or your very own > > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > > _______________________________________________ > > Sqlrelay-discussion mailing list > > Sql...@li... > > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: Firstworks/4access <dav...@fi...> - 2005-11-16 17:03:32
|
On Tue, 2005-11-08 at 09:39 +0100, Thomas Jonas wrote: > Hi guys! > I looked in the manual, but I didn't find anything regarding the > load-balancing in SQL Relay. Can you tell me what kind of load-balancing is > used in SQL Relay? Is it a simple round robin type or a real load dependent > load-balancing? I'm just curious... > > Thanks in advance! > I just uploaded http://sqlrelay.sourceforge.net/sqlrelay/loadbalfailover.html from the upcoming 0.37 docs (the "behindloadbalancer" flag isn't implemented in 0.36.4) Take a look. David Muse dav...@fi... |
|
From: Firstworks/4access <dav...@fi...> - 2005-11-16 16:57:26
|
I recently noticed this too. It should do something other than silently
ignore the error. I'll make sure to fix this one way or another for
0.37. For now though, yeah, you'll just have to be more careful what
you pass in.
Dave
dav...@fi...
On Thu, 2005-11-10 at 13:46 -0500, Andrew Langmead wrote:
> In my code, object to PySQLRClient.sqlrcursor.inputBind that I
> thought was a simple string, but had accidentally been upgraded to a
> unicode string. To my surprise, there were no errors reported, but
> the bind just was ignored entirely.
>
> Looking at the C code for the Python CSQLRelay extension, I see that
> inputBind is a long if/else if sequence with no default else clause.
>
> if (value==Py_None) {
> ((sqlrcursor *)sqlrcur)->inputBind(variable, (char *)NULL);
> } else if (PyString_Check(value)) {
> ((sqlrcursor *)sqlrcur)->inputBind(variable, PyString_AsString
> (value));
> } else if (PyInt_Check(value)) {
> ((sqlrcursor *)sqlrcur)->inputBind(variable, (long)PyInt_AsLong
> (value));
> } else if (PyFloat_Check(value)) {
> ((sqlrcursor *)sqlrcur)->inputBind(variable, (double)
> PyFloat_AsDouble(value)
> , (unsigned short)precision, (unsigned short)scale);
> }
>
>
> Should .inputBind return a status to say in bound correctly? Should
> it through a TypeError? Should it try to coerce its input into one of
> the four simple types it knows about?
>
> Or should I just be more careful what I pass into it?
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. Download
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
|
|
From: Firstworks/4access <dav...@fi...> - 2005-11-16 16:55:54
|
Is it possible to reliably reproduce the problem with a particular query, or is it kind of random? Offhand, it looks like java is trying to run (or return from) a native C++ function and has the wrong address for the function (or wrong return address) and it ends up jumping off into the weeds, possibly into a non-executable page of memory. This typically happens when a buffer overrun occurs and overwrites a jump address. Does this happen with really long queries? With Java/Perl/PHP/Ruby/TCL/Python, SQL Relay makes a copy of the query. It's possible that there's some kind of bug where the SQL Relay client is copying too much data and overrunning it's buffer. If it's only long queries, that would make sense and should be easy to patch. Let me know... David Muse dav...@fi... On Fri, 2005-11-11 at 17:48 -0200, Rodrigo P. Telles wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi Guys, > > I've been experiencing some errors using JAVA with sqlrelay-0.35 API and MySQL > 4.1.7 as a DB backend. > > Some thimes when I'm doing a query the application failed with that output > exception: > - ---------------------------------------------------------------------------------- > An unexpected exception has been detected in native code outside the VM. > Unexpected Signal : 11 occurred at PC=0x400C6C48 > Function=(null)+0x400C6C48 > Library=/lib/libc.so.6 > > NOTE: We are unable to locate the function name symbol for the error > just occurred. Please refer to release documentation for possible > reason and solutions. > > > Current Java thread: > at com.firstworks.sqlrelay.SQLRCursor.prepareQuery(Native Method) > at it.devel.Dao.getBean(Dao.java:185) > at it.devel.wiser.TerminadorDAO.calculaMinutagem(TerminadorDAO.java:131) > at it.devel.Bilhetagem.getTempoCorrigido(Bilhetagem.java:342) > at it.devel.Bilhetagem.bilhetaTerminador(Bilhetagem.java:320) > at it.devel.Bilhetagem.bilhetar(Bilhetagem.java:141) > at it.devel.Bilhetagem.main(Bilhetagem.java:693) > > Dynamic libraries: > 08048000-08056000 r-xp 00000000 08:06 246208 /usr/local/j2sdk1.4.2_06/bin/java > 08056000-08059000 rwxp 0000d000 08:06 246208 /usr/local/j2sdk1.4.2_06/bin/java > 40000000-40011000 r-xp 00000000 08:05 212994 /lib/ld-2.3.3.so > 40011000-40012000 rwxp 00011000 08:05 212994 /lib/ld-2.3.3.so > 40018000-40026000 r-xp 00000000 08:05 213024 /lib/libpthread-0.10.so > 40026000-40028000 rwxp 0000d000 08:05 213024 /lib/libpthread-0.10.so > 4006a000-4006c000 r-xp 00000000 08:05 213005 /lib/libdl-2.3.3.so > 4006c000-4006d000 rwxp 00001000 08:05 213005 /lib/libdl-2.3.3.so > 4006d000-40167000 r-xp 00000000 08:05 213001 /lib/libc-2.3.3.so > 40167000-40170000 rwxp 000fa000 08:05 213001 /lib/libc-2.3.3.so > 40173000-4056f000 r-xp 00000000 08:06 134540 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/client/libjvm.so > 4056f000-4058b000 rwxp 003fb000 08:06 134540 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/client/libjvm.so > 405a2000-405b1000 r-xp 00000000 08:05 213009 /lib/libnsl-2.3.3.so > 405b1000-405b2000 rwxp 0000f000 08:05 213009 /lib/libnsl-2.3.3.so > 405b4000-405d4000 r-xp 00000000 08:05 213007 /lib/libm-2.3.3.so > 405d4000-405d5000 rwxp 0001f000 08:05 213007 /lib/libm-2.3.3.so > 405d5000-405dd000 r-xp 00000000 08:06 101710 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/native_threads/libhpi.so > 405dd000-405de000 rwxp 00007000 08:06 101710 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/native_threads/libhpi.so > 405de000-405e2000 rwxs 00000000 08:09 14628 /tmp/hsperfdata_callstart/19866 > 405e3000-405ec000 r-xp 00000000 08:05 213015 /lib/libnss_files-2.3.3.so > 405ec000-405ed000 rwxp 00009000 08:05 213015 /lib/libnss_files-2.3.3.so > 405ed000-405fd000 r-xp 00000000 08:06 101717 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/libverify.so > 405fd000-405ff000 rwxp 0000f000 08:06 101717 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/libverify.so > 405ff000-4061f000 r-xp 00000000 08:06 101718 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/libjava.so > 4061f000-40621000 rwxp 0001f000 08:06 101718 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/libjava.so > 40621000-40635000 r-xp 00000000 08:06 101720 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/libzip.so > 40635000-40638000 rwxp 00013000 08:06 101720 > /usr/local/j2sdk1.4.2_06/jre/lib/i386/libzip.so > 40638000-41fdf000 r-xs 00000000 08:06 101803 > /usr/local/j2sdk1.4.2_06/jre/lib/rt.jar > 42029000-4203f000 r-xs 00000000 08:06 101742 > /usr/local/j2sdk1.4.2_06/jre/lib/sunrsasign.jar > 4203f000-4211c000 r-xs 00000000 08:06 101787 > /usr/local/j2sdk1.4.2_06/jre/lib/jsse.jar > 4211c000-4212d000 r-xs 00000000 08:06 101743 > /usr/local/j2sdk1.4.2_06/jre/lib/jce.jar > 4212d000-42686000 r-xs 00000000 08:06 101788 > /usr/local/j2sdk1.4.2_06/jre/lib/charsets.jar > 4472e000-4472f000 r-xs 00000000 08:06 117021 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/Itau.jar > 4c7b0000-4c7cc000 r-xs 00000000 08:06 117679 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/sunjce_provider.jar > 4c7cc000-4c7cf000 r-xs 00000000 08:06 117680 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/dnsns.jar > 4c7cf000-4c7dc000 r-xs 00000000 08:06 117682 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/ldapsec.jar > 4c7dc000-4c898000 r-xs 00000000 08:06 117684 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/localedata.jar > 4c898000-4c8a6000 r-xs 00000000 08:06 117022 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/activation.jar > 4c8a6000-4c8d3000 r-xs 00000000 08:06 117023 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/mailapi.jar > 4c8d3000-4c92a000 r-xs 00000000 08:06 117024 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/mail.jar > 4c92a000-4c930000 r-xs 00000000 08:06 117025 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/pop3.jar > 4c930000-4c936000 r-xs 00000000 08:06 117026 > /usr/local/j2sdk1.4.2_06/jre/lib/ext/smtp.jar > 4c936000-4c939000 r-xp 00000000 08:06 377923 > /usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRConnection.so > 4c939000-4c93a000 rwxp 00002000 08:06 377923 > /usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRConnection.so > 4c93a000-4c950000 r-xp 00000000 08:06 265533 > /usr/src/sqlrelay-0.35/src/api/c++/src/.libs/libsqlrclient-0.35.so.1.0.0 > 4c950000-4c953000 rwxp 00015000 08:06 265533 > /usr/src/sqlrelay-0.35/src/api/c++/src/.libs/libsqlrclient-0.35.so.1.0.0 > 4c953000-4c998000 r-xp 00000000 08:06 377564 > /usr/local/firstworks/lib/librudiments-0.27.so.1.0.0 > 4c998000-4c9a2000 rwxp 00044000 08:06 377564 > /usr/local/firstworks/lib/librudiments-0.27.so.1.0.0 > 4c9a7000-4c9d2000 r-xp 00000000 08:06 115308 /usr/lib/libssl.so.0.9.7 > 4c9d2000-4c9d5000 rwxp 0002a000 08:06 115308 /usr/lib/libssl.so.0.9.7 > 4c9d5000-4caab000 r-xp 00000000 08:06 115306 /usr/lib/libcrypto.so.0.9.7 > 4caab000-4cabc000 rwxp 000d6000 08:06 115306 /usr/lib/libcrypto.so.0.9.7 > 4cac0000-4cac4000 r-xp 00000000 08:05 213003 /lib/libcrypt-2.3.3.so > 4cac4000-4cac5000 rwxp 00003000 08:05 213003 /lib/libcrypt-2.3.3.so > 4caec000-4cb8a000 r-xp 00000000 08:06 114711 /usr/lib/libstdc++.so.5.0.5 > 4cb8a000-4cba0000 rwxp 0009d000 08:06 114711 /usr/lib/libstdc++.so.5.0.5 > 4cba5000-4cbac000 r-xp 00000000 08:06 114701 /usr/lib/libgcc_s.so.1 > 4cbac000-4cbad000 rwxp 00006000 08:06 114701 /usr/lib/libgcc_s.so.1 > 4cbad000-4cbb7000 r-xp 00000000 08:06 377924 > /usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRCursor.so > 4cbb7000-4cbb9000 rwxp 0000a000 08:06 377924 > /usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRCursor.so > > Heap at VM Abort: > Heap > def new generation total 576K, used 236K [0x44730000, 0x447d0000, 0x44c10000) > eden space 512K, 43% used [0x44730000, 0x44767248, 0x447b0000) > from space 64K, 24% used [0x447b0000, 0x447b3fa8, 0x447c0000) > to space 64K, 0% used [0x447c0000, 0x447c0000, 0x447d0000) > tenured generation total 1408K, used 339K [0x44c10000, 0x44d70000, 0x48730000) > the space 1408K, 24% used [0x44c10000, 0x44c64f58, 0x44c65000, 0x44d70000) > compacting perm gen total 4096K, used 1696K [0x48730000, 0x48b30000, 0x4c730000) > the space 4096K, 41% used [0x48730000, 0x488d8380, 0x488d8400, 0x48b30000) > > Local Time = Fri Nov 11 15:34:29 2005 > Elapsed Time = 771 > # > # The exception above was detected in native code outside the VM > # > # Java VM: Java HotSpot(TM) Client VM (1.4.2_06-b03 mixed mode) > - > -------------------------------------------------------------------------------------------------------- > > At the moment is not so easy for me to update to 0.36.x. > Does some one can help with that problem? > > Thanks in advance. > - -- > ============================================ > Rodrigo P. Telles <te...@de...> > IT Manager > Devel-IT - http://www.devel.it > IVOZ # 1029 > +55 14 3324-1200 > Bestcom Group > ============================================ > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.4 (GNU/Linux) > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org > > iD8DBQFDdPWSiLK8unYgEMQRAuEZAJ9jSyOPrSfJynxqDc3vSbkA5KkDjACcCbPE > rdJgJ1Z38BuP57tnSJ2xDsU= > =qMXp > -----END PGP SIGNATURE----- > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: Firstworks/4access <dav...@fi...> - 2005-11-16 16:39:17
|
What version of SQL Relay are you using? 0.36.4 should have printed out some more debug right after "incrementing session count". It's possible that the connection daemons didn't get started up properly. Either they shut down or hung at startup. They should have printed out an error at startup if there was a problem though. Do a ps -efa | grep sqlr-connection and see if they're running. If they're not running, the most common cause of a problem with the sqlr-connection daemons getting logged in is having the wrong tds version set in your freetds.conf file. I don't remember offhand what version you have to use with SQL Server 2000. I believe that valid versions are 4.2, 5.0, 7.0 and 8.0 though. You may want to try each of them. If you do all that and still have a problem, send me the output of the sqlr-start command and of "ps -efa | grep sqlr" and I'll see if I can spot the problem. Dave dav...@fi... On Mon, 2005-11-14 at 23:15 -0500, Deepak Mangal wrote: > > > > -- > > ___________________________________________________ > Play 100s of games for FREE! http://games.mail.com/ > > email message attachment > On Mon, 2005-11-14 at 23:15 -0500, Deepak Mangal wrote: > > Hi, > > > > I am having problem to run queries to access SQL Server 2000 database using SQL Relay. > > -------------------------------------- > > I first started the SQL Relay as follows: > > > > sqlr-start -id MyID > > > > It worked fine. But when i tried to run the queries as follow: > > > > sqlrsh -id MyID > > > > SQLRShell - Version 0.22 > > Connected to: localhost:4000 as ele2006 > > > > type help; for a help. > > > > 0> select * from editorial_tempmaster; > > Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9475 > > > > ---------------------------- > > No result was shown.The /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9475 contains: > > > > 11/11/2005 16:39:10 IST listener [9475] : getting authentication... > > > > 11/11/2005 16:39:10 IST listener [9475] : listener-based authentication succeeded > > > > 11/11/2005 16:39:10 IST listener [9475] : incrementing session count... > > > > 11/11/2005 16:39:10 IST listener [9475] : 2 > > > > ------------------ > > > > Please help me!! > > > > -- > > Deepak Mangal > > > > |
|
From: Firstworks/4access <dav...@fi...> - 2005-11-16 16:29:41
|
On Mon, 2005-11-14 at 10:55 -0500, Seth Gottlieb wrote: > Hello, > > I am using SQLRelayDA to talk to Oracle 10g and one of my fields is a > CLOB. When my update statement contains long strings, I get an error > from Oracle: > > ORA-01704: string literal too long > > Is there any simple way to do a prepared query with input binds through > the DA? Or should I interface directly with the PySQLRClient? > > Thanks, > > Seth > I'm not aware of any way to do input binds using the DA. ZSQLRelayDA uses the PySQLRDB.py module, which supports binds, but not Clob/Blob binds :( So, yeah, you'd need to use PySQLRClient to do Clob binds. David Muse dav...@fi... |
|
From: Arnaud C. <arn...@co...> - 2005-11-16 09:09:56
|
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 |
|
From: Arnaud C. <arn...@co...> - 2005-11-16 09:07:22
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> <title></title> </head> <body bgcolor="#ffffff" text="#000000"> <br> Hehehe, it works :-) That's sooooo great... Thanks very much.<br> <br> I've been able to switch from each server running its sqlrelay to all connected to the same sqlrelay... My mysql database thanks you also :-)<br> <br> This product is getting better and better.<br> <br> Cheers<br> <br> Arnaud<br> <br> <br> <br> Firstworks/4access wrote: <blockquote cite="mid...@lo..." type="cite"> <pre wrap="">That bug will be fixed in 0.37. I was using "long" integers in 0.36 which are 4 bytes on x86 but 8 bytes in x86_64. 0.37 uses int32_t and the like which are more explict. Give <a class="moz-txt-link-freetext" href="http://www.firstworks.com/sqlrelay-0.37pre3.tar.gz">http://www.firstworks.com/sqlrelay-0.37pre3.tar.gz</a> a try. David Muse <a class="moz-txt-link-abbreviated" href="mailto:dav...@fi...">dav...@fi...</a> On Mon, 2005-11-14 at 02:04 +0100, Arnaud Connois wrote: </pre> <blockquote type="cite"> <pre wrap="">Hi all, When I connect from php on a i386 machine to a sqlrelayd on a x86_64 machines I get theses kind of messages in the debug logs : 11/14/2005 00:29:14 CET listener [3622] : authentication failed: password size is wrong In a previous thread in the archives : <a class="moz-txt-link-freetext" href="http://sourceforge.net/mailarchive/message.php?msg_id=12064055">http://sourceforge.net/mailarchive/message.php?msg_id=12064055</a> I've seen that this is related to variable size between different OS. I'm using sqlrelay-0.36.4. Any idea if 0.37 will solves this ? Does somebody tried the pre versions of 0.37 and had some experience connecting between 2 different OS like this and had it working ? So far this is the only dificulty I had to sqlrelay. This is a great product. Thanks. Arnaud ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: <a class="moz-txt-link-freetext" href="http://sourceforge.net/geronimo.php">http://sourceforge.net/geronimo.php</a> _______________________________________________ Sqlrelay-discussion mailing list <a class="moz-txt-link-abbreviated" href="mailto:Sql...@li...">Sql...@li...</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion">https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion</a> </pre> </blockquote> <pre wrap=""><!----> ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: <a class="moz-txt-link-freetext" href="http://sourceforge.net/geronimo.php">http://sourceforge.net/geronimo.php</a> _______________________________________________ Sqlrelay-discussion mailing list <a class="moz-txt-link-abbreviated" href="mailto:Sql...@li...">Sql...@li...</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion">https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion</a> </pre> </blockquote> </body> </html> |
|
From: Paul D. W. <pdw...@qu...> - 2005-11-16 05:46:07
|
One feature that would be useful on a machine with multiple IPs would be the ability to bind SQL Relay to a particular IP via the configuration file. |
|
From: Firstworks/4access <dav...@fi...> - 2005-11-14 17:25:07
|
That bug will be fixed in 0.37. I was using "long" integers in 0.36 which are 4 bytes on x86 but 8 bytes in x86_64. 0.37 uses int32_t and the like which are more explict. Give http://www.firstworks.com/sqlrelay-0.37pre3.tar.gz a try. David Muse dav...@fi... On Mon, 2005-11-14 at 02:04 +0100, Arnaud Connois wrote: > Hi all, > > When I connect from php on a i386 machine to a sqlrelayd on a x86_64 > machines I get theses kind of messages in the debug logs : > > 11/14/2005 00:29:14 CET listener [3622] : > authentication failed: password size is wrong > > In a previous thread in the archives : > http://sourceforge.net/mailarchive/message.php?msg_id=12064055 > > I've seen that this is related to variable size between different OS. > > I'm using sqlrelay-0.36.4. Any idea if 0.37 will solves this ? > > Does somebody tried the pre versions of 0.37 and had some experience > connecting between 2 different OS like this and had it working ? > > So far this is the only dificulty I had to sqlrelay. This is a great > product. > > Thanks. > > Arnaud > > > > ------------------------------------------------------- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > _______________________________________________ > Sqlrelay-discussion mailing list > Sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion > |
|
From: Seth G. <sgo...@op...> - 2005-11-14 15:55:48
|
Hello, I am using SQLRelayDA to talk to Oracle 10g and one of my fields is a CLOB. When my update statement contains long strings, I get an error from Oracle: ORA-01704: string literal too long Is there any simple way to do a prepared query with input binds through the DA? Or should I interface directly with the PySQLRClient? Thanks, Seth -- Seth Gottlieb Optaros, Inc. 60 Canal Street Boston, MA 02114 e: sgo...@op... v: 617.227.1855 ext. 107 f: 617.227.1755 m: 617.852.2956 |
|
From: Arnaud C. <arn...@co...> - 2005-11-14 00:58:18
|
Hi all, When I connect from php on a i386 machine to a sqlrelayd on a x86_64 machines I get theses kind of messages in the debug logs : 11/14/2005 00:29:14 CET listener [3622] : authentication failed: password size is wrong In a previous thread in the archives : http://sourceforge.net/mailarchive/message.php?msg_id=12064055 I've seen that this is related to variable size between different OS. I'm using sqlrelay-0.36.4. Any idea if 0.37 will solves this ? Does somebody tried the pre versions of 0.37 and had some experience connecting between 2 different OS like this and had it working ? So far this is the only dificulty I had to sqlrelay. This is a great product. Thanks. Arnaud |
|
From: Rodrigo P. T. <te...@de...> - 2005-11-11 19:49:04
|
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi Guys,
I've been experiencing some errors using JAVA with sqlrelay-0.35 API and MySQL
4.1.7 as a DB backend.
Some thimes when I'm doing a query the application failed with that output
exception:
- ----------------------------------------------------------------------------------
An unexpected exception has been detected in native code outside the VM.
Unexpected Signal : 11 occurred at PC=0x400C6C48
Function=(null)+0x400C6C48
Library=/lib/libc.so.6
NOTE: We are unable to locate the function name symbol for the error
just occurred. Please refer to release documentation for possible
reason and solutions.
Current Java thread:
at com.firstworks.sqlrelay.SQLRCursor.prepareQuery(Native Method)
at it.devel.Dao.getBean(Dao.java:185)
at it.devel.wiser.TerminadorDAO.calculaMinutagem(TerminadorDAO.java:131)
at it.devel.Bilhetagem.getTempoCorrigido(Bilhetagem.java:342)
at it.devel.Bilhetagem.bilhetaTerminador(Bilhetagem.java:320)
at it.devel.Bilhetagem.bilhetar(Bilhetagem.java:141)
at it.devel.Bilhetagem.main(Bilhetagem.java:693)
Dynamic libraries:
08048000-08056000 r-xp 00000000 08:06 246208 /usr/local/j2sdk1.4.2_06/bin/java
08056000-08059000 rwxp 0000d000 08:06 246208 /usr/local/j2sdk1.4.2_06/bin/java
40000000-40011000 r-xp 00000000 08:05 212994 /lib/ld-2.3.3.so
40011000-40012000 rwxp 00011000 08:05 212994 /lib/ld-2.3.3.so
40018000-40026000 r-xp 00000000 08:05 213024 /lib/libpthread-0.10.so
40026000-40028000 rwxp 0000d000 08:05 213024 /lib/libpthread-0.10.so
4006a000-4006c000 r-xp 00000000 08:05 213005 /lib/libdl-2.3.3.so
4006c000-4006d000 rwxp 00001000 08:05 213005 /lib/libdl-2.3.3.so
4006d000-40167000 r-xp 00000000 08:05 213001 /lib/libc-2.3.3.so
40167000-40170000 rwxp 000fa000 08:05 213001 /lib/libc-2.3.3.so
40173000-4056f000 r-xp 00000000 08:06 134540
/usr/local/j2sdk1.4.2_06/jre/lib/i386/client/libjvm.so
4056f000-4058b000 rwxp 003fb000 08:06 134540
/usr/local/j2sdk1.4.2_06/jre/lib/i386/client/libjvm.so
405a2000-405b1000 r-xp 00000000 08:05 213009 /lib/libnsl-2.3.3.so
405b1000-405b2000 rwxp 0000f000 08:05 213009 /lib/libnsl-2.3.3.so
405b4000-405d4000 r-xp 00000000 08:05 213007 /lib/libm-2.3.3.so
405d4000-405d5000 rwxp 0001f000 08:05 213007 /lib/libm-2.3.3.so
405d5000-405dd000 r-xp 00000000 08:06 101710
/usr/local/j2sdk1.4.2_06/jre/lib/i386/native_threads/libhpi.so
405dd000-405de000 rwxp 00007000 08:06 101710
/usr/local/j2sdk1.4.2_06/jre/lib/i386/native_threads/libhpi.so
405de000-405e2000 rwxs 00000000 08:09 14628 /tmp/hsperfdata_callstart/19866
405e3000-405ec000 r-xp 00000000 08:05 213015 /lib/libnss_files-2.3.3.so
405ec000-405ed000 rwxp 00009000 08:05 213015 /lib/libnss_files-2.3.3.so
405ed000-405fd000 r-xp 00000000 08:06 101717
/usr/local/j2sdk1.4.2_06/jre/lib/i386/libverify.so
405fd000-405ff000 rwxp 0000f000 08:06 101717
/usr/local/j2sdk1.4.2_06/jre/lib/i386/libverify.so
405ff000-4061f000 r-xp 00000000 08:06 101718
/usr/local/j2sdk1.4.2_06/jre/lib/i386/libjava.so
4061f000-40621000 rwxp 0001f000 08:06 101718
/usr/local/j2sdk1.4.2_06/jre/lib/i386/libjava.so
40621000-40635000 r-xp 00000000 08:06 101720
/usr/local/j2sdk1.4.2_06/jre/lib/i386/libzip.so
40635000-40638000 rwxp 00013000 08:06 101720
/usr/local/j2sdk1.4.2_06/jre/lib/i386/libzip.so
40638000-41fdf000 r-xs 00000000 08:06 101803
/usr/local/j2sdk1.4.2_06/jre/lib/rt.jar
42029000-4203f000 r-xs 00000000 08:06 101742
/usr/local/j2sdk1.4.2_06/jre/lib/sunrsasign.jar
4203f000-4211c000 r-xs 00000000 08:06 101787
/usr/local/j2sdk1.4.2_06/jre/lib/jsse.jar
4211c000-4212d000 r-xs 00000000 08:06 101743
/usr/local/j2sdk1.4.2_06/jre/lib/jce.jar
4212d000-42686000 r-xs 00000000 08:06 101788
/usr/local/j2sdk1.4.2_06/jre/lib/charsets.jar
4472e000-4472f000 r-xs 00000000 08:06 117021
/usr/local/j2sdk1.4.2_06/jre/lib/ext/Itau.jar
4c7b0000-4c7cc000 r-xs 00000000 08:06 117679
/usr/local/j2sdk1.4.2_06/jre/lib/ext/sunjce_provider.jar
4c7cc000-4c7cf000 r-xs 00000000 08:06 117680
/usr/local/j2sdk1.4.2_06/jre/lib/ext/dnsns.jar
4c7cf000-4c7dc000 r-xs 00000000 08:06 117682
/usr/local/j2sdk1.4.2_06/jre/lib/ext/ldapsec.jar
4c7dc000-4c898000 r-xs 00000000 08:06 117684
/usr/local/j2sdk1.4.2_06/jre/lib/ext/localedata.jar
4c898000-4c8a6000 r-xs 00000000 08:06 117022
/usr/local/j2sdk1.4.2_06/jre/lib/ext/activation.jar
4c8a6000-4c8d3000 r-xs 00000000 08:06 117023
/usr/local/j2sdk1.4.2_06/jre/lib/ext/mailapi.jar
4c8d3000-4c92a000 r-xs 00000000 08:06 117024
/usr/local/j2sdk1.4.2_06/jre/lib/ext/mail.jar
4c92a000-4c930000 r-xs 00000000 08:06 117025
/usr/local/j2sdk1.4.2_06/jre/lib/ext/pop3.jar
4c930000-4c936000 r-xs 00000000 08:06 117026
/usr/local/j2sdk1.4.2_06/jre/lib/ext/smtp.jar
4c936000-4c939000 r-xp 00000000 08:06 377923
/usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRConnection.so
4c939000-4c93a000 rwxp 00002000 08:06 377923
/usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRConnection.so
4c93a000-4c950000 r-xp 00000000 08:06 265533
/usr/src/sqlrelay-0.35/src/api/c++/src/.libs/libsqlrclient-0.35.so.1.0.0
4c950000-4c953000 rwxp 00015000 08:06 265533
/usr/src/sqlrelay-0.35/src/api/c++/src/.libs/libsqlrclient-0.35.so.1.0.0
4c953000-4c998000 r-xp 00000000 08:06 377564
/usr/local/firstworks/lib/librudiments-0.27.so.1.0.0
4c998000-4c9a2000 rwxp 00044000 08:06 377564
/usr/local/firstworks/lib/librudiments-0.27.so.1.0.0
4c9a7000-4c9d2000 r-xp 00000000 08:06 115308 /usr/lib/libssl.so.0.9.7
4c9d2000-4c9d5000 rwxp 0002a000 08:06 115308 /usr/lib/libssl.so.0.9.7
4c9d5000-4caab000 r-xp 00000000 08:06 115306 /usr/lib/libcrypto.so.0.9.7
4caab000-4cabc000 rwxp 000d6000 08:06 115306 /usr/lib/libcrypto.so.0.9.7
4cac0000-4cac4000 r-xp 00000000 08:05 213003 /lib/libcrypt-2.3.3.so
4cac4000-4cac5000 rwxp 00003000 08:05 213003 /lib/libcrypt-2.3.3.so
4caec000-4cb8a000 r-xp 00000000 08:06 114711 /usr/lib/libstdc++.so.5.0.5
4cb8a000-4cba0000 rwxp 0009d000 08:06 114711 /usr/lib/libstdc++.so.5.0.5
4cba5000-4cbac000 r-xp 00000000 08:06 114701 /usr/lib/libgcc_s.so.1
4cbac000-4cbad000 rwxp 00006000 08:06 114701 /usr/lib/libgcc_s.so.1
4cbad000-4cbb7000 r-xp 00000000 08:06 377924
/usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRCursor.so
4cbb7000-4cbb9000 rwxp 0000a000 08:06 377924
/usr/local/firstworks/java/com/firstworks/sqlrelay/libSQLRCursor.so
Heap at VM Abort:
Heap
def new generation total 576K, used 236K [0x44730000, 0x447d0000, 0x44c10000)
eden space 512K, 43% used [0x44730000, 0x44767248, 0x447b0000)
from space 64K, 24% used [0x447b0000, 0x447b3fa8, 0x447c0000)
to space 64K, 0% used [0x447c0000, 0x447c0000, 0x447d0000)
tenured generation total 1408K, used 339K [0x44c10000, 0x44d70000, 0x48730000)
the space 1408K, 24% used [0x44c10000, 0x44c64f58, 0x44c65000, 0x44d70000)
compacting perm gen total 4096K, used 1696K [0x48730000, 0x48b30000, 0x4c730000)
the space 4096K, 41% used [0x48730000, 0x488d8380, 0x488d8400, 0x48b30000)
Local Time = Fri Nov 11 15:34:29 2005
Elapsed Time = 771
#
# The exception above was detected in native code outside the VM
#
# Java VM: Java HotSpot(TM) Client VM (1.4.2_06-b03 mixed mode)
-
--------------------------------------------------------------------------------------------------------
At the moment is not so easy for me to update to 0.36.x.
Does some one can help with that problem?
Thanks in advance.
- --
============================================
Rodrigo P. Telles <te...@de...>
IT Manager
Devel-IT - http://www.devel.it
IVOZ # 1029
+55 14 3324-1200
Bestcom Group
============================================
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFDdPWSiLK8unYgEMQRAuEZAJ9jSyOPrSfJynxqDc3vSbkA5KkDjACcCbPE
rdJgJ1Z38BuP57tnSJ2xDsU=
=qMXp
-----END PGP SIGNATURE-----
|
|
From: Deepak M. <dee...@ma...> - 2005-11-11 12:43:38
|
Hi,
I am having problem to run queries to access SQL Server 2000 database=20
using SQL Relay.
--------------------------------------
I first started the SQL Relay as follows:
sqlr-start -id MyID
It worked fine. But when i tried to run the queries as follow:
sqlrsh -id MyID
SQLRShell - Version 0.22
Connected to: localhost:4000 as ele2006
type help; for a help.
0> select * from editorial_tempmaster;
Debugging to: /usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9475
----------------------------
No result was shown.The=20
/usr/local/firstworks/var/sqlrelay/debug/sqlr-listener.9475 contains:
11/11/2005 16:39:10 IST listener [9475] : getting authentication...
11/11/2005 16:39:10 IST listener [9475] : listener-based=20
authentication succeeded
11/11/2005 16:39:10 IST listener [9475] : incrementing session count...
11/11/2005 16:39:10 IST listener [9475] : 2
------------------
Please help me!!
--
Deepak Mangal
--=20
___________________________________________________
Play 100s of games for FREE! http://games.mail.com/
|
|
From: Maciej W. <mac...@co...> - 2005-11-10 20:48:40
|
> If I execute a "SELECT *" in SQLRelay for the row I'm looking for, the body often (but not always) comes back empty. > If I do a request on just the body field, I can get back results. I had exactly the same problem with Clobs. AFAIR I even posted this to the forum (check archives). Because I'm not using CLOB's in my database (the problem appeared during tests only) and I had no time for SQLRelay recently (although I've used this sucessfully with java) I've forgotten about this :D -- Maciej Wisniowski |
|
From: Andrew L. <ala...@bo...> - 2005-11-10 18:47:52
|
In my code, object to PySQLRClient.sqlrcursor.inputBind that I
thought was a simple string, but had accidentally been upgraded to a
unicode string. To my surprise, there were no errors reported, but
the bind just was ignored entirely.
Looking at the C code for the Python CSQLRelay extension, I see that
inputBind is a long if/else if sequence with no default else clause.
if (value==Py_None) {
((sqlrcursor *)sqlrcur)->inputBind(variable, (char *)NULL);
} else if (PyString_Check(value)) {
((sqlrcursor *)sqlrcur)->inputBind(variable, PyString_AsString
(value));
} else if (PyInt_Check(value)) {
((sqlrcursor *)sqlrcur)->inputBind(variable, (long)PyInt_AsLong
(value));
} else if (PyFloat_Check(value)) {
((sqlrcursor *)sqlrcur)->inputBind(variable, (double)
PyFloat_AsDouble(value)
, (unsigned short)precision, (unsigned short)scale);
}
Should .inputBind return a status to say in bound correctly? Should
it through a TypeError? Should it try to coerce its input into one of
the four simple types it knows about?
Or should I just be more careful what I pass into it?
|
|
From: Andrew L. <ala...@bo...> - 2005-11-10 18:38:40
|
I'm using SQLRelay to talk to an oracle database. The database is
Oracle 10g running on Solaris. For the moment, the SQLRelay 0.36.4 is
running on Linux (Suse 9.1) using the Oracle InstantClient libraries
and I'm using the Python API to have my application talk to the
SQLRelay and database.
Most of my fields are varchar and int fields. One field, "body" is a
CLOB.
If I execute a "SELECT *" in SQLRelay for the row I'm looking for,
the body often (but not always) comes back empty. If I do a request
on just the body field, I can get back results.
Does the CLOB field need to be handled differently? Why do my results
differ if I request the field individually?
Below is an example of the problem using SQLRelay to demonstrate the
behavior.
langmead@breaker:~> /zope/bonzai-orp/bin/sqlrsh -id oracle
SQLRShell - Version 0.22
Connected to: localhost:9000 as bonzai
type help; for a help.
0> SELECT * from BZ_STORY_ASSET_SCHEMA WHERE SCHEMA_ID=539;
STORY_ID SCHEMA_ID ABSTRACT BODY BODY_LENGTH BYLINE
BYTTL COPYRIGHT_DATE COPYRIGHT_HOLDER DATELINE
EDITORIAL_TYPE OVERLINE COLUMN_NAME LOCATION
MAIN_HEADLINE REVIEW_RATING SUB_HEADLINE
EXTENDED_HEADLINE TEASE_HEADLINE TEASE_LAST_MODIFIED_DATE
TEASE_SUB_HEADLINE TEASE_SUBJECT TEASE_TEXT TEASE_WORD_LINK_NUMBER
URGENCY WORD_COUNT SOURCE PAGE_POSITION_PRIORITY PAGINATE_OFF
IGNORE_LINE_BREAKS MODIFIED_DATE_TIME MODIFY_INSTANCE
========================================================================
========================================================================
========================================================================
========================================================================
========================================================================
========================================================================
===========================================
-1291481359 539 26 Doug Ferguson AP Golf
Writer AUGUSTA, Ga.
News Traditional Augusta
remains
contemporary
7
5 0
100 0 0
Rows Returned : 1
Fields Returned : 32
System time : 20000
0> debug on;
0> SELECT * from BZ_STORY_ASSET_SCHEMA WHERE SCHEMA_ID=539;
Result Set Buffer Size: 100
Sending Query:
SELECT * from BZ_STORY_ASSET_SCHEMA WHERE SCHEMA_ID=539
Length: 55
Requesting Cursor: 0
Sending 0 Input Bind Variables:
Sending Output Bind Variables:
Send Column Info: yes
Skipping and Fetching
row to get: 99
Skipping 0 rows
Fetching 100 rows
Checking For An Error... none.
Getting Cursor ID...
Cursor ID: 0
Previous result set was not suspended.
Parsing Column Info
Actual row count: unknown
Affected row count: 0
Column count: 32
"STORY_ID","VARCHAR2", 20 (0,0)
"SCHEMA_ID","NUMBER", 22 (38,0) NOT NULL
"ABSTRACT","VARCHAR2", 1000 (0,0)
"BODY","CLOB", 0 (0,0)
"BODY_LENGTH","NUMBER", 22 (38,0)
"BYLINE","VARCHAR2", 50 (0,0)
"BYTTL","VARCHAR2", 50 (0,0)
"COPYRIGHT_DATE","VARCHAR2", 10 (0,0)
"COPYRIGHT_HOLDER","VARCHAR2", 20 (0,0)
"DATELINE","VARCHAR2", 100 (0,0)
"EDITORIAL_TYPE","VARCHAR2", 10 (0,0)
"OVERLINE","VARCHAR2", 30 (0,0)
"COLUMN_NAME","VARCHAR2", 30 (0,0)
"LOCATION","VARCHAR2", 30 (0,0)
"MAIN_HEADLINE","VARCHAR2", 100 (0,0)
"REVIEW_RATING","VARCHAR2", 10 (0,0)
"SUB_HEADLINE","VARCHAR2", 30 (0,0)
"EXTENDED_HEADLINE","VARCHAR2", 30 (0,0)
"TEASE_HEADLINE","VARCHAR2", 30 (0,0)
"TEASE_LAST_MODIFIED_DATE","DATE", 7 (0,0)
"TEASE_SUB_HEADLINE","VARCHAR2", 30 (0,0)
"TEASE_SUBJECT","VARCHAR2", 20 (0,0)
"TEASE_TEXT","VARCHAR2", 400 (0,0)
"TEASE_WORD_LINK_NUMBER","NUMBER", 22 (38,0)
"URGENCY","VARCHAR2", 10 (0,0)
"WORD_COUNT","NUMBER", 22 (38,0)
"SOURCE","VARCHAR2", 10 (0,0)
"PAGE_POSITION_PRIORITY","NUMBER", 22 (38,0)
"PAGINATE_OFF","VARCHAR2", 5 (0,0)
"IGNORE_LINE_BREAKS","VARCHAR2", 5 (0,0)
"MODIFIED_DATE_TIME","UNKNOWN", 11 (0,6)
"MODIFY_INSTANCE","VARCHAR2", 100 (0,0)
Receiving Output Bind Values:
Parsing Data
"-1291481359","539",(null),(null),"26","Doug Ferguson","AP Golf
Writer",(null),(null),"AUGUSTA, Ga.","News",(null),(null),
(null),"Traditional Augusta remains contemporary",(null),(null),
(null),(null),(null),(null),(null),(null),"7","5","0",
(null),"100","0","0",(null),(null),
Got end of result set.
STORY_ID SCHEMA_ID ABSTRACT BODY BODY_LENGTH BYLINE
BYTTL COPYRIGHT_DATE COPYRIGHT_HOLDER DATELINE
EDITORIAL_TYPE OVERLINE COLUMN_NAME LOCATION
MAIN_HEADLINE REVIEW_RATING SUB_HEADLINE
EXTENDED_HEADLINE TEASE_HEADLINE TEASE_LAST_MODIFIED_DATE
TEASE_SUB_HEADLINE TEASE_SUBJECT TEASE_TEXT TEASE_WORD_LINK_NUMBER
URGENCY WORD_COUNT SOURCE PAGE_POSITION_PRIORITY PAGINATE_OFF
IGNORE_LINE_BREAKS MODIFIED_DATE_TIME MODIFY_INSTANCE
========================================================================
========================================================================
========================================================================
========================================================================
========================================================================
========================================================================
===========================================
-1291481359 539 26 Doug Ferguson AP Golf
Writer AUGUSTA, Ga.
News Traditional Augusta
remains
contemporary
7
5 0
100 0 0
Rows Returned : 1
Fields Returned : 32
System time : 30000
0> SELECT SUBSTR(body,0,60) from BZ_STORY_ASSET_SCHEMA WHERE
SCHEMA_ID=539;
Result Set Buffer Size: 100
Sending Query:
SELECT SUBSTR(body,0,60) from BZ_STORY_ASSET_SCHEMA WHERE SCHEMA_ID=539
Length: 71
Requesting Cursor: 0
Sending 0 Input Bind Variables:
Sending Output Bind Variables:
Send Column Info: yes
Skipping and Fetching
row to get: 99
Skipping 0 rows
Fetching 100 rows
Checking For An Error... none.
Getting Cursor ID...
Cursor ID: 0
Previous result set was not suspended.
Parsing Column Info
Actual row count: unknown
Affected row count: 0
Column count: 1
"SUBSTR(BODY,0,60)","CLOB", 0 (0,0)
Receiving Output Bind Values:
Parsing Data
"For more than 40 years, the yardage on the scorecard at Augu",
Got end of result set.
SUBSTR(BODY,0,60)
============================================================
For more than 40 years, the yardage on the scorecard at Augu
Rows Returned : 1
Fields Returned : 1
System time : 30000
0> exit;
langmead@breaker:~>
|
16 messages has been excluded from this view by a project administrator.
