Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » NewbieSays: Arg! Can't 'ping' my MYSQL server? WTF?(Getting Ping failed error when connecting)
NewbieSays: Arg! Can't 'ping' my MYSQL server? WTF? [message #730705] Wed, 28 September 2011 23:11 Go to next message
John Fields is currently offline John FieldsFriend
Messages: 2
Registered: September 2011
Junior Member
Quickly: I am a developer so I know my way around a linux box. First time BIRT/Eclipse/Java user though, and I cannot seem to get connected to a mySQL database with a stock BIRT. I am expecting this is a common problem that is SO common as to not be documented anywhere.

I installed BIRT from the tar: eclipse-reporting-indigo-SR1-linux-gtk-x86_64.tar.gz
openSUSE v11.4, replaced the JVM with "real" Sun/Oracle, installed DTP and edited the eclipse.ini and the "About" screen in Eclipse shows the correct JVM is called.
Updated via the internal "check for updates".

When trying to create the database connection I get "ping failed".
I assure you this box CAN ping the mysql server on a different box.

I even tried dropping the DNS name: jdbc:mysql://192.168.55.65:3306/
(no joy).

The full detail of the error is:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
	at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:627)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
	at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:212)
	at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
	at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
	at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)
	at org.eclipse.datatools.enablement.internal.mysql.connection.JDBCMySQLConnectionFactory.createConnection(JDBCMySQLConnectionFactory.java:28)
	at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
	at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
	at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
	at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)


So no Tomcat, or production webserver. Just a single instance of stock BIRT on a workstation with a mysql server box on the same lan.

Help!? I am out of ideas to try...

Report message to a moderator

Re: NewbieSays: Arg! Can't 'ping' my MYSQL server? WTF? [message #730938 is a reply to message #730705] Thu, 29 September 2011 14:48 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
Did you use the manage drivers button to add the MySQL driver to the
designer? The driver should be in this directory:
eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_version\drivers

Jason


On 9/28/2011 7:11 PM, John Fields wrote:
> Quickly: I am a developer so I know my way around a linux box. First
> time BIRT/Eclipse/Java user though, and I cannot seem to get connected
> to a mySQL database with a stock BIRT. I am expecting this is a common
> problem that is SO common as to not be documented anywhere.
>
> I installed BIRT from the tar:
> eclipse-reporting-indigo-SR1-linux-gtk-x86_64.tar.gz
> openSUSE v11.4, replaced the JVM with "real" Sun/Oracle, installed DTP
> and edited the eclipse.ini and the "About" screen in Eclipse shows the
> correct JVM is called.
> Updated via the internal "check for updates".
>
> When trying to create the database connection I get "ping failed".
> I assure you this box CAN ping the mysql server on a different box.
>
> I even tried dropping the DNS name: jdbc:mysql://192.168.55.65:3306/
> (no joy).
>
> The full detail of the error is:
> java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
> at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
> at java.security.AccessController.doPrivileged(Native Method)
> at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
> at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:627)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
> at
> org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:212)
>
> at
> org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
>
> at
> org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
>
> at
> org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73)
>
> at
> org.eclipse.datatools.enablement.internal.mysql.connection.JDBCMySQLConnectionFactory.createConnection(JDBCMySQLConnectionFactory.java:28)
>
> at
> org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
>
> at
> org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
>
> at
> org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
>
> at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
>
>
> So no Tomcat, or production webserver. Just a single instance of stock
> BIRT on a workstation with a mysql server box on the same lan.
>
> Help!? I am out of ideas to try...

Report message to a moderator

Re: NewbieSays: Arg! Can't 'ping' my MYSQL server? WTF? [message #731377 is a reply to message #730938] Fri, 30 September 2011 19:09 Go to previous message
John Fields is currently offline John FieldsFriend
Messages: 2
Registered: September 2011
Junior Member
OK. Got it to work! Thx for your time!

For others:
Downloaded the mysql jdbc driver from mysql.com, copied just the mysql-connector-java-5.1.17-bin.jar file to this dir:
/home/john.fields/bin/eclipse/plugins/org.eclipse.birt.report.data.oda.jdbc_3.7.1.v20110905/drivers/

The ping error went away, but the system seemed to hang. Progress?

So I deleted both the eclipse directory and the workspace and reloaded clean...
1) unzip eclipse BIRT to my directory.
2) run it, re-create the workspace directory.
3) help -> update. (takes a while...)
4) cp the mysql.jar file mentioned above to the latest drivers dir.
5) THEN create a new BIRT reporting project and create the database connection.
6) It won't find the mysql.jar file yet, so you have to tell eclipse it is there..
...When you are creating the driver definition, where you enter the host name and mysql user/password...
...Look for the 'Edit Driver Definiton' icon, a Delta symbol (like a triangle).
...Click on the middle tab 'JAR List'.
...Remove the old jar.
...Add your new jar (point to the drivers directory you just copied the file into.
...Click OK
7) Now do a 'Test Connection'! It worked for me at this point, even with a v5.1 mysql driver and a v5.0 database.

Good luck space campers..

Report message to a moderator

Previous Topic:Error deploying BIRT 3.7 to JBOSS 6.0.0
Next Topic:How to suppress some bookmarks in the bookmarks view
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 23:13:19 GMT 2024

Powered by FUDForum. Page generated in 0.04331 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly