Web tier: servlets, JSP, Web frameworks: JSP \ Serlet connecting to db2 - How To
I'm very new here - So Apologies in advance if I've posted to the wrong forum.
- Posted by: Paul Nicholas
- Posted on: November 28 2005 11:20 EST
I need to read some data from db2 on a mainframe.
I'd like some advice - a where to start - or point me in the correct direction type response.
I have a thin client application that exposes an interface that allows you to call a uri to perform a search or recall data. The help says I can call a JSP or applet.
I want to get some data back from a db2 table on a mainframe. The thick client apps I want to copy use odbc with Neon Shadow as the driver.
There isnt an equivalent driver for jdbc.
The accepted way of connecting here is to use the db2 .net data control and ado.net, but thats no good if Im using Java - so where do I go from here
Im sure this is all very starightforward but I need a hint for where to start looking.
- JSP Serlet connecting to db2 - How To by Christian Spartano on November 28 2005 16:28 EST
- JSP Serlet connecting to db2 - How To by Kit Davies on November 29 2005 06:48 EST
Can you use a jdbc:odbc bridge driver? in that way you can use the Neon Shadow driver.
The Jdbc:odbc driver is not the best for performance, but it will work.
if you're shop is running db2, you should have access to a db2 jdbc driver. this would be preferred over anything else for db2.
hope that helps,
Can you use a jdbc:odbc bridge driver? in that way you can use the Neon Shadow driver.The Jdbc:odbc driver is not the best for performance, but it will work.
Thanks for the comments.
I did think of a JDBC ODBC Bridge but the comments I scanned on this approach in google suggested a bridge wasnt reliable in a server applet.
I really want the Java alternative to the ADO .NET Data provider for DB2 in there is such a thing?
You very definitely need the DB2 JDBC driver. You don't say which DB2 version you are using. If it is the Personal/Cloudscape/Derby version, the driver is here. Otherwise, I would be very surprised if your DB2 distribution doesn't already come with an appropriate driver, being IBM and all that. Check with your DB administrators.
Or maybe no one is supposed to know you're trying to access the DB using Java ;)