aspose file tools
The moose likes JDBC and the fly likes experience with databases and jdbc-drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "experience with databases and jdbc-drivers" Watch "experience with databases and jdbc-drivers" New topic
Author

experience with databases and jdbc-drivers

Chantal Ackermann
Ranch Hand

Joined: Sep 28, 2000
Posts: 508
hi all,
I'd like to know if someone has experience with the postgresql, mysql, sybase, oracle managing _lots_ of data or with database access both using java and perl.
for the task (I am looking for a solution), most of the time the data will be selected one row at a time (certainly using an index). on the other hand, it will be necessary to regularly parse large textfiles and insert the new data.
i'd like to do all that using java, but i'm afraid, a parser written in java will be quite slow - i'd like to get an objection to this!
moreover, I've heard, that the jdbc-driver (from postgres) for PostgreSQL (that i'm using at the moment) is not reliable when inserting a lot of data. has someone experienced anything alike? what about the other drivers one gets listed at sun's, that seem to work for postgres as well: has someone used different jdbc-drivers with the postgresql?
thanx for your advice
chantal
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: experience with databases and jdbc-drivers
 
Similar Threads
Postgres on WSAD 5.1 - it works
Tutorial PostgreSQL 8.3 on Glassfish V2.1 for ConnectionPool in Netbeans 6.5.1, WindowsXP (Post 3)
Postgres using hypersonic mappings?
error when going to forum from forum list
Creating Temp table and querying it