Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ora-01882 "timezone region not found" with 3.0.03.97 but not with 3.0.03.45

CharonMar 24 2011 — edited Apr 8 2011
I installed the version 3.0.03.97 of SQL-Developer and now get an ora-01882 when I connect to a DB. I don't get this Problem when using version 3.0.03.45.

Putting "AddVMOption -Duser.region=DE" in the sqldeveloper.conf didn't solve this problem though.

The problem happens both with the connection-type "simple" and "TNS".

I am on 32bit Windows 7 Professional.
Java JDK is jdk1.6.0_23.
Oracle Instantclient is 11.1.0.1.0
Database is version 9.2.0.1.0

Anyone got this problem too? What changed between both versions of the SQL-Developer?

Regards
Markus

Edited by: Charon on Mar 24, 2011 11:52 AM

Comments

807589
Here is another configuration file that uses multiple appenders.
log4j.rootLogger=debug, stdout, R

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

# Pattern to output the caller's file name and line number.
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] (%F:%L) - %m%n

log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File=example.log

log4j.appender.R.MaxFileSize=100KB
# Keep one backup file
log4j.appender.R.MaxBackupIndex=1

log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%p %t %c - %m%n
In addition, as the root logger has been allocated a second appender, output will also be directed to the example.log file. This file will be rolled over when it reaches 100KB. When roll-over occurs, the old version of example.log is automatically moved to example.log.1.
807589
Where does the log go in Linux if I do this:
log4j.appender.R.File=log4j.log
807589
revchrism wrote:
Where does the log go in Linux if I do this:
log4j.appender.R.File=log4j.log
to the mentioned location i.e. log4j.log
807589
Where is the file going to be located? /, /home, /tmp, the users home directory
625957
Where is the file going to be located? /, /home, /tmp, the users home directory
Why not try it? I vote for none of the above.

You can use java system properties in your log4 properties file: [http://forums.sun.com/thread.jspa?messageID=4445852]
807589
I have some users on Windows and others on Linux, currently the Windows users have no problem with the log4j.log (it's being created in C:\TEMP\). However the Linux users are not able to create the log4j.log because there is no file called C:\TEMP\ on their systems. What I need is a way to have the program see which OS the user has and change the output folder for the log4j.log. Is there anyway of doing that? Can I setup multiple file locations?
625957
From what I understand you have these options:

1) Create 2 builds of your app for different operating systems with different log4j configs
2) Create the logs in a directory relative to your application.
3) Use a java system property in log4j properties file and log to java.io.tempdir for example.

You seem really keen on logging to c:\temp or /tmp, why?
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 6 2011
Added on Mar 24 2011
#sql-developer
10 comments
18,248 views