[cfaussie] Re: Oracle Thin Client wierd ora-00933 error
Adobe have a hotfix for this which will be part of the next cumulative update for cf 8 (schedule unknown) http://zacster.blogspot.com/2008/01/my-cf-oracle-problem-ora-00933-was.html On Nov 9, 2007 1:15 AM, Zac Spitzer <[EMAIL PROTECTED]> wrote: > neither the data direct or the oracle driver liked it, it threw > "ORA-00911: invalid character" > > worth a shot tho, thanks > > On Nov 9, 2007 12:37 AM, Simon Haddon <[EMAIL PROTECTED]> wrote: > > Being that this is the oracle direct driver you might want to try a ; on > the > > end. Just on the off chance. > > > > Cheers, > > Simon > > > > > > > > On 02/11/2007, Zac Spitzer <[EMAIL PROTECTED]> wrote: > > > > > > I just switched to using the oracle thin jdbc driver, over from using > > > the enterprise oracle driver with cf8 and now i'm getting a strange > > > error > > > > > > The 11g jdbc drivers are available for a java 1.6 version i discovered > > > > > > ORA-00933: SQL command not properly ended > > > > > > for queries which work in sql plus etc... > > > > > > can anyone try this against the oracle thin driver? > > > > > > doesn't even far enough get to say the table is missing, just throws > > > the parse error straight away...argghh > > > > > > > > > INSERT INTO REGIONS_R (ENTITYID1) > > > SELECT ENTITYID1 > > > FROM REGION > > > > > > > > > wierd... > > > > > > z > > > > > > > > > -- > > > Zac Spitzer > > > http://zacster.blogspot.com/ > > > +61 405 847 168 (aussie moible) > > > > > > > > > > > > > > -- > > Cheers > > Simon Haddon > > > > > > > > > > > > > > -- > Zac Spitzer > http://zacster.blogspot.com/ > +61 405 847 168 (aussie moible) > -- Zac Spitzer - http://zacster.blogspot.com (My Blog) +61 405 847 168 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Oracle Thin Client wierd ora-00933 error
neither the data direct or the oracle driver liked it, it threw "ORA-00911: invalid character" worth a shot tho, thanks On Nov 9, 2007 12:37 AM, Simon Haddon <[EMAIL PROTECTED]> wrote: > Being that this is the oracle direct driver you might want to try a ; on the > end. Just on the off chance. > > Cheers, > Simon > > > > On 02/11/2007, Zac Spitzer <[EMAIL PROTECTED]> wrote: > > > > I just switched to using the oracle thin jdbc driver, over from using > > the enterprise oracle driver with cf8 and now i'm getting a strange > > error > > > > The 11g jdbc drivers are available for a java 1.6 version i discovered > > > > ORA-00933: SQL command not properly ended > > > > for queries which work in sql plus etc... > > > > can anyone try this against the oracle thin driver? > > > > doesn't even far enough get to say the table is missing, just throws > > the parse error straight away...argghh > > > > > > INSERT INTO REGIONS_R (ENTITYID1) > > SELECT ENTITYID1 > > FROM REGION > > > > > > wierd... > > > > z > > > > > > -- > > Zac Spitzer > > http://zacster.blogspot.com/ > > +61 405 847 168 (aussie moible) > > > > > > > > -- > Cheers > Simon Haddon > > > > > -- Zac Spitzer http://zacster.blogspot.com/ +61 405 847 168 (aussie moible) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Oracle Thin Client wierd ora-00933 error
Being that this is the oracle direct driver you might want to try a ; on the end. Just on the off chance. Cheers, Simon On 02/11/2007, Zac Spitzer <[EMAIL PROTECTED]> wrote: > > > I just switched to using the oracle thin jdbc driver, over from using > the enterprise oracle driver with cf8 and now i'm getting a strange > error > > The 11g jdbc drivers are available for a java 1.6 version i discovered > > ORA-00933: SQL command not properly ended > > for queries which work in sql plus etc... > > can anyone try this against the oracle thin driver? > > doesn't even far enough get to say the table is missing, just throws > the parse error straight away...argghh > > > INSERT INTO REGIONS_R (ENTITYID1) > SELECT ENTITYID1 > FROM REGION > > > wierd... > > z > > > -- > Zac Spitzer > http://zacster.blogspot.com/ > +61 405 847 168 (aussie moible) > > > > -- Cheers Simon Haddon --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Oracle Thin Client wierd ora-00933 error
looks like a cf8 issue, just tried this with a simple java jdbc test case and it works fine On Nov 2, 10:15 am, "Zac Spitzer" <[EMAIL PROTECTED]> wrote: > I just switched to using the oracle thin jdbc driver, over from using > the enterprise oracle driver with cf8 and now i'm getting a strange > error > > The 11g jdbc drivers are available for a java 1.6 version i discovered > > ORA-00933: SQL command not properly ended > > for queries which work in sql plus etc... > > can anyone try this against the oracle thin driver? > > doesn't even far enough get to say the table is missing, just throws > the parse error straight away...argghh > > > INSERT INTO REGIONS_R (ENTITYID1) > SELECT ENTITYID1 > FROM REGION > > > wierd... > > z > > -- > Zac Spitzerhttp://zacster.blogspot.com/ > +61 405 847 168 (aussie moible) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
