Thanks for the pointer. It turns out I overlooked this documentation. I
was reading the pdf file, and only saw the overview of the data types, and
the assignability matrix.
I guess I'll have to test my values for legal range before inserting into
the database. It's unfortunate that there's
Jim Newsham <[EMAIL PROTECTED]> writes:
> In the meantime, I'd like to ask. Should Java float always be safely
> settable to a field of Derby type REAL? This has been my assumption all
> along, and refderby.pdf seems to imply this. Or, are there edge cases, such
> as perhaps NaN which will caus
hi kristian
the command finished/aborted after about 80 minutes with the following message:
Log operation null encounters error writing itself out to the log stream, this
could be caused by an errant log operation or internal log buffer full due to
excessively large log operation. SQLSTATE: XJ0
hi kristian
> 1. How is the data inserted into your database?
i'm using hibernate (autocommit off). i think it tried and failed to insert the
same row over and over again (because of my program logic) but the string in
one column was too long to be inserted (or so)... could this cause this issue
> > hi all
> >
> > i've just recognized that drop table does not delete .dat files. is
> > this a feature or a bug? google did not help to answer this question
> > ;-(
>
> Hi Fabian,
>
> Are the dat files still there after you have performed a shutdown of the
> database? (DriverManager.getConnec
I found the replies to my query interesting. I guess I need to ask my
son why he favours SQLite. I much prefer to stick with a Java-based
solution as writing academic software on the Mac it has to be cross-
platform, and I was unaware - and found it heartening - that Sun's
JavaDB was an impl
Dag H. Wanvik wrote:
I think this code is old DB2 compatibility code, which could possibly be
lifted now. Does anyone know?
IMHO this limitation should be lifted.
Thomas
--
Thomas Nielsen
Given, Derby is an independent Apache product, i do not see a reason
keep this restriction.
Dag H. Wanvik wrote:
Hi Jim,
I found the following code in Derby, which may be the issue:
normalizeREAL checks the validity of the given java float that
it fits within the range of DB2 R
Personally, I think there's no comparison between Derby and SQLite.
Derby's an actual database with "all" the bells and whistles, but still
a really compact size. SQLite is an extremely fast database-like system
with a much smaller subset of features and SQL compliance. Plus, if
you're writing in J
Bernt M. Johnsen wrote (2007-10-31 09:48:14):
> Hi,
>
> Soumen Saha wrote (2007-10-26 22:36:19):
> > DELETE FROM QUIZ_OPTIONS_INFO WHERE OPTION_TEXT IN ('',null);
> >
>
> This statement is strictly not allowed in SQL since the data type of
> null is not determinable. Yo
Hi,
Soumen Saha wrote (2007-10-26 22:36:19):
> DELETE FROM QUIZ_OPTIONS_INFO WHERE OPTION_TEXT IN ('',null);
>
This statement is strictly not allowed in SQL since the data type of
null is not determinable. You should write something like
DELETE FROM QUIZ_OPTIONS_INFO WHERE OPTION_T
11 matches
Mail list logo