File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

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: 11651

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
I agree. Here's the link:
subject: insert 650 fields into oracle table