473,770 Members | 5,862 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

db2 jdbc trace ....

UDB PE 8.1 on Win XP.

Per the manual:

DB2 JDBC traces always begin with a header that lists important system
information such as key environment variable settings, the JDK or JRE
level,
the DB2 JDBC driver level, and the DB2 build level. For example:
1 =============== =============== =============== ===========
2 | Trace beginning on 2002-1-28 7:21:0.19
3 =============== =============== =============== ===========
4 System Properties:
5 ------------------
6 user.language = en
7 java.home = c:\Program Files\SQLLIB\ja va\jdk\bin\..
8 java.vendor.url .bug =
9 awt.toolkit = sun.awt.windows .WToolkit
10 file.encoding.p kg = sun.io
11 java.version = 1.1.8
12 file.separator = \
13 line.separator =
14 user.region = US
15 file.encoding = Cp1252
16 java.compiler = ibmjitc
17 java.vendor = IBM® Corporation
18 user.timezone = EST
19 user.name = db2user
20 os.arch = x86
21 java.fullversio n = JDK 1.1.8 IBM build n118p-19991124 (JIT ibmjitc
V3.5-IBMJDK1.1-19991124)
22 os.name = Windows® NT
23 java.vendor.url = http://www.ibm.com/
24 user.dir = c:\Program Files\SQLLIB\sa mples\java
25 java.class.path =
..:C:\Program Files\SQLLIB\li b;C:\Program Files\SQLLIB\ja va;
C:\Program Files\SQLLIB\ja va\jdk\bin\
26 java.class.vers ion = 45.3
27 os.version = 5.0
28 path.separator = ;
29 user.home = C:\home\db2user
30 ----------------------------------------

However, the JDBC trace that my application procuces does NOT have the
above header information; it just has the actual trace information.
Following are the first few lines from the trace:

jdbc.app.DB2Dri ver -> DB2Driver() (2004-06-17 12:27:19.437)
| Loaded db2jdbc from java.library.pa th
| DB2Driver: JDBC 2.0, BuildLevel: s030728
jdbc.app.DB2Dri ver <- DB2Driver() [Time Elapsed = 0.0] (2004-06-17
12:27:19.437)

DB2Driver - connect(jdbc:db 2:SAMPLE)

jdbc.app.DB2Con nection -> connect( SAMPLE, info, DB2Driver: JDBC 2.0
s030728, 0, false ) (2004-06-17 12:27:19.452)
| 10: conArg =
| 10: connectionHandl e = 1
jdbc.app.DB2Con nection <- connect() [Time Elapsed = 0.235] (2004-06-17
12:27:19.687)

Why is the header info. not getting published? My db2cli.ini has
following info:

jdbctrace=1
JDBCTRACEPATHNA ME="D:\Working-Directory\"
JDBCTRACEFLUSH= 1
Nov 12 '05 #1
0 3340

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1241
by: Swami | last post by:
Hi, I have installed MQ SQL Server 2000 on my laptop and trying to use SPARTA 2000 JDBC Driver (inetmssql.jar) to connect to the local db. I wrote a sample Java app to test the connection and I get the following error trace, DriverManager.initialize: jdbc.drivers = null JDBC DriverManager initialized SQLException: SQLState(08S01) {sql7=true, port=1433, user=sa, url=jdbc:inetdae7:US0211737-WP01:1433,
6
7257
by: Swami | last post by:
Hi, I have installed MQ SQL Server 2000 on my laptop and trying to use SPRINTA 2000 JDBC Driver (inetmssql.jar) to connect to the local db. I wrote a sample Java app to test the connection and I get the following error trace, DriverManager.initialize: jdbc.drivers = null JDBC DriverManager initialized SQLException: SQLState(08S01) {sql7=true, port=1433, user=sa, url=jdbc:inetdae7:US0211737-WP01:1433,
4
6348
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...
5
5630
by: Steffen | last post by:
hi there, i have a problem connecting to a db2 database 7.2.4 on AIX using java when running the javacode on AIX using jdk1.3.1. The classpath is correctly set to java12/... on windows the following code works fine for the same database: DB2XADataSource db2 = new DB2XADataSource(); db2.setDatabaseName("MYDB");
0
2567
by: SagittaDeveloper | last post by:
Hi, I'm have a problem connecting to IBM Universe via JDBC. When I run the connection code to UV from a none web application it connects and returns data. When I use the same connection code in my web application it fails. The same thing haoppenes when I using Suns JDBC to ODBC bridge. I'm using: Tomcat 5.5
1
7997
by: rjha94 | last post by:
Hi Folks we have a java application using hibernate ORM mapper on top of db2 UDB v9. we are using type 4 jdbc drivers for connections. Now the issue is we have a table with BLOB column and when you issue a query against this table, all the blob data are fetched into JVM memory. Needless to say this does not look like a scalable design. You can set some properties on db2 jdbc driver (fullymaterializelobData=false) to stream the lobs...
2
6671
by: anokun7 | last post by:
Hi, I am connecting to a DB2 v7.1 server from windows using JDBC type 2 (I figured out that type 4 is only for 8 and upwards). I used DB2 Connect to create a system DSN and seem to be able to connect fine using db2connect and run queries etc. The problem is when I try to use my java application to connect using the same DSN. The way the db has been configured is that I am
8
3765
by: cwhankey | last post by:
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.DisconnectException: 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
0
604
by: Jim Kennedy | last post by:
ALL DDL does a commit. Hence Drop Table movies; issues a commit. True you don't issue a commit and the driver does not issue a commit, but the server does for all DDL. That is probably where your commit is coming from. Jim -- Replace part of the email address: kennedy-down_with_spammers@attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out.
0
9425
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10225
Oralloy
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...
0
10053
jinu1996
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...
0
9867
tracyyun
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...
1
7415
isladogs
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...
0
5312
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...
0
5449
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3969
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
3
2816
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.