Help in connecting to JDBC using perl - Programmers Heaven

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.