The following doesn;t make sense... I need the resultset comprising the list
of all the tables in the db...and i wat that as a java.sql resultset...can
somebody help me here!???....urgent!!
java code :
String sqlQuery = "show tables";
try {
con = ConnectionPoolManager.getConnection();
stmt = con.createStatement();
rs = stmt.executeQuery(sqlQuery);
}
----- Original Message -----
From: Venu Anuganti <[EMAIL PROTECTED]>
To: Asha Ramaiah <[EMAIL PROTECTED]>
Sent: Thursday, July 19, 2001 11:55 AM
Subject: Re: Info needed!
> If Connection.isClosed() returns false means, the connection is open.
>
> :-Venu Anuganti
>
> ----- Original Message -----
> From: "Asha Ramaiah" <[EMAIL PROTECTED]>
> To: "Venu Anuganti" <[EMAIL PROTECTED]>
> Sent: Wednesday, July 18, 2001 11:28 PM
> Subject: Re: Info needed!
>
>
> > how do i check whether the db Connection is open??
> >
> > - Ash
> > ----- Original Message -----
> > From: Venu Anuganti <[EMAIL PROTECTED]>
> > To: Asha Ramaiah <[EMAIL PROTECTED]>
> > Sent: Thursday, July 19, 2001 11:48 AM
> > Subject: Re: Info needed!
> >
> >
> > > Hi Asha
> > >
> > > In JDBC itself, you can test it using the following options from -:
> > >
> > > 1. Connection.isClosed() to check, whether given connection is closed
or
> > > not.
> > >
> > > I am not sure whether this answers your questions. Let me know your
> > further
> > > feedback on this. If you want to USE C APIs, I can provide the links
to
> > > start the things. Because am not related to JDBC side, but am a
> developer
> > of
> > > MyODBC from MySQL AB. So, towards JDBC, not familiar.
> > >
> > > Thank you
> > > Venu Anuganti
> > > --
> > > For technical support contracts, go to https://order.mysql.com/
> > > __ ___ ___ ____ __
> > > / |/ /_ __/ __/ __ \/ / Mr. Venu Anuganti <[EMAIL PROTECTED]>
> > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
> > > /_/ /_/\_, /___/\___\_\___/ Redwood city, California USA
> > > <___/ www.mysql.com
> > > ----- Original Message -----
> > > From: "Asha Ramaiah" <[EMAIL PROTECTED]>
> > > To: "Venu Anuganti" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, July 18, 2001 10:57 PM
> > > Subject: Re: Info needed!
> > >
> > >
> > > > The reason for trying to use these methods is basically to do the
> > > following
> > > > :
> > > >
> > > > Check whether a connection is open (db) in mysql , which is use in a
> > > > Connection Pooling java obj .
> > > >
> > > > I want to basically know the mechanism to check at any time whether
a
> > > > connection is open to a db in mysql..
> > > >
> > > > Thanks & Regds
> > > > Ash
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: Venu Anuganti <[EMAIL PROTECTED]>
> > > > To: Asha Ramaiah <[EMAIL PROTECTED]>
> > > > Sent: Thursday, July 19, 2001 11:15 AM
> > > > Subject: Re: Info needed!
> > > >
> > > >
> > > > > Hi Asha
> > > > >
> > > > > No. You can't call these APIs through JAVA. They can be called
only
> > > > through
> > > > > C applications. If you can provoide me, why you want to use them
in
> > > JAVA,
> > > > > then I can help you if possible.
> > > > >
> > > > > Thanks in advance
> > > > > Venu Anuganti
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Asha Ramaiah" <[EMAIL PROTECTED]>
> > > > > To: "Venu Anuganti" <[EMAIL PROTECTED]>
> > > > > Sent: Wednesday, July 18, 2001 10:46 PM
> > > > > Subject: Re: Info needed!
> > > > >
> > > > >
> > > > > > thanks...Venu,
> > > > > > Another thing : there are some C API functions such as :
> > > > > > mysql_real_connect() and mysql_ping()
> > > > > >
> > > > > > How can I call these frm a java program?..is it possible at
all??
> > > > > >
> > > > > > Thanks and Regds
> > > > > > Ash
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > ----- Original Message -----
> > > > > > From: Venu Anuganti <[EMAIL PROTECTED]>
> > > > > > To: Asha Ramaiah <[EMAIL PROTECTED]>
> > > > > > Cc: <[EMAIL PROTECTED]>
> > > > > > Sent: Thursday, July 19, 2001 11:05 AM
> > > > > > Subject: Re: Info needed!
> > > > > >
> > > > > >
> > > > > > > Hi Asha
> > > > > > >
> > > > > > > Yes, you are correct. Please refer to the following link for
> more
> > > > > details:
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO
> > > > > > > W
> > > > > > >
> > > > > > > Thank you
> > > > > > > Venu Anuganti
> > > > > > > --
> > > > > > > For technical support contracts, go to
https://order.mysql.com/
> > > > > > > __ ___ ___ ____ __
> > > > > > > / |/ /_ __/ __/ __ \/ / Mr. Venu Anuganti
> <[EMAIL PROTECTED]>
> > > > > > > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
> > > > > > > /_/ /_/\_, /___/\___\_\___/ Redwood city, California USA
> > > > > > > <___/ www.mysql.com
> > > > > > > ----- Original Message -----
> > > > > > > From: "Asha Ramaiah" <[EMAIL PROTECTED]>
> > > > > > > To: <[EMAIL PROTECTED]>
> > > > > > > Sent: Wednesday, July 18, 2001 10:32 PM
> > > > > > > Subject: Info needed!
> > > > > > >
> > > > > > >
> > > > > > > I need to run a query from a java program to :
> > > > > > > 1) get the list of tables in a particular db]
> > > > > > > 2) get the desc of each table in the list I get
> > > > > > > Can I use the show tables; and desc tablename as a query to
get
> > the
> > > > > > desired
> > > > > > > RESULTSET in java(sql package) ??
> > > > > > >
> > > > > > > Plz do respond at hte earliest!
> > > > > > > Thanks and regds
> > > > > > > Ash
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>
>
---------------------------------------------------------------------
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
