Fwd: DBD::JDBC

Hu guys,

maybe someone of you can help Michael with that.

Anfang der weitergeleiteten Nachricht:

> Von: [email protected]
> Betreff: DBD::JDBC
> Datum: 16. Oktober 2013 03:05:41 MESZ
> An: [email protected]
> Antwort an: [email protected]
> 
> Hi Jens,
> 
> [...]
> 
> The reason for my note is that while searching for a solution to a 
> DBD::JDBC problem I noticed that you worked on this some. Perhaps you 
> can give me some pointers.
> 
> I've set the thing up and have the server running. tcpdump indicates 
> that the jdbc_server is passing the data to/from both the DBI 
> interface as well as the target driver and its server. However I 
> always get "failed: This method is not yet implemented".
> 
> The tcpdump looks the same up to the connect and exchange of the 
> first data clump asking the db host to connect.
> 
> My java code can connect just fine using the same drivers and using 
> DBD::Pg works just fine as well.
> 
> setup:
> my $cset = $ARGV[0] || 'ISO8859_1';
> my $user = 'waco';
> my $password = 'waco';
> my $host = 'eagle';
> my $port = 5432;
> 
> # pardon the wrap, its really not there
> my $dsn =
> "dbi:JDBX:hostname=localhost;port=9001;url=jdbc:postgresql://$host:543
> 2/waco;jdbc_character_set=$cset";
> 
> my $props = {
>        user            => $user,
>        password        => $password,
>        'hostname'      => $host,
>        'hostport'      => $port,
> 
> };
> 
> my $dbh = DBI->connect($dsn,undef,undef,
>        {
>                PrintError => 0,
>                RaiseError => 1,
>                jdbc_properties => $props
>        }
> );
> 
> DBI_TRACE=15 perl test.pl ASCII>tmp.tmp 2>&1
> 
> See attached 'eagle.tcpdump' and 'eagle.trace'. These are the tcp 
> transactions and trace from DBI respectively for our postgres server. 
> The trace has a Data::Dumper output of the content sent using 
> IO::xxxx to the jdbc_server interposed right before the actual send.
> 
> Also attached are similar 'delphi.tcpdump' and 'delphi.trace' files 
> from the oracle test server. 
> 
> The jdbc_driver is a different host from 'eagle' and 'delphi'
> 
> Can you give me a clue as to why both remote host servers respond 
> with basically the same error. ... or point me at someone that might 
> be able to help. I've been working on this for a couple of days with 
> no light at the end of the tunnel.
> 
> Best regards,
> Michael


Jens Rehsack
pkgsrc, Perl5
[email protected]