[Carob] perl to carob

Sat, 19 Aug 2006 07:12:08 -0700

Hello.
 

I have same problem wiht Carob. Please help me!

 

I see two way used Carob from perl:

1. perl    ->    ODBSequoia    ->    myDB

2. perl    ->    libmysequoia    ->    myDB

 

if I use 1, I  usualy write code:

carob version 0.5.2

ODBSequoia version 0.5.2a

Sequoia version   2.8.2

Linux Debian 3.1

db is PostgreSQL

 

use DBI;
use DBD::ODBC;

my $dsn = "dbi:ODBC:seqsource;host=localhost";
my $dbh = DBI->connect($dsn, 'user','pass') or die print "Error".$DBI::errstr;

my $sth = $dbh->prepare('select * from table');
      $sth->execute;
  my $record;
            while($record=$sth->fetchrow_array){
            print "  $record\n";
     }

 

and I have this 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)

 

 

if I use 2, I  usualy write code:

carob version 0.5.3

libmysequoia version 0.9

Sequoia version   2.9

Linux Debian 3.1

 

test program:

#!/usr/local/bin/perl

use DBI;
use DBD::mysql;

my $dsn = 'dbi:mysql:sequoia_cmhostdb';

 

my $dbh = DBI->connect($dsn, 'user','pass') or die print "Error".$DBI::errstr;

 

my $sth = $dbh->prepare('select * from table');
     $sth->execute;
my $record;
            while($record=$sth->fetchrow_array){
            print "  $record\n";
     }

 

And compile LD_PRELOAD=/usr/lib/libmysequoia.so perl test02.pl

 

and I have this Error:

 

Sequoia controller give  only this error  

 

Exception in thread "VirtualDatabaseWorkerThread-sequoia_cmhostdb" java.lang.NullPointerException

        at org.continuent.sequoia.controller.requestmanager.RequestManager.openPersistentConnection(RequestManager.java:478)

        at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.openPersistentConnection(VirtualDatabase.java:1037)

        at org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:335)

---------------------------------------------------------------------------------------------------------------------

 

Sequoia controller is correct configurate is true.

Sequoia conttroler is running when I start my test program;

 

######################################################################

I need to use Carob  to connect to db, it is very important for me.

If possible please give me real work example (and same configuration for him), which work from perl to carob with use ODBSequoia or libmysequoia.

 

And possibly please write step by step, how to use this example.

 

 

Thank you very much for your help this is really very important for me.

 

With best wishes

_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob

Reply via email to