Hi everybody, I am chaitanya, I am facing a problem and don't know what to do. Let me explain my requirement.
I am working on an application, where I have to create a user interface for MySQL database, it must function like Oracle 10g GUI.
But before starting itself I have struck with this problem. I am using connection pooling, where I have to enter user id and password. The id is 'root' and is fixed at installation, but the password is a variable thing.
How to solve this problem. Please can anybody help me solve this issue. Can I do this, or this is not possible.
As far as I know, you must provide a username and optionally a password to establish a connection to a MySQL database. I always create a specific user account and password for each database that I create in MySQL. That way I always have credentials available for use when defining the connection pool.
Exactly how are you using this connection pool of which you speak? Is your app a web app and the connection pool is defined in the app server? If so, which app server?
Hi Peter, I am doing a web application, I am using Apache Tomcat web server, not application server and my Connection pool is present at application level, not at server level, I mean it is in my project's META-INF folder.
Please help me, can I do this, is it possible? Thanks in advance.