Database tables invisible in NetBeans

[jsiii]

Hello,

I am trying to develop JSP application with Visual Web Pack in Netbeans 5.5.

I am trying to connect to MySql database. It was going all well and with some minor problems I was able to make my database appear in the Databases in the Runtime list. I can connect to my database and I can create a table (I check the database with MySql administration program and the table is there, also Netbeans displays error telling that table is already there when I try to recreate it).

The problem however is that I cannot see the table in the Runtime list. The Tables node is just plain empty (as well as all other nodes: views and procedures).

What to do about that? Any idea appreciated.
Thank you.

[ronverdonk]

Must have to do with the configuration/setup of your Visual Web Pack or NetBeans. When the table exists in the MySQL database, you know that at least that part works.

Look in the WebPack configuration and setup manual.

Ronald :cool:

[sand300]

I have the same problem herein described. I can add the tables created through netbeans 5.5 are viewable on the MySQL command line. So there is no problem creating the tables.

The tables node is viewable if one uses Derby DB, so it can´t be only a netbeans problem.

Might this suggests that Derby has added files, not in the MySQL connector, that allow tables to be visible?

[sand200]

I solved my problem for invisible tables in netbeans 5.5 and MYSql as follows:
Following the advice I read (Connecting to Databases http://www.netbeans.org/kb/40/using-netbeans/dbconn.html) I loaded driver's JAR file in my web proyect’s WEB-INF/lib folder.

This is in addition to having loaded it in NetBeans 5.5 JBDC drivers' folder.

However, that was not enough. Let me explain:
I had originally connected the driver using jdbc:mysql/// as the URL and THAT was the culprit. Changing the URL to jdbc:mysql//localhost:3306/DatabaseName solved the problem.

Thus, one must first create a database, give it a name, and then reconnect the driver with the database name in the URL. One can create the database either in the MySQL command line, or through netbeans. As already explained, if one chooses netbeans, one is not able to see tables, until one opens a new driver connection with the database name in the URL.

Note that 3306 is the port for MySQL.

Hope this helps someone.

[sand200]

Resolví mi problema de las tablas invisibles en netbeans 5.5 y MySQL de la siguiente forma:
Siguiendo el consejo que leí (Connecting to Databases http://www.netbeans.org/kb/40/using-netbeans/dbconn.html) metì el archivo JAR del driver's (solo hay 1) dentro de la carpeta WEB-INF/lib que se encuentra en los archivos del proyecto web en el cual estaba trabajando.

Esto lo hice en adiciòn a meterlo en la carpeta de NetBeans 5.5, JBDC drivers.

Sin embargo, aùn eso no fue suficiente. Me explico:
Originalmente yo habìa conectado el driver usando el URL jdbc:mysql/// y eso fue el problema verdadero. Cambiando el URL a
jdbc:mysql//localhost:3306/NombreDeBaseDeDatos
resolviò mi problema.

Por lo tanto, primero hay que crear una base de datos y luego conectar el driver con el nombre de la base de dato en el final del URL. Esto se puede hacer desde el command line con MySQL directamente o desde netbeans.
Como ya expliquè, si escojen crear la base de datos con netbeans no van a poder ver tablas, hasta que hagan una conexión del driver usando un URL que incluye el nombre de la base de datos.

Observen que 3306 es el puerto de MySQL.

¡Ojalan esto ayude a alguien!