|
hello.
Do I want to use Carob without JDBC, this
possibly?
What configuration must be in JDBC driver? send them please. I write code:
----------------------------------------------------------------------------------------------------------------------------
#!/usr/local/bin/perl -w
use DBI; use DBD::JDBC; my $dsn; my $usr; my $pas; my $host; my $port; my $url; $host = "localhost"; $port = 9001; $url =
"";
$dsn = "dbi:JDBC:hostname=$host;port=$port;url=""> $usr = 'my_user'; $pas = 'my_password'; my $dbh=DBI->connect($dsn,$usr,$pas) or die print "\nmy Error:
".$DBI::errstr."\n";
my $sth = $dbh->prepare("select id,name from
my_table");
$sth->execute; my ($id,$name); while(($id,$name)=$sth->fetchrow_array){ print " $id | $name\n"; } ---------------------------------------------------------------------------------------------------------------------------- this code is work I write code:
----------------------------------------------------------------------------------------------------------------------------
$host = "localhost";
$port = 9001; $url =
"";
$dsn = "dbi:JDBC:hostname=$host;port=$port;url=""> $usr = 'my_user'; $pas = 'my_password'; my $dbh=DBI->connect($dsn,$usr,$pas) or die print "\nmy Error:
".$DBI::errstr."\n";
my $sth = $dbh->prepare("select id,name from
my_table"); $sth->execute; my ($id,$name); while(($id,$name)=$sth->fetchrow_array){ print " $id | $name\n"; } ---------------------------------------------------------------------------------------------------------------------------- !Error!
DBD::JDBC::dr connect warning: No suitable driver at
/usr/local/lib/perl/5.8.8/DBI.pm line 617.
DBI connect('hostname=localhost;port=9001;url="" failed: No suitable driver I write code whithout:
----------------------------------------------------------------------------------------------------------------------------
$dsn = "dbi:ODBC:seqsource",
$usr='user'; $pas='';
my $dbh=DBI->connect($dsn,$usr,$pas) or die print "\nmy Error:
".$DBI::errstr."\n";
my $sth = $dbh->prepare("select id,name from
my_table"); $sth->execute; my ($id,$name); while(($id,$name)=$sth->fetchrow_array){ print " $id | $name\n"; } ---------------------------------------------------------------------------------------------------------------------------- !Error!
DEBUG: (RoundRobinConnectPolicy::getController) Selected
controller[0]:localhost:25322
INFO: (Connection::initConnection) Authenticating with controller localhost:25322 DEBUG: (JavaSocket::Create) Creating socket... DEBUG: (JavaSocket::Create) Socket created. DEBUG: (JavaSocket::connectTo) Connecting... INFO: (JavaSocket::connectTo) Connection to localhost:25322 succeeded DBI connect('seqsource','user',...) failed: [unixODBC][Driver Manager]Driver does not support this function (SQL-IM001)(DBD: dbd_db_login/SQLSetConnectOption err=-1) [unixODBC][Driver Manager]Driver does not support this function
(SQL-IM001)(DBD: dbd_db_login/SQLSetConnectOption err=-1) Please help me. Thank you |
_______________________________________________ Carob mailing list [email protected] https://forge.continuent.org/mailman/listinfo/carob
