phpbar.de logo

Mailinglisten-Archive

unsupported operation using mm.mysql-MysqlDataSource?

unsupported operation using mm.mysql-MysqlDataSource?

Fabian Sommer mysql-de_(at)_lists.bttr.org
Thu, 15 Aug 2002 17:11:42 +0200


Hello!

I got a problem using the mm.mysql-2.0.14-driver resp. the 
mysql-connector-3.0: 
I try to access a mysql-database (4.0 but I think this is not important)
using jsp with struts-extension, running on a Tomcat4.1
servlet-container.

I use standard-database-description in an xml-file, providing the url
for the driver and username and password.

I get a DataSource-object (javax.sql.DataSource) and I can use the
DataSource.getConnection() method. But all I get when I use this method
is a SQLException telling me that user "nobody_(at)_127.0.0.1 (using
Password:YES)" is not allowed to access the database. That's alright, I
expected this as this is what I entered in the Grant-tables. 

But when I try to use DataSource.getConnection(String user, String
passwd) method, using correct (or incorrect, doesn't matter) user entrys
all I get is an Exception "Unsupported Operation" which seems to got
thrown by the database driver. But how shall I connect using the
DataSource object if I can't use a username and password?

Please tell me if I made something wrong or there is a solution beside
my knowledge (I hope for this...).
Thanks for any help!

Fabian Sommer

---
Infos zur Mailingliste, zur Teilnahme und zum An- und Abmelden unter
-->>  http://www.4t2.com/mysql 



php::bar PHP Wiki   -   Listenarchive