Database

Hi,

I am trying to use a Postgress Database as a Datasource using the PostgresSQL and JDBC.  Is there any information on doing this. [Read More...]

Dear Sir/Madam,

I am trying to read data from an Oracle 11g database of type SYS.XMLTYPE but I am not able to read the same. [Read More...]

I have an informal desktop testing environment that is still using the default HSQL for the repository DB (my formal test environment uses MySQL).  The upgarde to 3.2 indicates a sql script ne [Read More...]

Hi,  [Read More...]

Hi, [Read More...]

Hi

I face a problem in passing multi values via single inputparam. [Read More...]

 I've attempted to set up MS SQL 2008 for our repo for our 3.1 installation several times without success, despite following the steps outlined in documentation. However, I don't see 2008 compatibility stated anywhere, just 2005. Are there any known compatibility issues with 2008?

How do you make a Windows Authentication or NTLM connection? Do you alwaays have to have SQL Server authentication?

Thanks,.

Hi

I am a new presto developer , and was wondering if the sql block used while creating the mashup is ran each time i run the application created from the mashup? or it just runs the query when it is actually created.

For example if i have a sql condition where sysdate - 1 then is it going give me the same data when the application was created? or it will run that condition whenever i run the mashup?

I am using Presto 3.1

Thanks!

Using Presto 3.1, I am trying to get information on what version of MS JDBC drivers to use in order to get a connection to a MS SQL Server 2008 server. I have tried the 3.0 and the 2.0 and I keep receiving the error: Unable to perform specified request. Unexpected exception thrown validating data source, java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.