I'm trying to connect to a zOS instance of DB2 via the IBM DB2 JDBC
driver, but I'm getting this error:
com.ibm.db2.jcc .b.DisconnectEx ception: The application server rejected
establishment of the connection. An attempt was made to access a
database, I0INTEST, which was not found.
Based uppon the error message and that I can connect to this DB thru
DB2 Connect I believe I have the right host name and port. What am I
missing? I0INTEST is a valid table as I can run a query against it in
DB2 Connect. I'm trying to establish a connection via SquirrelSQL as
well. 8 3758
On Feb 2, 9:17 am, cwhan...@gmail. com wrote:
I'm trying to connect to a zOS instance of DB2 via the IBM DB2 JDBC
driver, but I'm getting this error:
com.ibm.db2.jcc .b.DisconnectEx ception: The application server rejected
establishment of the connection. An attempt was made to access a
database, I0INTEST, which was not found.
Based uppon the error message and that I can connect to this DB thru
DB2 Connect I believe I have the right host name and port. What am I
missing? I0INTEST is a valid table as I can run a query against it in
DB2 Connect. I'm trying to establish a connection via SquirrelSQL as
well.
You shouldn't specify any table name in your connection information.
As the error message says, the connection attempt is interpreting
your 'IOINTEST' string as the database name. The real database name
is what you need to put there.
Joe Weinstein at BEA Systems
I need to make a correction to my problem description. I0INTEST is
the name of the Database.
On Feb 2, 1:30*pm, "joeNOS...@bea. com" <joe.weinst...@ gmail.com>
wrote:
On Feb 2, 9:17 am, cwhan...@gmail. com wrote:
I'm trying to connect to a zOS instance of DB2 via the IBM DB2 JDBC
driver, but I'm getting this error:
com.ibm.db2.jcc .b.DisconnectEx ception: The application server rejected
establishment of the connection. *An attempt was made to access a
database, I0INTEST, which was not found.
Based uppon the error message and that I can connect to this DB thru
DB2 Connect I believe I have the right host name and port. *What am I
missing? *I0INTEST is a valid table as I can run a query against it in
DB2 Connect. *I'm trying to establish a connection via SquirrelSQL *as
well.
You shouldn't specify any table name in your connection information.
As the error message says, the connection attempt is interpreting
your 'IOINTEST' string as the database name. The real database name
is what you need to put there.
Joe Weinstein at BEA Systems
cw******@gmail. com wrote:
I need to make a correction to my problem description. I0INTEST is
the name of the Database.
On Feb 2, 1:30Â*pm, "joeNOS...@bea. com" <joe.weinst...@ gmail.com>
wrote:
>On Feb 2, 9:17 am, cwhan...@gmail. com wrote:
I'm trying to connect to a zOS instance of DB2 via the IBM DB2 JDBC
driver, but I'm getting this error:
com.ibm.db2.jcc .b.DisconnectEx ception: The application server rejected
establishment of the connection. Â*An attempt was made to access a
database, I0INTEST, which was not found.
Based uppon the error message and that I can connect to this DB thru
DB2 Connect I believe I have the right host name and port. Â*What am I
missing? Â*I0INTEST is a valid table as I can run a query against it in
DB2 Connect. Â*I'm trying to establish a connection via SquirrelSQL Â*as
well.
You shouldn't specify any table name in your connection information. As the error message says, the connection attempt is interpreting your 'IOINTEST' string as the database name. The real database name is what you need to put there. Joe Weinstein at BEA Systems
From my dim and distant recollections of DB2 on Z/OS a database resides
inside a DB2 subsystem and you connect to the subsystem. Is IOINTEST a DB2
Database or a DB2 subsystem?
Colin
Firstly what type of JDBC driver are you using (Type2 / Type4)? Have
you tried to take a jcc trace to find out where the error is coming
from?
Cheers,
On Feb 6, 3:36 am, Colin Booth <colinsbo...@gm ail.comwrote:
cwhan...@gmail. com wrote:
I need to make a correction to my problem description. I0INTEST is
the name of the Database.
On Feb 2, 1:30 pm, "joeNOS...@bea. com" <joe.weinst...@ gmail.com>
wrote:
On Feb 2, 9:17 am, cwhan...@gmail. com wrote:
I'm trying to connect to a zOS instance of DB2 via the IBM DB2 JDBC
driver, but I'm getting this error:
com.ibm.db2.jcc .b.DisconnectEx ception: The application server rejected
establishment of the connection. An attempt was made to access a
database, I0INTEST, which was not found.
Based uppon the error message and that I can connect to this DB thru
DB2 Connect I believe I have the right host name and port. What am I
missing? I0INTEST is a valid table as I can run a query against it in
DB2 Connect. I'm trying to establish a connection via SquirrelSQL as
well.
You shouldn't specify any table name in your connection information.
As the error message says, the connection attempt is interpreting
your 'IOINTEST' string as the database name. The real database name
is what you need to put there.
Joe Weinstein at BEA Systems
From my dim and distant recollections of DB2 on Z/OS a database resides
inside a DB2 subsystem and you connect to the subsystem. Is IOINTEST a DB2
Database or a DB2 subsystem?
Colin
I'm using a type 4 driver. this is the version from the jcc trace:
[ibm][db2][jcc] Driver: IBM DB2 JDBC Universal Driver Architecture
2.10.27.
I admit I'm somwhat new to JDBC and definitely new to DB2. I trying
to connect to zOS instance of DB2 from Windwos & I do not have DB2
Connect installed on this PC. You do not need DB2 Connect with a type
4 driver. Correct?
On Feb 5, 3:50*pm, "db2st...@gmail .com" <db2st...@gmail .comwrote:
Firstly what type of JDBC driver are you using (Type2 / Type4)? *Have
you tried to take a jcc trace to find out where the error is coming
from?
Please contact me. I'd like to send you a test program.... to see
where/what the issue is.
Cheers,
On Feb 6, 10:39 am, cwhan...@gmail. com wrote:
I'm using a type 4 driver. this is the version from the jcc trace:
[ibm][db2][jcc] Driver: IBM DB2 JDBC Universal Driver Architecture
2.10.27.
I admit I'm somwhat new to JDBC and definitely new to DB2. I trying
to connect to zOS instance of DB2 from Windwos & I do not have DB2
Connect installed on this PC. You do not need DB2 Connect with a type
4 driver. Correct?
On Feb 5, 3:50 pm, "db2st...@gmail .com" <db2st...@gmail .comwrote:
Firstly what type of JDBC driver are you using (Type2 / Type4)? Have
you tried to take a jcc trace to find out where the error is coming
from?
cw******@gmail. com wrote:
I'm using a type 4 driver. this is the version from the jcc trace:
[ibm][db2][jcc] Driver: IBM DB2 JDBC Universal Driver Architecture
2.10.27.
I admit I'm somwhat new to JDBC and definitely new to DB2. I trying
to connect to zOS instance of DB2 from Windwos & I do not have DB2
Connect installed on this PC. You do not need DB2 Connect with a type
4 driver. Correct?
On Feb 5, 3:50 pm, "db2st...@gmail .com" <db2st...@gmail .comwrote:
>Firstly what type of JDBC driver are you using (Type2 / Type4)? Have you tried to take a jcc trace to find out where the error is coming from?
Double check the DCS entry on your DB2 Connect installation (db2 list
dcs directory) and make sure your providing JCC the "Target database
name" and not the local database alias. db******@gmail. com wrote:
Please contact me. I'd like to send you a test program.... to see
where/what the issue is.
Cheers,
On Feb 6, 10:39 am, cwhan...@gmail. com wrote:
>I'm using a type 4 driver. this is the version from the jcc trace:
[ibm][db2][jcc] Driver: IBM DB2 JDBC Universal Driver Architecture 2.10.27.
I admit I'm somwhat new to JDBC and definitely new to DB2. I trying to connect to zOS instance of DB2 from Windwos & I do not have DB2 Connect installed on this PC. You do not need DB2 Connect with a type 4 driver. Correct?
On Feb 5, 3:50 pm, "db2st...@gmail .com" <db2st...@gmail .comwrote:
Firstly what type of JDBC driver are you using (Type2 / Type4)? Have
you tried to take a jcc trace to find out where the error is coming
from?
Talk to your Z/OS DBA. They will be able to tell you what you need to do. It
is quite common for names of 'databases' and 'instances' to be given alises
in DB2 connect or on DB2 clients. You need to know what is defined on Z/OS.
You also need to know if the security system (RACF or equivalent) will let
you in.
Colin This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Axel Dachtler |
last post by:
Hello,
my Java-program can't load the JDBC driver.
I always get a java.lang.NoClassDefFoundError when I run it.
The JDBC Driver is in the directory: C:\programs\ora92\jdbc\lib
I think I have to set ORACLE_HOME environment variable and CLASSPATH,
but I have no idea how ?????????
|
by: sridhar nagabhurshana |
last post by:
hello
I am trying to connect to mysql database using connector/J jdbc driver
this is my code
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
|
by: Priya |
last post by:
Hi,
I am having some problem with DB2 Universal JDBC driver.
1. The method getColumnType(columnNumber)of ResultSetMetaData always
returns zero.
2. The method getColumnDisplaySize(ColumnNum) raises an exception,
with exception message - not supported.
Version of DB2 - 7.1
|
by: Dani |
last post by:
Hi everyone
Description of the problem:
Using a PreparedStatement to write down an integer (int) plus a
timestamp for testing purposes. When read out again the integer looks
very different. We found that it was shifted three Bytes to the left,
i.e. 4 becomes hex 4000000 which is 67108864 in decimal base. This
means that the value written and the value read sometimes do not
match, which is of course inacceptable for all real world...
|
by: Bing |
last post by:
Hi,
I am configuring the same DB2 v8.1 JDBC universal driver (db2jcc.jar
and db2jcc_license_cisuz.jar) from DB2 SP5 fix pack under WSAD 5.1.x
environment and WebSphere application Server 5.0.2 on Windows 2000
machines. I configured a connection pool data source using type 4 for
a local test environment in WSAD 5.1.x, and a connection pool data
source on the WebSphere Server too. Both data sources are accessing
the same database.
| |
by: Raquel |
last post by:
Read this about the Universal JDBC Driver....
"In a Type 2 mode, the Universal JDBC driver provides local
application performance gains (because it avoids using TCP/IP protocol
to communicate to the DB2 server). "
Wht does it mean by "local" application performance? In type 2 mode,
it is a pre-requisite that all the databases that the application
running at the client need to be cataloged (through CCA or otherwise)
on the client; Most...
|
by: Kris Jurka |
last post by:
The JDBC driver has been moved out of the main source tree to a gborg
project. This change will only affect new major releases. The 7.4 series
will continue to be maintained in the main tree. The impact on the
average user depends on how you got your .jar file.
If you downloaded a binary version from http://jdbc.postgresql.org/
then you will see no change. This website will remain the official place
for distributing the driver and...
|
by: Dino Nardini |
last post by:
Hey folks,
I'm currently evaluating an upgrade path from our current ColdFusion 5 /
PostgreSQL setup to ColdFusion MX / PostgreSQL. In the current setup,
we're using the Merant ODBC driver for postgres.
I've installed Fedora Core 2 with Apache 2 and ColdFusion MX, and I grabbed
the latest JDBC driver from the postgres website.
I copied one of our production websites over to the test box, but ran into
|
by: raj singh |
last post by:
Hi,
i am raj singh.I am using type 4 jdbc driver with db2
but its not working its giving the message "required user
property not set". the environment variable is set properly
with jar files which required for type 4 jdbc driver.
if anybody know about this problem pls provide the details.
how i can resolve this problem.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |