problems with jdbc wrapper on new server
Will Swain
So, setting up a new server, which is running a trial version of FR until I can switch across the license from the old server.
Anyway, the web hosting company did a port of all our settings and sites, via Plesk. I installed FR. For the datasources with fr jdbc wrappers I’m getting the following error:
EVENTNAME onApplicationStart
EXCEPTION
Error - struct
Cause
Error - struct
Cause
Error - struct
ErrorCode 0
Message No suitable driver
SQLState 08001
StackTrace java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:264) at com.intergral.fusionreactor.jdbc.Wrapper.connect(Wrapper.java:298) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:589) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67) at java.lang.Thread.run(Thread.java:619)
TagContext
Error - array [empty]
Type java.sql.SQLException
DataSource osn
Detail No suitable driver
ErrorCode 08001
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
Error - struct
ErrorCode 0
Message No suitable driver
SQLState 08001
StackTrace java.sql.SQLException: No suitable driver at java.sql.DriverManager.getDriver(DriverManager.java:264) at com.intergral.fusionreactor.jdbc.Wrapper.connect(Wrapper.java:298) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:589) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67) at java.lang.Thread.run(Thread.java:619)
TagContext
Error - array [empty]
Type java.sql.SQLException
SQLState 08001
I thought the JDBC wrapper was installed with FR. ColdFusion has been restarted. Am I missing anything obvious? And ideas welcome. CF8 FR 3.5.1,
Thanks
Will Swain
Hot Horse Ltd - Web Design and Development
0845 458 2536
The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, you are not authorised and must not disclose, copy, distribute or retain this message or any part of it.
The contents of this message may contain personal views which are not the views of Hot Horse Ltd, unless specifically stated.
Hot Horse Ltd Company Number 3877066 Registered Office The Stables, Connaught Road, Seaford, East Sussex. BN25 2PT.
Should you experience any problems with opening and reading emails and attachments or you are not the intended recipient, please contact sup...@hothorse.com
John Hawksley
The driver is installed with FR and by the looks of things (you can see com.intergral.fusionreactor.jdbc.* in the trace), it has been found. The problem is the wrapper can't find the underlying driver type.
Can you let us have the driver class (of the underlying driver) and the JDBC url (with passwords deleted) and we can take it from there.
Also useful would be details about the app server (CF standalone/etc, version) and FR version.
Either here or to sup...@fusion-reactor.com is fine.
All the best,
-John
-- John Hawksley Senior Engineer Voice: +49 7031 221 502 | Fax: +49 7031 221 524 www.intergral.com Intergral GmbH - Schickardstr 32 - D-71034 Boeblingen - Germany Geschaeftsfuehrer: David Tattersall, Darren Pywell Sitz der Gesellschaft: Boeblingen
--
You received this message because you are subscribed to the Google Groups "FusionReactor" group.
To post to this group, send email to fusion...@googlegroups.com.
To unsubscribe from this group, send email to fusionreacto...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/fusionreactor?hl=en.
Will Swain
Hi John,
Does this help?
Driver FusionReactor
JDBC URL jdbc:fusionreactor:wrapper:{jdbc:mysql://localhost:3306/acoustic?useUnicode=true&characterEncoding=I SO8859_1}
Username *****
Login timeout 30 seconds
Long text buffer size 64000
Timeout 1200 seconds
Maintain connections Yes
Interval 420 seconds
Restricted SQL operations
Disable connections No
Server Product ColdFusion
Version 8,0,1,195765
Edition
Operating System Windows 2003
OS Version 5.2
Fusion Reactor FR 3.5.1,
Let me know if you need anything else.
Cheers
Will
Will Swain
Hi John,
Thanks for the reply. Yes, we are using the built in MySQL driver.
I’ll try rewrapping the driver as you suggest, and see what happens.
Will let you know
Will
From: fusion...@googlegroups.com [mailto:fusion...@googlegroups.com] On Behalf Of John Hawksley
Sent: 12 July 2010 08:54
To: fusion...@googlegroups.com
Subject: Re: [fusionreactor] problems with jdbc wrapper on new server
Hi Will,
Thanks for that. I take it you're using the builtin MySQL driver?
The first thing I would suggest is rewrapping the driver using our admin tool:
- http://www.fusion-reactor.com/community/developers/autodev_detailed.cfm?article=FRS-234
- http://bit.ly/blyaWA
This should give you a JDBC URL with a "driver" parameter on the end.
If that doesn't work, you may need to use the split-jar method. This is a simple procedure which uses two FusionReactor jar files - one containing the core and one containing just the JDBC wrapper. This is necessary because of the way java partitions class loaders: FR sometimes finds itself in a position whereby the driver wrapper can't 'see' FusionReactor.
The procedure for the split-jar install is:
http://www.fusion-reactor.com/support/kb/FRS-240.cfm
The two jars are delivered with FR-3.5.1 and just need to be copied into place -- the procedure has all the details.
Please let us know how you get on!
-John
--
John Hawksley
Senior Engineer
Voice: +49 7031 221 502 | Fax: +49 7031 221 524
www.intergral.com
Intergral GmbH - Schickardstr 32 - D-71034 Boeblingen - Germany
Geschaeftsfuehrer: David Tattersall, Darren Pywell
Sitz der Gesellschaft: Boeblingen