Hi

I have set up a test database for working with hibernate, the only difference between my main and test databases is the word test appended to the end of the db name username and pwd, i.e. main db ABC, test db ABCtest, main pwd abc, test pwd abctest, main username abc, test username abctest, however when I change the parameters in the hibernate.cfg.xml file to the test details hibernate seems to try to connect to the main db but uses the test username and pwd with the following errors when trying to fetch records from the db....

Preparing the statement failed: Server user 'abctest' is not a valid user in database 'ABC'.

Server user 'abctest' is not a valid user in database 'ABC'.

Any ideas?

Thanks,

Mike.