Matthew Schleindl
2004-08-19 19:13:09 UTC
Hi -
Looks like I can run the basic hsqldb stuff, as
indicated in the 'Getting Started' section 'Create
tables' ("7 of 7 SQL statements executed
successfully").
Now for my stuff...
I've got an Oracle DB with 5000+ tables, so I'm
warming up on MS Sequel Server 2000's 'Northwind'
sample running locally (I am able to connect to it via
JDBC).
When I modify the corresponding mssql.xml and try the
same thing, I get:
Class Not Found: JDBC driver
com.microsoft.jdbc.sqlserver.SQLServerDriver could not
be loaded
My mssql.xml looks like this:
<property name="database.script.file"
value=""/>
<property name="database.driver.file"
value="${lib.dir}/mssqlserver.zip"/>
<property name="database.driver"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<property name="database.url"
value="jdbc:Microsoft:sqlserver://mfsmobile:1433;DatabaseName=Northwind"/>
<property name="database.userid"
value="sa"/>
<property name="database.password"
value="password"/>
<property name="database.schema"
value=""/>
<property name="database.catalog"
value=""/>
<!--poperty name="jboss.datasource.mapping"
value="MS SQLSERVER"/-->
<property name="jboss.datasource.mapping"
value="MS SQLSERVER2000"/>
Any ideas?
Thanks in advance...
Looks like I can run the basic hsqldb stuff, as
indicated in the 'Getting Started' section 'Create
tables' ("7 of 7 SQL statements executed
successfully").
Now for my stuff...
I've got an Oracle DB with 5000+ tables, so I'm
warming up on MS Sequel Server 2000's 'Northwind'
sample running locally (I am able to connect to it via
JDBC).
When I modify the corresponding mssql.xml and try the
same thing, I get:
Class Not Found: JDBC driver
com.microsoft.jdbc.sqlserver.SQLServerDriver could not
be loaded
My mssql.xml looks like this:
<property name="database.script.file"
value=""/>
<property name="database.driver.file"
value="${lib.dir}/mssqlserver.zip"/>
<property name="database.driver"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<property name="database.url"
value="jdbc:Microsoft:sqlserver://mfsmobile:1433;DatabaseName=Northwind"/>
<property name="database.userid"
value="sa"/>
<property name="database.password"
value="password"/>
<property name="database.schema"
value=""/>
<property name="database.catalog"
value=""/>
<!--poperty name="jboss.datasource.mapping"
value="MS SQLSERVER"/-->
<property name="jboss.datasource.mapping"
value="MS SQLSERVER2000"/>
Any ideas?
Thanks in advance...