JBoss 7 datasource
+1Hallo, I have a problem. How can I access vertica with an application running in JBoss? How does the data source xml file and the standalone.xml file look like? In May we stwiched from mysql to vertica. Our application is running in a JBoss 7.1. That's, what I did: 1. I have added a module with the vertica-jdbc.jar in my JBoss. 2. Then I added a driver to my standalone.xml: com.vertica.jdbc.DataSource 3. At last I deployed the a datasource file with the following content: jdbc:vertica://localhost:5433/oaslt_dwh vertica false false falsefalsetest test falsefalseSELECT 1 from dual false But my application is not able to connect to the vertica db? Did I miss something? Please help me. Thank you. Katrin
+1Sorry. My datasource file looks like: jdbc:vertica://localhost:5433/oaslt_dwh vertica false false falsefalsetest test falsefalseSELECT 1 from dual false
+1Sorry. I have to remove < brackets. Otherwise the editor doesn't show the correct content of my datasource file: datasources> xa-datasource jndi-name="java:/dwh" pool-name="dwh" enabled="true" use-ccm="false"> xa-datasource-property name="URL"> jdbc:vertica://localhost:5433/oaslt_dwh /xa-datasource-property> driver>vertica/driver> xa-pool> is-same-rm-override>false/is-same-rm-override> interleaving>false/interleaving> pad-xid>false/pad-xid> wrap-xa-resource>false/wrap-xa-resource> /xa-pool> security> user-name>test/user-name> password>test/password> /security> validation> validate-on-match>false/validate-on-match> background-validation>false/background-validation> check-valid-connection-sql>SELECT 1 from dual /check-valid-connection-sql> /validation> statement> share-prepared-statements>false/share-prepared-statements> /statement> /xa-datasource> /datasources>
+1Hallo Amelia, sorry, two hours ago we solved the problem. Thank you very much for xour time. Best regards Katrin
Hi, We are getting class cast exception when we use the same setting above. It says, vertica DataSource cannot be cast to javax DataSource. Thank you.
+1Can You post how you configured XADataSource with Vertica ?
Thanks
Thanks
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.
77 4th Avenue
Waltham, MA 02451 USA
