Hello,
can you deliver some detail informations?
1. What's the error message do you get?
2. What's your table definition ("Create table ...")?
3. Maybe you can send me a jdbc-trace
(http://sapdb.2scale.net/moin.cgi/JdbcTrace)
Regards,
Marco
----------------------------------------------
Marco PASKAMP
SAP DB, SAP Labs Berlin
> -----Original Message-----
> From: h2m meza [mailto:[EMAIL PROTECTED]]
> Sent: Montag, 20. Mai 2002 22:32
> To: [EMAIL PROTECTED]
> Subject: type longvarchar with getString() or setString()
>
>
> hi friends:
>
> i'm working with sapdb and java. My problem is that,
> i can't insert or update to a field of type
> LONGVARCHAR.
>
> i'm staying
>
> this is my code:
>
> String queryStr = "UPDATE " +
> DatabaseNames.AREA_TABLE
> + " SET id_especialidad = ? , "
> + "nombre = ? , "
> + "descripcion = ? , "
> + "fecha_creacion = ? , "
> + "estado = ? "
> + " WHERE id_area = ? ";
>
> Debug.println("updateString is: "+ queryStr);
>
> PreparedStatement stmt = null;
> try {
> getDBConnection();
>
> stmt =
> dbConnection.prepareStatement(queryStr);
> //
>
> stmt.setString(1,details.getSpecialty().id.trim());
>
> stmt.setString(2,details.getName().trim());
>
> stmt.setString(3,details.getDescription());
> stmt.setDate(4,details.getDateCreate());
>
> stmt.setString(5,details.getStatus().trim());
>
> stmt.setString(6,details.getAreaPK().id.trim());
> //
> stmt.executeUpdate();
>
>
>
> I'm thankful.
>
>
> _________________________________________________________
> Do You Yahoo!?
> Informaci�n de Estados Unidos y Am�rica Latina, en Yahoo! Noticias.
> Vis�tanos en http://noticias.espanol.yahoo.com
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
