Re: MySQL 5 and CFMX7
On 2/5/06, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Stan Winchester wrote: > > > > What I've been wondering is what MySQL engine should I be using "MyISAM" or > > the default "InnoDB"? > > What functionality do you want to use? For instance, transactions > require InnoDB while full text indexes require MyISAM. (So you > can't have both in MySQL.) Just to be really clear -- you can't have both *in the same table*. You can of course mix and match table types in the same database. Jochem knows this no doubt, but for the good of those of you less familiar w/ MySQL wanted to clarify > Jochem > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231504 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
At this point is has nothing to do with transactions or indexes. I want rds in Homesite/CF Studio to properly identify the datatype and field length for my cfc wizard. My wizard looks for datatypes and field lengths for form generation and client/server-side validation. As it is now, if the dsn is MySQL all fields have a length of 65535. SQL Server does not have this problem, nor does PostgreSQL, or even Access. If every field is 65535 in length, then I have to manually fix all my validation rules and on my forms change textarea fields to input/text fields. What I have been doing as a work around is to create the database/dsn in both MySQL and SQL Server so I run the wizard against the SQL Server dsn to get correct form and validation generation. I guess one obvious test to do to create a MySQL database using MyISAM and see what the field lengths are. I hope this all makes sense. > Stan Winchester wrote: > > > > What I've been wondering is what MySQL engine should I be using > "MyISAM" or the default "InnoDB"? > > What functionality do you want to use? For instance, transactions > require InnoDB while full text indexes require MyISAM. (So you > can't have both in MySQL.) > Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231389 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
Stan Winchester wrote: > > What I've been wondering is what MySQL engine should I be using "MyISAM" or > the default "InnoDB"? What functionality do you want to use? For instance, transactions require InnoDB while full text indexes require MyISAM. (So you can't have both in MySQL.) Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231383 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7 (New Problem)
Eeegadds My bad. I quickly went down the lsit and just wasn't paying attention to what I copied and pasted. I blame this on not enough coffee or too much coffee. Yes mysql-connector-java-3.1.12-bin.jar is the connector your looking for. MySQL Connector/J 3.1 Sorry about that. Casey On 2/4/06, John Paul Ashenfelter <[EMAIL PROTECTED]> wrote: > On 2/4/06, Casey Dougall <[EMAIL PROTECTED]> wrote: > > Mysql5, CF7, Win2003 all work together when using > > > > I recomend Connector/ODBC 3.51 > > This is awful advice. To use the ODBC drivers for MySQL, you have to > install the ODBC services and go through the JDBC-ODBC bridge. > > > I would say the 5.0 beta drivers are causing the issue. > > They're alpha (Connector J/5.0), so rolling back to the production > Connector J/3.1 drivers should be your first choice, unless there's > something very specific you need from the 5.0 drivers. > > > > > Casey > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231382 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7 (New Problem)
On 2/4/06, Casey Dougall <[EMAIL PROTECTED]> wrote: > Mysql5, CF7, Win2003 all work together when using > > I recomend Connector/ODBC 3.51 This is awful advice. To use the ODBC drivers for MySQL, you have to install the ODBC services and go through the JDBC-ODBC bridge. > I would say the 5.0 beta drivers are causing the issue. They're alpha (Connector J/5.0), so rolling back to the production Connector J/3.1 drivers should be your first choice, unless there's something very specific you need from the 5.0 drivers. > > Casey > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231365 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7 (New Problem)
Mysql5, CF7, Win2003 all work together when using I recomend Connector/ODBC 3.51 I would say the 5.0 beta drivers are causing the issue. Casey ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231347 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL 5 and CFMX7 (New Problem)
I have CFMX7, MySQL 5.0 and NaviCat all running locally -Original Message- From: ColdFusion [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 9:33 PM To: CF-Talk Subject: RE: MySQL 5 and CFMX7 (New Problem) Localhost is where the MySQL Database is at. It is all one machine -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:49 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) In your users table do have your machine or sub-net entered to accept a connection from your machine/user that is having trouble connecting? Is MySQL installed on the same machine as CF? If not then jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to use the mysql boxes ip instead of local host. Sorry if I'm stating the obvious and not helping. The error basically says it cant connect to the port. Which doesn't sound like a CF issue but a network issue. Is the machine that you are using Navicat to connect with also the machine you have CF installed on? The only other thing I would suggest is check the cf and mysql logs to see if the provide any lower lever details/clues. Dave On Feb 3, 2006, at 6:26 PM, ColdFusion wrote: > Yes, it is displayed under System Information in CF Admin > > -Original Message- > From: David Livingston [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 7:07 PM > To: CF-Talk > Subject: Re: MySQL 5 and CFMX7 (New Problem) > > Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class > path? > You have to restart CF after you add it so that the jdbc driver gets > loaded in. > > Here is a link to how to install the postgress driver. The mysql setup > should be similar. > http://cfguru.daemon.com.au/archives/82.html > > Dave > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231335 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL 5 and CFMX7 (New Problem)
Localhost is where the MySQL Database is at. It is all one machine -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:49 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) In your users table do have your machine or sub-net entered to accept a connection from your machine/user that is having trouble connecting? Is MySQL installed on the same machine as CF? If not then jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to use the mysql boxes ip instead of local host. Sorry if I'm stating the obvious and not helping. The error basically says it cant connect to the port. Which doesn't sound like a CF issue but a network issue. Is the machine that you are using Navicat to connect with also the machine you have CF installed on? The only other thing I would suggest is check the cf and mysql logs to see if the provide any lower lever details/clues. Dave On Feb 3, 2006, at 6:26 PM, ColdFusion wrote: > Yes, it is displayed under System Information in CF Admin > > -Original Message- > From: David Livingston [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 7:07 PM > To: CF-Talk > Subject: Re: MySQL 5 and CFMX7 (New Problem) > > Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class > path? > You have to restart CF after you add it so that the jdbc driver gets > loaded in. > > Here is a link to how to install the postgress driver. The mysql setup > should be similar. > http://cfguru.daemon.com.au/archives/82.html > > Dave > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231334 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
It works fine, it just shows all the datatypes as having a field length of 65535 in rds. The reason this is a problem is my HomeSite/CF Studio cfc wizard (http://www.aftershockweb.net/forums/messages.cfm/ThreadId/50) gets all the qForm & cfc validation rules wrong because rds says all the field lengths are 65535. > the appropriatel ocation, and then used the "other" datasource type > instead of the "mysql" datasource type, and it still didn't work? > Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231331 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7 (New Problem)
In your users table do have your machine or sub-net entered to accept a connection from your machine/user that is having trouble connecting? Is MySQL installed on the same machine as CF? If not then jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to use the mysql boxes ip instead of local host. Sorry if I'm stating the obvious and not helping. The error basically says it cant connect to the port. Which doesn't sound like a CF issue but a network issue. Is the machine that you are using Navicat to connect with also the machine you have CF installed on? The only other thing I would suggest is check the cf and mysql logs to see if the provide any lower lever details/clues. Dave On Feb 3, 2006, at 6:26 PM, ColdFusion wrote: > Yes, it is displayed under System Information in > CF Admin > > -Original Message- > From: David Livingston [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 7:07 PM > To: CF-Talk > Subject: Re: MySQL 5 and CFMX7 (New Problem) > > Did you add \ wwwroot \ web-inf\ lib into your java coldfusion > class path? > You have to restart CF after you add it so that the jdbc driver > gets loaded > in. > > Here is a link to how to install the postgress driver. The mysql setup > should be similar. > http://cfguru.daemon.com.au/archives/82.html > > Dave > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231329 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL 5 and CFMX7 (New Problem)
Yes, it is displayed under System Information in CF Admin -Original Message- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:07 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class path? You have to restart CF after you add it so that the jdbc driver gets loaded in. Here is a link to how to install the postgress driver. The mysql setup should be similar. http://cfguru.daemon.com.au/archives/82.html Dave ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231327 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7 (New Problem)
Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class path? You have to restart CF after you add it so that the jdbc driver gets loaded in. Here is a link to how to install the postgress driver. The mysql setup should be similar. http://cfguru.daemon.com.au/archives/82.html Dave ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231323 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL 5 and CFMX7 (New Problem)
Guess that would help java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connection -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 6:53 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) what error? On 2/3/06, ColdFusion <[EMAIL PROTECTED]> wrote: > Now I removed MySQL 5 and ran regClean to clean the registries. Then > re-installed MySQL 5. > > Downloaded the Connectors/J for 5.0 from MySQL > > copied the mysql-connector-java-5.0.0-beta-bin.jar > into CfusionMX7 \ wwwroot \ web-inf\ lib folder. > Restarted ColdFusion. > > Added the datasource using Other: > jdbc:mysql://localhost:3306/myTest > com.mysql.jdbc.Driver > > and now I have this error. > > Yes... MySQL is running on Port 3306 > Yes... I can connect to MySQL 5.0 using NaviCat using > Localhost:3306 > > Any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231322 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7 (New Problem)
what error? On 2/3/06, ColdFusion <[EMAIL PROTECTED]> wrote: > Now I removed MySQL 5 and ran regClean to clean > the registries. Then re-installed MySQL 5. > > Downloaded the Connectors/J for 5.0 from MySQL > > copied the mysql-connector-java-5.0.0-beta-bin.jar > into CfusionMX7 \ wwwroot \ web-inf\ lib folder. > Restarted ColdFusion. > > Added the datasource using Other: > jdbc:mysql://localhost:3306/myTest > com.mysql.jdbc.Driver > > and now I have this error. > > Yes... MySQL is running on Port 3306 > Yes... I can connect to MySQL 5.0 using NaviCat using > Localhost:3306 > > Any ideas? > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231321 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7 (New Problem)
Now I removed MySQL 5 and ran regClean to clean the registries. Then re-installed MySQL 5. Downloaded the Connectors/J for 5.0 from MySQL copied the mysql-connector-java-5.0.0-beta-bin.jar into CfusionMX7 \ wwwroot \ web-inf\ lib folder. Restarted ColdFusion. Added the datasource using Other: jdbc:mysql://localhost:3306/myTest com.mysql.jdbc.Driver and now I have this error. Yes... MySQL is running on Port 3306 Yes... I can connect to MySQL 5.0 using NaviCat using Localhost:3306 Any ideas? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231320 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
Stan Winchester wrote: > Yes I've installed the latest drivers from the MySQL site. It never has made > a difference. > > What I've been wondering is what MySQL engine should I be using "MyISAM" or > the default "InnoDB"? From coldfusion's perspective, it doesn't really matter unless you want to use transactions... so you downloaded the new mysql connectorJ, installed the jar file in the appropriatel ocation, and then used the "other" datasource type instead of the "mysql" datasource type, and it still didn't work? Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231296 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
Yes I've installed the latest drivers from the MySQL site. It never has made a difference. What I've been wondering is what MySQL engine should I be using "MyISAM" or the default "InnoDB"? >Are you guys using the same/correct jdbc drivers? CF7 doesn't ship with >MySQL drivers for version 4 and 5, you have to install them youself. Have >you install the latest ones from the mysql website? > >Russ > >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231294 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL 5 and CFMX7
Are you guys using the same/correct jdbc drivers? CF7 doesn't ship with MySQL drivers for version 4 and 5, you have to install them youself. Have you install the latest ones from the mysql website? Russ > -Original Message- > From: Stan Winchester [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 1:21 PM > To: CF-Talk > Subject: Re: MySQL 5 and CFMX7 > > How does rds in HomeSite or DW display the field lengths? Are they all > 65535? The reason this is important to me is because I have created a cfc > wizard for Homesite that works great with SQL Server, but with MySQL data > sources it thinks everything is 65535 in length. > > >I have been able to connect MySQL 5 and CF 7 using teh JDBC drivers > without > >issue. > > > >On 2/2/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
Pete Ruckelshaus wrote: > I was only able to get MySQL to work with MX7 using an ODBC passthrough. > > It's really too bad that MySQL makes it so difficult for companies > like Macromedia to get the Java version of their drivers so that they > could update the default support in a point release...I mean it's only > been, what, 3 years since mySQL3 was replaced by mySQL4? > > /SARCASM > > Seriously, Macromedia, update the darned mySQL drivers already. don't be too hard on Macromedia. From what I undestand, MySQL's modern JDBC drivers are released under a license that basically prohibits macromedia from distributing them. you don't have to do odbc passthru, you can just use "Other" and install a current MySQL JDBC Driver. That's why I do. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231277 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
How does rds in HomeSite or DW display the field lengths? Are they all 65535? The reason this is important to me is because I have created a cfc wizard for Homesite that works great with SQL Server, but with MySQL data sources it thinks everything is 65535 in length. >I have been able to connect MySQL 5 and CF 7 using teh JDBC drivers without >issue. > >On 2/2/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231275 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
I've gotten it to work with upgraded ODBC drivers and with the ConnectorJ. --Ferg Scott Stroz wrote: > I have been able to connect MySQL 5 and CF 7 using teh JDBC drivers without > issue. > > On 2/2/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > >> I was only able to get MySQL to work with MX7 using an ODBC passthrough. >> >> It's really too bad that MySQL makes it so difficult for companies >> like Macromedia to get the Java version of their drivers so that they >> could update the default support in a point release...I mean it's only >> been, what, 3 years since mySQL3 was replaced by mySQL4? >> >> /SARCASM >> >> Seriously, Macromedia, update the darned mySQL drivers already. >> >> Pete >> >> On 2/2/06, Adkins, Randy <[EMAIL PROTECTED]> wrote: >> >>> Does anyone have problems running MySQL 5 with CFMX 7? >>> >>> I have CMFX 7 and MySQL 4.1 but now the ODBC connections >>> bomb out for the following error: >>> >>> Connection verification failed for data source: DEV_THISSITE >>> java.sql.SQLException: Communication failure during handshake. Is there >>> a server running on localhost:3306? >>> The root cause was that: java.sql.SQLException: Communication failure >>> during handshake. Is there a server running on localhost:3306? >>> >>> >>> >>> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231271 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
Using JDBC drivers all of my MySQL data sources show a field length of 65535 regardless of data type. This is not specific to MySQL 5 with CFMX 7, I have had this problem since CF6.1 & MySQL 4. I would love to resolve this issue! >Have you tried one of the newer Mysql JDBC or ODBC drivers? > >http://www.mysql.com/products/connector/j/ >http://dev.mysql.com/downloads/connector/odbc/ > >Also check to see if Mysql is actually running on port 3306. > >Dave > >On Feb 2, 2006, at 11:07 AM, Adkins, Randy wrote: > >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
I have been able to connect MySQL 5 and CF 7 using teh JDBC drivers without issue. On 2/2/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > I was only able to get MySQL to work with MX7 using an ODBC passthrough. > > It's really too bad that MySQL makes it so difficult for companies > like Macromedia to get the Java version of their drivers so that they > could update the default support in a point release...I mean it's only > been, what, 3 years since mySQL3 was replaced by mySQL4? > > /SARCASM > > Seriously, Macromedia, update the darned mySQL drivers already. > > Pete > > On 2/2/06, Adkins, Randy <[EMAIL PROTECTED]> wrote: > > Does anyone have problems running MySQL 5 with CFMX 7? > > > > I have CMFX 7 and MySQL 4.1 but now the ODBC connections > > bomb out for the following error: > > > > Connection verification failed for data source: DEV_THISSITE > > java.sql.SQLException: Communication failure during handshake. Is there > > a server running on localhost:3306? > > The root cause was that: java.sql.SQLException: Communication failure > > during handshake. Is there a server running on localhost:3306? > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231232 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
I was only able to get MySQL to work with MX7 using an ODBC passthrough. It's really too bad that MySQL makes it so difficult for companies like Macromedia to get the Java version of their drivers so that they could update the default support in a point release...I mean it's only been, what, 3 years since mySQL3 was replaced by mySQL4? /SARCASM Seriously, Macromedia, update the darned mySQL drivers already. Pete On 2/2/06, Adkins, Randy <[EMAIL PROTECTED]> wrote: > Does anyone have problems running MySQL 5 with CFMX 7? > > I have CMFX 7 and MySQL 4.1 but now the ODBC connections > bomb out for the following error: > > Connection verification failed for data source: DEV_THISSITE > java.sql.SQLException: Communication failure during handshake. Is there > a server running on localhost:3306? > The root cause was that: java.sql.SQLException: Communication failure > during handshake. Is there a server running on localhost:3306? > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231231 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
I believe we had to update the ODBC drivers when we upgraded to 7. All is working just fine now though. --Ferg Adkins, Randy wrote: > Does anyone have problems running MySQL 5 with CFMX 7? > > I have CMFX 7 and MySQL 4.1 but now the ODBC connections > bomb out for the following error: > > Connection verification failed for data source: DEV_THISSITE > java.sql.SQLException: Communication failure during handshake. Is there > a server running on localhost:3306? > The root cause was that: java.sql.SQLException: Communication failure > during handshake. Is there a server running on localhost:3306? > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231207 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 and CFMX7
Have you tried one of the newer Mysql JDBC or ODBC drivers? http://www.mysql.com/products/connector/j/ http://dev.mysql.com/downloads/connector/odbc/ Also check to see if Mysql is actually running on port 3306. Dave On Feb 2, 2006, at 11:07 AM, Adkins, Randy wrote: > Does anyone have problems running MySQL 5 with CFMX 7? > > I have CMFX 7 and MySQL 4.1 but now the ODBC connections > bomb out for the following error: > > Connection verification failed for data source: DEV_THISSITE > java.sql.SQLException: Communication failure during handshake. Is > there > a server running on localhost:3306? > The root cause was that: java.sql.SQLException: Communication failure > during handshake. Is there a server running on localhost:3306? > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231148 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
MySQL 5 and CFMX7
Does anyone have problems running MySQL 5 with CFMX 7? I have CMFX 7 and MySQL 4.1 but now the ODBC connections bomb out for the following error: Connection verification failed for data source: DEV_THISSITE java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231136 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54