This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Connecting to CA-IDMS via JDBC drivers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connecting to CA-IDMS via JDBC drivers " Watch "Connecting to CA-IDMS via JDBC drivers " New topic

Connecting to CA-IDMS via JDBC drivers

jonathan pilling

Joined: Jul 24, 2008
Posts: 4
Hi there

I know that I can connect to an IDMS DB using JDBC type 4 drivers, but I have a few questions:

Is this the process:
- Set up the IDMS system to allow JDBC connections - defining TCP/IP lines etc.
- Install CA-IDMS Server on client PC
- Try to establish connection.
- Use JDBC driver in web page programming to connect to DB (similar to mySQL and ODBC?) and retrieve data from the IDMS-> display it on the webpage.

Is that overview correct, or have I got it totally wrong?

Here is the diagram of how it works:

It shows that connecting the IDMS via TCP/IP to the JDBC Type 4 driver requires either a Java Platform (does this mean Windows, linux etc) or a Java Client.....what do those mean? How does it work?

If anyone could help clear this up I would be very grateful.

Kind regards
I agree. Here's the link:
subject: Connecting to CA-IDMS via JDBC drivers
Similar Threads
PA #1.....picture association
JDBC Driver for Oracle RDB
Regarding Oracle thin and thick drivers
Help: Connecting Tomcat to CA-IDMS Using JDBC Type 4 Drivers (JNDI / IDMSDataSource)