I didn't actually count the characters but it looks very close to a
512-character limit. (I used a pica stick on the screen, very accurate!)
The error message appears to be showing a truncated line. Is possible?
--Jon
> > >
> > > 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_rs
> > >
n_cd,fld_aflgrp_cd,fld_aflgrp_name1,fld_aflgrp_name2,fld_city_t_name1,fl
> > > d_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]
