SQL Power Business Intelligence Productivity Tools

SQL Power Software Forum

SQL Power Software Forum

  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page  [Register] Register /  [Login] Login 
Getting "Locale not Recognized" when creating JDBC connection.  XML
Forum Index » SQL Power Architect Technical Support
Author Message
Kirti M


Joined: 2015-02-12 16:21:34
Messages: 71
Offline

Hi edo,

Can you post the detail log for this error and also steps to reproduce the error.

Thanks,

Kirti
diggydobby


Joined: 2016-09-19 03:52:46
Messages: 3
Offline

Kirti M wrote:Hi edo,

Can you post the detail log for this error and also steps to reproduce the error.

Thanks,

Kirti


When creating new Oracle11g connection, in preferences ojdbc5.jar, ons.jar. My Mac dont have EN as default language.

java.sql.SQLException: Locale not recognized
at oracle.jdbc.driver.T4CTTIoauthenticate.setSessionFields(T4CTTIoauthenticate.java:1006)
at oracle.jdbc.driver.T4CTTIoauthenticate.<init>(T4CTTIoauthenticate.java:23
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:52
at ca.sqlpower.sql.JDBCDataSource.createConnection(JDBCDataSource.java:296)
at ca.sqlpower.swingui.JDBCDataSourcePanel$1.actionPerformed(JDBCDataSourcePanel.java:16
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:234
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6533)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:629
at java.awt.Container.processEvent(Container.java:2236)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2294)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:488
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
at java.awt.Container.dispatchEventImpl(Container.java:2280)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:75
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:72
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

This message was edited 1 time. Last update was at 2016-09-19 03:58:05

diggydobby


Joined: 2016-09-19 03:52:46
Messages: 3
Offline

I switched my Mac to EN in Lang preferences, also added parameter:
-Duser.language=en -Duser.country=US
into Java settings (1.8 version btw) and restarted. Didn't helped.
Kirti M


Joined: 2015-02-12 16:21:34
Messages: 71
Offline

Hi!

Try to change default language from preference.

-Kirti
diggydobby


Joined: 2016-09-19 03:52:46
Messages: 3
Offline

Kirti M wrote:Hi!

Try to change default language from preference.

-Kirti


I have SQL PA in english.
I have whole system in english, region in US, time for US and it is still not enough. There are zero options to configure NLS in PA settings like in Oracle SQL Developer, which shows region, time and language right as I set it in system. What a disappointment, now I am stuck with Beaver.
cdlaurent


Joined: 2017-05-01 09:44:34
Messages: 1
Offline

I have the same problem. SQL PA doesn't do the right thing with the locale when trying to connect to Oracle over jdbc.

I ran a java program, and printed out the default locale - it was en_US, as it should be.
I don't know what SQL PA is/isn't passing to oracle; but SQL PA won't connect to oracle (at least on a mac).

Additionally, other Java based SQL tools don't have this problem (SQurrel, DBVisualizer, etc)

This message was edited 2 times. Last update was at 2017-05-03 09:13:27

 
Forum Index » SQL Power Architect Technical Support
Go to:   
Powered by JForum 2.1.8 © JForum Team