RE: How can i get all table's name from JDBC driver?

2001-07-24 Thread Jann VanOver 



Umm 
... can you guys take this off to a JDBC list somewhere?

  -Original Message-From: João Folha 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 23, 2001 7:56 
  PMTo: [EMAIL PROTECTED]Subject: Re: How can 
  i get all table's name from JDBC driver?
  ODBC, with ms access.
  
- Original Message - 
From: 
Sean 
Alphonse 
To: [EMAIL PROTECTED] 

Sent: Monday, July 23, 2001 3:55 
PM
Subject: RE: How can i get all table's 
    name from JDBC driver?

Which RDBMS are you using?

  -Original Message-From: João Folha [mailto:[EMAIL PROTECTED]]Sent: 
  July 23, 2001 9:48 PMTo: [EMAIL PROTECTED]Subject: 
      How can i get all table's name from JDBC driver?
  Hi there,
   
  I need to get all table's name from JDBC 
  driver and all column's name from any table.
   
  Can you help me?
   
  cheers
  João 
Folha

RE: How can i get all table's name from JDBC driver?

2001-07-24 Thread Jann VanOver 



What 
does this have to do with Tomcat?
 

  -Original Message-From: João Folha 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, July 23, 2001 7:48 
  PMTo: [EMAIL PROTECTED]Subject: How can i 
  get all table's name from JDBC driver?
  Hi there,
   
  I need to get all table's name from JDBC driver 
  and all column's name from any table.
   
  Can you help me?
   
  cheers
  João Folha

Re: How can i get all table's name from JDBC driver?

2001-07-23 Thread Christopher A Barbee 

Jo~ao,

Check the API for DatabaseMetadata in JDBC.  You should be able to
get the table names and column names from it.


--Chris

João Folha wrote:

> Hi Mike, I am using ms access, wan´t my choice... thanks João Folha
>
>  - Original Message -
>  From: Mike Alba
>  To: [EMAIL PROTECTED]
>  Sent: Monday, July 23, 2001 3:56 PM
>      Subject: Re: How can i get all table's name from JDBC
>  driver?
>   What kind of database?If Oracle there is a
>  tableall_tab_columns you can select
>  table_name,column_namefrom. Thanks Mike
>
>   - Original Message -
>   From: João Folha
>   To: [EMAIL PROTECTED]
>   Sent: Monday, July 23, 2001 7:48 PM
>   Subject: How can i get all table's name from JDBC
>   driver?
>Hi there, I need to get all table's name from
>   JDBC driver and all column's name from any
>   table. Can you help me? cheersJoão Folha
>

RE: How can i get all table's name from JDBC driver?

2001-07-23 Thread Loïc Lefèvre 
 {
r1 = rs.getString(1);
r2 = rs.getString(2);
r3 = rs.getString(3);
r4 = rs.getString(4);
r5 = rs.getString(5);
r6 = rs.getString(6);
r7 = rs.getString(7);
r8 = rs.getString(8);
r9 = rs.getString(9);
r10 = rs.getString(10);
r11 = rs.getString(11);
r12 = rs.getString(12);
r13 = rs.getString(13);
r14 = rs.getString(14);
r15 = rs.getString(15);
r16 = rs.getString(16);
r17 = rs.getString(17);
r18 = rs.getString(18);
r19 = rs.getString(19);
r20 = rs.getString(20);
r21 = rs.getString(21);
r22 = rs.getString(22);
r23 = rs.getString(23);
r24 = rs.getString(24);
r25 = rs.getString(25);
r26 = rs.getString(26);
r27 = rs.getString(27);
r28 = rs.getString(28);
r29 = rs.getString(29);
r30 = rs.getString(30);
r31 = rs.getString(21);
r32 = rs.getString(22);
r33 = rs.getString(23);
r34 = rs.getString(24);
r35 = rs.getString(25);
r36 = rs.getString(26);
r37 = rs.getString(27);
r38 = rs.getString(28);
r39 = rs.getString(29);
r40 = rs.getString(30);
}
catch (Exception n)
{}

if( n == 0 )
tables.add(r3);

System.out.println(r1 + "\t" + r2 + "\t" + r3 + "\t" + r4 + "\t" +
r5 + "\t" + r6 + "\t" + r7 + "\t" + r8 + "\t" + r9 + "\t" + r10 + "\t" + r11
+ "\t" + r12 + "\t" + r13 + "\t" + r14 + "\t" + r15 + "\t" + r16 + "\t" +
r17 + "\t" + r18 + "\t" + r19 + "\t" + r20 + "\t" + r21 + "\t" + r22 + "\t"
+ r23 + "\t" + r24 + "\t" + r25 + "\t" + r26 + "\t" + r27 + "\t" + r28 +
"\t" + r29 + "\t" + r30  + "\t" + r31 + "\t" + r32 + "\t" + r33 + "\t" + r34
+ "\t" + r35 + "\t" + r36 + "\t" + r37 + "\t" + r38 + "\t" + r39 + "\t" +
r40);
}
n++;
}
}

---8<---
-

Loïc Lefèvre

