Very rarely, like once or twice a day on a heavily trafficked application, I
get error notifications from my application that indicate a query has failed
because of invalid SQL. I am not able to reproduce this error. The "rootcause
sql" in the error is something like this:
(param 1) insert into
ot;
> Sent: Thursday, October 12, 2006 6:35 PM
> Subject: RE: mySql connector J
>
>
>
>> The generally recommended Connector/J driver is 5.03, which recently
>> came out of Beta. Its supports MySQL database 4 and 5, but not 3.x.
>>
>> Of the Connector/J 3.x driver
work with MX?
>
>
>
> - Original Message -
> From: "Steven Erat" <[EMAIL PROTECTED]>
> To: "CF-Talk"
> Sent: Thursday, October 12, 2006 6:35 PM
> Subject: RE: mySql connector J
>
>
> > The generally recommended Connector/J driver is 5.03,
Will the new 5.0 connector work with MX?
- Original Message -
From: "Steven Erat" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday, October 12, 2006 6:35 PM
Subject: RE: mySql connector J
> The generally recommended Connector/J driver is 5.03, which rece
The generally recommended Connector/J driver is 5.03, which recently
came out of Beta. Its supports MySQL database 4 and 5, but not 3.x.
Of the Connector/J 3.x drivers, 3.10 and 3.13 are recommended.
http://dev.mysql.com/downloads/connector/j/5.0.html
http://dev.mysql.com/doc/refman/5.0/en/conne
Oh, one other note. Some of the newer connector J drivers are known
not to work with CF. The 3.1 drivers are compatible. The one I'm
running is:
mysql-connector-java-3.1.10-bin.jar
Jon
On Oct 12, 2006, at 8:13 PM, Jon Clausen wrote:
> Your config is correct and is the same as mine. Did
Hell if I know :-/
- Original Message -
From: "Dan Plesse" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday, October 12, 2006 6:17 PM
Subject: Re: mySql connector J
> What the hell is "nexbid"?
>
>
> On 10/12/06, Doug Brown <[E
Talk"
Sent: Thursday, October 12, 2006 6:14 PM
Subject: RE: mySql connector J
> Perhaps these may help
> http://russ.michaels.me.uk/index.cfm/2005/10/25/Using-CFMX-with-MySQL-4x-
>
>
http://russ.michaels.me.uk/index.cfm/2006/3/7/Using-connectorJ-drivers-with-
> MySQL
>
> R
"Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday, October 12, 2006 5:04 PM
Subject: mySql connector J
> Can someone tell me what they have listed in CF for the mySql connector?
>
> Here is what I have
>
> CF DataSource = myDsn
What the hell is "nexbid"?
On 10/12/06, Doug Brown <[EMAIL PROTECTED]> wrote:
>
> Can someone tell me what they have listed in CF for the mySql connector?
>
> Here is what I have
>
> CF DataSource = myDsn
> JDBC URL = jdbc:mysql://localhost:3306/myDsn
> Driver Class = com.mysql.jdbc.Driver
> Driv
-Talk
Subject: mySql connector J
Can someone tell me what they have listed in CF for the mySql connector?
Here is what I have
CF DataSource = myDsn
JDBC URL = jdbc:mysql://localhost:3306/myDsn Driver Class =
com.mysql.jdbc.Driver Driver Name = blank Username = ROOT Password = ***
I get the
Your config is correct and is the same as mine. Did you restart CF
after installing the MySQL driver? I assume it's already been
installed in the WEB-INF/lib/ directory.
Jon
On Oct 12, 2006, at 8:04 PM, Doug Brown wrote:
> Can someone tell me what they have listed in CF for the mySql
>
Can someone tell me what they have listed in CF for the mySql connector?
Here is what I have
CF DataSource = myDsn
JDBC URL = jdbc:mysql://localhost:3306/myDsn
Driver Class = com.mysql.jdbc.Driver
Driver Name = blank
Username = ROOT
Password = ***
I get the following error
Connection verifi
Get out your scuba gear -- you'll most likely be diving deep!
Did you get the mysql connector working?
-- Josh
- Original Message -
From: "Deanna Schneider" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Monday, April 10, 2006 11:00 AM
Subject: Re: MySQL Conn
x27;ve done all that and it still doesn't work, not sure where to go.
>
> -- Josh
>
>
> - Original Message -
> From: "Deanna Schneider" <[EMAIL PROTECTED]>
> To: "CF-Talk"
> Sent: Monday, April 10, 2006 10:21 AM
> Subject: Re: MySQL Connector/J pro
#x27;s not too hard to decipher, and it's a true CF
> app.
> Unless you're very comfortable with lots o' Java you'll find AbleCommerce
> hard to work with.
>
> -- Josh
>
>
>
>
> - Original Message -
> From: "Josh Nathanson" &l
with.
-- Josh
- Original Message -
From: "Josh Nathanson" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Monday, April 10, 2006 10:37 AM
Subject: Re: MySQL Connector/J problems
> Just to confirm, are you using the "other" selection when specifying the
>
urdatabasenamehere
Driver class: com.mysql.jdbc.Driver
If you've done all that and it still doesn't work, not sure where to go.
-- Josh
- Original Message -
From: "Deanna Schneider" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Monday, April 10, 2006 10:21 AM
-Talk
Subject: MySQL Connector/J problems
Hey folks,
I'm trying to install a demo version of abelcommerce, and to do it I needed
to install the connector/j JDBC connector. The Adobe docs say to use version
3.1.10, but the ablecommerce site says to use 3.1.7. I went with the
ablecom
y using 3.0.17 with no problems. Others may
> have
> better info.
>
> -- Josh
>
>
> - Original Message -
> From: "Deanna Schneider" <[EMAIL PROTECTED]>
> To: "CF-Talk"
> Sent: Monday, April 10, 2006 10:02 AM
> Subject: MySQL Connec
I did drop the jar in the web-inf/lib directory. Then, I second-guessed
myself because it said "extract the contents of the download..blah blah
blah" So, I extracted it as well. But, the jar is there at web-inf/lib. I'd
tested it with just the jar file there before I did the extraction thing.
I ju
alk"
Sent: Monday, April 10, 2006 10:02 AM
Subject: MySQL Connector/J problems
> Hey folks,
> I'm trying to install a demo version of abelcommerce, and to do it I
> needed
> to install the connector/j JDBC connector. The Adobe docs say to use
> version
> 3.1.10
If you installed a driver class file, i'll need to be in
WEB-INF/classes, not WEB-INF/lib. Only JARs go in the 'lib'
directory, though I'm curious why you didn't just drop the Connector/J
JAR in?
cheers,
barneyb
On 4/10/06, Deanna Schneider <[EMAIL PROTECTED]> wrote:
> Hey folks,
> I'm trying to
Hey folks,
I'm trying to install a demo version of abelcommerce, and to do it I needed
to install the connector/j JDBC connector. The Adobe docs say to use version
3.1.10, but the ablecommerce site says to use 3.1.7. I went with the
ablecommerce recommendation, since I need to specifically test it.
Subject: MySQL Connector/J
I have just installed MySQL Connector/J 3.2 so that CFMX6.1 will work with
MySQL 4.1.13
My DSN's are working fine, but I have to put the username/password into the
DSN otherwise it wont work.
If the username/password is sent in the CFQUERY, then the DSN cannot conen
I have just installed MySQL Connector/J 3.2
so that CFMX6.1 will work with MySQL 4.1.13
My DSN's are working fine, but I have to put the username/password into the
DSN otherwise it wont work.
If the username/password is sent in the CFQUERY, then the DSN cannot conenct
to the database.
Is
Is anyone using MySQL Connector/J instead of the drivers shipped with CFMX? Any
performance gains?
Leonardo Crespo
ICQ: 198810
[EMAIL PROTECTED]
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
27 matches
Mail list logo
