windows - import comma separated text data to java database table -
i have several large ms access databases (e.g. 1gb each file), want import javadb derby database whole application can switched java platform. i'm using windows 7 64 bit/ netbeans 8.0 (which no more supports jdbc-odbc). using "ucanaccess" connect such large ms access database, problem system either takes infinitely long or stops responding, while trying connet ms access database. there other faster , more efficient way import/ convert such large access databases (almost 200 databases, 1gb each).
considering db size (e.g. 1gb each file) , number of db, out of scope of ucanaccess. performance may dramatically improved (using specific connection parameters), in specific case, doesn't make sense. should use jackcess directly metadata , data.
Comments
Post a Comment