Most likely you need to set your schema value in the db config file. That will fix the middlegen side however you have to remove the schema prefix from the DD before feeding to ejbdoclet. I used the ant <replace> task but if you have the latest cvs middlegen it apparently does not output the schema - or has a switch.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 6:43 PM To: [EMAIL PROTECTED] Subject: [Middlegen-user] can't find tables w/ MSSQL JDBC driver running airline sample Anyone see this msg before? I couldn't find it in the list archives. file:J:/MiddleGen/samples/build.xml:140: middlegen.MiddlegenException: Middlegen successfully connected to the database, but couldn't find any tables. Perhaps the specified schema or catalog is wrong? -Or maybe there aren't any tables in the database at all? My config: Ant 1.5.1 MiddleGen 2.0b1 JDK 1.4.1 MSSQL 2000 w/ latest JDBC driver I ran "ant create-tables" successfully and I can see the tables in the database. I also tried setting the schema to "dbo" since MSSQL seems present tables with that as a prefix sometimes. I'm running this in the MiddleGen samples directory. I can also run hsqldb-gui w/o problems, though the tree looks a little weird (the first item is really tall and it's blank). I suppose I could punt and use one of the supported database drivers, but the driver is listed on the MiddleGen web page as untested, so I thought I'd be nice and try using it :-) BTW, here's my mssqljdbc.xml file (goes in config\database). Feel free to add it to the distribution: =============== <property name="database.script.file" value="${src.dir}/sql/${name}-mssql.sql"/> <property name="database.driver.file" value="j:/win32app/mssql/java/lib/mssqlserver.jar"/> <property name="database.driver.classpath" value="j:/win32app/mssql/java/lib/mssqlserver.jar;j:/win32app/mssql/java /lib/msbase.jar;j:/win32app/mssql/java/lib/msutil.jar"/> <property name="database.driver" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/> <property name="database.url" value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=airline;Us er=Tester;Password=test"/> <property name="database.userid" value="Tester"/> <property name="database.password" value="test"/> <property name="database.schema" value=""/> <property name="database.catalog" value=""/> <property name="jboss.datasource.mapping" value="MSSQL"/> ========== thanks, ken ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ middlegen-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ middlegen-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user
