[postgres connection persistence issue]

no one? There must be a setting past the ones in the context.xml.

 

[postgres connection persistence issue]

Hi all, I'm using a JDNI connnection to postgres so that I can access a stored procedure. The problem is that I'm using postgres 7.4 which has issues with temp tables and persistent connections. What I need to do is basically disconnect after exach query. How do I go about that?

[Please help! ERROR: transaction is read-only]

Got it. I didn't realize that the context.xml was for the JDNI connection. After I assigned the datasource to the JDNI, everything worked.

[Please help! ERROR: transaction is read-only]

I have the exact same problem as topic id #50351, where I have Jasper Server connecting to a postgres stored procedure. The stored procedure uses temp tables and I cannot get by the access restriction.

I've tried different connection arguments such as:

jdbc:postgresql://server:5432/database/
jdbc:postgresql://server:5432/database/defaultReadOnly=false; txnAutoWrap=OFF; disableLocalTxn=true

and every combination of these with no luck.
Ive also modified the content.xml in C:Program Filesjasperserver-pro-3.0apache-tomcatwebappsjasperserver-proMETA-INF to include the resource (this was the other topic's fix):

   <Resource name="jdbc/postgres" auth="Container" type="javax.sql.DataSource"
        maxActive="100" maxIdle="30" maxWait="10000"
            username="foo" password="bar" driverClassName="org.postgresql.Driver"
            url="jdbc:postgresql://server:5432/database" defaultReadOnly="false"/>

No luck same issue.

I'm connecting to postgres version 7.4.19.

I have tried numerous configurations and connection arguments with no success. I need to get this up and running!

Please Help!

 

[PostgreSQL Jasper Reporting Server Error]

Iconklin,

I am having the same exact problem, so I'm glad that I founf this post. Is the context.xml file that you edited located at C:Program Filesjasperserver-pro-3.0apache-tomcatwebappsjasperserver-proMETA-INF ?

Also, this is still a JDBC connection? not a JDNI as the tech suggested?

 

[Newbie XY bar graph expression problem]

Still.. I can only use the YX bar graph when I want to use time on the X Axis? What if I wanted to do a line graph. Every other graph has category or xy datasets.

[Newbie XY bar graph expression problem]

After doing some digging, I found that I needed to use the YX Bar which gives you an option to categorize by time.

[Newbie XY bar graph expression problem]

I have a simple chart that I'm having problems with.

I have a query which returns 2 types, one of which is a long and another as a type time broken down in hourly increments.

I want to simply have the time displayed (2:00, 3:00, 4:00 etc) on the X-Axis Expression but I keep getting an error stating that the variable cannot be cast from time to Number. I tried casting it to ints but no luck.

Here is my expression list

Series Expression = Yesterday's Date (java.sql.Date)

X Value Expression = Hour (java.sql.Time)

Y Value Expression = Totalhits (java.sql.Long)

Label Expression = none.

What am I doing wrong? I simply want the each X hour to display Y hits.