f



Oracle 9.2 vs. Oracle 9.2.0.4. - Strange ResultSet behaviour

I'm using SDK 1.4.2_03 either with an Oracle 9.2 or an Oracle 9.2.0.4
client version.

The 9.2 version behaves as expected. 
My problem only occurs with the 9.2.0.4. version. 
If I try to process the ResultSet of database query and the selected
column data includes leading blanks, the 9.2.0.4 seems to trim these
leading blanks.

Is this behaviour known or am I doing something wrong ?
<code snippet>

ResultSet result = null;
Connection con = null;
Statement stmt = null;
Vector vec = new Vector();
try {
        con = DriverManager.getConnection(dbUrl, dbUser, dbPassword);
        stmt = con.createStatement();
        result = stmt.executeQuery("SELECT DATA FROM
CPTMESSAGEDATA";);
        while (result.next()) {
                vec.add(result.getString("DATA"));
        }
        con.close();
	stmt.close();

} catch (SQLException e) {
        
}        
</code snippet>
CPTMessageData.DATA is of type VARCHAR2(50) not nullable with values
like:
" @20013     @E123      @G123      @          @      @        "
" @3700167         @43186           @B50_300   @1 @20013     @1   @OK 
"

Any help is appreciated.

Alex
0
s
5/14/2004 10:56:40 AM
comp.lang.java.databases 3049 articles. 0 followers. samyaksulabh (16) is leader. Post Follow

0 Replies
886 Views

Similar Articles

[PageSpeed] 23

Reply:

Similar Artilces:

Oracle server 9.2.0.1.0, Client 9.2.0.4.0, Red Hat Linux enterprise advanced server 2.1
Hi Everybody, My Database server is running on Red Hat Linux enterprise advanced server 2.1, And my Oracle version is 9.2.0.1.0. My Client mechine also Red Hat Linux enterprise advanced server 2.1 , Oracle client version is 9.2.0.4.0. I am running a web application. Our application is in Magic edeveloper. I connect to Oracle using oracle gateway to my application. My Problem is my application is is becoming slow. I am not able to trace where the problem is. Before our application was running fine. recently i upgraded Oracle client version to 9.2.0.4.0. My Oracle client & server versi...

Upgrade from Oracle 9.2.0.1 to Oracle 9.2.0.3
Hello All, I am trying to upgrade oracle 9.2.0.1 to new patchset 9.2.0.3 or 9.2.0.4. Please recommend which is better 9.2.0.3 or 9.2.0.4? Also I had a bad experience with my development server when applying 9.2.0.3 patchset. Is there anything you recommend before I start again? Thanks Kumu Hello Kumu, What is the reason for upgrade? Any specific bugs or issues you experience? You can open TAR as well to get support recommendations for your situation. New patches can introduce new problems as you can see, Regards, Ron DBA Infopower http://www.dbainfopower.com Standard di...

Where to get oracle patch 9.2.0.4 and 9.2.0.5
I'm doing an install for work on a windows xp (32bit) development station. To mimik the production systems I need to install 9.2.0.1.0 and then the patches for 9.2.0.4 and 9.2.0.5. I've installed 9.2.0.1 and I have a disk for the patches but it is corrupted. Where can I get these patches? I've tried google to no avail. Thanks in advance! On 29 Jun 2006 15:13:24 -0700, "David.E.M....@gmail.com" <David.E.Murphy@gmail.com> wrote: >I'm doing an install for work on a windows xp (32bit) development >station. To mimik the production systems I need to ins...

help:How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7
How can i take Export of Oracle 9.2.0.1 from Oracle 9.2.0.7 1-what scripts are to be used 2-Where i can find these scripts. Thnks. You can't. You can use lower version export to export higher version database. The other way around has never been possible. -- Sybrand Bakker Senior Oracle DBA You probably have Oracle 9.2.0.1 running somewhere right, perhaps on another machine ? Set your ORACLE_HOME to 9.2.0.1 then export through sqlnet: exp username/pwd @9207instance Now you'll use the 9.2.0.1 export utility; this should work. "shahsyed" <shahsyed@gmail.co...

upgrade from oracle 9.2.0.1.0 to 9.2.0.5.0
Hi, I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for window version 32 bits, does anyone can provide the node document information of step by step doing it. many thanks leehi leehi wrote: > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window version 32 bits, Windows NT4? W2k? W2K3? W2K3 - Release 2? Why stop ot 9.2.0.5? > does anyone can provide the node document information of step by step > doing it. leehi wrote: > Hi, > > I have a 9.2.0.1.0 database that I want to upgrade to 9.2.0.5. for > window v...

Install problems with Oracle installer 2.2 for Oracle 9i Client 9.2.0.1.0
Please forgive me if I am posting this in the wrong forum - I am an Oracle Newbie. Here are my computer specs : Windows 2003 - fully patch from Microsoft as of Sept 4th 2004 HP LP2000r 1 x 1,1 Gig Intel processor 1 GB RAM Hardware RAID 1, 12 GB with 8 GB freespace Clean install, no other programs. At first I tried running the Oracle installer program from the CD ROM and came up with the error that it could not find the javaw.exe program. I then tried installing and reinstalling several versions of java to no avail. Next I searched through groups.google and found the solution: 1. Copy t...

9 (9.0.4) or 9.1 (9.2.2)?
I'm looking to upgrade from System 8.6 to 9 on my 7100/66, which has a Sonnet 266MHz upgrade card (and 104MB RAM). Some old posts I've seen say I can go up to 9.1 (which means 9.2.2 ultimately, unless there's a reason not to), but a couple other posts I've seen say 9.1 won't install on a 7100 (they don't mention upgrade cards though), so I'd have to stick with 9 (9.0.4). Can anyone tell me which is true (whether I should be looking for a 9 or 9.1 install CD on ebay, essentially)? Thank you. In article <oliverluNOSPAM-4219E8.11342630092003@news06.west.eart...

from oracle 9.2.04 to oracle 9.2.05
i'm a newbie, i'd like to guess if anybody knows how can I upgrade my oracle 9.2.04 to 9.2.05. My java_pool_size, shared_pool_size are under 150 MB. How can I set this value? Bye and thx a lot. jakko1982 wrote: > i'm a newbie, i'd like to guess if anybody knows how can I upgrade my > oracle 9.2.04 to 9.2.05. > My java_pool_size, shared_pool_size are under 150 MB. How can I set > this value? > > Bye and thx a lot. 1) Goto http://metalink.oracle.com and download the 9.2.0.5 patchset. You can also goto 9.2.0.6. Patch installation documentation comes with it....

