osdir.com
mailing list archive F.A.Q. -since 2001!



Subject: Here's a Hypersonic Ruby wrapper - msg#00020

List: java.hsqldb.user

Mail Archive Navigation:
by Date: Prev Next Date Index by Thread: Prev Next Thread Index

Hi all,

I've just released an open source Ruby wrapper for Hypersonic. I had a client who wanted to use Hypersonic from Rails and they wanted it open sourced. This driver was the first step. The Rails part would've used this part, but the project isn't being pursued, so the Rails part didn't get finished.
If you have any problems, please pass them on and I'll try to get them fixed in a timely manner. I do have a newer version of the driver with more code to support ActiveRecord/Rails requests, but I wanted to release the minimal version for now. When I have time I'll try to get the AR code support into the next release.
This is my first Hypersonic project, so the code hasn't been tested beyond the bundled tests and examples. Feel free to offer improvements. :)
http://rubyforge.org/projects/hypersonic/
I'll paste the readme at the end of this message.
btw, the downloadable gem wont' be available for an hour or two due to the project's infrastructure.
Jaredhttp://jaredrichardson.net

----------------------------------------
README.TXT
--------------------------------------
This is a driver (or bridge) to allow your Ruby code to use the Hypersonic database.
There are two things you need to do before you can use this driver.
First, you must have the Yet Another Java Bridge installed. http://www.cmt.phys.kyushu-u.ac.jp/~M.Sakurai/cgi-bin/fw/wiki.cgi?page=YAJB
Second, you must have hsqldb.jar in your classpath.
If you can run "rake test", then you're environment is probably fine. Just be sure that the user account you'll be running the driver under also has their classpath set up properly.
To build and install, type "rake gem", then "gem install hypersonic-1.0.gem" or "sudo gem install hypersonic-1.0.gem". You may need to insert a newer version number than 1.0
You can extract examples from the test folder. The Test_hypersonic.rb file will show you exactly how to use the driver, but here's a short example as well. It's extracted from the test folder.
@temp_table_name = "TEMP_TABLE_FOR_THESE_TESTS"
@h = Hypersonic.new@h.connect("jdbc:hsqldb:file:testdb2", "sa", "")@h.execute_update("DROP TABLE #{@temp_table_name} IF EXISTS")@h.execute_update("CREATE TABLE #{@temp_table_name} (c1 INTEGER, c2 VARCHAR)")@h.execute_update("INSERT INTO #{@temp_table_name}(c1, c2) VALUES (32, 'howdy')")rs = @h.execute_query("SELECT * FROM #{@temp_table_name}")rs = @h.execute_query("SELECT COUNT(*) FROM #{@temp_table_name}")

Please let me know if you have problems running the driver.
Jaredhttp://jaredrichardson.net



-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Thread at a glance:

Previous Message by Date:

MDB or DB -> HSQL

Hi HSQL folks :-) i've big database written by Paradox in Delphi and i've copy of it written by M$ Access How i can convert my database from Paradox or Access to HSQL format ? if anybody know any tool do that automatically it can help me, or u can give a code for converting process -- Best Regards ØØÙØØÙ Muhammad Bashir Al-Noimi ÙØÙØ ØØÙØ ØÙÙØÙÙÙ ÙØÙÙØÙ My Blog http://www.hali-sy.net/bashir ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Hsqldb-user mailing list Hsqldb-user@xxxxxxxxxxxxxxxxxxxxx https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Next Message by Date:

Re: MDB or DB -> HSQL

you need to compile and use the Transfer Tool. See the Guide for details. Fred ----- Original Message ----- From: "M. Bashir Al-Noimi" <hali83@xxxxxx> To: <hsqldb-user@xxxxxxxxxxxxxxxxxxxxx> Sent: 08 October 2006 15:34 Subject: [Hsqldb-user] MDB or DB -> HSQL Hi HSQL folks :-) i've big database written by Paradox in Delphi and i've copy of it written by M$ Access How i can convert my database from Paradox or Access to HSQL format ? if anybody know any tool do that automatically it can help me, or u can give a code for converting process -- Best Regards ØØÙØØÙ Muhammad Bashir Al-Noimi ÙØÙØ ØØÙØ ØÙÙØÙÙÙ ÙØÙÙØÙ My Blog http://www.hali-sy.net/bashir ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Hsqldb-user mailing list Hsqldb-user@xxxxxxxxxxxxxxxxxxxxx https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Hsqldb-user mailing list Hsqldb-user@xxxxxxxxxxxxxxxxxxxxx https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Previous Message by Thread:

