Re: MySql - JSP - Please help - URGENT

2001-02-01 Thread Enric Badia 

 
 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 - URGENT

2001-01-31 Thread Marko Sarunac 



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