Re: Netbeans Glassfish Server Connection Pools to MySQL Schemas
Posted by: Peter Brawley
Date: May 20, 2014 09:12PM

> user setup in the connection pool dictates the default schema that can be accessed in the MySQL database

Cart, horse.

First set up the required user/host privs with Grant commands, preferably using the mysql client program, also doable with Workbench but in general the fewer intervening variables with this the better.

Test and debug the connection using the mysql client program and WorkBench.

Then write a java program that test the connection.

When that all works, plug the settings into the NetBeans API.

Options: ReplyQuote


Subject
Written By
Posted
Re: Netbeans Glassfish Server Connection Pools to MySQL Schemas
May 20, 2014 09:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.