[Middlegen-user] MS Acess and Middlegen...

[Fernand Galiana]

Hello all,

Has anyone here successfully connected Middlegen to an MS Access database.
I've tried the JDBC-ODBC Bridge but I am getting the following error
when Middlegen queries for the schema

If you have had success on this task, could you send out the MS-Access driver you are using ?

Thanks,
Fernand

[middlegen] (middlegen.MiddlegenPopulator 269 ) [HYC00][Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
[middlegen] java.sql.SQLException: [HYC00][Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
[middlegen] at ids.sql.IDSSocket.error(IDSSocket.java:374)
[middlegen] at ids.sql.IDSSocket.verify(IDSSocket.java:320)
[middlegen] at ids.sql.IDSDBMetaData.metaQuery(IDSDBMetaData.java:133)
[middlegen] at ids.sql.IDSDBMetaData.getTables(IDSDBMetaData.java:1536)
[middlegen] at middlegen.MiddlegenPopulator.addTables(MiddlegenPopulator.java:904)
[middlegen] at middlegen.MiddlegenPopulator.populate(MiddlegenPopulator.java:244)
[middlegen] at middlegen.MiddlegenTask.execute(MiddlegenTask.java:403)
[middlegen] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:193)
[middlegen] at org.apache.tools.ant.Task.perform(Task.java:341)
[middlegen] at org.apache.tools.ant.Target.execute(Target.java:309)
[middlegen] at org.apache.tools.ant.Target.performTasks(Target.java:336)
[middlegen] at org.apache.tools.ant.Project.executeTarget(Project.java:1339)
[middlegen] at org.apache.tools.ant.Project.executeTargets(Project.java:1255)
[middlegen] at org.apache.tools.ant.Main.runBuild(Main.java:609)
[middlegen] at org.apache.tools.ant.Main.start(Main.java:196)
[middlegen] at org.apache.tools.ant.Main.main(Main.java:235)

[gdilem\@libero\.it]

Unlikely it does not exists a free ms-access driver usefull for middlegen that implents those features....u should use hslqdb driver.....using middlegen ,generating your code....and after all remapping all your stuff to MSAccess datasource...
I've done like that
Hope this help ; )


---------- Initial Header -----------