[DERBY-1705] Test jdbcapi/dataSourceReference.java fails with 10.2.1 beta candidate jars

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.1.6
• Fix Version/s: 10.2.1.6
• Component/s: Test
• Environment: Linux, Windows IBM 15, Sun jdk 1.5.0_07-b03,
• Urgency: Urgent
• Assignee: Unassigned
• Reporter: Rajesh Kartha
• Created: 16/Aug/06 20:26
• Updated: 13/Dec/07 09:05
• Resolved: 22/Aug/06 14:07

Description

With the Derby 10.2.1 beta candidate jars - 10.2.1.0 - (430903), test jdbcapi/dataSourceReference.java fails with java.lang.reflect.InvocationTargetException. I am seeing this failure in multiple platforms.

Here is the full diff:

Framework: embedded

• • • Start: dataSourceReference jdk1.5.0 2006-08-16 13:18:13 ***
      185 del
      < populated DataSource recreated using Reference as org.apache.derby.jdbc.ClientDataSource
      186 del
      < Start compare recreated
      187 del
      < connectionAttributes=XX_connectionAttributes_2135
      188 del
      < dataSourceName=XX_dataSourceName_1420
      189 del
      < databaseName=XX_databaseName_1206
      190 del
      < description=XX_description_1188
      191 del
      < loginTimeout=1280
      192 del
      < password=XX_password_883
      193 del
      < portNumber=1070
      194 del
      < retrieveMessageText=false
      195 del
      < securityMechanism=1805
      196 del
      < serverName=XX_serverName_1048
      197 del
      < traceDirectory=XX_traceDirectory_1476
      198 del
      < traceFile=XX_traceFile_911
      199 del
      < traceFileAppend=true
      200 del
      < traceLevel=1031
      201 del
      < user=XX_user_447
      202 del
      < Completed compare recreated
      203 del
      < populated DataSource recreated using serialization
      204 del
      < Start compare recreated
      205 del
      < connectionAttributes=XX_connectionAttributes_2135
      206 del
      < dataSourceName=XX_dataSourceName_1420
      207 del
      < databaseName=XX_databaseName_1206
      208 del
      < description=XX_description_1188
      209 del
      < loginTimeout=1280
      210 del
      < password=XX_password_883
      211 del
      < portNumber=1070
      212 del
      < retrieveMessageText=false
      213 del
      < securityMechanism=1805
      214 del
      < serverName=XX_serverName_1048
      215 del
      < traceDirectory=XX_traceDirectory_1476
      216 del
      < traceFile=XX_traceFile_911
      217 del
      < traceFileAppend=true
      218 del
      < traceLevel=1031
      219 del
      < user=XX_user_447
      220 del
      < Completed compare recreated
      221 del
      < DataSource class org.apache.derby.jdbc.ClientConnectionPoolDataSource
      222 del
      < property list
      223 del
      < connectionAttributes
      224 del
      < dataSourceName
      225 del
      < databaseName
      226 del
      < description
      227 del
      < loginTimeout
      228 del
      < password
      229 del
      < portNumber
      230 del
      < retrieveMessageText
      231 del
      < securityMechanism
      232 del
      < serverName
      233 del
      < traceDirectory
      234 del
      < traceFile
      235 del
      < traceFileAppend
      236 del
      < traceLevel
      237 del
      < user
      238 del
      < empty DataSource recreated using Reference as org.apache.derby.jdbc.ClientConnectionPoolDataSource
      239 del
      < Start compare recreated
      240 del
      < loginTimeout=0
      241 del
      < portNumber=1527
      242 del
      < retrieveMessageText=true
      243 del
      < securityMechanism=4
      244 del
      < serverName=xxxFILTERED_HOSTNAMExxx
      245 del
      < traceFileAppend=false
      246 del
      < traceLevel=-1
      247 del
      < user=APP
      248 del
      < Completed compare recreated
      249 del
      < empty DataSource recreated using serialization
      250 del
      < Start compare recreated
      251 del
      < loginTimeout=0
      252 del
      < portNumber=1527
      253 del
      < retrieveMessageText=true
      254 del
      < securityMechanism=4
      255 del
      < serverName=xxxFILTERED_HOSTNAMExxx
      256 del
      < traceFileAppend=false
      257 del
      < traceLevel=-1
      258 del
      < user=APP
      259 del
      < Completed compare recreated
      260 del
      < populated DataSource recreated using Reference as org.apache.derby.jdbc.ClientConnectionPoolDataSource
      261 del
      < Start compare recreated
      262 del
      < connectionAttributes=XX_connectionAttributes_2135
      263 del
      < dataSourceName=XX_dataSourceName_1420
      264 del
      < databaseName=XX_databaseName_1206
      265 del
      < description=XX_description_1188
      266 del
      < loginTimeout=1280
      267 del
      < password=XX_password_883
      268 del
      < portNumber=1070
      269 del
      < retrieveMessageText=false
      270 del
      < securityMechanism=1805
      271 del
      < serverName=XX_serverName_1048
      272 del
      < traceDirectory=XX_traceDirectory_1476
      273 del
      < traceFile=XX_traceFile_911
      274 del
      < traceFileAppend=true
      275 del
      < traceLevel=1031
      276 del
      < user=XX_user_447
      277 del
      < Completed compare recreated
      278 del
      < populated DataSource recreated using serialization
      279 del
      < Start compare recreated
      280 del
      < connectionAttributes=XX_connectionAttributes_2135
      281 del
      < dataSourceName=XX_dataSourceName_1420
      282 del
      < databaseName=XX_databaseName_1206
      283 del
      < description=XX_description_1188
      284 del
      < loginTimeout=1280
      285 del
      < password=XX_password_883
      286 del
      < portNumber=1070
      287 del
      < retrieveMessageText=false
      288 del
      < securityMechanism=1805
      289 del
      < serverName=XX_serverName_1048
      290 del
      < traceDirectory=XX_traceDirectory_1476
      291 del
      < traceFile=XX_traceFile_911
      292 del
      < traceFileAppend=true
      293 del
      < traceLevel=1031
      294 del
      < user=XX_user_447
      295 del
      < Completed compare recreated
      296 del
      < DataSource class org.apache.derby.jdbc.ClientXADataSource
      297 del
      < property list
      298 del
      < connectionAttributes
      299 del
      < dataSourceName
      300 del
      < databaseName
      301 del
      < description
      302 del
      < loginTimeout
      303 del
      < password
      304 del
      < portNumber
      305 del
      < retrieveMessageText
      306 del
      < securityMechanism
      307 del
      < serverName
      308 del
      < traceDirectory
      309 del
      < traceFile
      310 del
      < traceFileAppend
      311 del
      < traceLevel
      312 del
      < user
      313 del
      < empty DataSource recreated using Reference as org.apache.derby.jdbc.ClientXADataSource
      314 del
      < Start compare recreated
      315 del
      < loginTimeout=0
      316 del
      < portNumber=1527
      317 del
      < retrieveMessageText=true
      318 del
      < securityMechanism=4
      319 del
      < serverName=xxxFILTERED_HOSTNAMExxx
      320 del
      < traceFileAppend=false
      321 del
      < traceLevel=-1
      322 del
      < user=APP
      323 del
      < Completed compare recreated
      324 del
      < empty DataSource recreated using serialization
      325 del
      < Start compare recreated
      326 del
      < loginTimeout=0
      327 del
      < portNumber=1527
      328 del
      < retrieveMessageText=true
      329 del
      < securityMechanism=4
      330 del
      < serverName=xxxFILTERED_HOSTNAMExxx
      331 del
      < traceFileAppend=false
      332 del
      < traceLevel=-1
      333 del
      < user=APP
      334 del
      < Completed compare recreated
      335 del
      < populated DataSource recreated using Reference as org.apache.derby.jdbc.ClientXADataSource
      336 del
      < Start compare recreated
      337 del
      < connectionAttributes=XX_connectionAttributes_2135
      338 del
      < dataSourceName=XX_dataSourceName_1420
      339 del
      < databaseName=XX_databaseName_1206
      340 del
      < description=XX_description_1188
      341 del
      < loginTimeout=1280
      342 del
      < password=XX_password_883
      343 del
      < portNumber=1070
      344 del
      < retrieveMessageText=false
      345 del
      < securityMechanism=1805
      346 del
      < serverName=XX_serverName_1048
      347 del
      < traceDirectory=XX_traceDirectory_1476
      348 del
      < traceFile=XX_traceFile_911
      349 del
      < traceFileAppend=true
      350 del
      < traceLevel=1031
      351 del
      < user=XX_user_447
      352 del
      < Completed compare recreated
      353 del
      < populated DataSource recreated using serialization
      354 del
      < Start compare recreated
      355 del
      < connectionAttributes=XX_connectionAttributes_2135
      356 del
      < dataSourceName=XX_dataSourceName_1420
      357 del
      < databaseName=XX_databaseName_1206
      358 del
      < description=XX_description_1188
      359 del
      < loginTimeout=1280
      360 del
      < password=XX_password_883
      361 del
      < portNumber=1070
      362 del
      < retrieveMessageText=false
      363 del
      < securityMechanism=1805
      364 del
      < serverName=XX_serverName_1048
      365 del
      < traceDirectory=XX_traceDirectory_1476
      366 del
      < traceFile=XX_traceFile_911
      367 del
      < traceFileAppend=true
      368 del
      < traceLevel=1031
      369 del
      < user=XX_user_447
      370 del
      < Completed compare recreated
      371 del
      < Completed dataSourceReference
      371 add
      > Exception in thread "main" java.lang.reflect.InvocationTargetException
      > Caused by: java.sql.SQLException: Invalid attribute syntax: XX_connectionAttributes_2135
      > ... 6 more
      > Caused by: org.apache.derby.client.am.SqlException: Invalid attribute syntax: XX_connectionAttributes_2135
      > ... 7 more
      Test Failed.
    • End: dataSourceReference jdk1.5.0 2006-08-16 13:18:32 ***

The dataSourceReference.tmp file show little more info:

Exception in thread "main" java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.apache.derbyTesting.functionTests.tests.jdbcapi.dataSourceReference.testDSReference(Unknown Source)
at org.apache.derbyTesting.functionTests.tests.jdbcapi.dataSourceReference.main(Unknown Source)
Caused by: java.sql.SQLException: Invalid attribute syntax: XX_connectionAttributes_2135
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.jdbc.ClientBaseDataSource.setConnectionAttributes(Unknown Source)
... 6 more
Caused by: org.apache.derby.client.am.SqlException: Invalid attribute syntax: XX_connectionAttributes_2135
at org.apache.derby.jdbc.ClientBaseDataSource.tokenizeAttributes(Unknown Source)
... 7 more