issue 4
(Table TEST not found) commented on by pranesh.sharma
- I don't know how to update the issue but it is solved at myend. I was doing mistakes
due to which I wasn't able to run the example.
Thanks again
I don't know how to update the issue but it is solved at myend. I was doing mistakes
due to which I wasn't able to run the example.
Thanks again
Nov 02, 2009
issue 4
(Table TEST not found) commented on by pranesh.sharma
- I am sorry that that this issue which I am facing appeared as defect. Thanks to
Google who always open new issues as defect.
I am sorry that that this issue which I am facing appeared as defect. Thanks to
Google who always open new issues as defect.
Nov 02, 2009
issue 4
(Table TEST not found) reported by pranesh.sharma
-
I created a small console project in C# and used the same code which you
gave in your example. Before that I created table TEST in default database
test (connection url is jdbc:h2:~/test) using H2 console and disconnected
this session.
the main function of my program is below which, on execution, throws a
exception that table TEST not found.
static void Main(string[] args)
{
using (H2Connection connection = new H2Connection
("jdbc:h2:~/test;", "sa", ""))
{
connection.Open();
using (H2Command command = connection.CreateCommand())
{
command.CommandText = "Select * from TEST";
H2DataReader reader = command.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader["NAME"]);
}
reader.Close();
}
}
}
I am not whether it is due to H2Sharp or H2 database itself has some issue.
I create a table using the following SQL statements.
CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255));
INSERT INTO TEST VALUES(1, 'Hello');
INSERT INTO TEST VALUES(2, 'World');
Thanks
I created a small console project in C# and used the same code which you
gave in your example. Before that I created table TEST in default database
test (connection url is jdbc:h2:~/test) using H2 console and disconnected
this session.
the main function of my program is below which, on execution, throws a
exception that table TEST not found.
static void Main(string[] args)
{
using (H2Connection connection = new H2Connection
("jdbc:h2:~/test;", "sa", ""))
{
connection.Open();
using (H2Command command = connection.CreateCommand())
{
command.CommandText = "Select * from TEST";
H2DataReader reader = command.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader["NAME"]);
}
reader.Close();
}
}
}
I am not whether it is due to H2Sharp or H2 database itself has some issue.
I create a table using the following SQL statements.
CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255));
INSERT INTO TEST VALUES(1, 'Hello');
INSERT INTO TEST VALUES(2, 'World');
Thanks
issue 3
(Problem try to open a connection) reported by kkl.inferences
- What steps will reproduce the problem?
1. recompile H2 jar file "h2-1.2.121.jar" with ikvm-0.42.0.0
2. recompile H2Sharp with ikvm.openjdk.Text.dll, ikvm.openjdk.Util.dll,
ikvm.openjdk.Jdbc.dll, ikvm.openjdk.Core.dll, ikvm.Runtime.dll, h2-
1.2.121.dll previously generated
3. create a small test prog with H2Sharp.dll
4. Try to establish a connection to a H2 database
What is the expected output? What do you see instead?
I expect a successful connection but I get the following exception:
"Impossible to cast System.IO.FileNotFoundException to
Java.lang.Exception".
Peraps a problem in IKVM??
What version of the product are you using? On what operating system?
The ikvm-0.42.0.0 version, and latest H2 (h2-1.2.121)
Please provide any additional information below.
You could find a screenshoot in attachment
What steps will reproduce the problem?
1. recompile H2 jar file "h2-1.2.121.jar" with ikvm-0.42.0.0
2. recompile H2Sharp with ikvm.openjdk.Text.dll, ikvm.openjdk.Util.dll,
ikvm.openjdk.Jdbc.dll, ikvm.openjdk.Core.dll, ikvm.Runtime.dll, h2-
1.2.121.dll previously generated
3. create a small test prog with H2Sharp.dll
4. Try to establish a connection to a H2 database
What is the expected output? What do you see instead?
I expect a successful connection but I get the following exception:
"Impossible to cast System.IO.FileNotFoundException to
Java.lang.Exception".
Peraps a problem in IKVM??
What version of the product are you using? On what operating system?
The ikvm-0.42.0.0 version, and latest H2 (h2-1.2.121)
Please provide any additional information below.
You could find a screenshoot in attachment
Oct 14, 2009
issue 2
(Connection string not consistent with ADO.NET) commented on by kkl.inferences
- Hello Thomas,
Could give an example of the syntax to use when
we include user name and password into the connection
url string
Hello Thomas,
Could give an example of the syntax to use when
we include user name and password into the connection
url string
