This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
| Summary: | java.sql.SQLException: Syntax error: Encountered "." at line 1, column 81. | ||
|---|---|---|---|
| Product: | db | Reporter: | John Baker <jbaker> |
| Component: | Show Data | Assignee: | _ ahimanikya <ahimanikya> |
| Status: | VERIFIED FIXED | ||
| Severity: | blocker | CC: | jbaker, romanmostyka |
| Priority: | P2 | ||
| Version: | 6.x | ||
| Hardware: | Macintosh | ||
| OS: | All | ||
| URL: | http://statistics.netbeans.org/exceptions/detail.do?id=81247 | ||
| Issue Type: | DEFECT | Exception Reporter: | 81247 |
| Attachments: | SQL script to execute | ||
Created attachment 65495 [details]
SQL script to execute
Basically, I opened the attached SQL file, set the connection to Travel and execute. Travel is a sample database included in the NetBeans visualweb cluster Since we run each statement in background thread, this is happening since the required object does not exist when we are trying to execute create view travel.PersonTrip as select tripid, name from trip, person where trip.personid = person.personid ; When I tried executing separately it worked fine. So may be we need to execute the statements sequentially when, assigning this to David. I don't think the cause of the error is the background thread. The statement are executed sequentially in that thread. Moreover, the error is a syntax error. Had the view not existed, the message would have said so. Since David is not here, could you please have another look at it? Verified with build 080724. |
Build: NetBeans IDE Dev (Build 080721) VM: Java HotSpot(TM) Client VM, 1.5.0_13-121, Java(TM) 2 Runtime Environment, Standard Edition, 1.5.0_13-b05-241 OS: Mac OS X, 10.4.11, i386 User comments: I was executing a script to recreate tables for Derby. I will attach this sql script The SQL script I executed is located in the installation directory of NetBeans in the visualweb2/startup/samples folder. The filename is create-Travel-derby.sql STACKTRACE: (first 10 lines) java.sql.SQLException: Syntax error: Encountered "." at line 1, column 81. at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:0) at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:0) at org.apache.derby.client.am.Statement.execute(Statement.java:0) at org.netbeans.modules.db.dataview.output.SQLExecutionHelper.executeSQLStatement(SQLExecutionHelper.java:549) at org.netbeans.modules.db.dataview.output.SQLExecutionHelper.initialDataLoad(SQLExecutionHelper.java:97) at org.netbeans.modules.db.dataview.output.DataView.create(DataView.java:104) at org.netbeans.modules.db.dataview.api.DataView.create(DataView.java:71) at org.netbeans.modules.db.sql.execute.SQLExecuteHelper.execute(SQLExecuteHelper.java:112) at org.netbeans.modules.db.sql.loader.SQLEditorSupport$SQLExecutor.run(SQLEditorSupport.java:482) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)