Connecting mySQL to Ruby on NETBEAN 8.0

[infinite.curve]

So... I hae this issue trying to connect mySQL to ruby on net bean... Has anyone connected it before?

The code:

#!/user/bin/ruby


require 'mysql'


begin
puts "hello World"
con = Mysql.new 'localhost', 'sqluser', ''
puts con.get_server_info
rs = con.query 'SELECT VERSION();'
puts rs.fetch_row

rescue Mysql::Error => e
puts e.errno
puts e.error

ensure
con.close if con
end

LoadError: no such file to load -- mysql
require at org/jruby/RubyKernel.java:1027
require at /Users/eugenelemon/Library/Application Support/NetBeans/8.0/jruby/lib/ruby/shared/rubygems/custom_require.rb:36
(root) at /Users/eugenelemon/NetBeansProjects/RubyApplication1/lib/main.rb:9

 

[Borg]

I'm not a Ruby developer but perhaps this will help.

http://rubylearning.com/satishtalim/ruby_mysql_tutorial.html

 

[Borek]

LoadError: no such file to load -- mysql

Looks like the problem occurs long before you try to connect to the database.

 

[redrails]

Looks like it's a MySQL server issue as it's not able to access the database file that you're trying to pull.

 

[LudusRex]

I have not personally connected mySQL to Ruby on NetBean 8.0 before, but I do have some suggestions that may help you troubleshoot this issue.

Firstly, it appears that you are using JRuby as your Ruby implementation, which may have different requirements for connecting to mySQL compared to other Ruby implementations. I would recommend checking the JRuby documentation or forums for specific instructions on how to connect to mySQL.

Secondly, it seems that the error message is indicating that the mysql gem is not properly installed or loaded. Make sure that you have the mysql gem installed and properly configured in your project. You can also try using the require statement to explicitly load the mysql gem before attempting to use it.

Lastly, make sure that your mySQL server is running and that you have the correct credentials and permissions set up for your database. Double check your connection string and try connecting to the database using a different tool or language to make sure that the issue is not with the database itself.

I hope these suggestions help you resolve your issue and successfully connect mySQL to Ruby on NetBean 8.0. If you continue to experience difficulties, I would recommend reaching out to the NetBean or JRuby community for further assistance. Best of luck!