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 commi
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 impleme
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, y
The issue is that some databases support the comparison of
x = NULL
This is not a feature AFAIK that is an ANSI requirement.
You need to use IS NULL in your query.
you can use setNull or pass a null to setXXX if you choose, but this
does not correct your SQL grammer, you need to provide t
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.
http://wiki.apache.org/db-derby/Regress
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 mor
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
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, tha
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: [EMAI
> -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
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 ar
Jitendra Kharche wrote:
2. Is there any user interface tool for Derby?
ij is a (non-graphical) tool that is distributed with Derby. You can use
its command line interface to run SQL scripts or execute commands.
If you are looking for graphical UIs there are a number of different
variants out
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
http://cgs.qilan.com:8080/qilan
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 6351
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
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.
Regards,
Jitendra
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
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, Ty
18 matches
Mail list logo