Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Problem saving date in JDBC.ODBC -UNIX ORACLE

10 posts in Appeon (partner product) Last posting was on 2006-08-11 02:08:50.0Z
Dani D Posted on 2006-07-03 05:05:38.0Z
Sender: 5fb.44a8a54d.1804289383@sybase.com
From: DANI D
Newsgroups: sybase.public.appeon
Subject: Problem saving date in JDBC.ODBC -UNIX ORACLE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44a8a5a2.600.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub44a8a5a2"
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Jul 2006 22:05:38 -0700
X-Trace: forums-1-dub 1151903138 10.22.241.41 (2 Jul 2006 22:05:38 -0700)
X-Original-Trace: 2 Jul 2006 22:05:38 -0700, 10.22.241.41
Lines: 348
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1488
Article PK: 21214

Here it is

Maybe it's the Java how can't save date to database ?

i'm not using NATIVE

> Hi DaniD,
>
> The problem you met cannot be reproduced in Appeon.
> Can you provide the srd file of the problematic DataWindow
> for me to further the analysis?
>
> Regards
> Sally Li
>
> <Dani.D> wrote in message
> > news:4497e9c1.5b8.1681692777@sybase.com... Hello ,
> >
> > I'm tring to update Datawindow (including date field's)
> >
> > I get the Sql error 00904 ''invalid column name ''
> >
> > I'm using oracle on unix, appenon 3 , sun.jdbc-odbc
> >
> > what might be the problem ?
> >
> > Regards
>
>


Sally Li Posted on 2006-07-05 10:07:56.0Z
From: "Sally Li" <sally.li@appeon.com>
Newsgroups: sybase.public.appeon
References: <44a8a5a2.600.1681692777@sybase.com>
Subject: Re: Problem saving date in JDBC.ODBC -UNIX ORACLE
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 59.37.60.2
X-Original-NNTP-Posting-Host: 59.37.60.2
Message-ID: <44ab8f7c@forums-1-dub>
Date: 5 Jul 2006 03:07:56 -0700
X-Trace: forums-1-dub 1152094076 59.37.60.2 (5 Jul 2006 03:07:56 -0700)
X-Original-Trace: 5 Jul 2006 03:07:56 -0700, 59.37.60.2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1489
Article PK: 13026

Hi DaniD,

After checking the SRD file, Appeon engineer suspects the problem may be
caused by including invalid columns in the update statement.
I suggest you go to AEM and set the log file mode to debug. Then rerun the
application and modify the update statement according to the log
information.

Regards
Sally Li

<DANI D> wrote in message news:44a8a5a2.600.1681692777@sybase.com...
> Here it is
>
> Maybe it's the Java how can't save date to database ?
>
> i'm not using NATIVE
>
> > Hi DaniD,
> >
> > The problem you met cannot be reproduced in Appeon.
> > Can you provide the srd file of the problematic DataWindow
> > for me to further the analysis?
> >
> > Regards
> > Sally Li
> >
> > <Dani.D> wrote in message
> > > news:4497e9c1.5b8.1681692777@sybase.com... Hello ,
> > >
> > > I'm tring to update Datawindow (including date field's)
> > >
> > > I get the Sql error 00904 ''invalid column name ''
> > >
> > > I'm using oracle on unix, appenon 3 , sun.jdbc-odbc
> > >
> > > what might be the problem ?
> > >
> > > Regards
> >
> >
>


Dani D Posted on 2006-07-05 11:55:19.0Z
Sender: 233e.44ab9b05.1804289383@sybase.com
From: Dani D
Newsgroups: sybase.public.appeon
Subject: Re: Problem saving date in JDBC.ODBC -UNIX ORACLE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44aba8a7.24e8.1681692777@sybase.com>
References: <44ab8f7c@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Jul 2006 04:55:19 -0700
X-Trace: forums-1-dub 1152100519 10.22.241.41 (5 Jul 2006 04:55:19 -0700)
X-Original-Trace: 5 Jul 2006 04:55:19 -0700, 10.22.241.41
Lines: 61
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1490
Article PK: 13029

Pls take a look of the log

Driver][Oracle OCI]ORA-00904: invalid column name..,
Exception=,
ReturnValue=UpdatedRowCount=0,InsertedRowCount=0,DeletedRowCount=0
,SQL=insert into MEDVIS ( doct_no , institution , visit_date
, prod_code1 , prod_exmp1 , sequence , remarks , agent_no ,
year , per_no , day , remarks2 ) values( 20236.0 , 'aa' ,
to_timestamp('2006-06-14 00:00:00.0' , 'yyyy-mm-dd
hh24:mi:ss.ff') , 'VI' , 1.0 , 331.0 , '' , 1.0 , 2006.0 ,
6.0 , 14.0 , '' ) ]


Regard's

> Hi DaniD,
>
> After checking the SRD file, Appeon engineer suspects the
> problem may be caused by including invalid columns in the
> update statement. I suggest you go to AEM and set the log
> file mode to debug. Then rerun the application and modify
> the update statement according to the log information.
>
> Regards
> Sally Li
>
> <DANI D> wrote in message
> > news:44a8a5a2.600.1681692777@sybase.com... Here it is
> >
> > Maybe it's the Java how can't save date to database ?
> >
> > i'm not using NATIVE
> >
> > > Hi DaniD,
> > >
> > > The problem you met cannot be reproduced in Appeon.
> > > Can you provide the srd file of the problematic
> > > DataWindow for me to further the analysis?
> > >
> > > Regards
> > > Sally Li
> > >
> > > <Dani.D> wrote in message
> > > > news:4497e9c1.5b8.1681692777@sybase.com... Hello ,
> > > >
> > > > I'm tring to update Datawindow (including date
> > > field's) >
> > > > I get the Sql error 00904 ''invalid column name ''
> > > >
> > > > I'm using oracle on unix, appenon 3 , sun.jdbc-odbc
> > > >
> > > > what might be the problem ?
> > > >
> > > > Regards
> > >
> > >
> >
>
>