aspose file tools*
The moose likes JDBC and the fly likes Accessing SQL Object type Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Accessing SQL Object type" Watch "Accessing SQL Object type" New topic
Author

Accessing SQL Object type

Srikanth Basa
Ranch Hand

Joined: Jun 06, 2005
Posts: 241
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

Joined: Jun 06, 2005
Posts: 241
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Accessing SQL Object type