Why do I get SQLCODE=-204, SQLSTATE=42704 with DB2 LUW and WebSphere App Server?

The answer is case sensitivity.

This answer was in fact provided by mustaccio in a comment, but they don’t seem to want to add it as an answer. If you see this, @mustaccio, please add your own answer, so I can accept it.

Anyway, it turns out that WAS appears to effectively put quotes round the values you specify in the “Custom Properties” section. I had entered M51Dev for the currentSchema property, and it was being sent to DB2 as "M51Dev". But DB2 had stored the schema name as M51DEV It sees those as two different values, of course..

Specifiying M51DEV for the property value fixed the problem.

Related Posts:

  1. getting error HTTP Status 405 – HTTP method GET is not supported by this URL but not used `get` ever?
  2. SLF4J: Failed to load class “org.slf4j.impl.StaticLoggerBinder”
  3. Can’t find mysqladmin on Mac OSX 10.6.8
  4. DB2 jdbc connection error Connection refused. ERRORCODE=-4499, SQLSTATE=08001
  5. SLF4J: Failed to load class “org.slf4j.impl.StaticLoggerBinder”
  6. How to solve DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502
  7. DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704
  8. javac is not recognized as an internal or external command, operable program or batch file [closed]
  9. What is a StackOverflowError?
  10. How to uninstall Eclipse?
  11. How do I determine whether an array contains a particular value in Java?
  12. How can I solve Exception in thread “main” java.lang.NullPointerException error [duplicate]
  13. Why am I getting a NoClassDefFoundError in Java?
  14. How to avoid “ConcurrentModificationException” while removing elements from `ArrayList` while iterating it? [duplicate]
  15. Using Pairs or 2-tuples in Java [duplicate]
  16. Is there a way to convert all comments into javadoc comments? [Eclipse/Java]
  17. Reverse a string in Java
  18. Bad Operand Types for Binary Operator “>”?
  19. Error occurred during initialization of boot layer FindException: Module not found
  20. ‘mvn’ is not recognized as an internal or external command, operable program or batch file
  21. How to use multiple classes in java in one file?
  22. Java: Multiple class declarations in one file
  23. Why do JVM arguments start with “-D”?
  24. How to split a string in Java
  25. Printing out a linked list using toString
  26. Received fatal alert: handshake_failure through SSLHandshakeException
  27. Best way to Format a Double value to 2 Decimal places
  28. what does Dead Code mean under Eclipse IDE Problems Section
  29. java, get set methods
  30. Javadoc @see or {@link}?
  31. Remote debugging a Java application
  32. What’s the difference between next() and nextLine() methods from Scanner class?
  33. How to identify object types in java
  34. What is the result of making log4j additivity equals to true or false?
  35. How do I use a delimiter with Scanner.useDelimiter in Java?
  36. Sort a single String in Java
  37. Difference between slf4j-log4j12 and log4j-over-slf4j
  38. Java, “Variable name” cannot be resolved to a variable
  39. Causes of getting a java.lang.VerifyError
  40. “Unmappable character for encoding UTF-8” error
  41. UnsatisfiedDependencyException: Error creating bean with name
  42. Random shuffling of an array
  43. How to convert int[] to Integer[] in Java?
  44. Why am I getting a “; expected” error?
  45. How/where to download openjdk/openjre for windows [duplicate]
  46. copy a 2d array in java
  47. Exception in thread “main” java.lang.ArrayIndexOutOfBoundsException
  48. Generating all permutations of a given string
  49. imageio.IIOException: Can’t read input file
  50. Difference between OpenJDK and Adoptium/AdoptOpenJDK
  51. Compile failed; see the compiler error output for details
  52. Java: Rotating Images
  53. Invalid character constant in java
  54. How can I truncate a double to only two decimal places in Java?
  55. Cannot resolve symbol “Intent”
  56. What is the default initialization of an array in Java?
  57. java sort using anonymous class
  58. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  59. channel 3: open failed: connect failed: Connection refused
  60. Java Currency Number format
  61. How to create a generic array in Java?
  62. Print a boolean value with printf
  63. Meaning of @Resource annotation
  64. How to solve error lossy convertion from int to char?
  65. What does “error: ‘.class’ expected” mean and how do I fix it
  66. Printing the stack values in Java
  67. Import a custom class in Java
  68. What is the jasperrepots-fonts jar for and how to use it?
  69. Does Java have an StringStream equivalent?
  70. Difference between String replace() and replaceAll()
  71. How do I get the size of a java.sql.ResultSet?
  72. Java: How to set Precision for double value?
  73. Any way to declare an array in-line?
  74. java.io.StreamCorruptedException: invalid stream header: 54657374
  75. How to cast ArrayList<> from List<>
  76. Best way to “negate” an instanceof
  77. How to send HTTP request in java?
  78. why android studio show error of “Missing constraints in constraintlayout”?
  79. Change the size of a JTextField inside a JBorderLayout
  80. java.lang.ArrayIndexOutOfBoundsException: 0
  81. What’s wrong with overridable method calls in constructors?
  82. what is the difference between doGet() and doPost() in term of the flow?
  83. Java 3D Game Engine?
  84. How to cast ArrayList<> from List<>
  85. Using insertion sort for descending order?
  86. What is the home directory for JDK?
  87. java.lang.ClassNotFoundException: org.postgresql.Driver, Android
  88. Java – Change int to ascii
  89. Javadoc @author tag good practices
  90. A fatal error has been detected by the Java Runtime Environment: SIGSEGV, libjvm
  91. java.lang.IllegalStateException: Failed to introspect Class
  92. ShoppingCart.Java Program Assignment
  93. White spaces are required between publicId and systemId
  94. Http status 401 This request requires HTTP authentication (). in tomcat 6
  95. Get integer value of the current year in Java
  96. How to make the division of 2 ints produce a float instead of another int?
  97. Java Console Prompt for ENTER input before moving on [duplicate]
  98. Can’t load IA 32-bit .dll on a AMD 64-bit platform
  99. Android Studio 2.2.3: Gradle project sync failed. Basic functionality (e.g. editting, debugging) will not work properly
  100. How to draw a circle with given X and Y coordinates as the middle spot of the circle?

Leave a Comment