Re: JDBC and Access relationships
- From: "Bjorn Abelli" <bjorn_abelli@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 11 Jul 2005 02:08:43 +0200
"Sharp Tool" wrote...
> I'm using JDBC to connect to an Access database.
> Do I have to set up relationships before I do joins?
No, you don't.
> I know you have to do it when you do joins in Access.
No, you don't.
> Does this change when your using JDBC?
No, it doesn't.
> Do you write code to do relationships?
You can do that through JDBC by using standard SQL statements for creating
foreign key constraints. If it's *necessary* is another question.
> If you have to do relationships then it seems Access is
> kinda sucky to use JDBC.
As would be with any relational database in that case.
I think you may have confused the database "tool" which is MS Access, with
the actual database engine, which by default is Jet.
The "tool" MS Access can be seen as a fancy graphical interface to the
database, but underneath it, it's a very "simple" database engine, which
though complies to much of the SQL-92 standard syntax.
In that sense, your "problem" with "doing relationships" would exist with
most databases, not only Access/Jet.
// Bjorn A
.
- Prev by Date: oracle/java/frameworks query question
- Next by Date: Re: JSP/Oracle9i: SQLException
- Previous by thread: oracle/java/frameworks query question
- Next by thread: Re: JSP/Oracle9i: SQLException
- Index(es):
Relevant Pages
|
|
