Re: [Dbix-class] Re: DBIx::Class with ODBC

2013-02-20 Thread Peter Rabbitson 
On Wed, Feb 20, 2013 at 09:12:29AM -0500, Stephen Moy wrote:
 Thanks for all your help, Peter.
 
 We contacted the folks at Ingres (Actian), and they confirmed their
 ODBC driver had a slight issue (it didn't support SQL_DM_VER).  They
 are planning to add that in, but it might take a while.


Aha, ok. This is good to know - we'll adjust the info-check to take this
in consideration. I have been busy with other stuff [1], will get back
to this problem towards the weekend.

Cheers and stay tuned.

[1] https://twitter.com/dbix_class/status/304192804194762752

___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

Re: [Dbix-class] Re: DBIx::Class with ODBC

2013-02-19 Thread Peter Rabbitson 
On Sat, Jan 26, 2013 at 01:18:40AM +1100, Peter Rabbitson wrote:
 On Fri, Jan 25, 2013 at 06:05:44AM -0800, stephenmoy wrote:
When you connect to a DSN we do not yet know how to
support you should see something similar to this: [1]. However you
claimed you saw this exception [2]. 
  
  In my test, the following line:
  my ( $student ) = $schema-resultset( 'Student' )-search( { uid = $uid }
  );
  
  produces the DBIx::Class::ResultSet::search(): DBI Exception: DBD::ODBC::db
  get_info failed: [Ingres][Ingres ODBC Driver]Information type out of range
  (SQL-HY096) error.
 
 Right, and I was asking if you can debug *which* part of the code throws this
 exception - you should have seen the other output first, but apparently
 something is broken somewhere. Even just running the above under DBIC_TRACE=1
 should help (this will turn on full stacktracing).
 

Have you had a chance to look into this further?


___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

Re: [Dbix-class] Re: DBIx::Class with ODBC

2013-02-06 Thread Dave Howorth 
stephenmoy wrote:
 I appreciate the help up to this point, but still haven't got this working. 
 Any other ideas?

I haven't seen your reply to

Peter Rabbitson wrote:
 On Fri, Jan 25, 2013 at 06:05:44AM -0800, stephenmoy wrote:
 produces the DBIx::Class::ResultSet::search(): DBI Exception:
 DBD::ODBC::db get_info failed: [Ingres][Ingres ODBC
 Driver]Information type out of range (SQL-HY096) error.

 Right, and I was asking if you can debug *which* part of the code
 throws this exception - you should have seen the other output first,
 but apparently something is broken somewhere. Even just running the
 above under DBIC_TRACE=1 should help (this will turn on full
 stacktracing).

___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

[Dbix-class] Re: DBIx::Class with ODBC

2013-02-04 Thread stephenmoy 
I appreciate the help up to this point, but still haven't got this working. 
Any other ideas?



--
View this message in context: 
http://dbix-class.35028.n2.nabble.com/DBIx-Class-with-ODBC-tp7577958p7577973.html
Sent from the DBIx-Class mailing list archive at Nabble.com.

___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

[Dbix-class] Re: DBIx::Class with ODBC

2013-01-28 Thread stephenmoy 
Yes, sorry about that.  Ingres does support both OFFSET and LIMIT--Ingres'
equivalent for LIMIT is FIRST/NEXT, such as:

select * from table
offset 1
fetch first 10 rows only




--
View this message in context: 
http://dbix-class.35028.n2.nabble.com/DBIx-Class-with-ODBC-tp7577958p7577972.html
Sent from the DBIx-Class mailing list archive at Nabble.com.

___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

[Dbix-class] Re: DBIx::Class with ODBC

2013-01-25 Thread stephenmoy 
DBIC_TRACE=1 generates this:
Undefined subroutine Carp::longmess_heavy called at
/usr/lib/perl5/5.8.8/Carp.pm line 239.

 In addition - what limit dialect does Ingress support? Is
 it any of the already implemented ones [1] ? Note - we need limit *and*
 offset support, limit alone won't cut it. 

Ingres seems to support OFFSET only.



--
View this message in context: 
http://dbix-class.35028.n2.nabble.com/DBIx-Class-with-ODBC-tp7577958p7577970.html
Sent from the DBIx-Class mailing list archive at Nabble.com.

___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

Re: [Dbix-class] Re: DBIx::Class with ODBC

2013-01-25 Thread Dave Howorth 
stephenmoy wrote:
 DBIC_TRACE=1 generates this:
 Undefined subroutine Carp::longmess_heavy called at
 /usr/lib/perl5/5.8.8/Carp.pm line 239.
 
 In addition - what limit dialect does Ingress support? Is
 it any of the already implemented ones [1] ? Note - we need limit *and*
 offset support, limit alone won't cut it. 
 
 Ingres seems to support OFFSET only.

FIRST ?

___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

[Dbix-class] Re: DBIx::Class with ODBC

2013-01-24 Thread stephenmoy 
 Can you please debug it and see why/how it fails (perhaps step through it 
 with the debugger or something). Then get us the actual info it 
 produces, and hopefully adding the extra informix driver won't be much 
 work.

Using the Perl debugger, it seems like the error begins at:

DBIx::Class::Storage::DBI::_warn_undetermined_driver('DBIx::Class::Storage::DBI::ODBC=HASH(0x1b404a10)',
'This version of DBIC does not yet seem to supply a driver for...') called
at /lib/perl5/DBIx/Class/Storage/DBI.pm line 1289

Would the extra informix driver work?



--
View this message in context: 
http://dbix-class.35028.n2.nabble.com/DBIx-Class-with-ODBC-tp7577958p7577966.html
Sent from the DBIx-Class mailing list archive at Nabble.com.

___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

[Dbix-class] Re: DBIx::Class with ODBC

2013-01-22 Thread stephenmoy 
 Please connect to the database using plain DBI and give us the
 output of:

 $dbh-get_info(
$DBI::Const::GetInfoType::GetInfoType{SQL_DBMS_NAME}
 );

Output is INGRES



--
View this message in context: 
http://dbix-class.35028.n2.nabble.com/DBIx-Class-with-ODBC-tp7577958p7577961.html
Sent from the DBIx-Class mailing list archive at Nabble.com.

___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

Re: [Dbix-class] Re: DBIx::Class with ODBC

2013-01-22 Thread Peter Rabbitson 
On Tue, Jan 22, 2013 at 10:04:17AM -0800, stephenmoy wrote:
  Please connect to the database using plain DBI and give us the
  output of:
 
  $dbh-get_info(
 $DBI::Const::GetInfoType::GetInfoType{SQL_DBMS_NAME}
  );
 
 Output is INGRES
 

Grumble. The error before means that the information gathering routine 
_describe_connection() added here [1] actually fails on your setup. Can 
you please debug it and see why/how it fails (perhaps step through it 
with the debugger or something). Then get us the actual info it 
produces, and hopefully adding the extra informix driver won't be much 
work.

Cheers

[1] https://github.com/dbsrgits/dbix-class/commit/75d3bdb2431

___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk