should my connection string look like this? Connection conn = driverManager.getConnection("jdbc:as400://172.17.6.21;date format=iso","ccrgmd","george9"); Thanks George firstname.lastname@example.org wrote: > > It could be the format of the data in the table does not match the job date > format. Try setting the JDBC connection's date format to *ISO by adding >";date > format=iso" to the URL used when connecting via JDBC. You may need to >specify a > different date format depending on the format of the data in the table. > > David Wall > AS/400 Toolbox for Java > > "Dorer, George" <email@example.com> on 09/20/99 12:18:19 PM > > Please respond to JAVA400-L@midrange.com > > To: JAVA400-L@midrange.com > cc: > Subject: Re: JDBC Error? > > I am doing no date operations at all. Simply selecting all of the rows > from a table, then inserting those values into another table in a > different database on a separate machine using the getstring operation. > > George > > firstname.lastname@example.org wrote: > > > > ERROR: com.ibm.as400.access.AS400JDBCException: [SQL0183] Result of > > date or timestamp expression not valid. > > > > Any body ever seen this error? Trying to select data from an as/400 > > logical access path on a solaris or win98 machine gives this error. The > > data in the source file is fine, and I get results for well over 100 > > rows of data before the error occurs, there are three date fields in the > > source file and not selecting of the dates allows the program to run > > slightly longer before error occurs. > > ----------- > > The error message states that you are performing a arithmetic function that >is > > creating an invalid date or timestamp. The most likely culprit is trying to > > subtract one or more days from a date field with '01-01-0001'. Many >questions > > come to mind quickly: > > > > 1. Are you using L-dates or regular old YYMMDD or CCYYMMDD fields? > > 2. What date arithmetic are you performing > > > > Joe Pluta > > > > +--- > | This is the JAVA/400 Mailing List! > | To submit a new message, send your mail to JAVA400-L@midrange.com. > | To subscribe to this list send email to JAVA400-L-SUB@midrange.com. > | To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com. > | Questions should be directed to the list owner: email@example.com > +--- +--- | This is the JAVA/400 Mailing List! | To submit a new message, send your mail to JAVA400-L@midrange.com. | To subscribe to this list send email to JAVA400-L-SUB@midrange.com. | To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com. | Questions should be directed to the list owner: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.