jetty jdbc

2 replies [Last post]

Thu, 2010-02-11 18:07

apnels

Offline

Joined: 2010-02-04

Hi everybody!

Does someone know to to setup a specific password for 'sa' user in jdbc???

I'va found jdbcRealm.properties in witch a login is define but no way to find 'sa' user!
In AS2_DB.log file we can see that 'sa' is use for establishing connection to the database:

/*C11*/DISCONNECT
/*C13*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C14*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C15*/SET SCHEMA PUBLIC
CONNECT USER SA

Thanks.

Thu, 2010-02-11 22:17

heller

Offline

Joined: 2006-05-15

apnels,

Its a hsqldb issue. The user management is DB vendor specific. Please refer to http://hsqldb.org/web/hsqlDocsFrame.html for the documentation of the underlaying hsqldb database.

*Create a user on the DB
e.g. CREATE USER newuser PASSWORD 123test
*Assign some rights to the user
e.g. GRANT SELECT, UPDATE ON aTABLE TO newuser
*Change the DB access class
A change in the de.mendelson.comm.as.database package

Regards
Heller

Fri, 2010-02-12 11:18

apnels

Offline

Joined: 2010-02-04

Ok,

Thanks a lot