Re: Bug in Embedded Driver?

2007-04-02 Thread Rick Hillegas
It seems to me that the compiler should not think it has enough information at prepareStatement() time to assign the ? a type of VARCHAR. That looks like a bug to me. As a workaround, the following statement gives the compiler enough information to correctly type the ? parameter. This allows

Re: Bug in Embedded Driver?

2007-04-02 Thread Xavier Hanin
On 4/2/07, Rick Hillegas [EMAIL PROTECTED] wrote: It seems to me that the compiler should not think it has enough information at prepareStatement() time to assign the ? a type of VARCHAR. That looks like a bug to me. As a workaround, the following statement gives the compiler enough

Re: Bug in Embedded Driver?

2007-04-01 Thread Xavier Hanin
On 3/31/07, Oystein Grovlen - Sun Norway [EMAIL PROTECTED] wrote: Xavier Hanin wrote: On 3/31/07, *Øystein Grøvlen* [EMAIL PROTECTED] I'm using version 10.2.2.0 http://10.2.2.0. There have been some fixes in this area lately (see DERBY-1610), and I will try your test case

Bug in Embedded Driver?

2007-03-31 Thread Xavier Hanin
Hi Derby community, I'm currently using Derby on a freshly started project, and I ran into an issue which seems to be a bug. Indeed the same code works well with the Client Driver, and not with the Embedded Driver. The error I get from Derby is: org.apache.derby.impl.jdbc.EmbedSQLException: An

Re: Bug in Embedded Driver?

2007-03-31 Thread Øystein Grøvlen
Xavier Hanin wrote: con.createStatement().executeUpdate(create table Issue ( ID char(50) )); PreparedStatement st = con.prepareStatement(select count(*) from Issue where ? is null); st.setNull(1, Types.VARBINARY); I do not think that CHAR and VARBINARY

Re: Bug in Embedded Driver?

2007-03-31 Thread Øystein Grøvlen
Xavier Hanin wrote: On 3/31/07, *Øystein Grøvlen* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Xavier Hanin wrote: con.createStatement().executeUpdate(create table Issue ( ID char(50) )); PreparedStatement st = con.prepareStatement(select

Re: Bug in Embedded Driver?

2007-03-31 Thread Xavier Hanin
On 3/31/07, Øystein Grøvlen [EMAIL PROTECTED] wrote: Xavier Hanin wrote: On 3/31/07, *Øystein Grøvlen* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Xavier Hanin wrote: con.createStatement().executeUpdate(create table Issue ( ID char(50) ));

Re: Bug in Embedded Driver?

2007-03-31 Thread Oystein Grovlen - Sun Norway
Xavier Hanin wrote: On 3/31/07, *Øystein Grøvlen* [EMAIL PROTECTED] I'm using version 10.2.2.0 http://10.2.2.0. There have been some fixes in this area lately (see DERBY-1610), and I will try your test case on the development trunk later today. Ok, thanks a lot. I tried