Community discussion forum

Read HSQLDB data into a webpage

• • Reply

  1 year ago

  by ukmedia

  Richard Thatcher

  London, England, United Kingdom

  Joined 5 years ago

  Does anyone know if you can read a HSQLDB (java database) in asp or .net. I need to pull some data from a database and show it on a web page.

   Or even if there is a tool to get the data out and dump it into a SQL table or something.

   Cheers

  Report abuse
• • Reply

  1 year ago

  by joe90

  J Alan

  , United Kingdom

  Joined 4 years ago

  I have not (personally) heard of a .net "driver" that allows you to connect directly to a java database.. probably due to never having had the opportunity to do so.

  However, this may help: http://vikashazrati.wordpress.com/2007/07/30/dbunit-extracting-test-data-into-xml-file/

  ... extract to xml; then read xml file into asp internal datasource or directly into sql server and go from there. Xml then becoming the transition stage allowing you to extract from one system to another ... in the 'same' manner as web services allow disparate systems to communicate through a common medium.

  To be clear though - I have not done this, so am only guessing that it should work - I would be interested to find out how you go though.

  Joe 

  Report abuse
• • Reply

  1 year ago

  by ukmedia

  Richard Thatcher

  London, England, United Kingdom

  Joined 5 years ago

  Cheers for the reply I was looking through that and tbh I have no clue of JAVA at all!!

   An idea that did come to mind would be an JDBC-ODBC Bridge driver for windows but looking on the web I cannot find any free ones.

  Report abuse
• • Reply

  1 year ago

  by joe90

  J Alan

  , United Kingdom

  Joined 4 years ago

  My apologies - I automatically assumed that you knew Java - since that's where you're trying to extract data from.

  The JDBC-ODBC Bridge idea is not a bad one to go with .. but I''m guessing you'd prefer freeware

  How about posting a "how do I" in the Java area for extraction to xml file? Once you have the xml file, getting it into either asp.net or sql server is really quite easy.

  Unfortunately I'm not java-savy .. so am not really able to assist you in the first stage of this. 

  Joe 

  Report abuse