in reply to Re: Error connecting to Derby DB
in thread Error connecting to Derby DB

Hi Corion,

Thanks for the help. I added (RaiseError => 1, AutoCommit => 0 ), and got the same error.

Also, one thing that I found while going through the docs is, RaiseError is ON by default. And so the above change made no difference.

Regards,

~Prithvi

Replies are listed 'Best First'.
Re^3: Error connecting to Derby DB
by Corion (Patriarch) on Apr 09, 2011 at 15:38 UTC

    Then why do you ignore the error you get? Resolve

    DBI connect('hostname=localhost;port=1527;url=jdbc:derby:mydb%3Bsecuri
+tyMechanism%3D8','myuser',...) failed: I/O Error  001bd00200010015124
+c0006114900080006000c00000005114a03 at tmp.pl line 9

    [download]

    This is an error raised by the Derby DB or the Derby database driver. We cannot help you there.

[reply]
[d/l]

      But I am able to connect to Derby DB out of my perl script.It is only through my script that I am seeing this error. And so I thought of requesting a help in Perlmonks.

[reply]

        I assume you mean to say:

        But I am able to connect to Derby DB outside of my perl script.

        Then you have to debug what goes wrong. Maybe your encoding of SecurityMechanism is wrong. Maybe the hostname is wrong. Maybe the port number is wrong. Maybe the database driver is buggy. What does the documentation for the Derby DB DBD say on how to connect? What does it say about the error number you get? Have you contacted their technical support?

[reply]

In Section Seekers of Perl Wisdom