On Fri, 2003-03-07 at 16:13, Svetozar Radojcin wrote:
>
> Q 1: What I should to do, in order to insert row in a db table which
> contains DATE column (for example) ?

You can insert dates as strings. Firebird will do the conversion for
you. Should work for most apps. You may have to play with the format,
but that should not be a big problem. By formatting I mean something
like 1/1/2003 or 2003-1-1.

To the others on the list,

Is there any benefit to say using setDate as opposed to setString, or
setLong instead of setString.

Simply is there any benefit to passing the exact data format stored in a
column?

For some I specify, but for the most part I just use strings, and have
not run into any problem so far. At least none that I am aware of.

> Q2: (more complicated): how I can to 'explain' that, in a way, which my
> J2EE server can 'understand'
> (he uses PreparedStatement) ?

I think this will be handled since you should be able to insert a string
with a PreparedStatement. Unless the EJB will only call the setDate
function?

> Q3: (more important) : Whether exists a 'real' JDBC driver (other than
> interClient & JayBird) for the Firebird/Interbase RDBMS , which really
> implements a full set of JDBC 2.0 methods ?

I think there has been some discussion recently about a JDBC 2.0
compliant driver. Look in the archives for the past day or two.

--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone 707.766.9509
Fax 707.766.8989
http://www.obsidian-studios.com