Dreamweaver jsp / Websphere / DB2

[hjb2]

:confused; My WebSphere connections are working fine when testing. However,
how do I tell my dreamweaver site to use the WebSphere connectivity settings
instead of having to set the driver connectivity up in the dreamweaver wizard
that pops up when inserting or using database objects? Thanks. Lynne

[Chris In Madison]

hmmm... That's a tough one. Dreamweaver tends to do its own thing when it
comes to connecting to databases. I'm not so sure there's going to be an
easy way for you to do this and harness the data manipulating and formatting
functions that come with the core product.

That's kinda why Dreamweaver isn't the perfect Java development tool. It
tends to do things way out of the norm for typical Java development. Sorry
I don't have any great ideas for you... :-(

Greg? Any ideas?

Best regards,
Chris

[hjb2]

I am also having trouble connecting to DB2 OS/390 directly using these
variables..... String MM_mainframe1_DRIVER = 'COM.ibm.db2.jdbc.app.DB2Driver';
String MM_mainframe1_USERNAME = ' '; String MM_mainframe1_PASSWORD = '
'; String MM_mainframe1_STRING = 'jdbc:db2://host:port/database'; Is this the
correct driver for mainframe DB2 connections.? Thanks. Lynne

[Chris In Madison]

Not sure since I've never had to connect to DB2 before. First thing that
comes to mind is that COM shouldn't be capitalized. But it depends on what
the docs for the driver say.

Also, unless you're just putting this in for question-asking purposes,
you'll need to provide the host, port, and database name of the object
you're attempting to connect to.

Are you getting any specific errors you'd like to share?

Best regards,
Chris

[hjb2]

Thanks for the updates. I finally got my code to connect on the linux
machine.....however, it will not using the dreamweaver tool...Is there an
updated dreamweaver that allows OS/390 DB2 connection? I used the driver
provided with DB2Connect to connect on the linux machine; however, dreamweaver
gives the error message 'An unidentified error has occurred'...... I would
rather not switch tools because I really like and have been using Dreamweaver
for quite a while....

[hjb2]

By the way, I am using the hardcoded connections that Dreamweaver usually likes for my connections even though Dreamweaver does not work......not the WebSphere settings....Please advise

[Chris In Madison]

I chatted with one of my co-workers who has experience with DB2 on the 390,
and there's a possibility that this is a Type I native DB2 driver. If
that's the case, then it may not work on your Windows machine (presuming
you're developing on Windows here) since it was designed to work on the 390.
He thinks that if you were to install the DB2 client on your Windows
machine, however, that there would be a Windows native version of the driver
that might work in the /bin directory. He also suggests that if you find a
Type IV driver for DB2, then it should work because Type IV drivers work
over IP regardless of platform.

One other thing that pops into my head is the driver location for your DB2
connection. If you take a look at the connection properties you created for
the DB2 data source (once again, this presumes Windows), there are two radio
buttons: "Using Driver on Testing Server" and "Using Driver On This
Machine". Which do you have selected? I'd suggest the "testing server"
option. The way Dreamweaver uses database connections with the "this
machine" option is that it queries the database directly from your Windows
machine over IP. If there's a mismatch in drivers between your machine and
the server, then you could see the errors that you're experiencing. If you
use the "testing server" option, Dreamweaver FTPs a small javascript file to
the server, then it executes the script there, querying the data source
using the drivers on the server itself, thus minimizing the chance of a
conflict. It then ships back the data over HTTP, and Dreamweaver consumes
that data and creates your bindings and what-not.

I hope there's something useful for you here :-)

Best regards,
Chris