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!


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="";
my $port=30305;
my $dsn ='jdbc:gfsql';
$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");
while ($row = $sth->fetch()) {
print $row;

I am getting the below error.

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


  • JonathanJonathan Posts: 2,914Member

    I think the connection string is wrong...looking at the docs:

    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.

    (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.