This week's giveaway is in the Spring forum.
We're giving away four copies of Learn Spring Security (video course) and have Eugen Paraschiv on-line!
See this thread for details.
Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Accessing SQL Object type

 
Srikanth Basa
Ranch Hand
Posts: 241
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have to access SQL object types. One approach I know is to implement the SQLData interface and create classes for the type objects.

Is there any other mechanism to access ?

One simple way I see is using STRUCT. But I have nested Structures. Whether it is possible to retrieve all the attributes in nested structures without using the SQLData ?
[ March 01, 2007: Message edited by: Srikanth Basavaraju ]
 
Srikanth Basa
Ranch Hand
Posts: 241
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just thought of sharing that the following approach served my purpose.

I had a structure and within the structure they were simple attributes and some were Table types.



If you are looking for similar solution, hope you can do some research on above snippet to understand it

Cheers
Srikanth
[ March 01, 2007: Message edited by: Srikanth Basavaraju ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic