Re: [Sqlrelay-discussion] Problems getting SQLRelay to play nicewithDBIx::Class & Mysql on Solaris 5.9

[Tom H. <Tom...@bb...>]

Hmm.. after some playing it seems to be partly working using the
DBI:SQLRelay connection string and no loadable module.

However, I am still getting the "unknown database SQLRelay - using
GenericSubQ dialect" error.

Additionally I am finding the following errors:

 Can't set DBI::st=3DHASH(0x2a29320)->{PRECISION}: unrecognised attribute=

or invalid value at /home/tomh/Pips3/deps/perl5lib//DBD/SQLRelay.pm line
477.
Can't set DBI::st=3DHASH(0x2a29320)->{NULLABLE}: unrecognised attribute o=
r
invalid value at /home/tomh/Pips3/deps/perl5lib//DBD/SQLRelay.pm line
477.

And also some of my SQL is now failing syntax checks (although it works
perfectly when connecting directly via DBI.

any ideas?=20

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
Tom Howe
Sent: 22 November 2006 11:48
To: Discussion of topics related to SQL Relay
Subject: Re: [Sqlrelay-discussion] Problems getting SQLRelay to play
nicewithDBIx::Class & Mysql on Solaris 5.9

ps I'm running all this on solaris 9 (5.9)=20

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
Tom Howe
Sent: 22 November 2006 11:39
To: Discussion of topics related to SQL Relay
Subject: [Sqlrelay-discussion] Problems getting SQLRelay to play nice
withDBIx::Class & Mysql

Hi all, first post on this list.

I am looking to use SQLRelay as a db connection pooler for our
application server.=20

We use Perl/Catalyst/DBIx::Class for the application server and MySQL as
the backend database.

I have installed SQLRelay 0.38 with only Perl and Mysql support and it
has compiled and installed ok.

If I use sqlrsh I can connect to my database ok. I also successfully ran
a small test script using SQLRelay::Connection.

However when my application server tries to access the db via sqlrelay I
am having problems.

If I use the drop in replacement modules (for mysql v5.0) and leave my
DBI connection string as dbi:mysql.. I am getting the following errors.

"DBI Connection failed: DBD driver has not implemented the AutoCommit
attribute."
 and
"DBI Connection failed: Turning on AutoCommit failed"

If I change the connection string to DBI:SQLRelay.. I get the following
error:

"unknown database SQLRelay - using GenericSubQ dialect"

Can anyone advice what I am doing wrong?
Is DBIx::Class known to have problems with SQLRelay?



I also notice on the FAQ page a table showing why one should use SQL
Relay with different databases. For MySQL it says it does not overcome
Connection delays.

I plan to run SQLRelay on the server where my application holding a
number of connections with MySQL and then connect to SQLRelay via unix
sockets, which in my experience are much faster than TCPIP.

Will this work and will this also not give a performance improvement
over direct connections?


Many thanks, Tom

http://www.bbc.co.uk/
This e-mail (and any attachments) is confidential and may contain
personal views which are not the views of the BBC unless specifically
stated.
If you have received it in error, please delete it from your system.
Do not use, copy or disclose the information in any way nor act in
reliance on it and notify the sender immediately.
Please note that the BBC monitors e-mails sent or received.
Further communication will signify your consent to this.
				=09

------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT Join
SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

http://www.bbc.co.uk/
This e-mail (and any attachments) is confidential and may contain
personal views which are not the views of the BBC unless specifically
stated.
If you have received it in error, please delete it from your system.
Do not use, copy or disclose the information in any way nor act in
reliance on it and notify the sender immediately.
Please note that the BBC monitors e-mails sent or received.
Further communication will signify your consent to this.
				=09

------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT Join
SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
Sqlrelay-discussion mailing list
Sql...@li...
https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion

http://www.bbc.co.uk/
This e-mail (and any attachments) is confidential and may contain persona=
l views which are not the views of the BBC unless specifically stated.
If you have received it in error, please delete it from your system.
Do not use, copy or disclose the information in any way nor act in relian=
ce on it and notify the sender immediately.
Please note that the BBC monitors e-mails sent or received.
Further communication will signify your consent to this.
				=09