File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Using SQLData to pass nested types from DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Using SQLData to pass nested types from DB" Watch "Using SQLData to pass nested types from DB" New topic
Author

Using SQLData to pass nested types from DB

Joe May
Greenhorn

Joined: Sep 28, 2009
Posts: 22
Hi,

I have the following structure..




I have a problem here.... I have to pass my FundVO object to the stored procedure and retrieve it as my DB object MCD.T_TEST_FUND... Now, i know that i have to use the array descriptor to declare the table types. But the table types are inside the object. How should I do this> When i see my readData method getting executed.. the lists are coming as null. Any pointers would be greatly appreciated. Thanks!


Joe May
Greenhorn

Joined: Sep 28, 2009
Posts: 22
sorry, I'm trying to retrieve the Db object into a Java class. I have said that i am doing the reverse in my previous post. Sorry
Joe May
Greenhorn

Joined: Sep 28, 2009
Posts: 22
Okay.. caught the issue.... the problem was.. i was trying to read the list as an object... instead it shud be array
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31057
    
232

Thanks for posting the solution.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using SQLData to pass nested types from DB