SharpHSQL

New Post: How to connect to an existing database

JeanDanielGasser — Wed, 26 Nov 2008 17:12:52 GMT

Hello andresv,
thank you for your answer. In fact the database was not created by SharpHSQL, it was created by an application written in Java. I think this the reason because SharpHSQL can not open the database.

I found a workaround by using a commercial JDBC-ODBC Bridge.

But let me know if you think that SharpHSQL is able to open a database created with another application.

Greetings

J-D

New Post: How to connect to an existing database

andresv — Wed, 26 Nov 2008 16:57:46 GMT

By default newly created tables are persisted to disk only when a CHECKPOINT operation occurs.
if you are using the low level SharpHSql classes (Database) make sure you execute a CHECKPOINT command before your application finish.
I'm running the "ProviderTest" project and everything seems to be working as expected.
Let me know if you have any other problem.
Andrés.

New Post: How to connect to an existing database

JeanDanielGasser — Mon, 18 Aug 2008 09:13:13 GMT

Hello,
first of all thank you for your excellent work !

I want to connect to an existing database and mody it with my C# application. I can connect to the database, but I can't access the tables. Each time I try a SELECT command it returns me the S0002 : Table not found. I'm sure that the table exists. I tried to execute the "SHOW TABLES" command but the Result object contains only one element "TABLE" in its Names collection.

Can anybody help me ?

Source code checked in

andresv — Mon, 07 Apr 2008 14:59:56 GMT

Added Log4net dependency.

CLOSED TASK: Initial Source code migration

andresv — Mon, 07 Apr 2008 14:53:01 GMT

Initial source code upload for version 1.0.3.3

Source code checked in

andresv — Mon, 07 Apr 2008 14:52:59 GMT

Initial source code migration for v1.0.3.3

CREATED TASK: Initial Source code migration

andresv — Mon, 07 Apr 2008 14:52:16 GMT

Initial source code upload for version 1.0.3.3

NEW POST: Two Questions

andresv — Mon, 07 Apr 2008 13:38:31 GMT

I mean the second option: when those bugs are fixed, using just a memory DB in silverlight would require almost no changes to implement.

NEW POST: Two Questions

Dewey — Sun, 06 Apr 2008 08:21:25 GMT

Just for clarification, are you saying that the two problems described don't exist if the database is in memory, or just that once fixed, THEN memory databases would work fine in Silverlight?

andresv wrote:
Thanks for your time.

There are two major bugs right now, one related to the automatic checkpoint process and the other related to data corruption after inserting a number of rows.
I guess there might be other bugs, but these are show-stoppers. I don't know if I have some more detail on those bugs, I will try to find the old emails and threads from GotDotNet.
Regarding the use of SharpHSQL inside a Silverlight application, I don't see any problems for just memory databases. For disk based databases we need to make some changes to support isolated storage, I think.

Best regards,
Andrés.

Dewey wrote:
First let me say that I have used HSQL since the java days, and appreciate someone taking up the challenge to move the C# version forward. Having said that, I have 2 questions.

1. You mentioned important bugs, with a warning. If there are known major bugs, where are they documented?

2. Have you considered making a version for Microsoft's SilverLight? This would be a sweet addition to that great platform.

NEW POST: Two Questions

andresv — Sat, 05 Apr 2008 20:44:43 GMT

Thanks for your time.

There are two major bugs right now, one related to the automatic checkpoint process and the other related to data corruption after inserting a number of rows.
I guess there might be other bugs, but these are show-stoppers. I don't know if I have some more detail on those bugs, I will try to find the old emails and threads from GotDotNet.
Regarding the use of SharpHSQL inside a Silverlight application, I don't see any problems for just memory databases. For disk based databases we need to make some changes to support isolated storage, I think.

Best regards,
Andrés.

NEW POST: Two Questions

Dewey — Fri, 04 Apr 2008 19:31:54 GMT

First let me say that I have used HSQL since the java days, and appreciate someone taking up the challenge to move the C# version forward. Having said that, I have 2 questions.

1. You mentioned important bugs, with a warning. If there are known major bugs, where are they documented?

2. Have you considered making a version for Microsoft's SilverLight? This would be a sweet addition to that great platform.

UPDATED RELEASE: SharpHSQL v1.0.3.3 (dic 04, 2005)

Fri, 04 Apr 2008 15:11:17 GMT

! Release Date: 4/12/2005
Sources for VS.NET 2002 and binaries compiled for .NET 1.1 & Compact Framework.

! WARNING
This version is not ready for production grade applications. More testing is needed and some important bugs has to be fixed before that. You are warned.

UPDATED WIKI: Home

andresv — Fri, 04 Apr 2008 14:12:08 GMT

UPDATED WIKI: Home

andresv — Fri, 04 Apr 2008 14:11:26 GMT

Project Description
Small & embebdded database engine witten in C#. It is a port of the Hypersonic SQL v1.4 (HSQL) Java project and a continuation of the initial work done by Mark Tutt (http://www.codeproject.com/KB/database/sharphsql.aspx)

**Delete the following note before publishing **

This project is currently in setup mode and only available to project coordinators and developers. Once you have finished setting up your project you can publish it to make it available to all CodePlex visitors.

There are three requirements before you publish:

- Edit this page to provide information about your project
- Upload the initial source code for your project
- Add your project license

Additional information on starting a new project is available here: Project Startup Guide.