MDB or DB -> HSQL

Hi HSQL folks :-) i've big database written by Paradox in Delphi and i've copy of it written by M$ Access How i can convert my database from Paradox or Access to HSQL format ? if anybody know any tool do that automatically it can help me, or u can give a code for converting process -- Best Regards ØØÙØØÙ Muhammad Bashir Al-Noimi ÙØÙØ ØØÙØ ØÙÙØÙÙÙ ÙØÙÙØÙ My Blog http://www.hali-sy.net/bashir ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Hsqldb-user mailing list Hsqldb-user@xxxxxxxxxxxxxxxxxxxxx https://lists.sourceforge.net/lists/listinfo/hsqldb-user

Next Message by Thread:

Re: Here's a Hypersonic Ruby wrapper

btw, an article was just posted about the driver on InfoQ.comhttp://www.infoq.com/news/ruby-driver-hsqldbJaredhttp://jaredrichardson.netOn Oct 8, 2006, at 5:34 PM, Jared Richardson wrote:Hi all,I've just released an open source Ruby wrapper for Hypersonic. I had a client who wanted to use Hypersonic from Rails and they wanted it open sourced. This driver was the first step. The Rails part would've used this part, but the project isn't being pursued, so the Rails part didn't get finished.If you have any problems, please pass them on and I'll try to get them fixed in a timely manner. I do have a newer version of the driver with more code to support ActiveRecord/Rails requests, but I wanted to release the minimal version for now. When I have time I'll try to get the AR code support into the next release.This is my first Hypersonic project, so the code hasn't been tested beyond the bundled tests and examples. Feel free to offer improvements. :)http://rubyforge.org/projects/hypersonic/I'll paste the readme at the end of this message.btw, the downloadable gem wont' be available for an hour or two due to the project's infrastructure.Jaredhttp://jaredrichardson.net----------------------------------------README.TXT--------------------------------------This is a driver (or bridge) to allow your Ruby code to use the Hypersonic database.There are two things you need to do before you can use this driver.First, you must have the Yet Another Java Bridge installed. http://www.cmt.phys.kyushu-u.ac.jp/~M.Sakurai/cgi-bin/fw/wiki.cgi?page=YAJBSecond, you must have hsqldb.jar in your classpath.If you can run "rake test", then you're environment is probably fine. Just be sure that the user account you'll be running the driver under also has their classpath set up properly.To build and install, type "rake gem", then "gem install hypersonic-1.0.gem" or "sudo gem install hypersonic-1.0.gem". You may need to insert a newer version number than 1.0You can extract examples from the test folder. The Test_hypersonic.rb file will show you exactly how to use the driver, but here's a short example as well. It's extracted from the test folder.@temp_table_name = "TEMP_TABLE_FOR_THESE_TESTS"@h = Hypersonic.new@h.connect("jdbc:hsqldb:file:testdb2", "sa", "")@h.execute_update("DROP TABLE #{@temp_table_name} IF EXISTS")@h.execute_update("CREATE TABLE #{@temp_table_name} (c1 INTEGER, c2 VARCHAR)")@h.execute_update("INSERT INTO #{@temp_table_name}(c1, c2) VALUES (32, 'howdy')")rs = @h.execute_query("SELECT * FROM #{@temp_table_name}")rs = @h.execute_query("SELECT COUNT(*) FROM #{@temp_table_name}")Please let me know if you have problems running the driver.Jaredhttp://jaredrichardson.net-------------------------------------------------------------------------Take Surveys. Earn Cash. Influence the Future of ITJoin SourceForge.net's Techsay panel and you'll get the chance to share youropinions on IT & business topics through brief surveys -- and earn cashhttp://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV_______________________________________________Hsqldb-user mailing listHsqldb-user@xxxxxxxxxxxxxxxxxxxxxhttps://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642_______________________________________________ Hsqldb-user mailing list Hsqldb-user@xxxxxxxxxxxxxxxxxxxxx https://lists.sourceforge.net/lists/listinfo/hsqldb-user
blog comments powered by Disqus

Home | News | Sitemap | FAQ | advertise | OSDir is an Inevitable website. GBiz is too!