04-16-2008
Well, at last found out that Perl is unable to handle data value beyond "9219999999900004864". I am using Perl 5.8 and DBI 1.604
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello all,
i like to install an application program that will interact with
the oracle database.
oracle has been installed in /export/home/oracle
does the new application has to be in the same directory and
if not which one do you recommend?
There is a drive like the ODBC in oracle to... (2 Replies)
Discussion started by: rsh
2 Replies
2. UNIX for Advanced & Expert Users
Dose anybody knows about Installation and setup of ODBC under AIX 5.3 L (0 Replies)
Discussion started by: uhdesai
0 Replies
3. Solaris
Hi,
I have my application and database servers running on solaris. I need to check Db connectivity for a datasource in my Db server.
Please guide me how to do it in solaris env.
Aru (2 Replies)
Discussion started by: aarora_98
2 Replies
4. UNIX for Dummies Questions & Answers
how to find the version of ODBC and the database drivers in Unix box :eek: (0 Replies)
Discussion started by: raghunath_mv
0 Replies
5. UNIX for Dummies Questions & Answers
I see several questions regarding setting up ODBC on UNIX machines but I don't see any replies. I always thought ODBC was only possible on Windows machines, but I've recently heard drivers do exist for ODBC on UNIX. Does anyone know any more details about this: How to set up ODBC on UNIX, web sites... (1 Reply)
Discussion started by: ggmar
1 Replies
6. Windows & DOS: Issues & Discussions
I am attempting to access an Oracle 9i database located on a Solaris server from an XP client. The server is running Oracle 9i9.2.0.1.0 and the XP is Oracle client 9i 9.2.0.1.0. When I start a listener on the server, the listener starts but I receive a message “The listener supports no services”. I... (3 Replies)
Discussion started by: jkuchar747
3 Replies
7. AIX
I´m using an app that uses odbc to connect to the data base, i thought odbc was only available for NT plataforms...anybody knows how to create an odbc connection on AIX 5.1 (if possible).
Thanks a lot (3 Replies)
Discussion started by: paulcarbajal
3 Replies
8. Shell Programming and Scripting
Hi All,
I have a requirement where I need to connect to Oracle database which is installed on WINDOWS machine.
I dont have Oracle client installed on my AIX so i can't use SQLPLUS command.
But ODBC to connect to Oracle is configured on my UNIX server. Can any one help me with the steps of... (1 Reply)
Discussion started by: Raamc
1 Replies
9. Solaris
Hi,
this is my first experience with Solaris.
For work, I must configured an applicacion (oracle EPM, this include Datadirect odbc drivers) in solaris.
Additionally, we must connect to Sybase IQ Database (I installed odbc drivers to do this).
The problem is, I can't get those two odbc... (1 Reply)
Discussion started by: dmedinacl
1 Replies
LEARN ABOUT DEBIAN
jifty::dbi::filter
Jifty::DBI::Filter(3pm) User Contributed Perl Documentation Jifty::DBI::Filter(3pm)
NAME
Jifty::DBI::Filter - base class for Jifty::DBI filters
SYNOPSIS
# To implement your own filter
package MyApp::Filter::Uppercase;
use base qw/ Jifty::DBI::Filter /;
# Setup for DB storage, store in lowercase
sub encode {
my $self = shift;
my $value_ref = $self->value_ref;
return unless defined $$value_ref; # don't blow up on undef
$$value_ref = lc $$value_ref;
}
# Setup for Perl code to use, always sees uppercase
sub decode {
my $self = shift;
my $value_ref = $self->value_ref;
return unless defined $$value_ref; # don't blow up on undef
$$value_ref = uc $$value_ref;
}
# To use a filter
use MyApp::Record schema {
column filtered =>
type is 'text',
filters are qw/ MyApp::Filter::Uppercase /;
};
DESCRIPTION
A filter allows Jifty::DBI models to tweak data prior to being stored and/or loaded. This is useful for marshalling and unmarshalling
complex objects.
METHODS
new
Takes three arguments in a parameter hash:
value_ref
A reference to the current value you're going to be massaging. "encode" works in place, massaging whatever value_ref refers to.
column
A Jifty::DBI::Column object, whatever sort of column we're working with here.
handle
A Jifty::DBI::Handle object, because some filters (i.e. Jifty::DBI::Filter::Boolean) depend on what database system is being used.
encode
"encode" takes data that users are handing to us and marshals it into a form suitable for sticking it in the database. This could be
anything from flattening a DateTime object into an ISO date to making sure that data is utf8 clean.
decode
"decode" takes data that the database is handing back to us and gets it into a form that's OK to hand back to the user. This could be
anything from inflating an ISO date to a DateTime object to making sure that the string properly has the utf8 flag.
SEE ALSO
Jifty::DBI::Filter::Date, Jifty::DBI::Filter::DateTime, Jifty::DBI::Filter:SaltHash, Jifty::DBI::Filter::Storable,
Jifty::DBI::Filter::Time, Jifty::DBI::Filter::Truncate, Jifty::DBI::Filter::YAML, Jifty::DBI::Filter::base64, Jifty::DBI::Filter::utf8
LICENSE
Jifty::DBI is Copyright 2005-2007 Best Practical Solutions, LLC. Jifty::DBI is distributed under the same terms as Perl itself.
perl v5.14.2 2010-12-09 Jifty::DBI::Filter(3pm)