I have a php application on a Microsoft IIS server that can currently
connect and execute many queries to my MsSQL server. Unfortunately,
there are a few tables I need to serve that I'm thinking are just too
big for php/odbc.

I am currently looking for an SQL parser written in Java, preferably
with source code. What I want to do is to infer (as far as possible)
the schema from an SQL DML statement. The parser should give me some
nice, traversable Java object tree/abstract syntax tree.

Hi this is really not a Java specific question but more in regards to OO
design in general.  I have an application which has access to multiple
tables in a database and a multitude of different SQL statements for
manipulating the many tables and retrieving data from them.  The ...

I'm retrieving a Connection to an Oracle Database from a connection pool
defined in a portal. In my gui, I have to display some information about the
system the user is connected to.
Is there any way to get the connection url or the Oracle SID from the

When i use Derby with MyEclipse,there is some problems,as following:
  Caused by: java.lang.SecurityException: class
"org.objectweb.asm.CodeVisitor"'s signer information does not match
signer information of other classes in the same package

I need to have a portable global sequence generator that works
regardless of database engine used. For example, Postgres have
sequence, mssql doesn't, but I need sequence for both. I tried to
create one, uzing SERIALIZABLE transactions, but under the increased

selectedName = request.getParameter("Combo Box");
statement.executeUpdate("delete ID,PHONENAME from PHONE where
ID=(select ID from PHONE WHERE PHONENAME= +selectedName ) " );
I want corect code for deletind data from database(SQL);

I have a Date insert that is formatted into an Oracle 9i database and
it works.
But I had to make the Date variable a varchar2 in Oracle to get it to
work:

(AP) Increasingly application developers are required to include
flexible and extensible reporting options within their core product
sets. This is not only being driven by CIO's, who rank Business
Intelligence in the top 3 of priorities, but also their end users -

Is this a good way to insert and update into an Oracle database or is
there anything I can improve?
public class Sports
{

I got an error, when i tried to connect mysql with java. Any
suggestions ?
Thank you.
                                                 Bug Report

I had earlier posted the same problem I am having on
comp.java.lang.programmer earlier and someone suggested this post
would probably fall better under this group. Here is the link to the
original post with the original post copy pasted below.

     I hava a problem about speed of database enquiry.
     Problem:
            It's a B/S application. Now I hava a database enquiry.
The statement stmt.executeQuery(sSQL) used long time(about 30s). The

what if any are the recommended ways of accessing a database using jdbc from a
c++ application?
I have a large c++ app suite with a database layer that may need to change how
it accessed a variety of db's, so I thought I would find out if it was

I am trying to get an SQL statement to check that the users ID and the
ID row in a table match. There maybe up to a hundred users using the
database.
I have two tables in SQl Server express - Users and Property1 both