Search...
FAQs Subscribe
Pie
FAQs
Recent topics Flagged topics Hot topics Best topics
Search...
Search within JDBC and Relational Databases Search Coderanch
Advance search Google search
Register / Login
thread boost book review grid granny polymorphism advertise on coderanch
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
meaningless drivel book review grid advertise on coderanch thread boost building better world book
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Liutauras Vilda
  • Jeanne Boyarsky
  • paul wheaton
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Henry Wong
Saloon Keepers:
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Tim Moores
  • Mikalai Zaikin
Bartenders:
  • Frits Walraven

XML, flat files to database

 
Dushy Inguva
Ranch Hand
Posts: 264
posted 20 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Hi all,
I am trying to insert from a CSV file, a tabbed file and if possible an xml file into the database.
The solution has to be java only and independent of the database (we are porting from sqlserver to db2). So, are there any free java based utilities which insert the given flat file's data into the database?
I searched and was surprised to find therez no obvious free ones. This is quite common requirement right?
Thanks
Dushy

SJCP, SCBCD, SJCD, SCDJWS, SCEA (Part I)

 
jimmy coyne
Greenhorn
Posts: 8
posted 20 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Could you insert it as a clob ?
 
Joe Ess
Bartender
Posts: 9626
16
I like...
Mac OS X Linux Windows
posted 20 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
If you happen to be using MS SQL Server, it has a utility called Data Transformation Services. Great tool for doing what you describe.

[How To Ask Questions On JavaRanch]

 
Joe Nguyen
Ranch Hand
Posts: 161
posted 20 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Convert the file to either blob or clob and store it to the table
 
What I don't understand is how they changed the earth's orbit to fit the metric calendar. Tiny ad:
Gift giving made easy with the permaculture playing cards
https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing
reply
reply
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!
Similar Threads
More...