RE: MSAccess
RE: MSAccess
- Subject: RE: MSAccess
- From: "Kieran Kelleher" <email@hidden>
- Date: Fri, 9 May 2003 15:03:32 -0400
Romeo, I would strongly advise you not to use MS Access even if you get it
working for the following reasons
1) "The version of SQL created by Microsoft is called Jet SQL and it is the
database engine behind Microsoft's Access.
Jet SQL has certain limitations compared to the other versions of SQL. In
general, Jet SQL is not designed to manage a database, but rather, it is
used to retrieve information from a database"
-- http://www.devguru.com/Technologies/jetsql/quickref/jet_sql_intro.html
2) It is not a supported configuration for WebObjects:
http://docs.info.apple.com/article.html?artnum=72598
I recommend you try MySQL which is FREE (www.mysql.com), move your Access
tables to MySQL and then use WebObjects for Web-based applications to the
data and you can still link to the MySQL tables from directly within MS
Access for internal legacy Access applications using the MyODBC connector,
also FREE at www.mysql.com
-----Original Message-----
From: email@hidden
[mailto:email@hidden]On Behalf Of Romeo Mariani
Sent: Friday, May 09, 2003 10:25 AM
To: email@hidden
Subject: MSAccess
What about MSAccess and WO5.2?
NT 2000 sp3, MSAccess 2000. ODBC bridge.
We can fetch data into EOModeler but an error is returned when we try
to do it from the application.
This is part of the NSLog aoutput:
=========================
[2003-05-07 09:35:58 CEST] <WorkerThread0> Using JDBCPlugIn
'com.webobjects.jdbcadaptor.OdbcPlugIn' for JDBCAdaptor@5965234
[2003-05-07 09:35:58 CEST] <WorkerThread0> connecting with dictionary:
{plugin = ""; username = ""; driver = "sun.jdbc.odbc.JdbcOdbcDriver";
password = "<password deleted for log>"; URL = "jdbc:odbc:Documenti"; }
[2003-05-07 09:35:58 CEST] <WorkerThread0> === Begin Internal
Transaction
[2003-05-07 09:35:58 CEST] <WorkerThread0> evaluateExpression:
<com.webobjects.jdbcadaptor.JDBCExpression: "SELECT t0.Descrizione,
t0.IDPadre, t0.IDSezione, t0.News, t0.NomeComponent, t0.Posizione FROM
Sezioni t0 WHERE t0.IDPadre is NULL ORDER BY t0.Posizione ASC">
[2003-05-07 09:35:58 CEST] <WorkerThread0> 7 row(s) processed
[2003-05-07 09:35:58 CEST] <WorkerThread0> === Commit Internal
Transaction
[2003-05-07 09:35:58 CEST] <WorkerThread0> connection disconnected.
[2003-05-07 09:35:58 CEST] <WorkerThread0> connecting with dictionary:
{plugin = ""; username = ""; driver = "sun.jdbc.odbc.JdbcOdbcDriver";
password = "<password deleted for log>"; URL = "jdbc:odbc:Documenti"; }
[2003-05-07 09:35:58 CEST] <WorkerThread0> === Begin Internal
Transaction
[2003-05-07 09:35:58 CEST] <WorkerThread0> evaluateExpression:
<com.webobjects.jdbcadaptor.JDBCExpression: "SELECT t0.Descrizione,
t0.IDPadre, t0.IDSezione, t0.News, t0.NomeComponent, t0.Posizione FROM
Sezioni t0 WHERE t0.IDPadre is NULL ORDER BY t0.Posizione ASC">
[2003-05-07 09:35:58 CEST] <WorkerThread0> 7 row(s) processed
[2003-05-07 09:35:58 CEST] <WorkerThread0> === Commit Internal
Transaction
[2003-05-07 09:35:58 CEST] <WorkerThread0>
<com.webobjects.appserver.WODirectAction>: Exception in
performActionNamed() on the action "default" with the message:
com.webobjects.jdbcadaptor.JDBCAdaptorException: Unable to close
ResultSet after completing fetch:
Next exception:SQL State:null -- error code: 0 -- msg: ResultSet is
closed
[2003-05-07 09:35:58 CEST] <WorkerThread0>
com.webobjects.jdbcadaptor.JDBCAdaptorException: Unable to close
ResultSet after completing fetch:
Next exception:SQL State:null -- error code: 0 -- msg: ResultSet is
closed
=========================
Thank's in advance
Romeo
_______________________________________________
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.
_______________________________________________
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.
| References: | |
| | >MSAccess (From: Romeo Mariani <email@hidden>) |