| MySQL statements with incorrect quotes [message #120453] |
Wed, 13 July 2005 12: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 #121060 is a reply to message #120935] |
Fri, 15 July 2005 10:48  |
| Eclipse User |
|
|
|
Originally posted by: alain.poirier.net-ng.com
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
|
|
|
|
| Re: MySQL statements with incorrect quotes [message #144823 is a reply to message #126103] |
Fri, 21 October 2005 15:30 |
| Eclipse User |
|
|
|
Originally posted by: user.domain.invalid
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?
Sean
|
|
|
| Re: MySQL statements with incorrect quotes [message #145324 is a reply to message #144823] |
Thu, 27 October 2005 01: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.03461 seconds
] 
Search
Help
Register
Login
Home
