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]
