Hi!
I'm experiencing a problem when I try to create a table linked to MS
SQL server. I've got an exception "Common language runtime (CLR)
execution is not supported under lightweight pooling. Disable one of
two options: "clr enabled" or "lightweight pooling"" But CLR execution
is disabled on my server ("clr enabled" set to 0).
Can anyone tell me what I'm doing wrong and how to get around of this
problem?
Code that causes a problem:
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Class.forName("org.h2.Driver");
Connection h2 = DriverManager.getConnection("jdbc:h2:mem:ms");
Statement h2Statement = h2.createStatement();
// exception pops up here
h2Statement.execute("CREATE LINKED TABLE
foo('com.microsoft.sqlserver.jdbc.SQLServerDriver', " +
"'jdbc:sqlserver://127.0.0.1;databaseName=mybase', " +
"'user', 'password', 'foo')");
ResultSet result = h2Statement.executeQuery("select * from foo");
h2.close();
Exception raised in method TableLink.readMetaData(), if it might help.
Thanks in advance for any help and suggestions.
Best regards,
Max
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
