Jason Tesser wrote:
HI
Are you sure the issue is the change from PG7.4=>PG8.0, or have you
upgraded your jdbc package at the same time?
I have upgraded the driver to the version that matched pg 8.0
I think your previous version should work just fine.
here is where I am executing the sta
HI
>
> Are you sure the issue is the change from PG7.4=>PG8.0, or have you
> upgraded your jdbc package at the same time?
I have upgraded the driver to the version that matched pg 8.0
> > Here is my prepared statment in my java class
> >
> > private static final String MANUALINSERT =
> >
Jason Tesser wrote:
Hi Richard and thank you for your help. Here is the actual message from
the pg log
ERROR: 42804: column "datetimein" is of type timestamp without time
zone but expression is of type character varying
HINT: You will need to rewrite or cast the expression.
I can aviod thi
Hi Richard and thank you for your help. Here is the actual message from
the pg log
ERROR: 42804: column "datetimein" is of type timestamp without time
zone but expression is of type character varying
HINT: You will need to rewrite or cast the expression.
I can aviod this by rewritting my quer
Jason Tesser wrote:
I just upgraded 7.4 to 8.0 and I have noticed that i am getting alot
of error that are saying i have a type problem. For example it is
saying big int expected but it was sent character varying.
Is it right? Do you have an example you could give?
> These
same queries use t
I just upgraded 7.4 to 8.0 and I have noticed that i am getting alot of error
that are saying i have a type problem. For example it is saying big int
expected but it was sent character varying. These same queries use to work in
7.4 I am using java and jboss. My queries are all dynamic sql in
