When I start my ofbiz 4.0 instance, I am receiving the following errors:
2009-04-25 18:43:57,071 (main) [ DatabaseUtil.java:299:ERROR] WARNING:
Column [ACCTG_TRANS_ID] of table [dbo.ACCTG_TRANS] of entity [AcctgTrans] IS
NOT a primary key in the database, but IS a primary key in the entity
definition. The primary key for this table needs to be re-created or
modified to add this column to the primary key. Note that data may need to
be added first as a primary key column cannot have an null values.
2009-04-25 18:43:57,072 (main) [ DatabaseUtil.java:299:ERROR] WARNING:
Column [ACCTG_TRANS_ID] of table [dbo.ACCTG_TRANS_ATTRIBUTE] of entity
[AcctgTransAttribute] IS NOT a primary key in the database, but IS a primary
key in the entity definition. The primary key for this table needs to be
re-created or modified to add this column to the primary key. Note that data
may need to be added first as a primary key column cannot have an null
values.
I have installed and configured MSSQL as per the notes in entityengine.xml
<datasource name="localmssql"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
schema-name="dbo"
field-type-name="mssql"
check-on-start="true"
add-missing-on-start="true"
join-style="ansi"
alias-view-columns="false"
use-fk-initially-deferred="false">
<read-data reader-name="seed"/>
<read-data reader-name="demo"/>
<read-data reader-name="ext"/>
<inline-jdbc
jdbc-driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc-uri="jdbc:sqlserver://192.168.69.5:1433;databaseName=MyDB;SelectMethod=cursor;"
jdbc-username="X"
jdbc-password="X"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="20"/>
</datasource>
Everything appears to be working ok, despite the warnings.
Any ideas?
Many thanks,
Chris
--
View this message in context:
http://www.nabble.com/MS-SQL-%3E-WARNING%3A-Column--ACCTG_TRANS_ID--of-table--dbo.ACCTG_TRANS--of-entity--AcctgTrans--IS-NOT-a-primary-key-...-tp23234651p23234651.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
