Thanks. I did more reading on derby doc and find the encryption may serve the purpose since the derby db is used as embed db.
The 'derby.connection.requireAuthentication' need to set as system
property (using -D) while running your application
or as a database property (within the database).
More info at:
Also, there is some discussion on this in one of the JIRA issues at:
From you example you seem to pass the property as Connection properties
which has a limited scope.
Hope the above helps. Do post to the list should you have further questions.
Hong Ji wrote:
> The ij is still able to access the database without user name and
> I set properties and create new database in java as following:
> m_dbProperties = new Properties();
> m_dbProperties.put("user", "admin");
> m_dbProperties.put("password", "adminadmin");
> m_dbProperties.put(" derby.driver",
> m_dbProperties.put("derby.url", "jdbc:derby:");
> m_dbProperties.put("derby.connection.requireAuthentication ",
> m_dbProperties.put("create", "true");
> dbConnection = DriverManager.getConnection(dbUrl, m_dbProperties);
> Is something still not set up properly?
> On 8/29/06, *Francois Orsini* <firstname.lastname@example.org
> <mailto: email@example.com>> wrote:
> and make sure to re-boot the database or derby instance for the
> 'derby.connection.requireAuthentication' property to be taken into
> account...It is a static property.
> On 8/29/06, *Fernanda Pizzorno* <Fernanda.Pizzorno@sun.com
> <mailto:Fernanda.Pizzorno@sun.com >> wrote:
> To enable user authentication in Derby you must set the
> /derby.connection.requireAuthentication/ property to true.
> You can find more information about derby security on "Derby and
> Security" in "/Derby Developer's Guide"
> ( http://db.apache.org/derby/docs/dev/devguide/
> < http://db.apache.org/derby/docs/dev/devguide/>).
> Hong Ji wrote:
>> I created a derby database in Java with user name and password.
>> However, the
>> ij tool can open and view the database without input of the
> user name or
>> So how could a derby database be protected? Anyone can use ij
> to view the
>> Hong Ji