Thread: [Squirrel-sql-users] Why SQuirrel won't display the time for an Oracle database?

A Java SQL client for any JDBC compliant database

Brought to you by: colbell, gerdwagner

squirrel-sql-users

[Squirrel-sql-users] Why SQuirrel won't display the time for an Oracle database?

From: lacapu <lac...@ya...> - 2008-05-02 22:38:16

Hi. I'm using the oracle thin driver to connect to my Oracle database
(oracle.jdbc.driver.OracleDirver). When I do a query on a table that has a
column of type of TIMESTAMP(6), the output of the column does not show the
time of each of the record; but rather SQuirrel shows the content of that
column as:
<Unknonw(-100)>

However, when I use sqlplus, I can see the time just fine. Can someone tell
me what is the settings or whatever that I need to do in order to see the
right time in a field/column of type TIMESTAMP(6).

Thanks in advanced!
-- 
View this message in context: http://www.nabble.com/Why-SQuirrel-won%27t-display-the-time-for-an-Oracle-database--tp17029083p17029083.html
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

Re: [Squirrel-sql-users] Why SQuirrel won't display the time for an Oracle database?

From: Robert M. <rob...@gm...> - 2008-05-05 11:06:45

On Fri, May 2, 2008 at 6:38 PM, lacapu <lac...@ya...> wrote:
>
>  Hi. I'm using the oracle thin driver to connect to my Oracle database
>  (oracle.jdbc.driver.OracleDirver). When I do a query on a table that has a
>  column of type of TIMESTAMP(6), the output of the column does not show the
>  time of each of the record; but rather SQuirrel shows the content of that
>  column as:
>  <Unknonw(-100)>

Wow, that doesn't sound right - I don't see that at all.   A couple of
questions:

1. What version of SQuirreL are you using?
2. What version of Oracle?
3. Is your JDBC driver version matched with the Oracle server version?
4. When you look at the columns tab for the table in SQuirreL, what is
the TYPE_NAME value?

Rob

Re: [Squirrel-sql-users] Why SQuirrel won't display the time for an Oracle database?

From: lacapu <lac...@ya...> - 2008-05-05 18:33:30

Thanks to the suggestions by Robert from this forum, I've resolved the
problem. The problem had to do with the jdbc thin driver that I was using
from the classes12.zip. It was an older jdbc and it wasn't JDBC 3.0
complaint. Once I replaced the classes12.zip that came with my Oracle
installation, SQuirreL did show up the time on the "TIMESTAMP(6)" type
column of my table.

Thanks again to all for your emails and suggestions!

lacapu wrote:
> 
> Hi. I'm using the oracle thin driver to connect to my Oracle database
> (oracle.jdbc.driver.OracleDirver). When I do a query on a table that has a
> column of type of TIMESTAMP(6), the output of the column does not show the
> time of each of the record; but rather SQuirrel shows the content of that
> column as:
> <Unknonw(-100)>
> 
> However, when I use sqlplus, I can see the time just fine. Can someone
> tell me what is the settings or whatever that I need to do in order to see
> the right time in a field/column of type TIMESTAMP(6).
> 
> Thanks in advanced!
> 

-- 
View this message in context: http://www.nabble.com/Why-SQuirrel-won%27t-display-the-time-for-an-Oracle-database--tp17029083p17067927.html
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

Re: [Squirrel-sql-users] Why SQuirrel won't display the time for an Oracle database?

From: anisah <ani...@ya...> - 2008-09-30 02:08:51

Hi Robert
I am facing the same problem.  Could you kindly let me know where could i
download this classes12.zip.
Or could you email me this classess12.zip file.
Thank you.
Anisah



lacapu wrote:
> 
> Thanks to the suggestions by Robert from this forum, I've resolved the
> problem. The problem had to do with the jdbc thin driver that I was using
> from the classes12.zip. It was an older jdbc and it wasn't JDBC 3.0
> complaint. Once I replaced the classes12.zip that came with my Oracle
> installation, SQuirreL did show up the time on the "TIMESTAMP(6)" type
> column of my table.
> 
> Thanks again to all for your emails and suggestions!
> 
> lacapu wrote:
>> 
>> Hi. I'm using the oracle thin driver to connect to my Oracle database
>> (oracle.jdbc.driver.OracleDirver). When I do a query on a table that has
>> a column of type of TIMESTAMP(6), the output of the column does not show
>> the time of each of the record; but rather SQuirrel shows the content of
>> that column as:
>> <Unknonw(-100)>
>> 
>> However, when I use sqlplus, I can see the time just fine. Can someone
>> tell me what is the settings or whatever that I need to do in order to
>> see the right time in a field/column of type TIMESTAMP(6).
>> 
>> Thanks in advanced!
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Why-SQuirrel-won%27t-display-the-time-for-an-Oracle-database--tp17029083p19734683.html
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

Re: [Squirrel-sql-users] Why SQuirrel won't display the time for an Oracle database?

