Re: [Dbix-class] Table name length constraint?

2015-02-24 Thread Greg Coates 

Yes, that is correct.

On 2/24/2015 12:57 AM, Hartmaier Alexander wrote:

So the correct way to handle that case is to limit only the tablename
portion, right?

On 2015-02-24 02:00, Greg Coates wrote:

That looks to be what is happening.  Is there any way to turn this
behavior off?  This is a legitimate table name with a dblink and
schema appended.  It works in a direct query.

Thanks,
Greg

On 2/23/2015 4:49 PM, Ben Tilly wrote:

Random guess, DBIx::Class is working around a database limitation.
For example see
http://search.cpan.org/~ribasushi/DBIx-Class-0.082810/lib/DBIx/Class/Storage/DBI/Oracle/Generic.pm#relname_to_table_alias 



for how your situation could have happened.

On Mon, Feb 23, 2015 at 4:36 PM, Greg Coates g...@coatesoft.com 
wrote:

Is there code somewhere in DBIx::Class that limits the length of a
table
name?

I have a schema package with the following table name:

__PACKAGE__-table('RDSPRD.REC_CLASS_MTG_INSTRUCTOR_DTL@FRONT1');

When I try to access data from this table, I get an error saying the
table
does not exist, but if I look at the generated SQL in the error
message, the
table name has changed to RDSPRD.RcClssMtgInstrctrDt_D412VD8KCP.

If I change the table name to REC_CLASS_MTG_INSTRUCTOR_DTL, the
table name
doesn't get changed in the SQL.

Does anyone have any idea what is going on here?

Thanks,
Greg Coates


___
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

___
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



___
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




*** 


T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*** 

Notice: This e-mail contains information that is confidential and may 
be privileged.

If you are not the intended recipient, please notify the sender and then
delete this e-mail immediately.
*** 



___
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



___
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] Table name length constraint?

2015-02-24 Thread Greg Coates 

Yes, that worked.  Thanks!

On 2/23/2015 11:12 PM, Peter Rabbitson wrote:

On 02/24/2015 01:36 AM, Greg Coates wrote:

Is there code somewhere in DBIx::Class that limits the length of a table
name?

I have a schema package with the following table name:

__PACKAGE__-table('RDSPRD.REC_CLASS_MTG_INSTRUCTOR_DTL@FRONT1');


Please try with:

__PACKAGE__-table(\'RDSPRD.REC_CLASS_MTG_INSTRUCTOR_DTL@FRONT1');

to indicate to DBIC I know what I am doing

___
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



___
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] Table name length constraint?

2015-02-23 Thread Greg Coates 

One note: The ' at ' in the table name should have been an actual at sign.

Greg

On 2/23/2015 4:36 PM, Greg Coates wrote:
Is there code somewhere in DBIx::Class that limits the length of a 
table name?


I have a schema package with the following table name:

__PACKAGE__-table('RDSPRD.REC_CLASS_MTG_INSTRUCTOR_DTL@FRONT1');

When I try to access data from this table, I get an error saying the 
table does not exist, but if I look at the generated SQL in the error 
message, the table name has changed to 
RDSPRD.RcClssMtgInstrctrDt_D412VD8KCP.


If I change the table name to REC_CLASS_MTG_INSTRUCTOR_DTL, the table 
name doesn't get changed in the SQL.


Does anyone have any idea what is going on here?

Thanks,
Greg Coates




___
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] Table name length constraint?

2015-02-23 Thread Greg Coates 
Is there code somewhere in DBIx::Class that limits the length of a table 
name?


I have a schema package with the following table name:

__PACKAGE__-table('RDSPRD.REC_CLASS_MTG_INSTRUCTOR_DTL@FRONT1');

When I try to access data from this table, I get an error saying the 
table does not exist, but if I look at the generated SQL in the error 
message, the table name has changed to 
RDSPRD.RcClssMtgInstrctrDt_D412VD8KCP.


If I change the table name to REC_CLASS_MTG_INSTRUCTOR_DTL, the table 
name doesn't get changed in the SQL.


Does anyone have any idea what is going on here?

Thanks,
Greg Coates


___
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] Table name length constraint?

2015-02-23 Thread Greg Coates 
That looks to be what is happening.  Is there any way to turn this 
behavior off?  This is a legitimate table name with a dblink and schema 
appended.  It works in a direct query.


Thanks,
Greg

On 2/23/2015 4:49 PM, Ben Tilly wrote:

Random guess, DBIx::Class is working around a database limitation.
For example see
http://search.cpan.org/~ribasushi/DBIx-Class-0.082810/lib/DBIx/Class/Storage/DBI/Oracle/Generic.pm#relname_to_table_alias
for how your situation could have happened.

On Mon, Feb 23, 2015 at 4:36 PM, Greg Coates g...@coatesoft.com wrote:

Is there code somewhere in DBIx::Class that limits the length of a table
name?

I have a schema package with the following table name:

__PACKAGE__-table('RDSPRD.REC_CLASS_MTG_INSTRUCTOR_DTL@FRONT1');

When I try to access data from this table, I get an error saying the table
does not exist, but if I look at the generated SQL in the error message, the
table name has changed to RDSPRD.RcClssMtgInstrctrDt_D412VD8KCP.

If I change the table name to REC_CLASS_MTG_INSTRUCTOR_DTL, the table name
doesn't get changed in the SQL.

Does anyone have any idea what is going on here?

Thanks,
Greg Coates


___
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

___
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



___
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