ORACLE 9.2.0.4.0 + LINUX SLACKWARE 9.0 = SUCCESS
Hi all, for anyone interested, I've just successfully installed Oracle 9iR2 (9.2.0.4.0) on Linux Slackware 9.0 (gcc-3.2.2, kernel 2.4.20). Actually, the installation of base release 9.2.0.1.0 produced some relink errors, fully resolved by patchset 9.2.0.4.0. Best regards. Angelo Della Penna (adellape@yahoo.com) On Tue, 16 Sep 2003 03:13:36 -0700, Angelo Della Penna wrote: > Hi all, > > for anyone interested, I've just successfully installed Oracle 9iR2 > (9.2.0.4.0) on Linux Slackware 9.0 (gcc-3.2.2, kernel 2.4.20). > > Actually, the installation of base r...

oracle 9.2.0.4.0 red hat 9
Hi, I'm having problems installing Oracle 9.2.0.4.0 on Red Hat 9. During runInstaller, I get numerous errors about something wrong with the target of makefile in various directories. Also, many of the assistants, like the Database Configuration Assistant don't get installed. I can start sqlplus. But then I can't mount the starter database I created during the installation. Also, when I try to run dbca, I get this error: /hutch/oracle/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libz...

restoring 9.2.0.6 datafiles with 9.2.0.7 Oracle
Hello Is there potential problem ? we want to use old datafiles in 9.2.0.6 with a patched oracle in 9.2.0.7... Thank you nonor wrote: > Hello > > Is there potential problem ? we want to use old datafiles in 9.2.0.6 > with a patched oracle in 9.2.0.7... > > Thank you No, you don't want to do that. You want to solve some problem, for which you believe that to be the solution. What is the problem you are trying to solve? In answer to your question -- yes, I'd think there would be disasterous problems. So, again -- what is the problem you are trying to solve? ...

