Hi !!! )-----Original Message----- )From: aDragon [mailto:[EMAIL PROTECTED]] )Sent: Thursday, August 23, 2001 10:22 PM )To: [EMAIL PROTECTED] )Subject: question about use JDBC to connect with MySQL in JSP,please help ) ) )hello,everyone, ) I am using JDBC in JSP to connect with MySQL under BEA )WEBLOgic Server 6.0, )I have copied the following codes from a book, but the server )always says that )It was wrong, expecial the variable "con", I don't know why even )thinking hard! ) please help,thanks. ) )the code following: )================== )<HTML> ) <BODY> )<% Properties P = System.getProperties(); ) P.put("jdbc.drivers", "org.gjt.mm.mysql.Driver"); ) System.setProperties(P); ) ) Java.sql.connection con=DriverManager.getConnection("JDBC:MySQL://localhost:3306","root","root") ; I too don't know much about JSP. But as a first glance, the problem looks to be with the Coonection object declaration. It should be Connection not connection. Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA <___/ www.mysql.com --------------------------------------------------------------------- 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
