| Server Explorer problem [message #116560] |
Wed, 06 July 2005 06:03  |
Eclipse User |
|
|
|
I have problem with server explorer. When I connect to MySQL 4.0.1.2
(Eclipse 3.1 WTP M5) Explorer works correct shows me db and list of the
tables but it couldn't shows me collumns, and when I try to see whole
content of the table I got an Exception
"Starting run
SELECT * FROM "price"."items"
java.sql.SQLException: Syntax error or access violation message from
server: "You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near '"price"."items"' at line 1"
tell me if something wrong I do.
Thanks
|
|
|
| Re: Server Explorer problem [message #116588 is a reply to message #116560] |
Wed, 06 July 2005 08:54  |
| Eclipse User |
|
|
|
> I have problem with server explorer. When I connect to MySQL 4.0.1.2
> (Eclipse 3.1 WTP M5) Explorer works correct shows me db and list of the
> tables but it couldn't shows me collumns, and when I try to see whole
> content of the table I got an Exception
> "Starting run
>
> SELECT * FROM "price"."items"
>
> java.sql.SQLException: Syntax error or access violation message from
> server: "You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near '"price"."items"' at line 1"
I noticed this "bug" too yesterday. For now you need to write your own SQL
instead of using menu.
Instead of this construct (created by WTP) :
SELECT * FROM "price"."items"
write your own SQL command to SQL Scrapbook page :
SELECT * FROM items
Frantisek Augusztin
|
|
|
| Re: Server Explorer problem [message #116613 is a reply to message #116588] |
Wed, 06 July 2005 08:38 |
| Eclipse User |
|
|
|
Frantisek Augusztin wrote:
>>I have problem with server explorer. When I connect to MySQL 4.0.1.2
>>(Eclipse 3.1 WTP M5) Explorer works correct shows me db and list of the
>>tables but it couldn't shows me collumns, and when I try to see whole
>>content of the table I got an Exception
>>"Starting run
>>
>>SELECT * FROM "price"."items"
>>
>>java.sql.SQLException: Syntax error or access violation message from
>>server: "You have an error in your SQL syntax. Check the manual that
>>corresponds to your MySQL server version for the right syntax to use
>>near '"price"."items"' at line 1"
>
>
> I noticed this "bug" too yesterday. For now you need to write your own SQL
> instead of using menu.
>
> Instead of this construct (created by WTP) :
>
> SELECT * FROM "price"."items"
>
> write your own SQL command to SQL Scrapbook page :
>
> SELECT * FROM items
>
> Frantisek Augusztin
Thank you, Frantisek, But where can I found this "SQL Scrapbook page"?
|
|
|
| Re: Server Explorer problem [message #116618 is a reply to message #116588] |
Wed, 06 July 2005 08:43 |
| Eclipse User |
|
|
|
Frantisek Augusztin wrote:
>>I have problem with server explorer. When I connect to MySQL 4.0.1.2
>>(Eclipse 3.1 WTP M5) Explorer works correct shows me db and list of the
>>tables but it couldn't shows me collumns, and when I try to see whole
>>content of the table I got an Exception
>>"Starting run
>>
>>SELECT * FROM "price"."items"
>>
>>java.sql.SQLException: Syntax error or access violation message from
>>server: "You have an error in your SQL syntax. Check the manual that
>>corresponds to your MySQL server version for the right syntax to use
>>near '"price"."items"' at line 1"
>
>
> I noticed this "bug" too yesterday. For now you need to write your own SQL
> instead of using menu.
>
> Instead of this construct (created by WTP) :
>
> SELECT * FROM "price"."items"
>
> write your own SQL command to SQL Scrapbook page :
>
> SELECT * FROM items
>
> Frantisek Augusztin
I'm sorry I found it thank you again.
But still as I undestand when I try to export/generate dtd - it shows
tables without fields
|
|
|
| Re: Server Explorer problem [message #116623 is a reply to message #116613] |
Wed, 06 July 2005 08:52 |
| Eclipse User |
|
|
|
Andy wrote:
> Frantisek Augusztin wrote:
>>>I have problem with server explorer. When I connect to MySQL 4.0.1.2
>>>(Eclipse 3.1 WTP M5) Explorer works correct shows me db and list of the
>>>tables but it couldn't shows me collumns, and when I try to see whole
>>>content of the table I got an Exception
>>>"Starting run
>>>
>>>SELECT * FROM "price"."items"
>>>
>>>java.sql.SQLException: Syntax error or access violation message from
>>>server: "You have an error in your SQL syntax. Check the manual that
>>>corresponds to your MySQL server version for the right syntax to use
>>>near '"price"."items"' at line 1"
>>
>>
>> I noticed this "bug" too yesterday. For now you need to write your own
>> SQL instead of using menu.
>>
>> Instead of this construct (created by WTP) :
>>
>> SELECT * FROM "price"."items"
>>
>> write your own SQL command to SQL Scrapbook page :
>>
>> SELECT * FROM items
>>
>> Frantisek Augusztin
> Thank you, Frantisek, But where can I found this "SQL Scrapbook page"?
Ctrl+N : Data->SQL Scrabook Page
|
|
|
Powered by
FUDForum. Page generated in 0.03873 seconds
Home