I used following settings:
- Name: mysqlpool
- Resource Type: javax.sql.DataSource
- Database Vendor: mysql
then i used:
- serverName: 127.0.0.1
- port: 3306
- user: (the username that i use to connect to db)
- password: (the users password)
- databaseName: authTest
when i try and use "Connection Validation" via table using a table containing records, i get a "No database selected" error...
and when i try and use jdbc realm auth i get the following error:
MySQLPool;java.sql.SQLException: No database selected;_RequestID=35bc9017-6dcb-42cb-84f0-1cd771858642;|RAR5117 : Failed to obtain/create connection from connection pool [ MySQLPool ]. Reason : java.sql.SQLException: No database selected|#]
what am i doing wrong?
[Message sent by forum member 'huggy77' (huggy77)]
http://forums.java.net/jive/thread.jspa?messageID=291425