mysql 4.1 + CF 7 - i want to slap myself....

[hugstable77]

ugh - was able to get a connection using the 3.x driver that comes with cf7 to connect to a myswl 4.1 db... I am running a simple insert:

<cfquery name="addFoo" datasource="apFtp" debug="1" dbname="apFtp">
INSERT INTO tbl_usr
(usr_eml, usr_pwd)
VALUES ('foo','foo2')
</cfquery>

apFtp is my dsn

i am getting null pointer errors left and right...

i am super new to MySql - thought it was because of my programming - did some research and i am hoping the error beceause i have to download the correct java connection jar file...

can someone confirm this for me... i am about to pull out ALL my hair...

i get that error but the query inserts the data...

rest of error:
ava.lang.NullPointerException
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
at org.gjt.mm.mysql.Connection.setTransactionIsolation(Unknown Source)
at coldfusion.server.j2ee.sql.JRunConnection.setTransactionIsolation(JRunConnection.java:499)
at coldfusion.server.j2ee.sql.JRunConnection.clean(JRunConnection.java:229)
at coldfusion.server.j2ee.sql.pool.JDBCPool.returnConnection(JDBCPool.java:785)
at coldfusion.server.j2ee.sql.pool.JDBCPool.connectionErrorOccurred(JDBCPool.java:326)
at coldfusion.server.j2ee.sql.JRunConnection.sendErrorEvent(JRunConnection.java:317)
at coldfusion.server.j2ee.sql.JRunConnection.setCatalog(JRunConnection.java:483)
at coldfusion.server.j2ee.sql.JRunConnectionHandle.setCatalog(JRunConnectionHandle.java:133)
at coldfusion.tagext.sql.QueryTag.doFinally(QueryTag.java:608)
at cftest22ecfm1149387751.runPage(/var/

http://www/apache2-default/test2.cfm:1)

at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

 

[hugstable]

bump