JDBC and PHP. How does it work, and are there any limitations?
At present, our I.T. department are exploring different methods of connecting to our IDMS database via the internet.
We have realised that we could use an alternative to ODBC drivers to connect to our IDMS database. The alternative is JDBC Type 4 drivers. If we have to use ODBC drivers, it means we are going to have to set up a lot of new software on our mainframe which will be a lengthy process.
If we use JDBC, we may be able to establish a connection with our IDMS database a lot sooner than if we were to use ODBC. It all depends upon the pros and cons of both ODBC and JDBC.
So, can JDBC be connected to through PHP, ASP, etc.........or does it have to be connected to via JSP and Java? Will using JDBC limit which scripting technologies we can use? If connecting to JDBC via PHP, ASP etc is possible, is it a tricky process? Or is it relatively straight forward? What does it involve?
Will using JDBC limit what kind of applications we can build? Or is it just as flexible as ODBC?
We don't want rush ahead and implement the use of JDBC without checking with first. Even though it may be quicker to set up JDBC initially, there may be complications that pop-up further down the line that some of you may be aware of?
Also, the way that we set up the connection to our database mentions these 3 possible routes:
1) TCP/IP connects to the Type 4 JDBC driver, which resides on the Java Platform.
2) Type 4 JDBC driver connects to a servlet, which connects to web server (these also reside on the Java Platform)
3) The web server then connects to an applet on the browser client.
When it says any Java Platform, does this mean Windows, Linux etc? And then where it says it connects to an applet on the browser client, does that mean it connects to the internet browser? I am a little confused.
Another route is as follows:
1) TCP/IP connects to the Type 4 JDBC driver, which resides on the Java Client.
2) The Type 4 JDBC driver then connects directly to the applet, which also resides on the Java Client.
What is a Java Client?
The final route is using JDBC type 3 drivers. It says that to use these drivers, we must have a JDBC Server which is located on the Java Platform. It connects this way:
1) TCP/IP connects to the JDBC server, which resides on the Java Platform.
2) The JDBC server connects to the Type 3 JDBC driver, which resides on the browser client.
3) The type 3 ODBC driver then connects to an applet on the browser client.
I am so stumped by all this. Can anyone help clarify all this for me???