xad

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

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?

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.

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!

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?

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.

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

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.