aspose file tools
The moose likes JDBC and the fly likes How to retrive long data Types of oracle in java Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "How to retrive long data Types of oracle in java" Watch "How to retrive long data Types of oracle in java" New topic
Author

How to retrive long data Types of oracle in java

Vetri Selvi
Greenhorn

Joined: Mar 27, 2001
Posts: 3
Hi,
Any urgent help appreciated.
I have table which contains oracle Long data type.
using result set i am getting all the columns but I am not able to map any jdbc data type (getXXXXXX) to this Long data type.
Please let me know how to get long data type in jdbc program
thanks
Vetri selvi
Michael Arnett
Ranch Hand

Joined: Mar 22, 2001
Posts: 65
I am a Java newbie, but I believe that you can retrieve a long value from an oracle database into a java resultset, and then assign it to an InputStream variable. For example:
InputStream saveLong = rsOracle.getAsciiStream ( 1 );

might work.
-MLA

Sun Certified Programmer for the Java 2 Platform 1.4
Raja Shekhar
Ranch Hand

Joined: Apr 02, 2001
Posts: 49
Hi !!
Getting The Long Data...

LongData ... or any type of Data
Just try
rst.getString("columnname");
(OR)
just try
rst.getLong("columnname")

And Let me Know the Result..

Bye..
Hope this will Help U..

 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: How to retrive long data Types of oracle in java
 
Similar Threads
JDBC Type $ Driver
How to get USE ORACLE LONG in java.
getString() in ResultSet
updating a Long column in Oracle thru JDBC deployed on a Weblogic 6.1 Server
Data size bigger than the max size for this type;