-Message d'origine-
De : João Folha [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 24 juillet 2001 04:48
À : [EMAIL PROTECTED]
Objet : How can i get all table's name from JDBC driver?


Hi there,

I need to get all table's name from JDBC driver and all column's name from
any table.

Can you help me?

cheers
João Folha

Re: How can i get all table's name from JDBC driver?

2001-07-23 Thread Jim Cheesman 

Check out java.sql.DatabaseMetaData and ResultSetMetaData



Jim


At 04:53 AM 24/07/01, you wrote:
>Hi Mike,
>
>I am using ms access, wan´t my choice...
>
>thanks
>
>João Folha
>>- Original Message -
>>From: <mailto:[EMAIL PROTECTED]>Mike Alba
>>To: <mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]
>>Sent: Monday, July 23, 2001 3:56 PM
>>Subject: Re: How can i get all table's name from JDBC driver?
>>
>>What kind of database?
>>If Oracle there is a table
>>all_tab_columns you can select table_name,column_name
>>from.
>>
>>Thanks
>>
>>Mike
>>>- Original Message -
>>>From: <mailto:[EMAIL PROTECTED]>João Folha
>>>To: <mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]
>>>Sent: Monday, July 23, 2001 7:48 PM
>>>Subject: How can i get all table's name from JDBC driver?
>>>
>>>Hi there,
>>>
>>>I need to get all table's name from JDBC driver and all column's name 
>>>from any table.
>>>
>>>Can you help me?
>>>
>>>cheers
>>>João Folha


--

   *   Jim Cheesman   *
 Trabajo: 
[EMAIL PROTECTED] - (34)(91) 724 9200 x 2360
  Always be on the 
lookout for conspicuousness.

Re: How can i get all table's name from JDBC driver?

2001-07-23 Thread João Folha 



ODBC, with ms access.

  - Original Message - 
  From: 
  Sean 
  Alphonse 
  To: [EMAIL PROTECTED] 
  Sent: Monday, July 23, 2001 3:55 PM
  Subject: RE: How can i get all table's 
  name from JDBC driver?
  
  Which RDBMS are you using?
  
-Original Message-From: João Folha [mailto:[EMAIL PROTECTED]]Sent: 
July 23, 2001 9:48 PMTo: [EMAIL PROTECTED]Subject: 
    How can i get all table's name from JDBC driver?
Hi there,
 
I need to get all table's name from JDBC driver 
and all column's name from any table.
 
Can you help me?
 
cheers
João 
Folha

Re: How can i get all table's name from JDBC driver?

2001-07-23 Thread Timo Boehme 

Hi,

On Tue, 24 Jul 2001, João Folha wrote:

> Hi there,
>  
> I need to get all table's name from JDBC driver and all column's name
> from any table.

Connection.getMetaData()

or

if you have an ResultSet:

rs.getMetaData()


Best regards,

Timo

RE: How can i get all table's name from JDBC driver?

2001-07-23 Thread Sean Alphonse 



Which 
RDBMS are you using?

  -Original Message-From: João Folha 
  [mailto:[EMAIL PROTECTED]]Sent: July 23, 2001 9:48 
  PMTo: [EMAIL PROTECTED]Subject: How can i 
  get all table's name from JDBC driver?
  Hi there,
   
  I need to get all table's name from JDBC driver 
  and all column's name from any table.
   
  Can you help me?
   
  cheers
  João Folha

Re: How can i get all table's name from JDBC driver?

2001-07-23 Thread João Folha 



Hi Mike,
 
I am using ms access, wan´t my 
choice...
 
thanks
 
João Folha

  - Original Message - 
  From: 
  Mike Alba 

  To: [EMAIL PROTECTED] 
  Sent: Monday, July 23, 2001 3:56 PM
  Subject: Re: How can i get all table's 
  name from JDBC driver?
  
  What kind of database?
  If Oracle there is a table 
  all_tab_columns you can select 
  table_name,column_name
  from.
   
  Thanks
   
  Mike
  
- Original Message - 
From: 
João Folha 
To: [EMAIL PROTECTED] 

Sent: Monday, July 23, 2001 7:48 
PM
Subject: How can i get all table's name 
    from JDBC driver?

Hi there,
 
I need to get all table's name from JDBC driver 
and all column's name from any table.
 
Can you help me?
 
cheers
João 
Folha

Re: How can i get all table's name from JDBC driver?

2001-07-23 Thread Mike Alba 



What kind of database?
If Oracle there is a table 
all_tab_columns you can select 
table_name,column_name
from.
 
Thanks
 
Mike

  - Original Message - 
  From: 
  João Folha 
  To: [EMAIL PROTECTED] 
  
  Sent: Monday, July 23, 2001 7:48 PM
  Subject: How can i get all table's name 
  from JDBC driver?
  
  Hi there,
   
  I need to get all table's name from JDBC driver 
  and all column's name from any table.
   
  Can you help me?
   
  cheers
  João Folha

How can i get all table's name from JDBC driver?

2001-07-23 Thread João Folha 



Hi there,
 
I need to get all table's name from JDBC driver and 
all column's name from any table.
 
Can you help me?
 
cheers
João Folha