Does any one know of a good book, tutorial or URL for Java and mySQL connectivity? I run Tomcat & mySQL on a RedHat 7.1 server and have used mySQL to setup a database with a table and a few values so I can have a real sample to toy with. I put the servlet names in the web.xml file in my webapp, but I don't know HOW to code the JAVA to talk to it.
I know this is not 100% tomcat and I apologize for that, is there another group I can ask if this one is inappropriate? -----Original Message----- From: Craig R. McClanahan [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 11:39 AM To: '[EMAIL PROTECTED]' Subject: Re: *** HELP *** mySQL connectivity problems On Mon, 30 Jul 2001, SIMONIN Alexandre wrote: > Hi, > > I'm running mySQL 2.0.4 and Tomcat 4.0 on Cobalt/Linux. > Are you running Tomcat 4 with a security manager (i.e. "$CATALINA_HOME/bin/catalina.sh start -security")? That seems likely, given the fact that you're gatting a security manager exception. If so, you need to grant your JDBC driver permission to create a network connection to port 3306 on your database host. This is done in the "conf/catalina.policy" file. There are some notes near the bottom of that file documenting the way that you add this permission. Craig McClanahan > When trying to get a connection to the database, I got the following error > (the code is provided below - exact id and password replaced for > confidentiality). > > Step 1 : Class.forName("org.gjt.mm.mysql.Driver"); OK > Step 2 : > getConnection("jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myID&p > assword=myPwd"); *** FAILURE *** > SQLException: Cannot connect to MySQL server on > sherweb7.sherweb.com:3306. Is there a MySQL server running on the > machine/port you are > trying to connect to? (java.security.AccessControlException) > SQLState: 08S01 > VendorError: 0 > > Few comments: > 1/ the mySQL server's site address is OK (not the localhost) > 2/ the mySQL server's port is OK > 3/ the table name is OK > 4/ the userID is OK > 5/ the password is OK > 6/ the connection looks fine through phpMyAdmin > 7/ I get the same java.security.AccessControlException when doing the same > request without the userID and password > 6/ I got a java.net.ConnectException (which seems normal to me) when trying > to call the server as if it was local to my machine, i.e.: > jdbc:mysql:///myDatabase?user=myID&password=myPwd > > Any suggestion? > > The code: > > try { > Class.forName("org.gjt.mm.mysql.Driver"); // this or <the > same>.newInstance() does the same > System.out.println("Step1: Class.forName(\"org.gjt.mm.mysql.Driver\"): > OK"); > } > catch (Exception e) { > System.out.println("Class.forName(\"org.gjt.mm.mysql.Driver\"): *** > FAILURE ***"); > } > > Connection myConn = null; > > try { > myConn = > DriverManager.getConnection("jdbc:mysql://sherweb7.sherweb.com:3306/myDataba > se?user=myID&password=myPwd"); > System.out.println("Step 2: > getConnection(\"jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myID& > password=myPwd\"): OK"); > } > catch (SQLException e) { > System.out.println("Step 2: > getConnection(\"jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myID& > password=myPwd\"): *** FAILURE ***"); > System.out.println(" SQLException: "+e.getMessage()); > System.out.println(" SQLState: "+e.getSQLState()); > System.out.println(" VendorError: "+e.getErrorCode()); > } > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
