I have an ODBC-Driver under Linux running. Now I need a connection from
java to the Database.
I will use the java-odbc-bridge to connect to the server. But i get the
following error:

If I do the following:
           String cmd = "INSERT INTO Orders(Id, CompilationTitle,
Template, PurchaseDate, RecievedPayment, CompilationDate, TotalCost,
TotalLength, Customer_Id) VALUES(Orders_sequence.nextval, ";

I am using JDBC to connect to a MySQL database. The database has a table
'customer' with a primary key that is automatically generated by my
program. There is another unique key (customerID) which has to be
entered by the user. When the user chooes a value for customerID that is

Does anyone know how to query the database within a java to display a
list of users who have connections to the database?

Ok, I have a prototype running, or I should say crawling, to copy data from
an MS Access database over to an MySQL database.  I'd already set up the
tables and indeces, and was using a Java program to select all of the
contents from each table in the Access DB and insert each row ...

i recently made a project in JSP and use MySQL as its DBMS, now the
project is complete and i have to copy it from my PC to the PC on which
we will give the presentation, but when i try to copy MySQL data from
my PC to my friend PC i face some problems,

Could some one help me out with this Q?
If I designed a db (MySQL or PostgreSQL) & it contained more than 5+
million users with all unique user names... how can I speed up db
access ...etc to search a new users name if it has already been taken?

Here goes my requirement . I hava a set of tables in Database , which
will be accessed by my application frequently . My application has to
answer a lot of queries and that too a lot faster for which the
database is not able to cope up with. So Iam in need to store all the

Answer is propably simple, but I'm struggling and can't solve this
problem. I have two tables:
Table GARMENT
STYLE_NO    DESCRIPTION    LABOUR_COST    NOTIONS

I am unable to update a record using sql statement in java. The
variable numUpdated returns 0, so I think something is wrong with my
code. The objective on thiis numUpdated variable was to return the
number of rows changed. Please help!

If anybody knows how to connect my MIDlet to database MsAccess? What I
have to do?
megi

I am just tired about this error, i don't know how to fix it....
I get the error:
java.sql.SQLException: null,  message from server: "#HY000Host
'localhost.localdomain' is not allowed to connect to this MySQL server"

Does anyone know cloudscape database size limitation? Any documentation
states the relation between cloudscape database size and performance?

    I have a web-apps that sends unicode data to my servlet. I can save it
ot he MS SQL server and when I read it using JDBC client (Squirrel), I
can see the unicode correctly in the DB.
I use Hibernate to read/write to the DB.

JRower is a tool for loading relational database tables from flat
files. It is useful in situations where your database table undergoes
periodic refreshes from an Excel spread sheet or other data file. You
supply a XML file describing the fields in the file and their mapping