• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Bear Bibeault
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Jj Roberts
  • Tim Holloway
  • Piet Souris
Bartenders:
  • Himai Minh
  • Carey Brown
  • salvin francis

Error derby 40000

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Greetings, I have a problem running the database on netbeans 8.2, hopefully you can help me

Log:

Mon Nov 09 01:10:40 COT 2020 : Servidor de red Apache Derby: Se ha iniciado 10.11.1.2 - (1629631) y está listo para aceptar las conexiones en el puerto 1527
Mon Nov 09 01:10:40 COT 2020 Thread[DRDAConnThread_2,5,main] Cleanup action starting
ERROR XBM0X: La descripción de configuración regional suministrada 'es_419' no es válida, se esperaba ln[_CO[_variante]]
ln=código de idioma ISO-639 de dos letras en minúsculas, CO=código de país ISO-3166 de dos letras en mayúsculas, consulte java.util.Locale.

Caused by: ERROR XJ041: No se ha podido crear la base de datos 'fdfdfd', consulte la excepción siguiente para obtener más información.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 16 more
Caused by: ERROR XBM0X: La descripción de configuración regional suministrada 'es_419' no es válida, se esperaba ln[_CO[_variante]]
ln=código de idioma ISO-639 de dos letras en minúsculas, CO=código de país ISO-3166 de dos letras en mayúsculas, consulte java.util.Locale.

============= begin nested exception, level (1) ===========
java.sql.SQLException: La descripción de configuración regional suministrada 'es_419' no es válida, se esperaba ln[_CO[_variante]]
ln=código de idioma ISO-639 de dos letras en minúsculas, CO=código de país ISO-3166 de dos letras en mayúsculas, consulte java.util.Locale.

Caused by: ERROR XBM0X: La descripción de configuración regional suministrada 'es_419' no es válida, se esperaba ln[_CO[_variante]]
ln=código de idioma ISO-639 de dos letras en minúsculas, CO=código de país ISO-3166 de dos letras en mayúsculas, consulte java.util.Locale.

Cleanup action completed
Mon Nov 09 01:10:40 COT 2020 Thread[DRDAConnThread_2,5,main] (DATABASE = fdfdfd), (DRDAID = {1}), No se ha podido crear la base de datos 'fdfdfd', consulte la excepción siguiente para obtener más información.
Mon Nov 09 01:10:40 COT 2020 Thread[DRDAConnThread_2,5,main] (DATABASE = fdfdfd), (DRDAID = {1}), La descripción de configuración regional suministrada 'es_419' no es válida, se esperaba ln[_CO[_variante]]
ln=código de idioma ISO-639 de dos letras en minúsculas, CO=código de país ISO-3166 de dos letras en mayúsculas, consulte java.util.Locale.

 
Marshal
Posts: 71047
291
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to the Ranch

What does the error message say when you translate it from Spanish to English? Have you tried running that SQL instruction anywhere other than NetBeans?

Moving to our databases forum.
 
Saloon Keeper
Posts: 22784
153
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Double fun, translating not only text in a foreign language, but also acronyms.

As near as I can make out, there's an invalid data problem where a 2-character uppercase nationality code (ES, MX, US, GB, DE, ...) is required by the actual value encountered seems to have been someone randomly typing (fsfsfs). So it's both the wrong length and the wrong characters.

I'm not sure if the error is in the schema definition of a database or table or in a value intended to be stored in a table. "CO" means "column" here, I think.
 
Rancher
Posts: 4741
50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
XJ041 is "Failed to create database '<databaseName>', see the next exception for details.".
The cause was:
XBM0X, which is "Supplied territory description '<value>' is invalid, expecting ln[_CO[_variant]] ln=lower-case two-letter ISO-639 language code, CO=upper-case two-letter ISO-3166 country codes, see java.util.Locale."

'fdfdfd' is the database name, and 'es_419' is the incorrect value being used.

And I think this is when Derby is trying to start up, and is not when it's being used...possibly related to this:
http://mail-archives.apache.org/mod_mbox/db-derby-dev/201901.mbox/%3CJIRA.12732734.1407459093000.142601.1548067680251@Atlassian.JIRA%3E
 
Well THAT's new! Comfort me, reliable tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic