Re: MySql - JSP - Please help - URGENT
Connection myConn = DriverManager.getConnection("jdbc:mysql:///test_db1?user=Usernamepassword=pas sword"); Try with: Connection myConn = DriverManager.getConnection("jdbc:mysql://localhost/test_db1,"user","passwor d"); === Saludos, Enric Badia SONRIE, LAS COSAS NO OCURREN POR CASUALIDAD. - S O N R I Eweb : http://www.sonrie.com Pompeyo, 4e-mail: [EMAIL PROTECTED] 25006 Lleida Tel : +34 973 725 093 Spain Fax : +34 973 725 281 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySql - JSP - Please help
I am running mySql 3.23.32 on Redhat 7, with Apaache and Tomcat Jakarta 3.2.1 and for database connection i use mm.mysql.jdbc-1.2c Here is my problem I have got MySql to run fine but when i try to interfaec it over the web i get te follwoing error error 500 javax.servlet.ServletException: Server configuration denies access to data source The jsp page it self has code that is as follows %@ page language="java" import="java.sql.*" % html code here % Class.forName("org.gjt.mm.mysql.Driver"); Connection myConn = DriverManager.getConnection("jdbc:mysql:///test_db1?user=Usernamepassword=password"); Statement stmt = myConn.createStatement(); ResultSet myResultSet = stmt.executeQuery("select * from test_tb1"); Is the a problem with mySql user permissions, or tomcat, or JDBC driver or what else. All help is greatelly appreciated! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySql - JSP - Please help - URGENT
I am running mySql 3.23.32 on Redhat 7, with Apaache and Tomcat Jakarta 3.2.1 and for database connection i use mm.mysql.jdbc-1.2c Here is my problem I have got MySql to run fine but when i try to interfaec it over the web i get te follwoing error error 500 javax.servlet.ServletException: Server configuration denies access to data source The jsp page it self has code that is as follows %@ page language="java" import="java.sql.*" % html code here % Class.forName("org.gjt.mm.mysql.Driver"); Connection myConn = DriverManager.getConnection("jdbc:mysql:///test_db1?user=Usernamepassword=password"); Statement stmt = myConn.createStatement(); ResultSet myResultSet = stmt.executeQuery("select * from test_tb1"); Is the a problem with mySql user permissions, or tomcat, or JDBC driver or what else. All help is greatelly appreciated! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php