|
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 |
