| MySQL statements with incorrect quotes [message #120453] |
Wed, 13 July 2005 08:52  |
Eclipse User |
|
|
|
Originally posted by: alain.poirier.net-ng.com
Hi,
I use WTP M5, eclipse 3.1, MySQL 4.0.24 and jdbc-mysql 3.0.16.
I can connect to a database and send SQL requests with the SQL ScrapBook.
But, when I try to open a table with the Explorer View, I see
Eclipse emitting incorrect SQL statements with quotes, like
SELECT * FROM "test"."address"
instead of the correct ones: SELECT * FROM test.address
Any ideas ? Is it a bug or some configuration is needed ?
Regards
|
|
|
|
|
|
|
| Re: MySQL statements with incorrect quotes [message #145324 is a reply to message #144823] |
Wed, 26 October 2005 21:34  |
| Eclipse User |
|
|
|
Originally posted by: user.domain.invalid
user@domain.invalid wrote:
> Top posting reformatted.
>
> Dion Barrier wrote:
>
>>Alain Poirier wrote:
>>
>>
>>>Hi,
>>>
>>>Thanks for your reply.
>>>
>>>
>>>
>>>>I thought we already fixed this in M5. Please verify that the database
>>>>definition file (org.eclipse.wst.rdb.dbdefinition.MySQL plugin) that you
>>>>get for MySQL contains following tag:
>>>>
>>>><queryDefinition hostVariableMarker="@" IdentifierQuoteString="'" />
>>>>
>>>>MySQL need to use the single quote instead.
>>>
>>>
>>>
>>>Indeed, I checked the MySql_4.0.xmi file and found the line :
>>>
>>><queryDefinition identifierQuoteString="`" hostVariableMarker="@"
>>>hostVariableMarkerSupported="true"/>
>>>
>>>This definition seems to be correct because MySQL needs a back-quote
>>>char.
>>>
>>>But this delimiter is not used into the SQL queries. In fact, the only
>>>values that I can use are "\"" and "'". All others values ("`" included)
>>>seems to be ignored and replaced by "
>>>
>>>Does a filter on the possible values exist somewhere ?
>>>
>>>Regards
>>>
>>
>>I am using RC3 and am having the same issue. It is defined correctly
>>as a backtick ( ` ) in the xmi file. It would seem however that this
>>definition is being ignored. It doesn't matter what I change the
>>identifier quote to it continues to insert a double-quote in its
>>place.
>>
>>Any help would be very much appreciated.
>>
>>Thanks, Dion
>>___________
>
>
> I see there hasn't been any activity on this thread since July. I'm
> running Eclipse 3.1.0, WST 0.7.0 and MySQL 4.0.26 and am encountering
> the same problem. It doesn't matter what I change the value of
> identifierQuoteString to be in MySQL_4.0.xmi, the query still uses "s
> around the database and table names.
>
> Has anyone been able to work around this yet?
BTW, I upgraded to WST 0.7.1. Still no luck.
Anybody get this working with MySQL yet?
Sean
|
|
|
Powered by
FUDForum. Page generated in 0.03817 seconds
Home