RE: *** HELP *** mySQL connectivity problems
I would recommend a book on Java Servlets (www.servlets.com) as long as
they have JDBC examples.
JDBC is the way to go with mysql their are mysql JDBC Drivers available at
http://mmmysql.sourceforge.net/
There are many examples/tutorials on sun's site (java.sun.com)
As for the mysql part as long as you setup your users correctly and
remember to do a reload after you add them. it should just work :)
Good Luck!
Scott Archer
[EMAIL PROTECTED]
"Swart, James
(Jim) ** CTR To: "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>
**" cc:
10/31/2001
12:19 PM
Please respond
to "Tomcat
Users List"
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 same>.newInstance() does the same
> System.out
RE: *** HELP *** mySQL connectivity problems
You might consider the book titled:
"JSP, Servlets, and MySQL" by David Harms.
It seems like a pretty descent book.
Tim
--- "Swart, James (Jim) ** CTR **" <[EMAIL PROTECTED]>
wrote:
> 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 > 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]>
>
__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
RE: *** HELP *** mySQL connectivity problems
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 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]>
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 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());
> }
>
>
>
*** HELP *** mySQL connectivity problems
Hi,
I'm running mySQL 2.0.4 and Tomcat 4.0 on Cobalt/Linux.
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 .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());
}
