Re: OUT Parameter of type used defined object array obtained as null

Hi Dave,
You are right.I am using Enterprise DB version
of PostgreSQL .But As far as I know both have same features. It would be fine If you could suggest me some work outs in postgre sql.

From: dmp-2 [via PostgreSQL] [mailto:ml-node+s1045698n5713201h10(at)n5(dot)nabble(dot)com]
Sent: Tuesday, June 19, 2012 7:15 AM
To: Neethu Johny (WI01 - Solutions)
Subject: Re: OUT Parameter of type used defined object array obtained as null

Dave Cramer wrote:

> Dave Cramer
>
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca
>
>
> On Mon, Jun 18, 2012 at 2:55 PM, dmp<[hidden email]</user/SendEmail.jtp?type=node&node=5713201&i=0>> wrote:
>>> It would be of great
>>> help if somebody could just let me know whether or not fetch is possible
>>> with the custom object Array types.
>>> We have a sample code which yields no error but the OUT object array is
>>> obtained as null. Any hint on what we are missing out or any other
>>> guidance
>>> from your team will be highly appreciated.
>>>
>>> Please find the code snippets below.
>>
>>
>> import java.sql.Array;
>> import java.sql.CallableStatement;
>> import java.sql.Connection;
>> import java.sql.DriverManager;
>> import java.sql.ResultSet;
>> import java.sql.SQLException;
>> import java.sql.Statement;
>> import java.sql.Types;
>> --> import com.edb.util.PGobject;
>>
>> What is com.edb.util.PGobject? This does not appear to be the the PGobject
>> class provided from the PostgreSQL JDBC driver, org.posgresql.util.PGobject.
>> It does not appear you are using the Class.forName("org.postgresql.Driver");
>>
>> danap.
>>
>>
>
>
> This is the EDB jdbc driver.
>
>
>> --
>> Sent via pgsql-jdbc mailing list ([hidden email]</user/SendEmail.jtp?type=node&node=5713201&i=1>)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc
>

After I sent this I pretty much guessed this was the Enterprise DB version
of PostgreSQL. I guess the point was that don't they have there own compiled
version of PostgreSQL and maybe the JDBC? If so then this forum might not be
the appropriate place to pose the question, since EDB, features might be different.

danap.

--
Sent via pgsql-jdbc mailing list ([hidden email]</user/SendEmail.jtp?type=node&node=5713201&i=2>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

________________________________
If you reply to this email, your message will be added to the discussion below:
http://postgresql.1045698.n5.nabble.com/OUT-Parameter-of-type-USER-DEFINED-OBJECT-ARRAY-obtained-as-null-tp5713033p5713201.html
To unsubscribe from OUT Parameter of type-(USER DEFINED OBJECT ARRAY) obtained as null, click here<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5713033&code=bmVldGh1LmpvaG55QHdpcHJvLmNvbXw1NzEzMDMzfDc5Mzg5Mzg1MQ==>.
NAML<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

Please do not print this email unless it is absolutely necessary.

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com

--
View this message in context: http://postgresql.1045698.n5.nabble.com/OUT-Parameter-of-type-USER-DEFINED-OBJECT-ARRAY-obtained-as-null-tp5713033p5713209.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.