wood burning stoves 2.0*
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 | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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://aspose.com/file-tools
 
subject: How to retrive long data Types of oracle in java
 
Similar Threads
Data size bigger than the max size for this type;
getString() in ResultSet
updating a Long column in Oracle thru JDBC deployed on a Weblogic 6.1 Server
How to get USE ORACLE LONG in java.
JDBC Type $ Driver