-
1. Re: Configure to MS SQL Server 6.5
thudacko Jul 30, 2003 9:39 PM (in response to rfeenstr)You wrote:
>>Of course, -????- is just for this post. I've tried
several different values (MSSQL, MS SQLServer, etc.), to no avail. The O'Reilly example just puts "Oracle8" there, without explaining why (simple example).
Coincidentally, I also am trying the same workbook example with MS SQL Server and had/have the same problem.
I can only provide part of the answer. The string "Oracle8" as the datasource-mapping provided by the example you cited should refer to valid type-mapping by that same name that defines the jdbc/Java/Oracle native types mapping. Unfortunately, we are not given the named Oracle8 type-mapping (or I simply cannot find it). This should be defined in the jboss-3.2.1/server/default/conf/standardjbosscmp-jdbc.xml file. If you examine this file, you will see that there is a type-mapping named "Hypersonic SQL" further down in the file. There should be a similar mapping for Oracle8 in order for the example to work (using Oracle). Same goes for what other db you may decide to use, such as MSSQLDS
Alternatively, it seems possible that the dataset-mapping could be defined in the example's src/resources/META-INF/jboss-jdbc.xml file, but I am not certain of this.
Does anyone know of a library of valid type-mappings anyone is sharing? Otherwise, this will be trial and error to obtain a type-mapping that works.
See p. 625-630 of the JBossBook_321.pdf (the $10 purchase) for more info. -
2. Re: Configure to MS SQL Server 6.5
thudacko Jul 30, 2003 10:06 PM (in response to rfeenstr)Here's the rest of the answer:
Read further to page 627, section on "Datasource Configuration":
"JBossCMP includes predefined type-mappings for many databases including:... MS SQLSERVER, MS SQLSERVER 2000, ..."
There you have it. Pick the one appropriate to the version of the db you are running.