From OpenBase To MSSQLServer2000 (EOModeller)
From OpenBase To MSSQLServer2000 (EOModeller)
- Subject: From OpenBase To MSSQLServer2000 (EOModeller)
- From: "Jonathan Fleming" <email@hidden>
- Date: Fri, 30 May 2003 18:02:28 +0100
Sorry guys I'm looking for a quick fix here as I don't know SQL that well
and I've just changed datasources from OpenBase to MSSQLServer2000 (yet to
be learned), but I have no time left to read tons of docs as I have to get
this app deployed.
Can anyone tell me how I would go about converting this derived attribute in
EOModel that I did use and had worked with OpenBase to now work with
MSSQLServer2000 ( I have several of these in various tables that are
scripted the same).
Name: countOfPicsForJob
Derived: (SELECT COUNT(*) FROM TB_JOB_PICTURE WHERE
TB_JOB_PICTURE.TB_JOB_ID = TB_JOB.TB_JOB_ID)
External Type: int
Internal Data Type: Integer
The problem happens when I attempt to view the data in EOModeller by using
the data browser under menu Tools>DataBrowser... Everything in my EOModel
works when the derived attribute is taken out and i'm able to see all data
OK, when the derived attributes are left in I get this error message:
JDBCAdaptorException: EvaluateExpression failed:
<MicrosoftPlugIn$MicrosoftExpression: "SELECT (SELECT COUNT(*) FROM
TB_JOB_PICTURE WHERE TB_JOB_PICTURE.TB_JOB_ID = TB_JOB.TB_JOB_ID),
t0.DATA_DIR_JOB, t0.JOB_REF_NO, t0.LOCATION, t0.TB_CLIENT_ID, t0.TB_JOB_ID,
t0.TEXT_ABOUT_JOB FROM TB_JOB t0">:
Next exception:SQL State:HY000 -- error code: 107 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The column prefix
'TB_JOB' does not match with a table name or alias name used in the query.
Next exception:SQL State:HY000 -- error code: 16945 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The cursor was not
declared.
Next exception:SQL Warning: -- error code: 0 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC]Database changed to JandM
Next exception:SQL Warning: -- error code: 0 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed database
context to 'JandM'.
Next exception:SQL Warning: -- error code: 0 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC]Language changed to us_english
Next exception:SQL Warning: -- error code: 0 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed language
setting to us_english.
Stack Trace:
JDBCAdaptorException: EvaluateExpression failed:
<MicrosoftPlugIn$MicrosoftExpression: "SELECT (SELECT COUNT(*) FROM
TB_JOB_PICTURE WHERE TB_JOB_PICTURE.TB_JOB_ID = TB_JOB.TB_JOB_ID),
t0.DATA_DIR_JOB, t0.JOB_REF_NO, t0.LOCATION, t0.TB_CLIENT_ID, t0.TB_JOB_ID,
t0.TEXT_ABOUT_JOB FROM TB_JOB t0">:
Next exception:SQL State:HY000 -- error code: 107 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The column prefix
'TB_JOB' does not match with a table name or alias name used in the query.
Next exception:SQL State:HY000 -- error code: 16945 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The cursor was not
declared.
Next exception:SQL Warning: -- error code: 0 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC]Database changed to JandM
Next exception:SQL Warning: -- error code: 0 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed database
context to 'JandM'.
Next exception:SQL Warning: -- error code: 0 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC]Language changed to us_english
Next exception:SQL Warning: -- error code: 0 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed language
setting to us_english.
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.lang.RuntimeException.<init>(Compiled Code)
at com.apple.yellow.foundation.NSException.<init>(NSException.java:34)
at JDBCAdaptorException.<init>(JDBCAdaptorException.java:21)
at JDBCContext._jdbcErrorWithChannel(Compiled Code)
at JDBCChannel._evaluateExpression(Compiled Code)
at JDBCChannel.evaluateExpression(Compiled Code)
at JDBCChannel.selectAttributes(JDBCChannel.java:185)
Any Ideas? Anyone know how derived attributes are impemented in
MSSQLServer2000?
Jonathan ;^)
_________________________________________________________________
Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.