setNull in select doesn't work

Hello, We are trying to perform a select query to the Derby database with PreparedStatement PreparedStatement ps = c.prepareStatement(select * from table where value = ?); //several methods performed on statement (separately ofcourse) 1. ps.setNull(1,Types.VARCHAR); 2. ps.setObject(1, null,

Re: setNull in select doesn't work

Marieke Vandamme [EMAIL PROTECTED] writes: Hello, We are trying to perform a select query to the Derby database with PreparedStatement PreparedStatement ps = c.prepareStatement(select * from table where value = ?); //several methods performed on statement (separately ofcourse) 1.

Re: ERROR 22001

Jitendra Kharche wrote: Hi, I am using Derby that is embedded in Websphere App Server Community Edition. I get the following error ERROR 22001: A truncation error was encountered trying to shrink VARCHAR Can anybody explain about this and how can i remove it. Hello Jitendra, To me it looks

Java Data Types in Derby

Thanks Kristian. I checked. The column size is smaller than the data being inserted. I have two questions 1. Does Derby support java data types like cloudscape? 2. Is there any user interface tool for Derby? Regards, Jitendra Kharche Geometric Software Solutions Co. Ltd. Work: +91-20-2290

Re: Java Data Types in Derby

Jitendra, 2. Is there any user interface tool for Derby? We are working on a web based manager for Derby. Derby and the manager will be part of our Qilan v3.8 release. This release is due out by 8/1/06, but you can download v3.7 now. http://www.qilan.com

Re: !!! Regression Search and Destroy Contest !!!

Rajesh Kartha wrote: Kathey Marsden wrote: I posted the Wiki page this morning for the Derby 10.2 Regression Search and Destroy contest. The contest winners will be: The top three developers or users who have made the greatest contribution toward a seamless upgrade to 10.2. Details are

RE: Java Data Types in Derby

-Original Message- From: Jitendra Kharche [mailto:[EMAIL PROTECTED] Sent: Monday, July 24, 2006 6:52 AM To: Derby Discussion Subject: Java Data Types in Derby Thanks Kristian. I checked. The column size is smaller than the data being inserted. I have two questions 1. Does

RE: ERROR 22001

The .trim() method of a String will truncate the ending white space. You can do a substring with a starting position of 0 and the MAX value of a VARCHAR (which should be a constant somewhere). This should ensure that the string is truncated and will fit. -Original Message- From: [EMAIL

Re: Java Data Types in Derby

Hi Jitendra, Jitendra Kharche wrote: Thanks Kristian. I checked. The column size is smaller than the data being inserted. I have two questions 1. Does Derby support java data types like cloudscape? I think you may be asking whether Derby, like Cloudscape, supports abstract data types,

RE: Java Data Types in Derby

Thanks for your quick responses. [mjs] DERBY IS CLOUDSCAPE. And JavaDB Michael does it mean that I can specify column data types in terms of Java Data Types e.g. java.lang.String etc. Regards, Jitendra

Re: setNull in select doesn't work

Hello, When using other Database Drivers (like postgres) this is supported. When suggesting Derby doesn't, what are the alternatives for my problem? I really need to use it in the form of PreparedStatement, like select * from table where value = ?, because we are using select statement with more

Re: !!! Regression Search and Destroy Contest !!!

We now have our panel of judges. Thanks to Stan, Rajesh and John for volunteering. Now all we need is an army of users to try their applications and flush all the bugs out of the product and documentation for 10.2. Please take a look and participate.

RE: Java Data Types in Derby

Uhm no, Derby/Cloudscape/JavaDB (you can pick and choose your name)... is a relational database written in Java. With respect to column data types, you should refer to the manual... These are also the database types supported by the JDBC class(es). Just like any other JDBC compliant database,

Re: setNull in select doesn't work

Hi Marieke,You have hit one of the big usability issues with SQL. While many vendors have implemented "WHERE value = ?" such that it behaves exactly like "WHERE value IS NULL" in case the parameter passed is null, it isn't required by the governing standard, and is not therefore a bug in an

Re: Please try your applications with 10.2 optimizer changes

Army wrote: Kathey Marsden wrote: The DERBY-781 fix is not included with the latest snapshot, but you can get it with the latest unofficial builds that Ole posts at:: http://www.multinet.no/~solberg/public/Apache/Derby/builds/ Actually, I don't think the DERBY-781 changes haven't been