I have a little problem with Toplink:
I have a table in Oracle DB:
table T1 {A: integer, B: integer, C: integer}.
I want to have following mapping:

  I am trying to insert my file content to the Mysql 5.0, i am trying
to insert 1000 files, but when inserting some of the file, i got an
exception, why?
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for

I cannot seem to figure this out. When I use a PreparedStatement, I get
a SQLException. If, rather, I just replace the variable and use
Statement, it works just fine. I am trying to run against ODBC to an
Access db. I've tried searching the web, but see little, out of the

What have been done:
-------------------------------
installed jdbc driver for ms sql server 2000;
found a sample / edited it to form some java code for testing

What would be the best method of getting data from a Resultset that
has multiple joined tables?
Example
select

Is it a practise to make the connection on application initialisation
(talking about jsp, servlet type app.), so you don't make connections every
time you query database, you have it all the time, and then just grab it
from app. scope/context and execute Statements?

I am using
JAVA VERSION :- 1.4.03
OS:-WINDOWS XP PROFESSIONAL SP2
ORACLE 9I DATABASE

bonjor tout le monde
j'essaye de me connecter à une base de données oracle installée sur
un serveur solaris à traver un programme
java et bien sur le jdbc aprés exécussion du programme le message

I once used an application that you run and it tells you if the driver
is odbc 1,2 or 3 compliant. I cannot recall which application this was.
Does anyone have any idea of an application that tells you if the
driver meets certain odbc compliancies?

I've run into this issue multiple times with no solution yet.
For different reasons, the connection between the java application and
the oracle server may drop. This can happen because the network
interface was stopped and started or because of a firewall.

I wrote a simple java program, where a Connection is created at the
beginning, and than is used to make queries to an Oracle DB (let me say
"a very very primitive connection pool").
When I run this program on a PC with only one ethernet card and

We are having problems with instance aliasing in our application.  I
was hoping that the secondary cache would fix the problem.  But alas it
doesn't.  Basically we create an object A and store it.  Another piece
of code in the same JVM does a query and finds object A and

I have some newbie's questions. I use some applications where there are
two techniques handling with concurrent access do DB:
- Multi-Read-Single-Write Lock
- transactions based on JDBC

I am trying to use Attinuty connect driver for JDBC to access data in
the Oracle RDB database. I have to use this driver as my company uses
Attunity as the middleware. Can anybody tell me how/where I can
download this driver (or give any link)? I know Attunity.com should

Oracle DB 9.2.0.1.0
Oracle9i 9.2.0.8 JDBC Drivers For use with JDK 1.4
The Problem is that I get a sql.exception ORA-00955 when trying to
create a Table and insert records.