JBoss 7 datasource

Hallo, 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

Comments

  • Sorry. My datasource file looks like: jdbc:vertica://localhost:5433/oaslt_dwh vertica false false falsefalsetest test falsefalseSELECT 1 from dual false
  • Sorry. 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>
  • Hallo 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.

  • Can You post how you configured XADataSource with Vertica ?
    Thanks
  • HibikiHibiki Vertica Employee Employee

    I configured the data source for Vertica in JBoss EAP 7.0.0.GA as below.

    [module.xml]

    <?xml version="1.0" encoding="UTF-8"?>
    <module xmlns="urn:jboss:module:1.3" name="com.vertica">
        <properties>
            <property name="jboss.api" value="unsupported"/>
        </properties>
        <resources>
            <resource-root path="vertica-jdbc-11.0.2-0.jar"/>
        </resources>
        <dependencies>
            <system export="true">
                <paths>
                    <path name="javax/naming"/>
                    <path name="javax/net"/>
                    <path name="javax/net/ssl"/>
                    <path name="javax/security/auth/callback"/>
                    <path name="javax/security/auth/login"/>
                    <path name="javax/sql"/>
                </paths>
            </system>
        </dependencies>
    </module>
    

    [standalone.xml]

    <subsystem xmlns="urn:jboss:domain:datasources:4.0">
        <datasources>
            <datasource jndi-name="java:/datasources/datasource_name" pool-name="pool-name" enabled="true" use-java-context="true">
                <connection-url>jdbc:vertica://hostname:port/database-name</connection-url>
                <driver>vertica</driver>
                <security>
                    <user-name>username</user-name>
                    <password>password</password>
                </security>
            </datasource>
            <drivers>
                <driver name="vertica" module="com.vertica"/>
            </drivers>
        </datasources>
    </subsystem>
    

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file