Sorry, but... try using setString not setObject bye
maxsoft -----Messaggio originale----- Da: Fabio Pinotti [mailto:[EMAIL PROTECTED] Inviato: giovedì 10 giugno 2004 12.15 A: Massimo Renzi (MaticaSrl); [EMAIL PROTECTED] Oggetto: Re: Passing parameters from java Hi massimo, I dont' understand your answer. Where do you see field name? Thanks Fabio ----- Original Message ----- From: "Massimo Renzi (MaticaSrl)" <[EMAIL PROTECTED]> To: "Fabio Pinotti" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 10, 2004 11:41 AM Subject: R: Passing parameters from java > Ciao Fabio, > i parametri non puoi passare il nome di un campo come parametro. > > ciao > > Hi Fabio, > I think that you cannot pass a field name as a parameter. > > bye > > maxsoft > > -----Messaggio originale----- > Da: Fabio Pinotti [mailto:[EMAIL PROTECTED] > Inviato: giovedì 10 giugno 2004 11.19 > A: [EMAIL PROTECTED] > Oggetto: Passing parameters from java > > > Hi, > I have this simple piece of java code that gives me an error (it is just > a dummy slq expresson that include the error I get on a more complex > query...): > > String sqlString="Select 1 FROM DUAL WHERE > " DECODE(?,'1','ONE','NOT_ONE')='ONE'" + > " AND ?='guest'"; > > PreparedStatement st= cn.prepareStatement(sqlString); > st.setObject(1,"0"); > st.setObject(2,"guest"); > ResultSet rs=st.executeQuery(); > > The error is > > javax.servlet.ServletException: SAP DBTech JDBC: Parameter 1: value too > large. > > The connection seems to be valid, because I succesfully execute other sql > commands. > The strange thing is that the following statement, executed with the same > code above, runs succesfully > > String sqlString="Select 1 FROM DUAL WHERE " + > " ?='1'" + > " AND ?='guest'"; > > so it seems that the problem is raised by "decode".... > I tried to specify parameter types, or to use setString instead of > setObject, but nothing changes. > > > Thanks > > Fabio > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
