Hi ALex,
On 21/05/10 09:36, Alexander Hartmaier wrote:
DDL queries executed by your model at runtime sounds like a VERY bad
idea!
Your app db user shouldn't even be allowed to execute those.
Why?
I'm using Oracle with partitioned tables (one per month for historical
data) as well and the database itself cares about creating the partition
for the next month in advance.
What for are you using the partitions?
The table itself holds information of matches to genomic DNA from
sequencing experiments. We do this for several different organisms and
experiments and the table will get pretty large (currently 92M rows).
The partitions are used to separate data mappings into different
experiments.
Would this be better done via a trigger?
Cheers,
Chris
--
Best regards, Alex
Am Mittwoch, den 12.05.2010, 10:07 +0200 schrieb Chris Cole:
On Tue, 11 May 2010 21:52:47 +0100, Rob Kinyon<rob.kin...@gmail.com>
wrote:
On Tue, May 11, 2010 at 16:01, Chris Cole<ch...@compbio.dundee.ac.uk>
wrote:
Gives this error:
Warning - transaction failed and rolling back:
DBIx::Class::Schema::txn_do(): Can't locate object method "do" via
package
"DBIx::Class::Storage::DBI::Oracle::Generic" at
/homes/ccole/projects/workspace/NGSdb/load_drs_data.pl line 176.
Any ideas why $dbh-do() is failing?
Maybe reading the documentation instead of relying purely on my advice
would be a good plan.
If you'd put a caveat, maybe I would have looked harder. I did search for
the docs, but couldn't find them.
http://search.cpan.org/~frew/DBIx-Class-0.08121/lib/DBIx/Class/Storage/DBI.pm#dbh_do
$storage->dbh_do( sub {
my ($storage, $dbh, @args) = @_;
....
}, @args );
Thanks.
_______________________________________________
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
--
Dr Chris Cole
Senior Bioinformatics Research Officer
School of Life Sciences Research
University of Dundee
Dow Street
Dundee
DD1 5EH
Scotland, UK
url: http://network.nature.com/profile/drchriscole
e-mail: ch...@compbio.dundee.ac.uk
Tel: +44 (0)1382 388 721
The University of Dundee is a registered Scottish charity, No: SC015096
_______________________________________________
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
