Subject Re: [IB-Java] Time for an alpha for the all java jca-jdbc driver?
Author David Jencks
On 2002.01.03 18:33:12 -0500 Paulo Gaspar wrote:
> > I think type conversions are not yet complete.
>
> I have a load of type conversion code. (Actually a package.)
>
> If you tell me more about what is missing and/or where I should look
> for the type conversion code I can see if what I have is adequate.

I think the type conversion is pretty simple to do, you just have to handle
all the cases. I'd actually like to refactor the code so there is a class
for each Firebird native type, that can handle conversions to/from all
appropriate java types. Roman did some work that might be related to this
a while back but it never got put in and I don't know how relevant it still
is. I think the type conversion code is currently in FBResultSet.
>
>
> Have fun,
> Paulo Gaspar
>
>
> P.S.: If you are still interested on that kind of thing I also have
> a very simple and light logger now together with the common interface
> and wrappers for the JSR-47 + LogKit + Log4J logging APIs. (These
> ones evolved a bit.)

I'm definitely interested but have little time. I don't suppose you'd have
time to integrate this?

Thanks
david jencks

>
>
> > -----Original Message-----
> > From: David Jencks [mailto:davidjencks@...]
> > Sent: Thursday, January 03, 2002 11:55 PM
> > To: IB-Java@yahoogroups.com
> > Subject: Re: [IB-Java] Time for an alpha for the all java jca-jdbc
> > driver?
> >
> >
> > On 2002.01.03 16:59:47 -0500 William Surowiec wrote:
> > > David
> > >
> > > A follow-up on my last msg.
> > >
> > > I receive "sqldata null in writeSQLDatum" msg when one of the
> prepared
> > > parameters does not receive a value (my intent is to force the
> > > corresponding field in the database to null).
> >
> > Do you have a stack trace/line # where the exception originate?
> Setting
> > parameters to null should work.
> > >
> > > Two more observations (not suggesting something is wrong, nor
> requesting
> > > a change in behavior):
> > >
> > > 1) I was setting one parameter within my prepared statements to s
> sqlInt
> > > when in fact the column was a double. I received a sql error message
> > > during execution. This used to pass through the InterClient driver
> > > without any error msg (value automatically converted to a double)
> >
> > I think type conversions are not yet complete.
> > >
> > >
> > > 2) In rebuilding the database I took a different path. Don't know if
> > > this message is unique to this driver: I started a transaction, tried
> to
> > > do something, could not, tried to exit the program - I could not end
> it
> > > because the driver held an open transaction. I had to stop the db
> engine
> > > to reset stuff. A good reminder to check transaction state before
> > > exiting the app.
> >
> > What stopped you from stopping your program??? What messages did you
> get?
> >
> > I'd recommend using try blocks to make sure all your transactions
> > complete,
> > but the result of not doing so shouldn't disable the database. Can you
> > provide a little test code?
> >
> > Thanks
> > david jencks
> > >
> > >
> > > Bill
> > >
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > IB-Java-unsubscribe@egroups.com
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >
>
>
> To unsubscribe from this group, send an email to:
> IB-Java-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
> To unsubscribe from this group, send an email to:
> IB-Java-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>