wood burning stoves 2.0*
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 Spring in Action this week in the Spring 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: 30762
    
156

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
 
Don't get me started about those stupid light bulbs.
 
subject: Using SQLData to pass nested types from DB