Have you looked at the database to see if those columns really are not
part of the primary key? Sometimes there are JDBC driver quirks for
checking things like primary keys, so the best thing to do is look in
the database itself to verify.
-David
On Apr 25, 2009, at 11:51 AM, snowch wrote:
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.
