Re:MS Acess and Middlegen...

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 -----------

From      : [email protected]
To          : [email protected]
Cc          : 
Date      : Thu, 16 Sep 2004 12:24:43 -0600
Subject : [Middlegen-user] MS Acess and Middlegen...

> 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)
> 
>     



-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php