Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and Relational Databases and the fly likes insert 650 fields into oracle table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Reply locked New topic
Author

insert 650 fields into oracle table

Tom Griffith
Ranch Hand

Joined: Aug 06, 2004
Posts: 275
Hello. If anybody has a minute, is inserting that many data fields into an oracle row (it's a single table as far as i know) kind of crazy? I can't even imagine the single prepared statement to handle all that. Are there alternatives via jdbc? Thank you very much for reading this. Any input is greatly appreciated.
Amit M Tank
Ranch Hand

Joined: Mar 28, 2004
Posts: 257
Did you try it out with JDBC Prepared statement?


Amit Tank
Linked In
Chad Clites
Ranch Hand

Joined: Aug 16, 2005
Posts: 134
On the face of it, it seems unusual. I have never run across tables with that many columns, and I can't think of anything that would require that many fields in a single row. If all of the values are unique to that single entity, then I don't suppose it is out of the question to have a table that big. May I ask what sort of entities are being recorded?
Andrew Monkhouse
author and jackaroo
Marshal Commander

Joined: Mar 28, 2003
Posts: 11730
    
116

This topic is now closed, as it is a duplicate of this post, which has a bit more information from the original poster in it.

Regards, Andrew


The Sun Certified Java Developer Exam with J2SE 5: paper version from Amazon, PDF from Apress, Online reference: Books 24x7 Personal blog
 
Have you checked out Aspose?
 
subject: insert 650 fields into oracle table
 
It's not a secret anymore!