You JDBC drivers should be in the classpath as defined in your CF App Server.
Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] Quoting Andrew Scott <[EMAIL PROTECTED]>: > If anyone is interested I think I have found the problem, but not sure on > how to fix it. > > The below code actually does work, the database class seems to fall over > when I move this over to the CF server. I have installed the MS JDBC drivers > over there but it seems to not have made any difference, it still fails. > > Do I need to place something into CF to tell it where to find the class > files for the JDBC, or should my java files already know that they are > installed? > > > > Regards > Andrew Scott > Technical Consultant > > NuSphere Pty Ltd > Level 2/33 Bank Street > South Melbourne, Victoria, 3205 > > Phone: 03 9686 0485 - Fax: 03 9699 7976 > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Andrew Scott > Sent: Friday, 14 May 2004 7:03 AM > To: [EMAIL PROTECTED] > Subject: RE: [CFCDev] Java again in CFC's > > Mark, > > The following code works if I call it from a within java, but from cf it > fails:-) > > public ArrayList db() throws Exception { > ArrayList list = new ArrayList(); > > Database db = new Database(); > Connection con = db.Connect(); > Statement stmt = con.createStatement(); > ResultSet rs = stmt.executeQuery("SELECT * FROM syState"); > > while(rs.next()) { > list.add(rs.getString("NAME")); > } > return list; > } > > > > Regards > Andrew Scott > Technical Consultant > > NuSphere Pty Ltd > Level 2/33 Bank Street > South Melbourne, Victoria, 3205 > > Phone: 03 9686 0485 - Fax: 03 9699 7976 > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Mark M > Sent: Thursday, 13 May 2004 2:16 PM > To: [EMAIL PROTECTED] > Subject: Re: [CFCDev] Java again in CFC's > > Andrew - > > You trying to create Object an entire package? > > Like > > createObject("java.lang"); > > Because that'll blow up hardcore. > > What are you trying to create? > > (and if it's not a Java lib object, can we have the constructor code?) > > Mark > ------------------------------------------------------------------ > [EMAIL PROTECTED] > ICQ: 3094740 > Safe From Bees > [ www.safefrombees.com ] > > > Quoting Andrew Scott <[EMAIL PROTECTED]>: > > > > > Hoping that a java guru can help me again... > > > > When I createObject a java package, I am getting the following error. > > > > The system has attempted to use an undefined value, which usually > > indicates a programming error, either in your code or some system code > > > > Now I assume that there is an error going down in the code, but is > > there a way to throw an exception so that CF can see where it is > occurring... > > > > > > Regards > > Andrew Scott > > Technical Consultant > > > > NuSphere Pty Ltd > > Level 2/33 Bank Street > > South Melbourne, Victoria, 3205 > > > > Phone: 03 9686 0485 - Fax: 03 9699 7976 > > > > > > ---------------------------------------------------------- > > You are subscribed to cfcdev. To unsubscribe, send an email to > > [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > > in the message of the email. > > > > CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, > > Corporation (www.mindtool.com). > > > > An archive of the CFCDev list is available at > > www.mail-archive.com/[EMAIL PROTECTED] > > > > > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, > Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at > www.mail-archive.com/[EMAIL PROTECTED] > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email to > [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, > Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at > www.mail-archive.com/[EMAIL PROTECTED] > > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported > by Mindtool, Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at > www.mail-archive.com/[EMAIL PROTECTED] > > > ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
