C:\Middlegen>ant Buildfile: build.xmlinit:fail-if-no-xdoclet-1.2:check-driver-present:panic-if-driver-not-present:middlegen: [echo] Class path = C:\Middlegen [middlegen] (middlegen.Middlegen 350 ) Registering plugin simple ->middlegen.Plugin [middlegen] (middlegen.Middlegen 350 ) Registering plugin java-> middlegen.javax.JavaPlugin [middlegen] (middlegen.Middlegen 350 ) Registering plugin plugin ->middlegen.Plugin [middlegen] (middlegen.Middlegen 350 ) Registering plugin hibern ate->middlegen.plugins.hibernate.HibernatePlugin [middlegen] Database URL:jdbc:oracle:thin:@localhost:1521:ora8 [middlegen] No <table> elements specified. Reading all tables. This might take a while...BUILD FAILED C:\Middlegen\build.xml:148: 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? Configured schema: Configured catalog: Available schemas: ADAMS AURORA$ORB$UNAUTHENTICATED BLAKE CLARK CTXSYS DBSNMP JONES MDSYS ORDPLUGINS ORDSYS OUTLN SCOTT SYS SYSTEM TEST TEST1 XIAN ZYYT Available catalogs: Total time: 6 seconds C:\Middlegen>显示如上,连用户都列出来了,就是提示找不到表
<property name="database.driver.file" value="${lib.dir}/classes12.jar"/>
<property name="database.driver.classpath" value="${database.driver.file}"/>
<property name="database.driver" value="oracle.jdbc.driver.OracleDriver"/>
<property name="database.url" value="jdbc:oracle:thin:@10.171.136.1:1521:gzgbs0"/>
<property name="database.userid" value="liwei"/>
<property name="database.password" value="love"/>
<property name="jboss.datasource.mapping" value="Oracle8"/>
C:\Middlegen>ant
Buildfile: build.xmlinit:fail-if-no-xdoclet-1.2:check-driver-present:panic-if-driver-not-present:middlegen:
[echo] Class path = C:\Middlegen
[middlegen] (middlegen.Middlegen 350 ) Registering plugin simple
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 350 ) Registering plugin java->
middlegen.javax.JavaPlugin
[middlegen] (middlegen.Middlegen 350 ) Registering plugin plugin
->middlegen.Plugin
[middlegen] (middlegen.Middlegen 350 ) Registering plugin hibern
ate->middlegen.plugins.hibernate.HibernatePlugin
[middlegen] Database URL:jdbc:oracle:thin:@localhost:1521:ora8
[middlegen] No <table> elements specified. Reading all tables. This might take a
while...BUILD FAILED
C:\Middlegen\build.xml:148: 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?
Configured schema:
Configured catalog:
Available schemas:
ADAMS
AURORA$ORB$UNAUTHENTICATED
BLAKE
CLARK
CTXSYS
DBSNMP
JONES
MDSYS
ORDPLUGINS
ORDSYS
OUTLN
SCOTT
SYS
SYSTEM
TEST
TEST1
XIAN
ZYYT
Available catalogs:
Total time: 6 seconds
C:\Middlegen>显示如上,连用户都列出来了,就是提示找不到表
如果数据库中没有设schema(如mssql),可以用其用户名代替
oracle我没试过,不过,我想会是这样的,你试试吧用schema也有好处,把没用的表不加进middle-gen中
catalog="${database.catalog}"
build.xml中以上两行不要删除。其他地方说以上两条需要删除,但经测试解决不了问题首先将mssqlserver.jar,msbase.jar,msutil.jar复制到Middlegen-Hibernate-r5\lib下
mssql.xml配置如下:
<property name="database.script.file" value=""/>
<property name="database.driver.file" value="${lib.dir}/mssqlserver.jar"/>
<property name="database.driver" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<property name="jdbc:microsoft:sqlserver://localhost:1433/>
<property name="database.userid" value="数据库用户名"/>
<property name="database.password" value="数据库密码"/>
<property name="database.schema" value="数据库所有者,一般为dbo"/>
<property name="database.catalog" value="数据库名"/>
<property name="jboss.datasource.mapping" value="MS SQLSERVER2000"/>
schema="${database.schema}"
catalog="${database.catalog}"删啦,其它的保留,你用Oracle,如果是scott用户下的表,这样配置:schema="scott,"就能找到scott下的表啦,如果是sys用户,改成sys就可以啦,
也就是说schema就是你要的用户.