Quote:
Originally Posted by lse123
may run same time DSN from all kind of databases eg MySQL or Access interchangeably without any setting to setup for the change?
|
You have only to select a MySQL driver in your Class.forName(""); instruction. You'll find the java library on Sun's site or MySQL site. However, SQL syntax may vary slightly from one database to another.
Quote:
Originally Posted by lse123
even appear
SQL statement:INSERT INTO WINES VALUES ('kChampagne2', 'Pink2', 25.22, 152)
Record Added.
and when privileges for insert no exist [no insert]
so no written data ?
|
Yes. Try to execute a commit(); on your Connection Object just in case it is not in autoCommit mode.
Laurent