Thanks for your answer. I changed my standardjbosscmp-jdbc.xml as follows:
<defaults> | <datasource>java:/MSSQLDS</datasource> | <!-- optional since 4.0 <datasource-mapping>Hypersonic SQL</datasource-mapping> --> | | <create-table>true</create-table> | <remove-table>false</remove-table> | <read-only>false</read-only> | <read-time-out>300000</read-time-out> | <row-locking>false</row-locking> | <pk-constraint>true</pk-constraint> | <fk-constraint>true</fk-constraint> | <preferred-relation-mapping>foreign-key</preferred-relation-mapping> | <read-ahead> | <strategy>on-load</strategy> | <page-size>1000</page-size> | <eager-load-group>*</eager-load-group> | </read-ahead> | <list-cache-max>1000</list-cache-max> | <clean-read-ahead-on-load>false</clean-read-ahead-on-load> | | <unknown-pk> | <key-generator-factory>UUIDKeyGeneratorFactory</key-generator-factory> | <unknown-pk-class>java.lang.Integer</unknown-pk-class> | <jdbc-type>INTEGER</jdbc-type> | <sql-type>INTEGER</sql-type> | </unknown-pk> | | <entity-command name="mssql-fetch-key" class="org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCSQLServerCreateCommand"/> | <ql-compiler>org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler</ql-compiler> | </defaults> I still get the same error. Any ideas? Or if somebody has working code, it would be very helpful. Thanks Joe View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3854866#3854866 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3854866 ------------------------------------------------------- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
