rajukvg Posted February 22, 2009 Share Posted February 22, 2009 Hi, We are using Vertica database, trying to connect to Jasperserver. Where do i place the jdbc driver of Vertica in jasperserver ?(currently i placed it at <localpath>/jasperserver/scripts/drivers) and while configuring the JDBC data source i have provided the driver name as com.vertica.Driver and the jdbc url as jdbc:vertica://<ipAddress>:5433/dbname When i tried testing the connection. It gives me a message saying "connection Failed". Can any one help me on this? Regards,Raju Link to comment Share on other sites More sharing options...
rajukvg Posted February 22, 2009 Author Share Posted February 22, 2009 Ignore my question. I was able to identify the proper path where to place the JDBC jar. I placed in the wrong location. I am able to connect to this datasource Link to comment Share on other sites More sharing options...
rajukvg Posted February 22, 2009 Author Share Posted February 22, 2009 Though i was able to connect to the database. When i try creating a new Domain from this datasource. The objects are not replaced. From the Admin-> resources page. I selected the menu option to create a new domain. Application asked me for the datasource. I have provided the datasource that i have newly created. Immideately i got a popup asking to select the "schema" to which i want to connect to. Upon selecting and pressing ok, the tables are not loaded. Is there any alternative for this? Regards, Raju Link to comment Share on other sites More sharing options...
andrewsok Posted February 22, 2009 Share Posted February 22, 2009 Copying my message from another thread.My experience with Vertica was that their JDBC v.2.1 driver has a bug.If you get DatabaseMetaData object and call getTables method on it, and pass an array of table types, it returns nothing unless you request just "TABLE" type and nothing else. If you add "VIEW", "ALIAS", etc., it stops returning even tables.Therefore, to make Domain Designer work , you need to edit jdbcMetaConfiguration bean in applicationContext-semanticLayer.xml file and comment out all table types but <value>TABLE</value>. Link to comment Share on other sites More sharing options...
rajukvg Posted February 22, 2009 Author Share Posted February 22, 2009 Thank u so much. I followed your instructions and i am able to see the tables. Regards, Raju Link to comment Share on other sites More sharing options...
cloghin Posted February 24, 2009 Share Posted February 24, 2009 Thejava.sql.DatabaseMetaData meta = conn.getMetaData(); call to getTables has been fixed in the 2.5.7 version of the jdbc driver. This was indeed reported in 2.1 and fixed subsequently. Thanks, Colin, Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now