API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 13th, 2019
205
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 30.98 KB | None | 0 0
raw download clone embed print report
  1. 2019-01-13 23:23:49,058 [DEBUG][o.s.j.c.JdbcTemplate:612] Executing prepared SQL statement [SELECT a.ID, a.TITLE, a.CARD_TYPE, b.ID SERVICE_ID, '0' SEQUENCE, '0' PRE_REQ, a.WMLID, a.WML_VERSION VERSION, a.WML, dp.WSM_SVVID SVVID, a.WML_BYTECODE FROM A1_CC_WML a   INNER JOIN A1_CC_SERVICE b     ON a.SERVICE_ID=b.ID   LEFT JOIN CC_DP_MAPPING_SERVICES dp     ON a.SERVICE_ID=dp.CC_SVRID and a.WML_VERSION = dp.CC_SVR_VER WHERE b.ID=?   AND a.WML_VERSION=?   AND a.CARD_TYPE='WIB' ]
  2. CCWMLRowMapper ID set
  3. CCWMLRowMapper TITLE set
  4. CCWMLRowMapper SERVICE_ID set
  5. CCWMLRowMapper CARD_TYPE set
  6. CCWMLRowMapper SVVID set
  7. CCWMLRowMapper VERSION set
  8. CCWMLRowMapper WMLID set
  9. CCWMLRowMapper WML set
  10. CCWMLRowMapper CARD_TYPE set
  11. 2019-01-13 23:23:49,115 [INFO ][a.s.s.s.AppLoggingService:49] S0001: Found WIB WML for service_id:13,935 and version:1
  12. 2019-01-13 23:23:49,116 [DEBUG][o.s.t.s.AbstractPlatformTransactionManager:759] Initiating transaction commit
  13. 2019-01-13 23:23:49,118 [DEBUG][o.s.j.d.DataSourceTransactionManager:269] Committing JDBC transaction on Connection [ProxyConnection[PooledConnection[oracle.jdbc.driver.T4CConnection@7ce702ee]]]
  14. 2019-01-13 23:23:49,118 [DEBUG][o.s.j.d.DataSourceTransactionManager:327] Releasing JDBC Connection [ProxyConnection[PooledConnection[oracle.jdbc.driver.T4CConnection@7ce702ee]]] after transaction
  15. 2019-01-13 23:23:49,119 [DEBUG][o.s.j.d.DataSourceUtils:327] Returning JDBC Connection to DataSource
  16. 2019-01-13 23:23:49,120 [DEBUG][o.s.t.s.AbstractPlatformTransactionManager:367] Creating new transaction with name [app.solution.smart.bom.ui.service.PcaService.isOngoingPushService]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; ''
  17. 2019-01-13 23:23:49,120 [DEBUG][o.s.j.d.DataSourceTransactionManager:206] Acquired Connection [ProxyConnection[PooledConnection[oracle.jdbc.driver.T4CConnection@7ce702ee]]] for JDBC transaction
  18. 2019-01-13 23:23:49,120 [DEBUG][o.s.j.d.DataSourceTransactionManager:223] Switching JDBC Connection [ProxyConnection[PooledConnection[oracle.jdbc.driver.T4CConnection@7ce702ee]]] to manual commit
  19. 2019-01-13 23:23:49,122 [DEBUG][o.s.j.c.JdbcTemplate:678] Executing prepared SQL query
  20. 2019-01-13 23:23:49,122 [DEBUG][o.s.j.c.JdbcTemplate:612] Executing prepared SQL statement [SELECT COUNT(DISTINCT H.PCAID) FROM PCA_CCA H RIGHT JOIN PCA_CCA_DETAILS D ON H.PCAID=D.PCAID WHERE D.SRVID IN (?) AND H.STATUS = 'PROCESSING' AND H.MSISDN = ? ]
  21. 2019-01-13 23:23:49,128 [DEBUG][o.s.t.s.AbstractPlatformTransactionManager:759] Initiating transaction commit
  22. 2019-01-13 23:23:49,129 [DEBUG][o.s.j.d.DataSourceTransactionManager:269] Committing JDBC transaction on Connection [ProxyConnection[PooledConnection[oracle.jdbc.driver.T4CConnection@7ce702ee]]]
  23. 2019-01-13 23:23:49,129 [DEBUG][o.s.j.d.DataSourceTransactionManager:327] Releasing JDBC Connection [ProxyConnection[PooledConnection[oracle.jdbc.driver.T4CConnection@7ce702ee]]] after transaction
  24. 2019-01-13 23:23:49,130 [DEBUG][o.s.j.d.DataSourceUtils:327] Returning JDBC Connection to DataSource
  25. 2019-01-13 23:23:49,131 [INFO ][a.s.s.b.u.c.ApiController:147] SAVE PCA {pcaId=PCA201900000109, dateIssue=Sun Jan 13 23:23:49 PHT 2019, msisdn=639476668896, imsi=null, simtype=WIB, author=anonymousUser, status=PROCESSING, completedDate=null, wsmIdAdd=null, wsmIdDel=null, details=[PcaDetails{id=null, pcaId=PCA201900000109, serviceCode=GETWMLCF, srvId=13935, srvSequence=1, srvVersion=1, operationType=ADD, status=PROCESSING, dpSvvId=320894, wmlId=526, wmltext=<?xml version="1.0" encoding="ISO-8859-1"?>
  26. <wml xmlns="http://www.smarttrust.com/WIG-WML/5.0"
  27. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  28. xsi:schemalocation="http://www.smarttrust.com/WIG-WML/5.0 http://www.smarttrust.com/xsd/wigwml-5.0.xsd">
  29. <card id="Test1">
  30. <p>Hello World</p>
  31. </card>
  32. </wml>, chkSimVer=false, msisdn=639476668896, brand=WIB_IMS_BroPre_01, svcKeyword=GETREG, svcAccessCode=8168343}], removeList=[], sfmList=[]}
  33. 2019-01-13 23:23:49,131 [DEBUG][o.s.t.s.AbstractPlatformTransactionManager:367] Creating new transaction with name [app.solution.smart.bom.ui.service.PcaService.savePca]: PROPAGATION_REQUIRES_NEW,ISOLATION_DEFAULT; ''
  34. 2019-01-13 23:23:49,132 [DEBUG][o.s.j.d.DataSourceTransactionManager:206] Acquired Connection [ProxyConnection[PooledConnection[oracle.jdbc.driver.T4CConnection@7ce702ee]]] for JDBC transaction
  35. 2019-01-13 23:23:49,132 [DEBUG][o.s.j.d.DataSourceTransactionManager:223] Switching JDBC Connection [ProxyConnection[PooledConnection[oracle.jdbc.driver.T4CConnection@7ce702ee]]] to manual commit
  36. 2019-01-13 23:23:49,134 [DEBUG][o.s.j.c.JdbcTemplate:865] Executing prepared SQL update
  37. 2019-01-13 23:23:49,135 [DEBUG][o.s.j.c.JdbcTemplate:612] Executing prepared SQL statement [INSERT INTO PCA_CCA (PCAID, DATEISSUE, MSISDN, IMSI, SIMTYPE, AUTHOR, STATUS, REFID) VALUES(?, ?, ?, ?, ?, ?, ?, ?)]
  38. 2019-01-13 23:23:49,150 [DEBUG][o.s.j.c.StatementCreatorUtils:266] JDBC 3.0 getParameterType call not supported - using fallback method instead: java.sql.SQLException: Unsupported feature
  39. 2019-01-13 23:23:49,158 [DEBUG][o.s.j.c.JdbcTemplate$2:875] SQL update affected 1 rows
  40. 2019-01-13 23:23:49,166 [DEBUG][o.s.j.c.JdbcTemplate:943] Executing SQL batch update [INSERT INTO PCA_CCA_DETAILS (ID, PCAID, SRVID, SRVSEQ, SRVVER, STATUS, OP_TYPE, BRAND) VALUES(?, ?, ?, ?, ?, ?, ?, ?)]
  41. 2019-01-13 23:23:49,168 [DEBUG][o.s.j.c.JdbcTemplate:612] Executing prepared SQL statement [INSERT INTO PCA_CCA_DETAILS (ID, PCAID, SRVID, SRVSEQ, SRVVER, STATUS, OP_TYPE, BRAND) VALUES(?, ?, ?, ?, ?, ?, ?, ?)]
  42. 2019-01-13 23:23:49,169 [DEBUG][o.s.j.s.JdbcUtils:372] JDBC driver supports batch updates
  43. 2019-01-13 23:23:49,171 [INFO ][a.s.s.s.AppLoggingService:49] S0001: Save PCA transaction Succeded
  44. 2019-01-13 23:23:49,172 [DEBUG][o.s.t.s.AbstractPlatformTransactionManager:759] Initiating transaction commit
  45. 2019-01-13 23:23:49,173 [DEBUG][o.s.j.d.DataSourceTransactionManager:269] Committing JDBC transaction on Connection [ProxyConnection[PooledConnection[oracle.jdbc.driver.T4CConnection@7ce702ee]]]
  46. 2019-01-13 23:23:49,176 [DEBUG][o.s.j.d.DataSourceTransactionManager:327] Releasing JDBC Connection [ProxyConnection[PooledConnection[oracle.jdbc.driver.T4CConnection@7ce702ee]]] after transaction
  47. 2019-01-13 23:23:49,176 [DEBUG][o.s.j.d.DataSourceUtils:327] Returning JDBC Connection to DataSource
  48. 2019-01-13 23:23:49,177 [INFO ][a.s.s.b.u.c.ApiController:371] PcaDetails{id=null, pcaId=PCA201900000109, serviceCode=GETWMLCF, srvId=13935, srvSequence=1, srvVersion=1, operationType=ADD, status=PROCESSING, dpSvvId=320894, wmlId=526, wmltext=<?xml version="1.0" encoding="ISO-8859-1"?>
  49. <wml xmlns="http://www.smarttrust.com/WIG-WML/5.0"
  50. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  51. xsi:schemalocation="http://www.smarttrust.com/WIG-WML/5.0 http://www.smarttrust.com/xsd/wigwml-5.0.xsd">
  52. <card id="Test1">
  53. <p>Hello World</p>
  54. </card>
  55. </wml>, chkSimVer=false, msisdn=639476668896, brand=WIB_IMS_BroPre_01, svcKeyword=GETREG, svcAccessCode=8168343}
  56. 2019-01-13 23:23:49,178 [DEBUG][o.s.t.s.AbstractPlatformTransactionManager:367] Creating new transaction with name [app.solution.smart.bom.ui.service.openapi.OpenApiTrxType.findPcaDetailByServiceId]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT; ''
  57. 2019-01-13 23:23:49,178 [DEBUG][o.s.j.d.DataSourceTransactionManager:206] Acquired Connection [ProxyConnection[PooledConnection[oracle.jdbc.driver.T4CConnection@7ce702ee]]] for JDBC transaction
  58. 2019-01-13 23:23:49,179 [DEBUG][o.s.j.d.DataSourceTransactionManager:223] Switching JDBC Connection [ProxyConnection[PooledConnection[oracle.jdbc.driver.T4CConnection@7ce702ee]]] to manual commit
  59. 2019-01-13 23:23:49,190 [DEBUG][o.s.j.c.JdbcTemplate:678] Executing prepared SQL query
  60. 2019-01-13 23:23:49,191 [DEBUG][o.s.j.c.JdbcTemplate:612] Executing prepared SQL statement [select a.id as ID, a.title as TITLE, a.service_id as SERVICE_ID, a.card_type as CARD_TYPE,a.wml_sequence as SEQUENCE, a.pre_req as PRE_REQ,a.wml_version as VERSION, a.wmlid as WMLID, a.wml as WML, a.wml_bytecode as WML_BYTECODE,0 as SVVID from a1_cc_wml a where SERVICE_ID=13935 and CARD_TYPE = 'WIB' order by VERSION asc]
  61. 2019-01-13 23:23:49,202 [DEBUG][o.s.c.e.MutablePropertySources:109] Adding [systemProperties] PropertySource with lowest search precedence
  62. 2019-01-13 23:23:49,203 [DEBUG][o.s.c.e.MutablePropertySources:109] Adding [systemEnvironment] PropertySource with lowest search precedence
  63. 2019-01-13 23:23:49,203 [DEBUG][o.s.c.e.AbstractEnvironment:127] Initialized StandardEnvironment with PropertySources [systemProperties,systemEnvironment]
  64. 2019-01-13 23:23:49,204 [INFO ][o.s.b.f.x.XmlBeanDefinitionReader:317] Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
  65. 2019-01-13 23:23:49,211 [DEBUG][o.s.b.f.x.DefaultDocumentLoader:73] Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl]
  66. 2019-01-13 23:23:49,231 [DEBUG][o.s.b.f.x.BeansDtdResolver:74] Found beans DTD [http://www.springframework.org/dtd/spring-beans-2.0.dtd] in classpath: spring-beans-2.0.dtd
  67. 2019-01-13 23:23:49,259 [DEBUG][o.s.b.f.x.DefaultBeanDefinitionDocumentReader:92] Loading bean definitions
  68. 2019-01-13 23:23:49,293 [DEBUG][o.s.b.f.s.DefaultSingletonBeanRegistry:221] Creating shared instance of singleton bean 'DB2'
  69. 2019-01-13 23:23:49,293 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:448] Creating instance of bean 'DB2'
  70. 2019-01-13 23:23:49,294 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:529] Eagerly caching bean 'DB2' to allow for resolving potential circular references
  71. 2019-01-13 23:23:49,303 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:484] Finished creating instance of bean 'DB2'
  72. 2019-01-13 23:23:49,304 [DEBUG][o.s.b.f.s.DefaultSingletonBeanRegistry:221] Creating shared instance of singleton bean 'Derby'
  73. 2019-01-13 23:23:49,304 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:448] Creating instance of bean 'Derby'
  74. 2019-01-13 23:23:49,304 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:529] Eagerly caching bean 'Derby' to allow for resolving potential circular references
  75. 2019-01-13 23:23:49,307 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:484] Finished creating instance of bean 'Derby'
  76. 2019-01-13 23:23:49,308 [DEBUG][o.s.b.f.s.DefaultSingletonBeanRegistry:221] Creating shared instance of singleton bean 'H2'
  77. 2019-01-13 23:23:49,309 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:448] Creating instance of bean 'H2'
  78. 2019-01-13 23:23:49,309 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:529] Eagerly caching bean 'H2' to allow for resolving potential circular references
  79. 2019-01-13 23:23:49,310 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:484] Finished creating instance of bean 'H2'
  80. 2019-01-13 23:23:49,311 [DEBUG][o.s.b.f.s.DefaultSingletonBeanRegistry:221] Creating shared instance of singleton bean 'HSQL'
  81. 2019-01-13 23:23:49,311 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:448] Creating instance of bean 'HSQL'
  82. 2019-01-13 23:23:49,312 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:529] Eagerly caching bean 'HSQL' to allow for resolving potential circular references
  83. 2019-01-13 23:23:49,313 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:484] Finished creating instance of bean 'HSQL'
  84. 2019-01-13 23:23:49,313 [DEBUG][o.s.b.f.s.DefaultSingletonBeanRegistry:221] Creating shared instance of singleton bean 'Informix'
  85. 2019-01-13 23:23:49,314 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:448] Creating instance of bean 'Informix'
  86. 2019-01-13 23:23:49,314 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:529] Eagerly caching bean 'Informix' to allow for resolving potential circular references
  87. 2019-01-13 23:23:49,315 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:484] Finished creating instance of bean 'Informix'
  88. 2019-01-13 23:23:49,316 [DEBUG][o.s.b.f.s.DefaultSingletonBeanRegistry:221] Creating shared instance of singleton bean 'MS-SQL'
  89. 2019-01-13 23:23:49,316 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:448] Creating instance of bean 'MS-SQL'
  90. 2019-01-13 23:23:49,316 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:529] Eagerly caching bean 'MS-SQL' to allow for resolving potential circular references
  91. 2019-01-13 23:23:49,318 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:484] Finished creating instance of bean 'MS-SQL'
  92. 2019-01-13 23:23:49,319 [DEBUG][o.s.b.f.s.DefaultSingletonBeanRegistry:221] Creating shared instance of singleton bean 'MySQL'
  93. 2019-01-13 23:23:49,319 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:448] Creating instance of bean 'MySQL'
  94. 2019-01-13 23:23:49,320 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:529] Eagerly caching bean 'MySQL' to allow for resolving potential circular references
  95. 2019-01-13 23:23:49,320 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:484] Finished creating instance of bean 'MySQL'
  96. 2019-01-13 23:23:49,321 [DEBUG][o.s.b.f.s.DefaultSingletonBeanRegistry:221] Creating shared instance of singleton bean 'Oracle'
  97. 2019-01-13 23:23:49,321 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:448] Creating instance of bean 'Oracle'
  98. 2019-01-13 23:23:49,322 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:529] Eagerly caching bean 'Oracle' to allow for resolving potential circular references
  99. 2019-01-13 23:23:49,323 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:484] Finished creating instance of bean 'Oracle'
  100. 2019-01-13 23:23:49,324 [DEBUG][o.s.b.f.s.DefaultSingletonBeanRegistry:221] Creating shared instance of singleton bean 'PostgreSQL'
  101. 2019-01-13 23:23:49,324 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:448] Creating instance of bean 'PostgreSQL'
  102. 2019-01-13 23:23:49,325 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:529] Eagerly caching bean 'PostgreSQL' to allow for resolving potential circular references
  103. 2019-01-13 23:23:49,326 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:484] Finished creating instance of bean 'PostgreSQL'
  104. 2019-01-13 23:23:49,326 [DEBUG][o.s.b.f.s.DefaultSingletonBeanRegistry:221] Creating shared instance of singleton bean 'Sybase'
  105. 2019-01-13 23:23:49,327 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:448] Creating instance of bean 'Sybase'
  106. 2019-01-13 23:23:49,327 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:529] Eagerly caching bean 'Sybase' to allow for resolving potential circular references
  107. 2019-01-13 23:23:49,330 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:484] Finished creating instance of bean 'Sybase'
  108. 2019-01-13 23:23:49,331 [DEBUG][o.s.b.f.s.DefaultSingletonBeanRegistry:221] Creating shared instance of singleton bean 'Hana'
  109. 2019-01-13 23:23:49,331 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:448] Creating instance of bean 'Hana'
  110. 2019-01-13 23:23:49,332 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:529] Eagerly caching bean 'Hana' to allow for resolving potential circular references
  111. 2019-01-13 23:23:49,333 [DEBUG][o.s.b.f.s.AbstractAutowireCapableBeanFactory:484] Finished creating instance of bean 'Hana'
  112. 2019-01-13 23:23:49,334 [INFO ][o.s.j.s.SQLErrorCodesFactory:126] SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]
  113. 2019-01-13 23:23:49,340 [DEBUG][o.s.j.s.SQLErrorCodesFactory:199] Looking up default SQLErrorCodes for DataSource [org.apache.tomcat.jdbc.pool.DataSource@547ea63b{ConnectionPool[defaultAutoCommit=null; defaultReadOnly=null; defaultTransactionIsolation=-1; defaultCatalog=null; driverClassName=oracle.jdbc.driver.OracleDriver; maxActive=20; maxIdle=20; minIdle=10; initialSize=10; maxWait=60000; testOnBorrow=true; testOnReturn=false; timeBetweenEvictionRunsMillis=5000; numTestsPerEvictionRun=0; minEvictableIdleTimeMillis=60000; testWhileIdle=false; testOnConnect=false; password=********; url=jdbc:oracle:thin:@10.128.56.175:1521/DP9A3.smart.com.ph; username=dpownert; validationQuery=SELECT 1 FROM DUAL; validationQueryTimeout=-1; validatorClassName=null; validationInterval=30000; accessToUnderlyingConnectionAllowed=true; removeAbandoned=false; removeAbandonedTimeout=60; logAbandoned=false; connectionProperties=null; initSQL=null; jdbcInterceptors=null; jmxEnabled=true; fairQueue=true; useEquals=true; abandonWhenPercentageFull=0; maxAge=0; useLock=false; dataSource=null; dataSourceJNDI=null; suspectTimeout=0; alternateUsernameAllowed=false; commitOnReturn=false; rollbackOnReturn=false; useDisposableConnectionFacade=true; logValidationErrors=false; propagateInterruptState=false; ignoreExceptionOnPreLoad=false; }]
  114. 2019-01-13 23:23:49,342 [DEBUG][o.s.j.s.SQLErrorCodesFactory:217] Database product name cached for DataSource [org.apache.tomcat.jdbc.pool.DataSource@547ea63b]: name is 'Oracle'
  115. 2019-01-13 23:23:49,343 [DEBUG][o.s.j.s.SQLErrorCodesFactory:175] SQL error codes for 'Oracle' found
  116. 2019-01-13 23:23:49,344 [DEBUG][o.s.j.s.SQLErrorCodeSQLExceptionTranslator:281] Unable to translate SQLException with Error code '17004', will now try the fallback translator
  117. 2019-01-13 23:23:49,345 [ERROR][a.s.s.b.u.s.o.OpenApiTrxType:87] Cannot get {0} WML for service_id:{1}. cause:{3}
  118. 2019-01-13 23:23:49,347 [DEBUG][a.s.s.b.u.s.o.OpenApiTrxType:88] PreparedStatementCallback; uncategorized SQLException for SQL [select a.id as ID, a.title as TITLE, a.service_id as SERVICE_ID, a.card_type as CARD_TYPE,a.wml_sequence as SEQUENCE, a.pre_req as PRE_REQ,a.wml_version as VERSION, a.wmlid as WMLID, a.wml as WML, a.wml_bytecode as WML_BYTECODE,0 as SVVID from a1_cc_wml a where SERVICE_ID=13935 and CARD_TYPE = 'WIB' order by VERSION asc]; SQL state [null]; error code [17004]; Invalid column type; nested exception is java.sql.SQLException: Invalid column type
  119. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select a.id as ID, a.title as TITLE, a.service_id as SERVICE_ID, a.card_type as CARD_TYPE,a.wml_sequence as SEQUENCE, a.pre_req as PRE_REQ,a.wml_version as VERSION, a.wmlid as WMLID, a.wml as WML, a.wml_bytecode as WML_BYTECODE,0 as SVVID from a1_cc_wml a where SERVICE_ID=13935 and CARD_TYPE = 'WIB'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!