web stats
MySQL Doubt - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 09-19-2006, 07:24 AM
pitchfork pitchfork is offline
Mirth Newb
 
Join Date: Sep 2006
Posts: 19
pitchfork
Default MySQL Doubt

Hi again,

I am trying to connect Mirth with an external MySQL Database (inbound).

In the "destination" tab I fill in the fields with these values:

Connector Type: Database Writer
Driver: MySQL
Database URL: jdbc:mysql://server-ip/test
Username and password

Is there something wrong with this configuration? I cannot insert a single value in the database table.

Thank you very much!
Reply With Quote
  #2  
Old 09-19-2006, 08:36 AM
chrisl chrisl is offline
Mirth Employee
 
Join Date: Aug 2006
Posts: 967
chrisl is an unknown quantity at this point
Default Re: MySQL Doubt

I need to see the full channel and any errors you are getting to figure out where you might have problems. The database URL looks fine. Check your mirth.log for errors, and paste anything that's related to the JDBC writer.

-Chris
__________________
Chris Lang
Reply With Quote
  #3  
Old 09-19-2006, 10:57 PM
pitchfork pitchfork is offline
Mirth Newb
 
Join Date: Sep 2006
Posts: 19
pitchfork
Default Re: MySQL Doubt

Hi,

I have read in another thread that maybe is not availabe the mysql driver yet??Mith MS SQL Server works fine. Although my primary goal is to connect Mirth to an Informix Database. If anyone knows how to do it I would be very grateful.

Thanks very much.

This is what I get in the log file.

ERROR [4_destination_4.dispatcher.1] org.mule.impl.DefaultExceptionStrategy: Caught exception in Exception Strategy: com.mysql.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.mule.providers.jdbc.JdbcConnector.getConnectio n(JdbcConnector.java:361)
at org.mule.providers.jdbc.JdbcMessageDispatcher.doDi spatch(JdbcMessageDispatcher.java:93)
at org.mule.providers.AbstractMessageDispatcher$Worke r.run(AbstractMessageDispatcher.java:257)
at org.mule.impl.work.WorkerContext.run(WorkerContext .java:290)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.runTask(ThreadPoolExecutor. java:650)
at edu.emory.mathcs.backport.java.util.concurrent.Thr eadPoolExecutor$Worker.run(ThreadPoolExecutor.java :675)
at java.lang.Thread.run(Unknown Source)
Reply With Quote
  #4  
Old 09-20-2006, 03:27 AM
pitchfork pitchfork is offline
Mirth Newb
 
Join Date: Sep 2006
Posts: 19
pitchfork
Default Re: MySQL Doubt

Ok, I solved it just adding the mysql driver that was missing.

Reply With Quote
  #5  
Old 09-20-2006, 06:16 AM
mrslatezb mrslatezb is offline
Mirth Newb
 
Join Date: Sep 2006
Posts: 15
mrslatezb
Default Re: MySQL Doubt

I get the same message when I try to connect via MySQL. Is there anyway you can provide instructions on how you readded the driver because I still can't get my connection to work using the same methods described here. I did add the old mysql drivers to the lib/dbdrivers folder but it hasnt fixed the problem. I get the exact same error messages as Pitchfork.
Reply With Quote
  #6  
Old 09-20-2006, 06:32 AM
pitchfork pitchfork is offline
Mirth Newb
 
Join Date: Sep 2006
Posts: 19
pitchfork
Default Re: MySQL Doubt

I added this file version to the \mirth\lib\dbdrivers folder: mysql-connector-java-3.1.13-bin.jar

It should fix the problem.




Reply With Quote
  #7  
Old 09-20-2006, 08:43 AM
mrslatezb mrslatezb is offline
Mirth Newb
 
Join Date: Sep 2006
Posts: 15
mrslatezb
Default Re: MySQL Doubt

Thanks for the help now that error has went away. But iget the No Suitable Driver error now. I guess i have to figure out what I am missing now !
Reply With Quote
  #8  
Old 09-20-2006, 09:14 AM
chrisl chrisl is offline
Mirth Employee
 
Join Date: Aug 2006
Posts: 967
chrisl is an unknown quantity at this point
Default Re: MySQL Doubt

Update to version 1.1.0 and the MySQL driver is included.

-Chris
__________________
Chris Lang
Reply With Quote
  #9  
Old 09-20-2006, 04:24 PM
mrslatezb mrslatezb is offline
Mirth Newb
 
Join Date: Sep 2006
Posts: 15
mrslatezb
Default Re: MySQL Doubt

Thanks for the help. I actually just to uninstall completely and reinstall and then copy the mysql driver into place. I didnt get a chance to download the updated 1.1.0. Everything works great, this program is fantastic! Thanks Chris.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
using a mysql db supertoms Support 6 04-01-2009 02:56 AM
Using mysql instead of Derby for mirth Bleupomme Support 4 05-13-2008 05:01 AM
How to connect to MySQL server? drperl Support 3 04-20-2008 11:02 PM
Reducing the lookups in MySQL DB Svetlomir Kasabov Support 0 02-26-2008 01:19 PM
mirth 1.5 MySQL csaccavini Support 1 05-29-2007 09:40 AM


All times are GMT -8. The time now is 07:37 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Mirth Corporation