-----Original Message-----
From: shane [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 21, 2001 10:49 AM
To: [EMAIL PROTECTED]
Subject: RE: MySQL JDBC
yes. thks
actually all i did was to do a: GRANT ALL ON DB.* TO "user"@"localhost"
IDENTIFIED BY "pwd"
-----Original Message-----
From: Venu Anuganti [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 21, 2001 12:39 AM
To: shane
Subject: RE: MySQL JDBC
does this solved your problem ?
:-Venu
> -----Original Message-----
> From: shane [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 19, 2001 11:16 PM
> To: [EMAIL PROTECTED]
> Subject: RE: MySQL JDBC
>
>
> thks a million :)
> shane
>
> -----Original Message-----
> From: Venu Anuganti [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 20, 2001 2:07 PM
> To: shane; Ricardo Striquer Soares
> Cc: [EMAIL PROTECTED]
> Subject: RE: MySQL JDBC
>
>
> Here is the one...it looks lists.mysql.com is filtering the attachments.
> --
> import java.sql.*;
>
> public class TestMySQL
> {
> public static void main(String[] Args)
> {
> try {
> // The newInstance() call is a work around for some
> // broken Java implementations
> Class.forName("org.gjt.mm.mysql.Driver").newInstance();
> }
> catch (Exception E) {
> System.err.println("Unable to load driver.");
> E.printStackTrace();
> }
> try {
> /* Connection Management */
> //Here test is the database name
> //vanuganti--UID
> //venu--PWD
> Connection conn =
> DriverManager.getConnection("jdbc:mysql://localhost:3306/test","va
> nuganti","
> venu");
> conn.setAutoCommit(true);
>
> /* Create stmt and process some basic SQL statements */
> Statement stmt = conn.createStatement();
> stmt.execute("drop table test_mysql");
> stmt.execute("create table test_mysql(col1 int, col2 varchar(25))");
> stmt.execute("insert into test_mysql values(100,'mysql')");
> stmt.execute("insert into test_mysql values(200,'myjdbc')");
>
> /* Result set */
> ResultSet rs = stmt.executeQuery("SELECT * FROM test_mysql");
> while (rs.next())
> {
> System.out.println("COL1:"+rs.getInt(1));
> System.out.println("COL2:"+rs.getString(2));
> }
>
> // Clean up after ourselves
> rs.close();
> stmt.close();
> conn.close();
> }
> catch (SQLException E) {
> System.out.println("SQLException: " + E.getMessage());
> System.out.println("SQLState: " + E.getSQLState());
> System.out.println("VendorError: " + E.getErrorCode());
> }
> }
> }
> --
>
> > -----Original Message-----
> > From: shane [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, July 19, 2001 10:15 PM
> > To: Venu Anuganti; Ricardo Striquer Soares; shane
> > Cc: [EMAIL PROTECTED]
> > Subject: RE: MySQL JDBC
> >
> >
> > think the attachment is wrong. the only thing i get is a text file
> > containing
> >
> > 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
> >
> > could you pls send us the samples again, thks
> >
> > shane
> > -----Original Message-----
> > From: Venu Anuganti [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, July 20, 2001 11:45 AM
> > To: Ricardo Striquer Soares; shane
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: MySQL JDBC
> >
> >
> > Hi Ricardo / Shane
> >
> > If you are using mmmysql JDBC Driver, please find the attaches
> simple JDBC
> > sample that can be used with this driver to connect to MySQL
> server and do
> > some basic operations. Before compiling the sample, make sure
> you set the
> > CLASSPATH variable to mmmysql JDBC driver installed/achieved directory.
> >
> > Hope this helps you. If you have any questions or feedback let us know.
> >
> > Thank you
> > Venu Anuganti
>
---------------------------------------------------------------------
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
