Connecting to DB2 with JRun4
rshanmugam
We have JRun4 product running under Windows 2000. I'm trying to connect to
DB2 UDB 8.1 running on the mainframe (Z/OS 1.07). I've configured JRun4 JMC
for the following JDBC datasource:
JNDI Name : jdbc/DB52
Driver Class Name : macromedia.jdbc.db2.DB2Driver
URL :
jdbc:macromedia:db2://xxx.xxx.xxx.xxx:5005;LocationName=NETSNDB52;CollectionId=N
ULLID;PackageName=JDBCPKG;CreateDefaultPackage=FALSE
When the server starts up, I get the following information on the console:
Starting Macromedia JRun 4.0 (Build 106363), lts server
08/24 09:12:35 info JRun Naming Service listening on *:2908
08/24 09:12:35 info JRunDataSource bound to JNDI under name jdbc/DB52
08/24 09:12:35 info JRun DataSourceService: Created JDBC XA Connection Pool
named DB52
08/24 09:12:35 info Bound a LinkRef from "DefaultDataSource" to the default
DataSource "jdbc/DB52"
08/24 09:12:35 info JRun Web Server listening on *:8400
08/24 09:12:36 info Deploying enterprise application "JRun 4.0 Internal J2EE
Components" from: file:/D:/JRun4/lib/jrun-comp.ear
08/24 09:12:36 info Deploying EJB "JRunSQLInvoker" from:
file:/D:/JRun4/lib/jrun-comp.ear
08/24 09:12:36 info Deploying enterprise application "Flash Remoting EAR"
from: file:/D:/JRun4/lib/flashgateway.ear
08/24 09:12:36 info Deploying web application "Flash Remoting" from:
file:/D:/JRun4/lib/flashgateway.ear
08/24 09:12:36 user JSPServlet: init
08/24 09:12:36 user FlashGatewayServlet: init
08/24 09:12:36 info Deploying web application "lts" from: file:/C:/lts.war
08/24 09:12:37 user JSPServlet: init
Server lts ready (startup time: 9 seconds)
When the application is ready to make the connection I get the following error
message:
Error::us.nc.state.dot.database.SqlExecutor:@20304267[Wed Aug 23 15:43:34 EDT
2006]
SQLException while attempting to connect: java.sql.SQLException:
[Macromedia][DB2 JDBC
Driver]Bind process is not active. Please ensure that the user has permissions
to
create packages. Packages cannot be created in an XA Connection.
java.sql.SQLException: SQLException while attempting to connect:
java.sql.SQLException: [Macromedia][DB2 JDBC Driver]Bind process is not active.
Please ensure that the user has permissions to create packages. Packages cannot
be created in an XA Connection
Here are my questions:
1) Does the macromedia DB2 driver support DB2 UDB 8.1 running on the
mainframe Z/OS?
2) Does the macromedia driver internally creates the DB2 package "JDBCPKG"
while creating connection or the DBA has to create the package manually?
3) Is the DB2 package name "JDBCPKG" valid? If not, what is the correct value
for "PackageName" parameter on the connection string?
4) The error message on the console indicates that the Packages cannot be
created in an XA Connection. How can I turn off the XA connection? Is there
any other type of connection?
5) How do I configure the Datasource correctly to get it working with the
Macromedia driver?
I'd earlier tried to use IBM DB2Connect driver to connect to DB2 database, but
it failed. I'm not sure on the parameters for the Datasource connection
string. The following are the JMC configuration data for IBM DB2Connect driver:
JNDI Name: jdbc/DB52
Driver Class Name : COM.ibm.db2.jdbc.app.DB2Connection
URL: jdbc:db2
The DB2Connect product is configured correctly to go to DB52 database. I'm
able to connect to the DB2 database thru' DB2Connect screen (using Test
Connection). But our application did not connect to database from both
drivers. If someone has successfully used either driver to connect, please let
me know what the parameters are and what you did to get it working?
Thanks
Ravi Shanmugam