CX 6.1/MySQL 4.1 - logger class error?

[Gambit6]

I was getting the error logged here:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url] I ran
through those steps and now am getting this error: Connection verification
failed for data source: patientsafety []java.sql.SQLException: Unable to
instantiate logger class 'com.mysql.jdbc.log.Log4JLogger', exception in
constructor? The root cause was that: java.sql.SQLException: Unable to
instantiate logger class 'com.mysql.jdbc.log.Log4JLogger', exception in
constructor? My ODBC attempted setup is: JDBC URL =
jdbc:mysql://localhost:3306/patientsafety Driver class = com.mysql.jdbc.Driver
My version of CF is the developer version of MX 6.1, if that matters. Any
ideas? Thanks.

[{CrkZ}-DJ-]

I am having this exact same problem.

Copied the mysql-connector-java-3.1.8-bin.jar file to
C:\CFusionMX\wwwroot\WEB-INF\lib\ directory.

Restarted all Coldfusion Services.

Attempted to add the datasource as directed and recieved the error Gambit6
posted above.

Ver.
Windows XP
CFMX 6.1 Developer --> installed with default "server" option
MySQL Essential 4.1.11

[{CrkZ}-DJ-]

Did you figure this out Gambit?

[Gambit6]

Unfortunately, not yet. Haven't had a chance to work on the issue yet today. If I do figure it out, I will post the solution here.

[Gambit6]

I figured out a solution. I had downloaded version 3.1 of MySQL Connector J. I just removed that and replaced it with the previous version (3.0). Now it works.

[Lil-Rugger]

What version of 3.0 did you use to solve this problem?
mysql-connector-java-3.{n}-bin.jar - what was the name of this file that you
put in the WEB_INF/lib file?

I got the original logging error you discussed when I put the 3.1.8 jar file.
Then I changed to

C:\CFusionMX\wwwroot\WEB-INF\lib\mysql-connector-java-3.0.6-stable-bin.jar
stopped and started CF services and rebooted the server

I set-up my datasource and got the error below:
jdbc:mysql://111.222.333.444:3306/mydbname
Driver Class: com.mysql.jdbc.Driver
Drive Name:
Username: enteredminehere
Password: enteredmineere

Connection verification failed for data source: testing
[]java.sql.SQLException: Communication link failure: java.io.IOException,
underlying cause: Unexpected end of input stream ** BEGIN NESTED EXCEPTION **
java.io.IOException MESSAGE: Unexpected end of input stream STACKTRACE:
java.io.IOException: Unexpected end of input stream at
com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:107 3) at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:61 9) at
com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1511) at
com.mysql.jdbc.Connection.(Connection.java:485) at
com.mysql.jdbc.Driver.connect(Driver.java:341) at
coldfusion.server.j2ee.sql.pool.JDBCPool.createPhy sicalConnection(JDBCPool.java:
511) at
coldfusion.server.j2ee.sql.pool.ConnectionRunner$R unnableConnection.run(Connecti
onRunner.java:64) at java.lang.Thread.run(Thread.java:534) ** END NESTED
EXCEPTION **
The root cause was that: java.sql.SQLException: Communication link failure:
java.io.IOException, underlying cause: Unexpected end of input stream ** BEGIN
NESTED EXCEPTION ** java.io.IOException MESSAGE: Unexpected end of input stream
STACKTRACE: java.io.IOException: Unexpected end of input stream at
com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:107 3) at
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:61 9) at
com.mysql.jdbc.Connection.createNewIO(Connection.j ava:1511) at
com.mysql.jdbc.Connection.(Connection.java:485) at
com.mysql.jdbc.Driver.connect(Driver.java:341) at
coldfusion.server.j2ee.sql.pool.JDBCPool.createPhy sicalConnection(JDBCPool.java:
511) at
coldfusion.server.j2ee.sql.pool.ConnectionRunner$R unnableConnection.run(Connecti
onRunner.java:64) at java.lang.Thread.run(Thread.java:534) ** END NESTED
EXCEPTION **

[Brad]

There is one other change I had to make for this to work. In addition to
having to roll back to an older than current stable release of the Connector
(3.1.6 in my case) I also had to place this file into the CFusionMX/lib
folder rather than the cfroot/web-inf/lib folder.

Once I made these two changes, I can now connect to MySQL 4.1 from MX 6.1
Enterprise. I've leaving comments for Macromedia that their technote
6ef0253 is either incomplete or wrong since it tells you to copy to the
web-inf/lib folder. That wasted a good deal fo my time.

.....Brad


"Gambit6" <webforumsuser@macromedia.com> wrote in message
news:d489t7$5ht$1@forums.macromedia.com...
I figured out a solution. I had downloaded version 3.1 of MySQL Connector
J. I just removed that and replaced it with the previous version (3.0).
Now it works.

[Michael van K]

Thanks for this folks, it helped me too with mysql-connector-java-3.0.16-ga-bin.jar in the CFusionMX/lib folder.

[Sarge]

Hi all. I had a customer bring the technote in question to my attention and the
information in it is technically correct. The only problem I found was with the
link to MySQL's Connector J download site. You are all correct that the 3.1.8a
drivers throw a Log4j error -- I logged a bug for it -- and the 3.0.16ga
drivers work. However, I loaded my 3.0.16ga drivers into
cf_root/wwwroot/WEB-INF/lib at they worked for me -- on both CFMX 6.1 Updater
and CFMX 7. I would rather none of you put anything into cf_root/lib other than
Macromedia supplied files. If you insist cf_root/wwwroot/WEB-INF/lib is not
working for you, use cf_root/runtime/servers/lib (create it if it doesn't
exist) for Server and J2EE w/JRun 4 (jrun_root/server_instance/lib)
configurations.

I blogged this at [url]http://www.sargeway.com/blog/index.cfm?mode=entry&entry=62[/url]

[alexzive]

Thanks to all here !!!!!!!!!!!!!!!!!!!! I was desperate!!!!!
Greetings from Italy:)

[xipher1]

Hi there, I am having some difficulties with this. I have it working fine with
3.0.17-ga, but it seems that this connector is not supporting multi queries? I
have it working on a seperate production server with CFMX7.0 and v3.1.10
connector, and multi-queries are working just dandy, and I am confused why they
dont work with 3.0.17 AND why I can't install 3.1.10 with CFMX6.1?

Any thoughts?

[Mountain Lover]

maybe try using the allowMultiQueries property in the connection URL ?
[url]http://dev.mysql.com/doc/refman/5.0/en/cj-configuration-properties.html[/url]
HTH
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]