Moving a single instance 9.2.0.7 database to a clustered 9.2.0.6 database environment #2
HI, I have the following situation: We have Veritas cluster setup , and there are 2 solaris servers on which VCS is set up. On this set up we have about 8 databases all of which are 9.2.0.6 version. Now we have one stand alone solaris server, and it has a 9.2.0.7 database. This database is for a third party application -Clear Case & Clear Quest. Now it is required to move the single instance database to clustered environment. Since in the clustered environment we have 9.2.0.6 version, is it AT ALL POSSIBLE to move this database, which is 9.2.0.7 to that enviroment? I guess not, and i...

Connection from Oracle Developer Suite 10g 9.0.4.0.1 to Oracle DB 10g Release 10.1.0.2.0
Hi, I have installed Oracle DB 10g Release 10.1.0.2.0 on Windows XP. START->ALL PROGS->oracle-OraDb10g_home3 Location of TNSNAMES FILE: C:\oracle\product\10.1.0\db_3\NETWORK\ADMIN\TNSNAMES.ORA with two alias: 1)ORCL3 2) EXTPROC_CONNECTION_DATA I can logon to database via SQL*PLUS and I can log on to EM on the web as well using ORCL3. After that I installed Oracle Developer Suite 10g 9.0.4.0.1 to my the same computer. During installation it was not allowing me to install this suite to the same ORACLE home. I installed this in the following home: START->ALL PROGS->...

optimizer_features_enable difference between 9.2.0.1/9..2.0.3/9.2.0.6?
Hi, All, I noticed for this parameter optimizer_features_enable , oracle document says: Syntax OPTIMIZER_FEATURES_ENABLE = {8.0.0 | 8.0.3 | 8.0.4 | 8.0.5 | 8.0.6 | 8.0.7 | 8.1.0 | 8.1.3 | 8.1.4 | 8.1.5 | 8.1.6 | 8.1.7 | 9.0.0 | 9.0.1 | 9.2.0} I noticed when I keep it default to 9.2.0 in init.ora, in version 9.2.0.3 and 9.2.0.5 with exact same database and exact same init.ora, oracle CBO did choose different plan. So there is some difference between 9.2.0.X versioin for the CBO. Where can we get such information about the difference? Thanks On 12 Jul 2005 23:37:28 -0700, "ch...

Oracle 9.2.0.5, RedHat 7.3 (2.4.27) and SGA size 2.7GB
Hello all, My problem : I'm trying to increase the SGA to 2.7 GB. What have I done so far : 1) I have succesfully installed the above mentioned database following the HOWTO http://www.puschitz.com/InstallingOracle9i.shtml#RunningOracleInstallation. The database is working without problems, but uses only 1.7GB of memory for SGA. 2) I have followed the excelent HOWTO from Werner Puschitz located on http://www.puschitz.com/TuningLinuxForOracle.shtml#IncreasingSpaceForLargerSGA, but when I come to the point for changing the mapped base on Linux OS level, I'm unable to locate the file ...

oracle 9i release 2 ( 9.2.0.1.0 ) on AIX 5.2
Hi, is there some other sw required beside bos.adt.base, bos.adt.libm, bos.perf.perfstat and bos.perf.libperfstat for running oracle on AIX 5.2 ML5? Regards tomiskra@vodatel.net <tomiskra@vodatel.net> wrote: > is there some other sw required beside bos.adt.base, bos.adt.libm, > bos.perf.perfstat and bos.perf.libperfstat for running oracle on AIX > 5.2 ML5? If you have access to Oracle Metalink, you can find all the information in Note 282036.1, 'Minimum Software Versions and Patches Required to Support Oracle Products on IBM pSeries'. All I quote from here on is an...

Oracle Warehouse Builder 9.2.0.2.8 and Workflow 2.6.2 on linux
Hi there, I downloaded OWB_9.2.0.2.8_linux.tar.gz from here: http://otn.oracle.com/software/products/warehouse/index.html In the above download I found OWB installation documentation. In the OWB installation documentation, I see evidence that Oracle Warehouse Builder (runtime portion) makes use of "Oracle Workflow". It does not mention a version though. It does say that Workflow is neccessary. The documentation for Workflow was easy to find here: http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage#index-WOR I'm not sure where to find the Workflow software though. ...

