Java database connection with protected table

Question

I'am connecting my application to a Microsoft Access DB. The problem is that every table of this database is protected by a password(because the data in the table are imported from MS share point). Every time I try to execute a query by using a Statement object it ask me user and password. Is there a way to pass automatically user and pwd and avoid to insert them every time?

Vijay · Accepted Answer · 2013-07-02 09:24:57Z

2

try out this

final String fileName = "c:/myDataBase.mdb";
Connection con = null;
try {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+fileName;
    con = DriverManager.getConnection(url,"username","password");
} catch (Exception e) {

    // Handle exceptions
    ...
} finally {
    try { if(con!=null) {con.close();} } catch (Exception e) {}
}

answered Jul 2, 2013 at 9:24

Vijay

8,47111 gold badges47 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2541888 Over a year ago

In this way you pass user and pwd for connecting to database: my db is not protected, the tables are

epoch · Accepted Answer · 2013-07-02 09:05:02Z

1

You can supply the username and password in the JDBC connection string.

answered Jul 2, 2013 at 9:05

epoch

16.7k5 gold badges50 silver badges72 bronze badges

1 Comment

user2541888 Over a year ago

Do you mean the string like "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=myDB.accdb" ?

Collectives™ on Stack Overflow

Java database connection with protected table

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related