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

[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?

[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?

[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?

[Loïc Lefèvre]

Here is some source code in java:
usage:

java  testOra url:port user password  alltables

If the connection fail, try to change the jdbc driver...

---8<---
---

import java.io.*;
import java.net.*;
import java.util.*;
import java.sql.*;


/**
 *
 */
class testOra
{

static ArrayList tables = new ArrayList();
static int n = 0;

/**
 *
 */
public static void main (String[] argv)
{

try
{
Connection con;

DriverManager.registerDriver(new 
oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection ("jdbc:oracle:thin:@" + 
argv[0],
argv[1], argv[2]);

System.out.println("Connection OK !");

Statement stmt = con.createStatement();

BufferedReader input = new BufferedReader(new
FileReader(argv[3]));
String line = "";

if(argv.length > 4)
{
DatabaseMetaData dbmd = con.getMetaData();
String [] types = new String[7];
types[0] = "TABLE";
types[1] = "VIEW";
types[2] = "SYSTEM TABLE";
types[3] = "GLOBAL TEMPORARY";
types[4] = "LOCAL TEMPORARY";
types[5] = "ALIAS";
types[6] = "SYNONYM";
ResultSet rset = dbmd.getTables("%","%","%",types);


System.out.println("
-");
System.out.println("DATABASE'S TABLES");

execRequest(rset);
}

int num = 1;
while((line=input.readLine()) != null)
{

System.out.println("
-");
System.out.println("REQUETE numero : "+num);
num++;

ResultSet rs = stmt.executeQuery(line);
execRequest(rs);
}


System.out.println("
-");

if(argv.length > 4)
{
Iterator i = tables.iterator();
while(i.hasNext())
{
line = (String)i.next();

System.out.println("
-");
System.out.println("TABLE : "+line);
System.err.println("Processing table "+line+"...");

try
{
ResultSet rs = stmt.executeQuery("select * from "+line);
execRequest(rs);
}
catch(Exception e)
{
System.out.println("Impossible d'executer : select *
from "+line);
System.out.println(e.getMessage());
}
}


System.out.println("
-");
}
}
catch (Exception e)
{
e.printStackTrace();
}
}

public static void execRequest(ResultSet rs)
throws Exception
{
ResultSetMetaData rsmd = rs.getMetaData();

String labels = "";
for(int i = 1; i <= rsmd.getColumnCount(); i++ )
{
labels+=rsmd.getColumnName(i)+"\t";
}

System.out.println(labels);

String  r1,r2,r3,r4,r5,r6,r7,r8,r9,r10;
String  r11,r12,r13,r14,r15,r16,r17,r18,r19,r20;
String  r21,r22,r23,r24,r25,r26,r27,r28,r29,r30;
String  r31,r32,r33,r34,r35,r36,r37,r38,r39,r40;

while( rs.next() )
{
r1 = r2 = r3 = r4 = r5 = r6 = r7 = r8 = r9 = r10 = "";
r11 = r12 = r13 = r14 = r15 = r16 = r17 = r18 = r19 = r20 = "";
r21 = r22 = r23 = r24 = r25 = r26 = r27 = r28 = r29 = r30 = "";
r31 = r32 = r33 = r34 = r35 = r36 = r37 = r38 = r39 = r40 = "";
try
{
r1 = rs.getString(1);
r2 = rs.getString(2);
r3 = rs.getString(3);
r4 = rs.getString(4);
r5 = rs.getString(5);
r6 = rs.getString(6);
   

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

[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?

[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?

[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?

[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?

[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?

[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