How to connect to database without password using connection pooling

[chaitanya karthikk]

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.

Thank you in advance, have a nice day.

[chaitanya karthikk]

There was a problem with my net connection, I thought the question was not posted and posted the same topic second time.

Sorry, forgive me, I sincerely apologize for this mistake.

[Campbell Ritchie]

Apologies accepted

I have taken the liberty (Scott, Jan, Jeanne, I hope you don't mind) of moving your other thread to our "deleted" forum.

[chaitanya karthikk]

Thanks a lot Ritchie. I was worried a lot.

[chaitanya karthikk]

Hi moderators, my problem has not been resolved yet, this thread is marked as 'moderator says its resolved'. Please help me.

[Jan Cumps]

anusha chaitanya wrote:Hi moderators, my problem has not been resolved yet, this thread is marked as 'moderator says its resolved'. Please help me.

I have removed the resolved marker.
Regards, Jan

[chaitanya karthikk]

Thanks a lot Jan, and can you please help me with my problem?

[Jan Cumps]

anusha chaitanya wrote:Thanks a lot Jan, and can you please help me with my problem?

I don't know how to solve this. Let's hope that another rancher can help you.
Regards, Jan

[chaitanya karthikk]

Its ok Jan, thanks again, have a nice day

[Peter Johnson]

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?

[chaitanya karthikk]

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.

[Peter Johnson]

OK, this has now become a Tomcat configuration question. I am moving this thread to a more appropriate forum.

[chaitanya karthikk]

Peter Johnson wrote:OK, this has now become a Tomcat configuration question. I am moving this thread to a more appropriate forum.

Hi Peter, I think this is not related to Tomcat, it is related to database connectivity through pooling. Please once check the question.

Thanks in advance.