Hello All,

I have the following environment:

MySQL 4.1.3-beta-standard
Connector/J 3.0.14
SUN Java JDK 1.4.2
SUSE Linux 9.1

I have written a java program to insert information into an "emp" table
as follows:

INSERT INTO dirxml.emp
(fld_ind_id,fld_frname,fld_srname,fld_init,fld_sh_name1,fld_sh_name2,fld_posnacty_cd,fld_posnacty_name1,fld_posnacty_name2,fld_emp_job_desc1,fld_emp_job_desc2,fld_statrsn_cd,fld_statrsn_name1,fld_statrsn_name2,fld_rsn_cd,fld_aflgrp_cd,fld_aflgrp_name1,fld_aflgrp_name2,fld_city_t_name1,fld_city_t_name2,fld_manager_indv_id,fld_comm_lang)
VALUES("100000087","SANIA","RANCOURT","","Miss","Mlle","TFR","T L VISION
FRAN AISE R GIONALE","T L VISION FRAN AISE R GIONALE","MAKE-UP
ARTIST","MAQUILLEUR (EUSE)","R01","RETURN TO ACTIVE STATUS","REMISE EN
ACTIVIT ","019","U2R","STARF","STARF","QUEBEC","QUEBEC","SYSM63","F");

When I run this statement from MySQL Control Center, it work without any
errors but when I execute it via java code, I get the following error:
--
SEVERE: 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 '"QUEB' at line 1"
--
SEVERE: SQLState: 42000
--
SEVERE: VendorError: 1064

Can someone please help what I may be doing wrong...

Thanks,
Shaffin.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to