driver not capable
Hi
I am using vertica-jdk5-6.1.3-4.jar and a JNDI datasource on WAS server 8.5.
Uasing hibernate in my application, with PostGreSQL dialect.
Trying to execute the following query
SELECT A.ACC_CLS_DT as "date",
text(B.PTY_ID) as "partyId",
text(A.ACCNO) as "accountNo",
text(A.PROD_TYP_CD) as "productCode",
'Home Loan Closed' as "description",
TRUE as "positiveExperience"
FROM DWCRHONL_D1.ARNG A INNER JOIN DWCRHONL_D1.PTY_ARNG_REL B
ON A.ARNG_KEY=B.ARNG_KEY WHERE ((A.ACC_APPSYS_ID= '380' AND A.ACC_PD_CTGY_CD='MLA')
OR A.ACC_APPSYS_ID='192') AND A.ARNG_TYP_CD<>'A' AND ACC_CLS_DT IS NOT NULL AND PTY_ID= ?
getting the following exception.
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: [Vertica][JDBC](10220) Driver not capable. DSRA0010E: SQL State = HYC00, Error Code = 10,220
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:280)
... 94 more
Please advice. Thanks
sanath.
I am using vertica-jdk5-6.1.3-4.jar and a JNDI datasource on WAS server 8.5.
Uasing hibernate in my application, with PostGreSQL dialect.
Trying to execute the following query
SELECT A.ACC_CLS_DT as "date",
text(B.PTY_ID) as "partyId",
text(A.ACCNO) as "accountNo",
text(A.PROD_TYP_CD) as "productCode",
'Home Loan Closed' as "description",
TRUE as "positiveExperience"
FROM DWCRHONL_D1.ARNG A INNER JOIN DWCRHONL_D1.PTY_ARNG_REL B
ON A.ARNG_KEY=B.ARNG_KEY WHERE ((A.ACC_APPSYS_ID= '380' AND A.ACC_PD_CTGY_CD='MLA')
OR A.ACC_APPSYS_ID='192') AND A.ARNG_TYP_CD<>'A' AND ACC_CLS_DT IS NOT NULL AND PTY_ID= ?
getting the following exception.
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: [Vertica][JDBC](10220) Driver not capable. DSRA0010E: SQL State = HYC00, Error Code = 10,220
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:280)
... 94 more
Please advice. Thanks
sanath.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.