Why SQuirrel won't display the time for an Oracle database?

[lacapu]

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!

[manningr]

On Fri, May 2, 2008 at 6:38 PM, lacapu <lacapuchita@...> 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

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[lacapu]

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!

[anisah]

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



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!

[anisah]

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!

[manningr]

On Mon, Sep 29, 2008 at 9:50 PM, anisah <anisah88aris@...> 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

-------------------------------------------------------------------------
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
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Matthew Dahlman-2]

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:anisah88aris@...]
Sent: Monday, 29 September, 2008 18:51
To: squirrel-sql-users@...
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
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

-------------------------------------------------------------------------
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
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users