Dbd::jdbc

I am 6.7.1 on Win. I am trying ti install the JDBC.pm on to the system and test a simple connection. I didn't fully comprehend as where i was going wrong. I was following the README file did this.

[html]
C:\Interwoven\TeamSite\iw-perl\bin>iwperl C:/DBD-JDBC-0.70/Makefile.PL
Warning: prerequisite DBI 1.48 not found. We have 1.38.
Could not open 'JDBC.pm': No such file or directory at C:/Interwoven/TeamSite/iw
-perl/lib/ExtUtils/MM_Unix.pm line 3079.
[/html]

Can i just utilize the simple JDBC.pm insted of going through these steps?

But there are many Parameters which are undefined? can anyone fully define these for me?

[html]
#!C:/Interwoven/TeamSite/iw-perl/bin/perl -w

# call the required modules
use DBI;
use DBD::JDBC;
# The actual DSN (one line, separated here for readability)
my $dbh =
DBI->connect( "dbi:JDBC:hostname=$host;port=$port;
url=jdbc:sequoia://$CONTROLLERNAME1,$CONTROLLERNAME2/$DBNAME",
"$USERNAME","$PASSWORD" )
or die print $DBI::errstr;

[/html]

hostname - dbserver
port - 43321
$CONTROLLERNAME1 - no Idea
$CONTROLLERNAME2 - no Idea
$DBNAME - db name
$USERNAME - username
$PASSWORD - password

jdbc:sequoia is an example, if i define some DNS will that be replaced by sequoia? if i am using this on solaris, i cannot set up a DNS there how would i go about in implementing the same.

Can some one ppoint me a right direction

Thank You

Find more posts tagged with

Comments

Adam Stoller

A number of the DBI / DBD modules are a combination of Perl and compiled code (usually C, I believe) and thus for those you would need to go through the compilations steps.

Beyond that - the Makefile is a means of making sure that all pre-requisites are in place and tests validated before putting the module and any of its supporting files into place.

This is a good thing - as you can see from your attempt - the specific version of the JDBC module you downloaded is intended for a newer version of DBI than what came with iwperl.

You could try updating the DBI as well, but you might be better off seeing if you can find an older version of the JDBC to download.