Get exception trying to set timezone on connection & can't see column definitions
|
View:
New views
11 Messages
—
Rating Filter:
Alert me
|
 |
Get exception trying to set timezone on connection & can't see column definitions
by KARR, DAVID (ATTCINW)
::
Rate this Message:
I recently installed SQuirreL 3.0.2. I just configured the Oracle
driver by adding the path to my local ojdbc14.jar file. I created an alias for an Oracle database. I connected to it. I noticed the red mark in the status line, and I saw the following in the log: -------------------- Logged by net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin at 7/17/09 11:46 AM: Unexpected exception while trying to set session timezone: oracle.jdbc.OracleConnection -------------------- I don't know what symptoms this will produce. Also, while viewing my tables, I see that I can see the Content of the table (with reasonable column headers), but nothing shows when I go to the "Columns" tab. Is this just an Oracle permissions problem? ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
|
Re: Get exception trying to set timezone on connection & can't see column definitions
by Maury Hammel
::
Rate this Message:
KARR, DAVID (ATTCINW) wrote:
> I recently installed SQuirreL 3.0.2. I just configured the Oracle > driver by adding the path to my local ojdbc14.jar file. I created an > alias for an Oracle database. I connected to it. I noticed the red > mark in the status line, and I saw the following in the log: I don't know for sure if this is related to your problems, but I'd go get the latest (11.1) Oracle JDBC driver, they have one that is meant for Java 6 (ojdbc6.jar). Maury ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
|
Re: Get exception trying to set timezone on connection & can't see column definitions
by KARR, DAVID (ATTCINW)
::
Rate this Message:
> -----Original Message-----
an
> From: Maury Hammel [mailto:ml1.hammel@...] > Sent: Friday, July 17, 2009 4:58 PM > To: squirrel-sql-users@... > Subject: Re: [Squirrel-sql-users] Get exception trying to set timezone > on connection & can't see column definitions > > KARR, DAVID (ATTCINW) wrote: > > I recently installed SQuirreL 3.0.2. I just configured the Oracle > > driver by adding the path to my local ojdbc14.jar file. I created > > alias for an Oracle database. I connected to it. I noticed the red > > mark in the status line, and I saw the following in the log: > > I don't know for sure if this is related to your problems, but I'd go > get the latest (11.1) Oracle JDBC driver, they have one that is meant > for Java 6 (ojdbc6.jar). Hmm, that leads me down a slippery slope. We're using JDK1.5 for our projects, but I try to use JDK1.6 for my desktop tools, and apparently SQuirreL 3.x requires JDK1.6. It would be unfortunate if I had to use a newer JDBC driver for SQuirreL, when nothing else here uses that driver. ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
|
Re: Get exception trying to set timezone on connection & can't see column definitions
by KARR, DAVID (ATTCINW)
::
Rate this Message:
> -----Original Message-----
an
> From: Maury Hammel [mailto:ml1.hammel@...] > Sent: Friday, July 17, 2009 4:58 PM > To: squirrel-sql-users@... > Subject: Re: [Squirrel-sql-users] Get exception trying to set timezone > on connection & can't see column definitions > > KARR, DAVID (ATTCINW) wrote: > > I recently installed SQuirreL 3.0.2. I just configured the Oracle > > driver by adding the path to my local ojdbc14.jar file. I created > > alias for an Oracle database. I connected to it. I noticed the red > > mark in the status line, and I saw the following in the log: > > I don't know for sure if this is related to your problems, but I'd go > get the latest (11.1) Oracle JDBC driver, they have one that is meant > for Java 6 (ojdbc6.jar). In any case, modifying the driver to use ojdbc6 instead made no difference. I still get the timezone error, and I still can't see column definitions. > > > Maury > > > ----------------------------------------------------------------------- > ------- > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited > time, > vendors submitting new applications to BlackBerry App World(TM) will > have > the opportunity to enter the BlackBerry Developer Challenge. See full > prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > Squirrel-sql-users mailing list > Squirrel-sql-users@... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
|
Re: Get exception trying to set timezone on connection & can't see column definitions
by manningr
::
Rate this Message:
David,
It is fine to use ojdbc14.jar with SQuirreL 3.x (Java 1.6). We don't yet take advantage of JDBC 4.0 features available in Java 1.6, and when we do, there will still be a fair number of drivers that only support JDBC 3.0. So we will try to degrade gracefully there. As for the timezone error, that is most likely the feature that allows you to set your session timezone (in case you use TZ columns). You can disable this feature by unchecking the checking in Global Preferences -> Oracle -> Initialize Session Timezone. The columns tab issue is not one that I have seen. What version of the JDBC driver and server are you using ? (Click on the top node in the object tree and select the Metadata tab to see values for getDriverVersion and getDatabaseProductVersion). If they don't match you should be able to retrieve a matching JDBC driver jar from $ORACLE_HOME/jdbc/lib/ folder on your database server. Rob On Fri, Jul 17, 2009 at 8:08 PM, KARR, DAVID (ATTCINW)<dk068x@...> wrote: >> -----Original Message----- >> From: Maury Hammel [mailto:ml1.hammel@...] >> Sent: Friday, July 17, 2009 4:58 PM >> To: squirrel-sql-users@... >> Subject: Re: [Squirrel-sql-users] Get exception trying to set timezone >> on connection & can't see column definitions >> >> KARR, DAVID (ATTCINW) wrote: >> > I recently installed SQuirreL 3.0.2. I just configured the Oracle >> > driver by adding the path to my local ojdbc14.jar file. I created > an >> > alias for an Oracle database. I connected to it. I noticed the red >> > mark in the status line, and I saw the following in the log: >> >> I don't know for sure if this is related to your problems, but I'd go >> get the latest (11.1) Oracle JDBC driver, they have one that is meant >> for Java 6 (ojdbc6.jar). > > In any case, modifying the driver to use ojdbc6 instead made no > difference. I still get the timezone error, and I still can't see > column definitions. > >> >> >> Maury >> >> >> > ----------------------------------------------------------------------- >> ------- >> Enter the BlackBerry Developer Challenge >> This is your chance to win up to $100,000 in prizes! For a limited >> time, >> vendors submitting new applications to BlackBerry App World(TM) will >> have >> the opportunity to enter the BlackBerry Developer Challenge. See full >> prize >> details at: http://p.sf.net/sfu/Challenge >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squirrel-sql-users@... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > ------------------------------------------------------------------------------ > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited time, > vendors submitting new applications to BlackBerry App World(TM) will have > the opportunity to enter the BlackBerry Developer Challenge. See full prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > Squirrel-sql-users mailing list > Squirrel-sql-users@... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
|
Re: Get exception trying to set timezone on connection & can't see column definitions
by KARR, DAVID (ATTCINW)
::
Rate this Message:
> -----Original Message-----
> From: Robert Manning [mailto:robert.m.manning@...] > Sent: Friday, July 17, 2009 5:58 PM > To: KARR, DAVID (ATTCINW) > Cc: Maury Hammel; squirrel-sql-users@... > Subject: Re: [Squirrel-sql-users] Get exception trying to set timezone > on connection & can't see column definitions > > The columns tab issue is not one that I have seen. What version of > the JDBC driver and > server are you using ? (Click on the top node in the object tree and > select the Metadata > tab to see values for getDriverVersion and getDatabaseProductVersion). > If they don't match > you should be able to retrieve a matching JDBC driver jar from > $ORACLE_HOME/jdbc/lib/ folder > on your database server. getDriverVersion: 11.1.0.7.0-Production getDatabaseProductVersion: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options I tried it earlier with the ojdbc14.jar, but I don't know how these values would change. It shouldn't really matter. > > Rob > > On Fri, Jul 17, 2009 at 8:08 PM, KARR, DAVID (ATTCINW)<dk068x@...> > wrote: > >> -----Original Message----- > >> From: Maury Hammel [mailto:ml1.hammel@...] > >> Sent: Friday, July 17, 2009 4:58 PM > >> To: squirrel-sql-users@... > >> Subject: Re: [Squirrel-sql-users] Get exception trying to set > timezone > >> on connection & can't see column definitions > >> > >> KARR, DAVID (ATTCINW) wrote: > >> > I recently installed SQuirreL 3.0.2. I just configured the Oracle > >> > driver by adding the path to my local ojdbc14.jar file. I created > > an > >> > alias for an Oracle database. I connected to it. I noticed the > red > >> > mark in the status line, and I saw the following in the log: > >> > >> I don't know for sure if this is related to your problems, but I'd > go > >> get the latest (11.1) Oracle JDBC driver, they have one that is > meant > >> for Java 6 (ojdbc6.jar). > > > > In any case, modifying the driver to use ojdbc6 instead made no > > difference. I still get the timezone error, and I still can't see > > column definitions. > > > >> > >> > >> Maury > >> > >> > >> > > --------------------------------------------------------------------- > -- > >> ------- > >> Enter the BlackBerry Developer Challenge > >> This is your chance to win up to $100,000 in prizes! For a limited > >> time, > >> vendors submitting new applications to BlackBerry App World(TM) will > >> have > >> the opportunity to enter the BlackBerry Developer Challenge. See > full > >> prize > >> details at: http://p.sf.net/sfu/Challenge > >> _______________________________________________ > >> Squirrel-sql-users mailing list > >> Squirrel-sql-users@... > >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > > > --------------------------------------------------------------------- > --------- > > Enter the BlackBerry Developer Challenge > > This is your chance to win up to $100,000 in prizes! For a limited > time, > > vendors submitting new applications to BlackBerry App World(TM) will > have > > the opportunity to enter the BlackBerry Developer Challenge. See full > prize > > details at: http://p.sf.net/sfu/Challenge > > _______________________________________________ > > Squirrel-sql-users mailing list > > Squirrel-sql-users@... > > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
|
Re: Get exception trying to set timezone on connection & can't see column definitions
by manningr
::
Rate this Message:
My test instance is 10.2.0.4 as well (although it is 32-bit). I tried
the latest driver (11.1.0.7.0-Production) and columns tab works fine for me. Are there any other exceptions in the log ? Perhaps it is a permissions issue . I'll try a 10g 64-bit instance the next chance I get. Rob On Fri, Jul 17, 2009 at 11:58 PM, KARR, DAVID (ATTCINW)<dk068x@...> wrote: >> -----Original Message----- >> From: Robert Manning [mailto:robert.m.manning@...] >> Sent: Friday, July 17, 2009 5:58 PM >> To: KARR, DAVID (ATTCINW) >> Cc: Maury Hammel; squirrel-sql-users@... >> Subject: Re: [Squirrel-sql-users] Get exception trying to set timezone >> on connection & can't see column definitions >> >> The columns tab issue is not one that I have seen. What version of >> the JDBC driver and >> server are you using ? (Click on the top node in the object tree and >> select the Metadata >> tab to see values for getDriverVersion and getDatabaseProductVersion). >> If they don't match >> you should be able to retrieve a matching JDBC driver jar from >> $ORACLE_HOME/jdbc/lib/ folder >> on your database server. > > getDriverVersion: 11.1.0.7.0-Production > getDatabaseProductVersion: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production > With the Partitioning, OLAP, Data Mining and Real Application Testing options > > I tried it earlier with the ojdbc14.jar, but I don't know how these values would change. It shouldn't really matter. > >> >> Rob >> >> On Fri, Jul 17, 2009 at 8:08 PM, KARR, DAVID (ATTCINW)<dk068x@...> >> wrote: >> >> -----Original Message----- >> >> From: Maury Hammel [mailto:ml1.hammel@...] >> >> Sent: Friday, July 17, 2009 4:58 PM >> >> To: squirrel-sql-users@... >> >> Subject: Re: [Squirrel-sql-users] Get exception trying to set >> timezone >> >> on connection & can't see column definitions >> >> >> >> KARR, DAVID (ATTCINW) wrote: >> >> > I recently installed SQuirreL 3.0.2. I just configured the Oracle >> >> > driver by adding the path to my local ojdbc14.jar file. I created >> > an >> >> > alias for an Oracle database. I connected to it. I noticed the >> red >> >> > mark in the status line, and I saw the following in the log: >> >> >> >> I don't know for sure if this is related to your problems, but I'd >> go >> >> get the latest (11.1) Oracle JDBC driver, they have one that is >> meant >> >> for Java 6 (ojdbc6.jar). >> > >> > In any case, modifying the driver to use ojdbc6 instead made no >> > difference. I still get the timezone error, and I still can't see >> > column definitions. >> > >> >> >> >> >> >> Maury >> >> >> >> >> >> >> > --------------------------------------------------------------------- >> -- >> >> ------- >> >> Enter the BlackBerry Developer Challenge >> >> This is your chance to win up to $100,000 in prizes! For a limited >> >> time, >> >> vendors submitting new applications to BlackBerry App World(TM) will >> >> have >> >> the opportunity to enter the BlackBerry Developer Challenge. See >> full >> >> prize >> >> details at: http://p.sf.net/sfu/Challenge >> >> _______________________________________________ >> >> Squirrel-sql-users mailing list >> >> Squirrel-sql-users@... >> >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> > >> > --------------------------------------------------------------------- >> --------- >> > Enter the BlackBerry Developer Challenge >> > This is your chance to win up to $100,000 in prizes! For a limited >> time, >> > vendors submitting new applications to BlackBerry App World(TM) will >> have >> > the opportunity to enter the BlackBerry Developer Challenge. See full >> prize >> > details at: http://p.sf.net/sfu/Challenge >> > _______________________________________________ >> > Squirrel-sql-users mailing list >> > Squirrel-sql-users@... >> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> > > ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
|
Re: Get exception trying to set timezone on connection & can't see column definitions
by KARR, DAVID (ATTCINW)
::
Rate this Message:
No, nothing else in the log.
> -----Original Message----- > From: Robert Manning [mailto:robert.m.manning@...] > Sent: Friday, July 17, 2009 11:40 PM > To: KARR, DAVID (ATTCINW) > Cc: Maury Hammel; squirrel-sql-users@... > Subject: Re: [Squirrel-sql-users] Get exception trying to set timezone > on connection & can't see column definitions > > My test instance is 10.2.0.4 as well (although it is 32-bit). I tried > the latest driver > (11.1.0.7.0-Production) and columns tab works fine for me. Are there > any other exceptions > in the log ? Perhaps it is a permissions issue . I'll try a 10g > 64-bit instance the next chance > I get. > > Rob > > On Fri, Jul 17, 2009 at 11:58 PM, KARR, DAVID (ATTCINW)<dk068x@...> > wrote: > >> -----Original Message----- > >> From: Robert Manning [mailto:robert.m.manning@...] > >> Sent: Friday, July 17, 2009 5:58 PM > >> To: KARR, DAVID (ATTCINW) > >> Cc: Maury Hammel; squirrel-sql-users@... > >> Subject: Re: [Squirrel-sql-users] Get exception trying to set > timezone > >> on connection & can't see column definitions > >> > >> The columns tab issue is not one that I have seen. What version of > >> the JDBC driver and > >> server are you using ? (Click on the top node in the object tree and > >> select the Metadata > >> tab to see values for getDriverVersion and > getDatabaseProductVersion). > >> If they don't match > >> you should be able to retrieve a matching JDBC driver jar from > >> $ORACLE_HOME/jdbc/lib/ folder > >> on your database server. > > > > getDriverVersion: 11.1.0.7.0-Production > > getDatabaseProductVersion: Oracle Database 10g Enterprise Edition > Release 10.2.0.4.0 - 64bit Production > > With the Partitioning, OLAP, Data Mining and Real Application Testing > options > > > > I tried it earlier with the ojdbc14.jar, but I don't know how these > values would change. It shouldn't really matter. > > > >> > >> Rob > >> > >> On Fri, Jul 17, 2009 at 8:08 PM, KARR, DAVID > (ATTCINW)<dk068x@...> > >> wrote: > >> >> -----Original Message----- > >> >> From: Maury Hammel [mailto:ml1.hammel@...] > >> >> Sent: Friday, July 17, 2009 4:58 PM > >> >> To: squirrel-sql-users@... > >> >> Subject: Re: [Squirrel-sql-users] Get exception trying to set > >> timezone > >> >> on connection & can't see column definitions > >> >> > >> >> KARR, DAVID (ATTCINW) wrote: > >> >> > I recently installed SQuirreL 3.0.2. I just configured the > Oracle > >> >> > driver by adding the path to my local ojdbc14.jar file. I > created > >> > an > >> >> > alias for an Oracle database. I connected to it. I noticed > the > >> red > >> >> > mark in the status line, and I saw the following in the log: > >> >> > >> >> I don't know for sure if this is related to your problems, but > I'd > >> go > >> >> get the latest (11.1) Oracle JDBC driver, they have one that is > >> meant > >> >> for Java 6 (ojdbc6.jar). > >> > > >> > In any case, modifying the driver to use ojdbc6 instead made no > >> > difference. I still get the timezone error, and I still can't see > >> > column definitions. > >> > > >> >> > >> >> > >> >> Maury > >> >> > >> >> > >> >> > >> > ------------------------------------------------------------------ > --- > >> -- > >> >> ------- > >> >> Enter the BlackBerry Developer Challenge > >> >> This is your chance to win up to $100,000 in prizes! For a > limited > >> >> time, > >> >> vendors submitting new applications to BlackBerry App World(TM) > will > >> >> have > >> >> the opportunity to enter the BlackBerry Developer Challenge. See > >> full > >> >> prize > >> >> details at: http://p.sf.net/sfu/Challenge > >> >> _______________________________________________ > >> >> Squirrel-sql-users mailing list > >> >> Squirrel-sql-users@... > >> >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > >> > > >> > ------------------------------------------------------------------ > --- > >> --------- > >> > Enter the BlackBerry Developer Challenge > >> > This is your chance to win up to $100,000 in prizes! For a limited > >> time, > >> > vendors submitting new applications to BlackBerry App World(TM) > will > >> have > >> > the opportunity to enter the BlackBerry Developer Challenge. See > full > >> prize > >> > details at: http://p.sf.net/sfu/Challenge > >> > _______________________________________________ > >> > Squirrel-sql-users mailing list > >> > Squirrel-sql-users@... > >> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > >> > > > ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
|
Re: Get exception trying to set timezone onconnection & can't see column definitions
by KARR, DAVID (ATTCINW)
::
Rate this Message:
> -----Original Message-----
> From: KARR, DAVID (ATTCINW) > Sent: Friday, July 17, 2009 12:31 PM > To: squirrel-sql-users@... > Subject: [Squirrel-sql-users] Get exception trying to set timezone > onconnection & can't see column definitions > > Also, while viewing my tables, I see that I can see the Content of the > table (with reasonable column headers), but nothing shows when I go to > the "Columns" tab. Is this just an Oracle permissions problem? Someone else here said that when they use TOAD and QuantumDB (another SQL browser tool, I assume) they see the exact same symptom. That makes it clear this is some sort of DB permission issue. I'll pursue this with a DBA. It would be nice if SQuirreL was able to detect when features are unavailable due to DB permission issues. I have no idea whether that's possible. ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
|
Re: Get exception trying to set timezone onconnection & can't see column definitions
by KARR, DAVID (ATTCINW)
::
Rate this Message:
> -----Original Message-----
> From: KARR, DAVID (ATTCINW) > Sent: Friday, July 17, 2009 12:31 PM > To: squirrel-sql-users@... > Subject: [Squirrel-sql-users] Get exception trying to set timezone > onconnection & can't see column definitions > > Also, while viewing my tables, I see that I can see the Content of the > table (with reasonable column headers), but nothing shows when I go to > the "Columns" tab. Is this just an Oracle permissions problem? My DBA was able to give me a connection that can access the column definitions. He gave me an explanation that doesn't mean much to me, but it might be meaningful to you. I'll excerpt it here. ------------------- The <foo> user doesn't own any objects. The table is owned by user <bar> who has granted access and created a synonym for <foo>. Your client software is probably looking in the user_tab_columns view for the table definition. If it looked in all_tab_columns you would be able to see what you want. If you login as user <bar>/<bar> you will likely see what you expect. ------------------- > > ----------------------------------------------------------------------- > ------- > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited > time, > vendors submitting new applications to BlackBerry App World(TM) will > have > the opportunity to enter the BlackBerry Developer Challenge. See full > prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > Squirrel-sql-users mailing list > Squirrel-sql-users@... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
|
|
Re: Get exception trying to set timezone onconnection & can't see column definitions
by manningr
::
Rate this Message:
David,
Thanks for the explanation from the DBA - that helps explain the behavior you were seeing. Unfortunately, we don't control where the column tab info comes from since we rely on the JDBC implementation to give that information. It sounds like the driver returned the table from the call to getTables, but didn't return that table's columns when we called getColumns (these are two JDBC API methods that we rely heavily on). It may be an edge case that is not well supported by the Oracle JDBC driver. On the other hand, we may not be specifying the schema properly in the call to getColumns (I would have to verify that - just wild speculation on my part). Thanks again though for explaining the conditions under which the problem exists. Rob On Mon, Jul 20, 2009 at 1:19 PM, KARR, DAVID (ATTCINW)<dk068x@...> wrote: >> -----Original Message----- >> From: KARR, DAVID (ATTCINW) >> Sent: Friday, July 17, 2009 12:31 PM >> To: squirrel-sql-users@... >> Subject: [Squirrel-sql-users] Get exception trying to set timezone >> onconnection & can't see column definitions >> >> Also, while viewing my tables, I see that I can see the Content of the >> table (with reasonable column headers), but nothing shows when I go to >> the "Columns" tab. Is this just an Oracle permissions problem? > > My DBA was able to give me a connection that can access the column > definitions. He gave me an explanation that doesn't mean much to me, > but it might be meaningful to you. I'll excerpt it here. > > ------------------- > The <foo> user doesn't own any objects. The table is owned by user <bar> > who has granted access and created a synonym for <foo>. Your client > software is probably looking in the user_tab_columns view for the table > definition. If it looked in all_tab_columns you would be able to see > what you want. If you login as user <bar>/<bar> you will likely see what > you expect. > ------------------- > >> >> > ----------------------------------------------------------------------- >> ------- >> Enter the BlackBerry Developer Challenge >> This is your chance to win up to $100,000 in prizes! For a limited >> time, >> vendors submitting new applications to BlackBerry App World(TM) will >> have >> the opportunity to enter the BlackBerry Developer Challenge. See full >> prize >> details at: http://p.sf.net/sfu/Challenge >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squirrel-sql-users@... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > ------------------------------------------------------------------------------ > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited time, > vendors submitting new applications to BlackBerry App World(TM) will have > the opportunity to enter the BlackBerry Developer Challenge. See full prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > Squirrel-sql-users mailing list > Squirrel-sql-users@... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > ------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge _______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
| Free embeddable forum powered by Nabble | Forum Help |
