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
