lundi 30 juillet 2012

Having Eclipse (juno 4.2) Database Development pluging working correctly with oracle jdbc (ojdbc14.jar) in linux.

I recently had to reinstall a new development environment at work for my new laptop and it required to add the Database Development plugin to the latest Eclipse (Juno 4.2). My issue was occuring with a connection to an Oracle DB using the ojdbc14.jar library, I always faced a failure of connection (ping Failed, or Oracle 1275 NLS error ).
Anyway the machine hosting the Database was fully reachable and the proxy correctly configured, so there were absolutly no valuable reason to persistly refusing connecting to the DB.
After wasting half of a day googling, I remembered that  I faced exactly the same issue a year ago and that I resolved it adding the bellow lines to the eclipse.ini file:

-Duser.language=en
-Duser.country=US


Now, don't ask me why the language used in Eclipse has anything to do with the connection to the DB but anyway after restarting my Eclipse the plugin connection to the Oracle DB worked perfectly!!
Cheers to all!