FreeBSD 5.4-RELEASE-p7, Oracle 9.2.0.4
Hello, I tried to install Oracle 9 on FreeBSD, but during the installation, it's always blocked (freeze) at 66%, java runtime environment ( JRE ), I tried, all the Linux-Blackdown version and also all the Linux-sun-jdk ports without succes. I followed step by step http://ezine.daemonnews.org/200402/oracle.html. Any one have a Idea, where's my error ? thx Seb On Mon, 26 Sep 2005 02:49:40 -0400, Seb wrote: > Hello, > > I tried to install Oracle 9 on FreeBSD, but during the installation, > it's > always blocked (freeze) at 66%, ja...

Setting file permission error on Oracle 9.2 installation on RedHat 9.0 #2
Hi, On installing Oracle 9.2 on RedHat 9.0 and AS 2.1, I encounterd the same following error: Error in setting permissions on file/directory /opt/oracle/jre/1.1.8/LICENSE Could someone tell me why it happened and how to fix it? Your help is much appreciated. Thanks, Rob ...

Moving a single instance 9.2.0.7 database to a clustered 9.2.0.6 database environment
HI, I have the following situation: We have Veritas cluster setup , and there are 2 solaris servers on which VCS is set up. On this set up we have about 8 databases all of which are 9.2.0.6 version. Now we have one stand alone solaris server, and it has a 9.2.0.7 database. This database is for a third party application -Clear Case & Clear Quest. Now it is required to move the single instance database to clustered environment. Since in the clustered environment we have 9.2.0.6 version, is it AT ALL POSSIBLE to move this database, which is 9.2.0.7 to that enviroment? I guess not, and i...

Migrating from Oracle 7.3.4 to Oracle 9.2.0.6
Hello Everybody, Am in process of migrating a couple of application currently being hosted on ONE instance on a NCR hardware. Its Oracle 7.3.4. I have to move this entire set to Oracle9i. I went through the respective schema definitions on the current instance and see a lot of Segment and Block utilization parameters used. I plan to used 'Local Extent' management and 'Auto Segment Space' features on 9i. In that case the above parameters will not have any effect on the Database I suppose. Now I want to know MORE on these: a) Are my above assumptions right, I have a feeling that Oracle is more intelligent nowadays to automatically extend extents as needed and doing it manually can actually cause inefficient space usage. b) There are several batch processes running on the existing system and the same with eventually happen on the new one too. If there are any ROLLBACK segment related statements in these scripts will there create a problem in Oracle9i. I know that in Oracle 9i ROLLBACK is in form of UNDO tablespace and is managed by Oracle automatically. c) Am planning to use Export/Import method to move data between these 2 boxes. Are there anyother percautions I need to take care during this upgrade. Thanks a lot for your time and HELP, Raj. Raj, Actually with locally managed tablespace, LMT, using auto-allocate or uniform extents the initial storeage value does affect the storage allocation used by Oracle. In the case of...

Oracle 9.2.0.1.0 on SuSE9.2?
Hi, I would like to install Oracle 9.2.0.1.0 on SuSE 9.2. Is this possible? Is there a good cookbook howto install oracle on Suse 9.2? I've tried the short way by simply creating a new user oracle and typing "runInstaller" but all I receive is <cut> oracle@bw009870:~> Initializing Java Virtual Machine from /tmp/OraInstall2005-03-22_08-37-52AM/jre/bin/java. Please wait... Error occurred during initialization of VM Unable to load native library: /tmp/OraInstall2005-03-22_08-37-52AM/jre/lib/i386/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference </cut> regards Detlef -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/m2/ On Tue, 22 Mar 2005 08:58:16 +0100, Detlef Jockheck wrote: SuSE 9.2 is not certified, although people have made it work. A cookbook for the certified versions of SuSE is at http://www.novell.com/products/linuxenterpriseserver/oracle/matrix.html Read through those to get an idea of how to proceed. /FGB Detlef Jockheck wrote: > Hi, > > I would like to install Oracle 9.2.0.1.0 on SuSE 9.2. Is this possible? > Is there a good cookbook howto install oracle on Suse 9.2? I've tried > the short way by simply creating a new user oracle and typing > "runInstaller" but all I receive is > > <cut> > oracle@bw009870:~> Initializing Java Virtual M...

need to upgrade from 9.2.0.4 to 9.2.0.5
Hello, I hope this is an easy question. At any rate I need to upgrade from 9.2.0.4 to 9.2.0.5. I'm asking becuase I've intalled patches before but never changed release numbers and I don't want to screw anything up. Is upgrading to 9.2.0.5 as simple as loading the first 9.2.0.5 patch??? I'm on metalink and looking at Doc ID: Note:161549.1 as I'm writing this. Am I in the correct area to download the 9.2.0.5 patch? Thanks! Adam Sandler wrote: > Hello, > > I hope this is an easy question. At any rate I need to upgrade from > 9.2.0.4 to 9.2.0.5. I'...

