MySQL and Oracle JDeveloper

[Ayyaparaju Ganapathiraju]

Hi,

This is actually a question for Oracle JDeveloper forums, but I couldn't get 
any replies from that forum. If you are using JDeveloper on MySQL database, 
please help me with this question.

Since MySQL doesn't have any equivalent to schema or user as in Oracle, I am 
creating tables in multiple databases. I want to treat each database like a 
schema. Within MySQL, I can do joins, selects from all of these databases 
without a problem.

When I create a database connection in JDeveloper to MySQL, I am only 
connecting to one of the databases as specified in the connection URL 
(jdbc:mysql://localhost/dbname). I can only see tables from that database 
dbname. Is there a way to see all MySQL databases/tables in JDeveloper so 
that I can create BC4J components across all MySQL databases/tables.

Thanks, Raju



_
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus

-
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

Re: How to create a schema

[Ayyaparaju Ganapathiraju]

Thank you very much. That information is very helpful as I am just starting 
to use/learn MySQL.



Raju Ganapathiraju


From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: Ayyaparaju Ganapathiraju [EMAIL PROTECTED]
Subject: Re: How to create a schema
Date: Wed, 19 Feb 2003 13:32:32 +0100

* Ayyaparaju Ganapathiraju
 1). Is there an equivalent to creating a schema in MySQL. I would like 
to
 create tables in multiple schemas within the same database. Some of the
 tables will have foregign keys across schemas.

No, there is no consept of 'schema' in mysql, other than the implicit
'schema' resulting from the existing table definitions in a database.

 I'm aware that I can create multiple databases and switch between
 databases
 using use database name.

Yes, and you can also use multiple databases in the same sql statement,
using the database.table and database.table.column syntax:

select db1.table1.col1,db2.table2.col2
  from db1.table1,db2.table2
  where db1.table1.id = db2.table2.id

 2). How can I edit a statement within mysql. Suppose if I make a
 typo in a large select statement, can I go into an editor and fix
 it, then execute it from the buffer.

If you have a new version of mysql, see the standard client \e command.

It is mentioned here, but I have not found any further documentation:

URL: http://www.mysql.com/doc/en/mysql.html 

The \e command is not available in earlier versions of mysql, but I did not
find any mention of it in the change history, so I don't know when it 
became
available. Somewhere between versions 3.23.30 and 3.23.55.

I normally use a text editor, and then either copypaste my statements
directly into the mysql client, or I execute it from a command line with:

mysql dbname  script.sql

(or mysql -h host -u usrname -p dbname  script.sql)

HTH,

--
Roger


-
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



_
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail


-
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

How to create a schema

[Ayyaparaju Ganapathiraju]

Hi,

I have two questions here, please.

1). Is there an equivalent to creating a schema in MySQL. I would like to 
create tables in multiple schemas within the same database. Some of the 
tables will have foregign keys across schemas.

I'm aware that I can create multiple databases and switch between databases 
using use database name.

2). How can I edit a statement within mysql. Suppose if I make a typo in a 
large select statement, can I go into an editor and fix it, then execute it 
from the buffer.

Any suggestions.

Raju Ganapathiraju



_
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


-
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