Newbe here.  I'm unable to connect via JDBC using OpenOffice 2.2.1
Base to an Informix 7.01 UC1 std edition database.  My Classpath is
correct and passes the connection test.  Using a known good user name/
password to a known good database fails with "Database not found or no

Maybe my question is stupid and wrong but I hope that you will understand.
So, image that you need to create web application which will used by many
peoples in one LAN. They processing some documents and every person has the
particular number of documents in particular order (1. ...

I have a problem when I want to sort entities (order by) by
a boolean field.
TopLink throws following exception:
...

My application is a Java program using the Spring JDBC framework. For
a connection pool, I'm using the
org.apache.commons.dbcp.BasicDataSource class.
I have several complex queries that take 500-1000 milliseconds to run.

I'm trying to add support for Apache Derby to a piece of software that
already has support for Oracle, SQL Server and MySQL.  There is a lot
of DB specific coding involved to get the best performance possible.
Several of these queries involve checking to see if a nested query

I am currently adding Derby support to an application that already has
support for multiple DBMS via JDBC.  I have found it to be
significantly slower than SQL Server or MySQL when performing the same
task.  To provide this, I have created an exact duplicate database

I'm pleased to announce the beta availability of SQLfX (SQL for XML).
SQLfX is a brand new paradigm for database access to XML. It uses the
[often unrecognized] hierarchical operations built into SQL92 to bring
power and scalability to XML query and manipulation. SQLfX is a next

???

This is more of a general database question, not specific to Java, but
can someone describe an actual realistic use of outer joins?  I'm
familiar with how it works, and some trivial examples, but I'm frankly
unsure of why you'd actually need to use it.

I'm trying to insert a values for a CLOB column in a portable way. So far using
PreparedStatement.setCharacterStream() together with a Reader to read the CLOB
contents from a local file was working quite well (with various JDBC drivers).
Now I stumbled across a bug in my code that ...

Currently I have a fairly large SQL table. Half way through it is an integer
field that I'm using to represent 5 checkboxes on a JSP form. The reason I
used a single INTEGER instead of many BIT fields is I could well be adding
more checkboxes later, and I don't really want to see ...

when I am trying to use ojdbc1.4 with Oracle 10g express the jvm is
crash I use java 1.6 update 2
the message is :
#

Is there a possibility to get estimated rows count for asynchronous
cursors through JDBC?

I have severe performance problem with compilation of sql-queries. So
I wanted to ask, if there is another better way to create our queries
to avoid many compilations:
I must to notice that I DO use PreparedStatement.