Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Help in connecting to JDBC using perl

alluri1123alluri1123 Posts: 1Member
I am using the following code and i get the below error

use DBI;
use DBD::JDBC;

my $url="JDBC:gfsql://cqserver=fiappl03itf:30305";
my $hostname="fiappl03itf.fmrco.com";
my $port=30305;
my $dsn ='jdbc:gfsql';
my
$dbh= DBI->connect("DBI::$dsn;hostname=$hostname;port=$port;url=$url;jdbc_character_set=ASCII") or

die "Couldn't connect to database: " . DBI->errstr;

$sth = $dbh->prepare("select cusip,source from TT_VIEW");
$sth->execute();
while ($row = $sth->fetch()) {
print $row;
}

I am getting the below error.

Can't connect to data source jdbc:gfsql;hostname=fiappl03itf.fmrco.com;port=30305;url=JDBC:gfsql://cqserver=fiappl03itf:30305;jdbc_character_set=ASCII, no database driver specified and DBI_DSN env var not set at jdbc_conn.pl line 16

Comments

  • JonathanJonathan Posts: 2,914Member
    Hi,

    I think the connection string is wrong...looking at the docs:
    http://search.cpan.org/~vizdom/DBD-JDBC-0.70/JDBC.pod

    It should be more like "dbi:JDBC:hostname...". See that documentation for full details of the module - I'm not in any way familiar with it so I can't tell you any more than it can.

    Jonathan
    ###
    for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
    (tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
    /(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");
Sign In or Register to comment.