Oracle 9.2.0.4 and Linux SUSE 9.1
Hello, I have a problem which seems to be common to all of those who try to compile the sample programs that come with the xdk. Actually, I'm trying to compile the sample programs in the following directory: $ORACLE_HOME/xdk/demo/c/parser but I get lots of errors as follows: cc -o SAXSample -I../../../../xdk/include SAXSample.c -L../../../../lib -lxml9 -lxsd9 -lcore9 -lnls9 -lunls9 -lcore9 -lnls9 -lcore9 -lnls9 -lnsl -lm -lpthread .../../../../lib/libxml9.a(lpxerr.o)(.text+0x4d9): In function `LpxErrVPrintf': : undefined reference to `__ctype_b' .../../../../lib/libxml9.a(lpxm.o)(.text+0x37dd): In function `LpxmA2L': : undefined reference to `__ctype_b' .../../../../lib/libxml9.a(lpxm.o)(.text+0x38f9): In function `LpxmA2UL': : undefined reference to `__ctype_b' .../../../../lib/libxml9.a(lpxpar.o)(.text+0xae5): In function `LpxParseAttrList': : undefined reference to `__ctype_b' .../../../../lib/libxml9.a(lpxpar.o)(.text+0x1fa6): In function `LpxParseMultiAttrList': : undefined reference to `__ctype_b' .../../../../lib/libxml9.a(lpxpar.o)(.text+0x2709): more undefined references to `__ctype_b' follow .../../../../lib/libcore9.a(lstclo.o)(.text+0x52): In function `lstclo': : undefined reference to `__ctype_tolower' .../../../../lib/libcore9.a(lstclo.o)(.text+0x6f): In function `lstclo': : undefined reference to `__ctype_tolower' and so on. I have read posts across several for...

Oracle 9i Release 2(9.2.0.4) on Slackware 10.1
Does anybody out there have had these experience in performing such an installation ... does anybody have a how-to ... or some hints ... ??? Please help me with this issue. || So many thanks in advance, looking forward to hear from you guys .. !! Oralinuxdba wrote: > Does anybody out there have had these experience in performing such an > installation ... does anybody have a how-to ... or some hints ... ??? > Please help me with this issue. || So many thanks in advance, looking > forward to hear from you guys .. !! > Issue? What issue? The issue of using a non-oracle-support...

Web resources about - Oracle 9.2 vs. Oracle 9.2.0.4. - Strange ResultSet behaviour - comp.lang.java.databases

'jdbc' Top Users - Stack Overflow
Q&A for professional and enthusiast programmers

IBM Remote Supervisor Adapter - Wikipedia, the free encyclopedia
This is a full-length ISA or PCI adapter. The ISA version is very rare, and was only ever supported in one or two servers. This adapter can be ...

Java Developer Kit (JDK) Search Engine
Java Developer Kit (JDK) Search Engine


Java 7 Runtime and Cloud Endpoints Preview
... public static void viewTable(Connection con, String query) throws SQLException { try ( Statement stmt = con.createStatement(); ResultSet rs ...

The (Submission) Grinder
The market search page is very powerful and fliexible but can be daunting to new users. Here is a quick run down on how things work. The filters ...

All Packages from $.* to Freenet.*
Package Samples: Freenet Freenet.client Freenet.contrib.fproxy Freenet.message Freenet.crypt Freenet.node Freenet.support ...

The Goldman Sachs Group, Inc. - Selected Consolidated Financial Data
The selected historical consolidated income statement and balance sheetdata set forth below have been derived from Goldman Sachs' consolidatedfinancial ...

Clones of dapper-dot-net - dapper-dot-net - Simple SQL object mapper for ADO.NET - Google Project Hosting ...
My favorites ▼ - Sign in dapper-dot-net Simple SQL object mapper for ADO.NET Project Home Downloads Wiki Issues Source Repository: default wiki ...

A simple Delphi wrapper for Sqlite 3
Most applications use a database, and there are many excellent database engines to choose from, both free and commercial. SQLite is a smal

Resources last updated: 3/2/2016 11:13:01 PM