java - Jackcess -- How to change Column Name? -
i have jackcess table , working fine. can't find on how change column name in jackcess table.
the reason want change column name have resultset converted microsoft access using jackcess. column named "relation" when jackcess converts it, name changed "xrelation". must kind of blacklisted word...
i want change column name "relation" , changing "relation" else not option.
how can ?
jackcess cannot alter structure of table after has been created. so, if want column named relation
instead of xrelation
need
- explicitly create table first (e.g., using
tablebuilder
)relation
column name, , - use
importutil.importresultset
import table created:
importutil.importresultset(rs, db, "existingtable", new simpleimportfilter(), true);
that form of importresultset import existing table instead of creating new one.
Comments
Post a Comment