Netbeans + VWP + SQL,Java Tools,Development Tools / Java Tools

# 1

Hi There,If im understanding you right, YES it does understand the same query. Here is how you can edit the query generated. http://www.netbeans.org/kb/55/vwp-databoundcomponents.html#04ThanksK

kish@suna at 2007-7-8 23:17:13 >

top of Java-index,Development Tools,Java Tools...

# 3

Addition:I have to enter the SQL-Statement manually in the form "SELECT ALL field FROM table". Than the visual SSQL-Editor is working.

Willi2793a at 2007-7-8 23:17:13 >

# 5

Sure I can.

I'm using WinXP Pro SP2 and all patches.

Product version of Netbeans say: Netbeans IDE 5.5 (Build 200610171010, Visual Web Pack 061127_6)

Java 1.6.0

1GB RAM

Database is MySQL 5.0.27

JDBC is Connector/J 5.0.4

Now I create a new Project, drag a table to Page1. Than I switch to Databases under Runtime and drag a DB-Table to the Table in Page1. It looks good. The Table-Design is changed to show all Rows and the Headers are okay as well. Now I would like to customise the SQL-Staement wich looks "SELECT * FROM tablename". Therefor I doubleclick the Rowset (or click with right and select "Edit SQL Staement". Than the Error occurs.

If I click once the RowSet and edit the command-property manualy that it looks like "SELECT ALL tabname.rowname FROM tabname" the visual SQL-Editor works fine and I can customise my SQL-Statement.

If you have any further questions: don't hesitate to ask.

Regards

Willi2793a at 2007-7-8 23:17:13 >

# 7

Okay. I include the program wich created and filled the DB. I testted with the table "musiccategories". I even tested with a Driver 3.x but wwith the same results.

-- code --

/*

* MusicDB.java

*

* Created on February 28, 2006, 2:27 PM

*

* To change this template, choose Tools | Options and locate the template under

* the Source Creation and Management node. Right-click the template and choose

* Open. You can then make changes to the template in the Source Editor.

*/

package asg.databuild;

import java.sql.*;

public class MySQLMusicDB {

public static void main(String args[]) {

new MySQLMusicDB(args);

}

/** Creates a new instance of DerbyMusicDB */

public MySQLMusicDB(String args[]) {

try {

Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //NOI18N

} catch (Exception e) {

System.err.println("Class.forName: " + e.getMessage()); //NOI18N

System.exit(1);

}

createMusicDatabase(args);

}

void createMusicDatabase(String args[]) {

String port = "3306";

//String queryString = "select * from Recordings"; //NOI18N

Connection con;

Statement stmt;

String url = "jdbc:mysql://localhost:" + port + "/"; //NOI18N

try {

con = DriverManager.getConnection(url,"root","xxxxxx"); //NOI18N

stmt = con.createStatement();

try {

createUser(stmt, "Music", "music", "music"); //NOI18N

} catch (Exception e) {

}

try {

createSchema(stmt, "Music"); //NOI18N

} catch (Exception e) {

System.err.println("Unable to create user+schema on url " +

url );

e.printStackTrace(System.err) ;

}

con.close();

url += "Music";

con = DriverManager.getConnection(url, "music", "music"); //NOI18N

stmt = con.createStatement();

// Drop all tables first to avoid constraints

dropTable(stmt, "Tracks");

dropTable(stmt, "Recordings");

dropTable(stmt, "MusicCategories");

dropTable(stmt, "RecordingArtists");

dropTable(stmt, "ValidationOnly");

// Music Categories Table

createTable(stmt, "MusicCategories",

"MusicCategoryID INTEGER NOT NULL, MusicCategory VARCHAR(20)");

addConstraint(stmt, "MusicCategories",

"MusicCategoriesPK PRIMARY KEY (MusicCategoryID)");

insertRow(stmt, "MusicCategories", "1, 'Classical'");

insertRow(stmt, "MusicCategories", "2, 'Rock'");

insertRow(stmt, "MusicCategories", "3, 'Jazz'");

insertRow(stmt, "MusicCategories", "4, 'Rap'");

insertRow(stmt, "MusicCategories", "5, 'Country'");

insertRow(stmt, "MusicCategories", "6, 'Musical Theatre'");

insertRow(stmt, "MusicCategories", "7, 'Blues'");

// Recording Artists Table

createTable(stmt, "RecordingArtists",

"RecordingArtistID INTEGER NOT NULL, RecordingArtistName VARCHAR(36), Notes VARCHAR(200)");

addConstraint(stmt, "RecordingArtists",

"RecordingArtistsPK PRIMARY KEY (RecordingArtistID)");