Thanks Dave. That was exactly the problem. I added the path to my database driver jar file to coldfusion and worked like a charm.
James Davis Kaleida Systems, Inc. [EMAIL PROTECTED] -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, November 17, 2006 1:23 PM To: CF-Talk Subject: RE: Java Database Queries in ColdFusion > I have a Java object that runs a routine on our database (MSSQL). The > routine does financial calculations based on selection queries and > then inserts these calculated values back into the database. > > When I run the Java manually through a java stub program, I can see > the hits on the database via SQL Profiler, so I know that the java is > talking with the database fine. Presumably, your Java program uses JDBC to invoke a database driver, etc. When you run it by itself, presumably that database driver is in the classpath and can be found by your program. When you run your program from within CF, however, it probably won't be able to find or use it. It would be easier, generally, to let CF handle your data retrieval, and simply perform your calculations in your Java class. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore and Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
