Eclipse JPA tools fails to load schema metadata for SQL Server -
i trying use jpa sql server. eclipse has great tools map entities database , vice-versa. work, need associate connection jpa project.
so created database (named "rowcount") , table on database. when go eclipse, open jpa perspective, log in database (datasource explorer / database connections), cannot see schema associated particular database.
looking in "error log" view of eclipse, i've got following error everytime click on "schemas" tree-view item on eclipse:
eclipse.buildid=m20130204-1200 java.version=1.7.0_15 java.vendor=oracle corporation bootloader constants: os=win32, arch=x86_64, ws=win32, nl=pt_br framework arguments: -product org.eclipse.epp.package.jee.product command-line arguments: -os win32 -ws win32 -arch x86_64 -product org.eclipse.epp.package.jee.product error tue may 21 10:34:42 brt 2013 com.microsoft.sqlserver.jdbc.sqlserverexception com.microsoft.sqlserver.jdbc.sqlserverexception: incorrect syntax near keyword 'rowcount'. @ com.microsoft.sqlserver.jdbc.sqlserverexception.makefromdatabaseerror(sqlserverexception.java:216) @ com.microsoft.sqlserver.jdbc.sqlserverstatement.getnextresult(sqlserverstatement.java:1515) @ com.microsoft.sqlserver.jdbc.sqlserverstatement.doexecutestatement(sqlserverstatement.java:792) @ com.microsoft.sqlserver.jdbc.sqlserverstatement$stmtexeccmd.doexecute(sqlserverstatement.java:689) @ com.microsoft.sqlserver.jdbc.tdscommand.execute(iobuffer.java:5696) @ com.microsoft.sqlserver.jdbc.sqlserverconnection.executecommand(sqlserverconnection.java:1715) @ com.microsoft.sqlserver.jdbc.sqlserverstatement.executecommand(sqlserverstatement.java:180) @ com.microsoft.sqlserver.jdbc.sqlserverstatement.executestatement(sqlserverstatement.java:155) @ com.microsoft.sqlserver.jdbc.sqlserverstatement.executequery(sqlserverstatement.java:616) @ org.eclipse.datatools.connectivity.sqm.internal.core.connection.statementadapter.executequery(statementadapter.java:73) @ org.eclipse.datatools.enablement.msft.internal.sqlserver.loaders.sql2005schemaloader.createresultset(sql2005schemaloader.java:53) @ org.eclipse.datatools.connectivity.sqm.loader.jdbcschemaloader.loadschemas(jdbcschemaloader.java:111) @ org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.jdbccatalog.loadschemas(jdbccatalog.java:101) @ org.eclipse.datatools.connectivity.sqm.core.rte.jdbc.jdbccatalog.getschemas(jdbccatalog.java:64) @ org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.vnode.serverexplorervnodecontentprovidernav.displayschemanodechildren(serverexplorervnodecontentprovidernav.java:126) @ org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.abstractondemandcontentprovidernav.getchildren(abstractondemandcontentprovidernav.java:169) @ org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.abstractondemandcontentprovidernav.getchildren(abstractondemandcontentprovidernav.java:243) @ org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.layout.abstractlayoutprovidernav.getchildren(abstractlayoutprovidernav.java:85) @ org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.providers.content.impl.serverexplorercontentprovidernav.load(serverexplorercontentprovidernav.java:153) @ org.eclipse.datatools.connectivity.sqm.server.internal.ui.explorer.loading.loadingjob.run(loadingjob.java:43) @ org.eclipse.core.internal.jobs.worker.run(worker.java:53)
i using latest sqljdbc4.jar , "microsoft sql server 2008 jdbc driver" in jpa driver properties.
this error prevents me deploy application in ear file. if manage deploy manually on weblogic, application fails following reason:
openjpa-1.1.1-snapshot-r422266:957329 nonfatal user error> org.apache.openjpa.persistence.argumentexception: error occurred while parsing query filter "select n note n". error message: name "note" not recognized entity or identifier. known entity names: []
oddly, "master" database shows of objects , schemas. there workaround in sql server, in jdbc driver or eclipse this?
shame on me. problem caused because database name reserved word sql server. after renamed it, worked fine.
see comments above, on question.
my sincere apologies stumbled here while being stressed real problems.
Comments
Post a Comment