SQL generated by DbVis contains non SQL (garbage) code??
a
anonymous
started a topic
almost 12 years ago
[This topic is migrated from our old forums. The original author name has been removed]
1st off I'll say I'm not a sql whiz but I have access to one and he says there is a string in here that is not SQL. I tried upgrading from 8.0.11 to 9.0 and no change. Here's the code and the second line is the part of the string my SQL expert says isn't supposed to be there. Do I have an option selected that shouldn't be? This is causing the DB to reject changes.
INSERT INTO `qless`.`Message` (`id`, `name`, `bundle`, `locale`, `text`, `merchant_id`, `location_id`, `queue_id`) VALUES (null, 'pushed_please_return_status_update', 'defaultScript', 'es', 'TX DPS: Su espera est. es de ${wait}. Por favor regrese a la zona B y espere a ser llamado. Necesita mas tiempo? Responda "M". No escriba mientras conduce.', ${merchant_id||(null)||Long||nullable ds=20 dt=BIGINT}$, null, 7882);
${merchant_id||(null)||Long||nullable ds=20 dt=BIGINT}$
FYI in case needed
Product: DbVisualizer Pro 9.0
Build: #1902 (2012/11/30 15:08)
Java VM: Java HotSpot(TM) 64-Bit Server VM
Java Version: 1.6.0_35
Java Vendor: Sun Microsystems Inc.
OS Name: Windows 7
OS Arch: amd64
OS Version: 6.1
Current profile: mysql
Current facade: mysql
MySQL
5.1.63-0ubuntu0.10.04.1-log
MySQL-AB JDBC Driver
mysql-connector-java-5.1.21 ( Revision: ${bzr.revision-id} )
1 Comment
Roger Bjärevall
said
almost 12 years ago
[This reply is migrated from our old forums.]
Re: SQL generated by DbVis contains non SQL (garbage) code??
Ray,
Which feature in DbVisualizer are you using that generate this INSERT statement?
Regards
Roger
anonymous