Hi,
I have used sa account and able to capture the database shema.
But when I run my project it gives the following error:
[b]ADM1041:Sent the event to instance:[ResourceDeployEvent -- reference-added jdbc/commerc]
CORE5004: Resource Deployed: [jdbc:commerc].
disconnect
logout_successful
CORE5022: All ejb(s) of [commerc] were unloaded successfully!
ADM1064:The upload file at [C:\WINDOWS\Temp\s1astempdomain1server-943396518\commerc.ear] exists and will be overwritten.
ADM1006:Uploading the file to:[C:\WINDOWS\Temp\s1astempdomain1server-943396518\commerc.ear]
Deleted previous deployment directory: F:\Sun\SDK\domains\domain1\applications\j2ee-apps\commerc_old
deployed with moduleid = commerc
[TopLink Config]: 2007.05.08 11:19:04.659--ServerSession(28722705)--The alias name for the entity class [class commerc.Users] is being defaulted to: Users.
[TopLink Config]: 2007.05.08 11:19:04.659--ServerSession(28722705)--The table name for entity [class commerc.Users] is being defaulted to: USERS.
[TopLink Config]: 2007.05.08 11:19:04.659--ServerSession(28722705)--The column name for element [private java.lang.String commerc.Users.MSISDN] is being defaulted to: MSISDN.
[TopLink Config]: 2007.05.08 11:19:04.659--ServerSession(28722705)--The column name for element [private java.lang.String commerc.Users.FirstName] is being defaulted to: FIRSTNAME.
[TopLink Config]: 2007.05.08 11:19:04.659--ServerSession(28722705)--The column name for element [private java.lang.String commerc.Users.LastName] is being defaulted to: LASTNAME.
[TopLink Config]: 2007.05.08 11:19:04.659--ServerSession(28722705)--The column name for element [private java.lang.String commerc.Users.Password] is being defaulted to: PASSWORD.
[TopLink Config]: 2007.05.08 11:19:04.659--ServerSession(28722705)--The column name for element [private java.lang.String commerc.Users.address] is being defaulted to: ADDRESS.
[TopLink Config]: 2007.05.08 11:19:04.659--ServerSession(28722705)--The column name for element [private int commerc.Users.BrokerAcc] is being defaulted to: BROKERACC.
[TopLink Config]: 2007.05.08 11:19:04.659--ServerSession(28722705)--The column name for element [private int commerc.Users.age] is being defaulted to: AGE.
[TopLink Config]: 2007.05.08 11:19:04.659--ServerSession(28722705)--The column name for element [private java.lang.String commerc.Users.DeviceID] is being defaulted to: DEVICEID.
naming.bind
LDR5010: All ejb(s) of [commerc] loaded successfully!
WEB0100: Loading web module [commerc:commerc-war.war] in virtual server [server] at [/commerc-war]
[TopLink Config]: 2007.05.08 11:19:14.954--ServerSession(28722705)--property toplink.server.platform.class.name is deprecated, property toplink.target-server should be used instead.
topLink_version
application_server_name_and_version
platform=>SQLServerPlatform
user name=> ""
connector=>JNDIConnector datasource name=>null
);|connecting
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
;SQLServer;2.2.0040;
;|connected_user_database_driver
platform=>SQLServerPlatform
user name=> ""
connector=>JNDIConnector datasource name=>null
);|connecting
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1)
;SQLServer;2.2.0040;
;|connected_user_database_driver
login_successful
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.8 (Build 060830)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'USERS'.Error Code: 208
Call:SELECT MSISDN, PASSWORD, ADDRESS, FIRSTNAME, BROKERACC, AGE, LASTNAME, DEVICEID FROM USERS
Query:ReportQuery(commerc.Users)
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:303)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:551)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:465)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:213)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:199)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:270)
at oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:600)
at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2115)
at oracle.toplink.essentials.internal.queryframework.ExpressionQueryMechanism.selectAllReportQueryRows(ExpressionQueryMechanism.java:2081)
at oracle.toplink.essentials.queryframework.ReportQuery.executeDatabaseQuery(ReportQuery.java:774)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(DatabaseQuery.java:609)
at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:677)
at oracle.toplink.essentials.queryframework.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:731)
at oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2218)
at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:937)
at oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:909)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:346)
at oracle.toplink.essentials.internal.ejb.cmp3.base.EJBQueryImpl.getResultList(EJBQueryImpl.java:447)
at commerc.UsersFacade.findAll(UsersFacade.java:50)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1050)
at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:165)
at com.sun.ejb.containers.BaseContainer.invokeTargetBeanMethod(BaseContainer.java:2766)
at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:3847)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:184)
at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:118)
at $Proxy38.findAll(Unknown Source)
at mcommerce.ListUsers.processRequest(ListUsers.java:48)
at mcommerce.ListUsers.doGet(ListUsers.java:64)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:397)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:278)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:239)
at com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667)
at com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
at com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844)
at com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
at com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
at com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'USERS'.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:711)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:486)
... 57 more[/b]
Please help me with these...
Thanx....
[Message sent by forum member 'deepak1234' (deepak1234)]
http://forums.java.net/jive/thread.jspa?messageID=215975