From: anisah <ani...@ya...> - 2008-09-30 02:41:28



anisah wrote:
> 
> Hi Robert,
> OK actually I got the latest classes12.zip and its JDBC 3 compliance.  But
> I notice that when I imported a file with date for eg.  "1/04/2008 
> 7:00:11 AM", it shows in squirrels as "4/1/08 12:00 AM"
> Could you kindly assist as to how could i get the same timing as the
> original data.
> Thank you
> 
> 
> Hi Robert
> I am facing the same problem.  Could you kindly let me know where could i
> download this classes12.zip.
> Or could you email me this classess12.zip file.
> Thank you.
> Anisah
> 
> 
> 
> lacapu wrote:
>> 
>> Thanks to the suggestions by Robert from this forum, I've resolved the
>> problem. The problem had to do with the jdbc thin driver that I was using
>> from the classes12.zip. It was an older jdbc and it wasn't JDBC 3.0
>> complaint. Once I replaced the classes12.zip that came with my Oracle
>> installation, SQuirreL did show up the time on the "TIMESTAMP(6)" type
>> column of my table.
>> 
>> Thanks again to all for your emails and suggestions!
>> 
>> lacapu wrote:
>>> 
>>> Hi. I'm using the oracle thin driver to connect to my Oracle database
>>> (oracle.jdbc.driver.OracleDirver). When I do a query on a table that has
>>> a column of type of TIMESTAMP(6), the output of the column does not show
>>> the time of each of the record; but rather SQuirrel shows the content of
>>> that column as:
>>> <Unknonw(-100)>
>>> 
>>> However, when I use sqlplus, I can see the time just fine. Can someone
>>> tell me what is the settings or whatever that I need to do in order to
>>> see the right time in a field/column of type TIMESTAMP(6).
>>> 
>>> Thanks in advanced!
>>> 
>> 
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Why-SQuirrel-won%27t-display-the-time-for-an-Oracle-database--tp17029083p19735240.html
Sent from the squirrel-sql-users mailing list archive at Nabble.com.

Re: [Squirrel-sql-users] Why SQuirrel won't display the time for an Oracle database?

From: Matthew D. <mda...@ja...> - 2008-09-30 16:50:24

Anisah,

Oracle makes their JDBC driver available on their website at no cost. You
can get classes12.zip and its later versions like ojdbc14.jar there.

Regards,
Matt

-----Original Message-----
From: anisah [mailto:ani...@ya...] 
Sent: Monday, 29 September, 2008 18:51
To: squ...@li...
Subject: Re: [Squirrel-sql-users] Why SQuirrel won't display the time for
an Oracle database?


Hi Robert
I am facing the same problem.  Could you kindly let me know where could i
download this classes12.zip.
Or could you email me this classess12.zip file.
Thank you.
Anisah



lacapu wrote:
> 
> Thanks to the suggestions by Robert from this forum, I've resolved the 
> problem. The problem had to do with the jdbc thin driver that I was 
> using from the classes12.zip. It was an older jdbc and it wasn't JDBC 
> 3.0 complaint. Once I replaced the classes12.zip that came with my 
> Oracle installation, SQuirreL did show up the time on the 
> "TIMESTAMP(6)" type column of my table.
> 
> Thanks again to all for your emails and suggestions!
> 
> lacapu wrote:
>> 
>> Hi. I'm using the oracle thin driver to connect to my Oracle database 
>> (oracle.jdbc.driver.OracleDirver). When I do a query on a table that 
>> has a column of type of TIMESTAMP(6), the output of the column does 
>> not show the time of each of the record; but rather SQuirrel shows 
>> the content of that column as:
>> <Unknonw(-100)>
>> 
>> However, when I use sqlplus, I can see the time just fine. Can 
>> someone tell me what is the settings or whatever that I need to do in 
>> order to see the right time in a field/column of type TIMESTAMP(6).
>> 
>> Thanks in advanced!
>> 
> 
> 

--
View this message in context:
http://www.nabble.com/Why-SQuirrel-won%27t-display-the-time-for-an-Oracle-
database--tp17029083p19734683.html
Sent from the squirrel-sql-users mailing list archive at Nabble.com.


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the
world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

Re: [Squirrel-sql-users] Why SQuirrel won't display the time for an Oracle database?

From: Robert M. <rob...@gm...> - 2008-09-30 10:13:14

On Mon, Sep 29, 2008 at 9:50 PM, anisah <ani...@ya...> wrote:
>
> Hi Robert
> I am facing the same problem.  Could you kindly let me know where could i
> download this classes12.zip.
> Or could you email me this classess12.zip file.
> Thank you.
> Anisah

On the machine where you have installed Oracle, look in
$ORACLE_HOME/jdbc/lib.  There will jars and zips there. You just need
one of them.  Ideally you would use ojdbc14.jar (classes12.zip is for
an older version of Java).

Rob