On 29/12/2011 05:45, Lau Eng Huat wrote: > Hi tomcat experts, > > I'm having this problem with the mysql connection in tomcat using netbeans. > I'm always having a exclamation mark on the Blue World Globe in netbeans > project tabs.
I don't know what that means. > Everytime I try to resolve the data source problem using "New > Connection Wizard" in netbeans, the database textfield is always mysql. No idea about this either. > I > change it to abc_admin and press test connection button , it managed to > connect. When I press the finished button I always get " Unable to add > connection. Connection already exist " Are you having an issue with Netbeans rather than with Tomcat? If so, you may find more help with that community. p > Web.xml : > ======== > <resource-ref> > <description>GRANT SELECT, INSERT, DELETE, UPDATE ON abc_admin.* > TO 'all_100'@'localhost' IDENTIFIED BY 'gpwd_admin'</description> > <res-ref-name>jdbc/my_admin</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> > > Context.xml > ========== > <Resource name="jdbc/my_admin" auth="Container" > type="javax.sql.DataSource" > maxActive="20" > maxIdle="30" > maxWait="10000" > username="all_100" > password="gpwd_abc_admin" > driverClassName="com.mysql.jdbc.Driver" > url="jdbc:mysql://localhost:3306/abc_admin?autoReconnect=true" > /> > > MYSQL Create Users > ================= > > "CREATE USER 'all_100'@'localhost' IDENTIFIED BY 'pwd_abc_admin'", > "FLUSH PRIVILEGES", > > "GRANT SELECT, INSERT, DELETE, UPDATE ON abc_admin.* TO > 'all_100'@'localhost' IDENTIFIED BY 'gpwd_abc_admin'", > "FLUSH PRIVILEGES", > > Java Code to get the connection > ======================= > protected Connection getCardDatabaseConnection(String ConnectionType) > throws NamingException, SQLException { > Connection connection = null; > DataSource dataSource; > InitialContext initialContext; > > initialContext = new InitialContext(); > dataSource = (DataSource) initialContext.lookup("java:comp/env/" + > "jdbc/my_admin"); > connection = dataSource.getConnection(); > > return connection; > } > -- [key:62590808]
signature.asc
Description: OpenPGP digital signature