Home.... | log in.... | Pub my question! | Sign-up....

Java-index >> Enterprise & Remote Computing >> Enterprise Technologies

what should i do the derby database can't be connected?

i downloaded the j2eetutorial of Sun ,and i practice the bank examples of J2EE platform, the other steps finished successfully according the pdf tutorial ,and formed the BankApp.ear ,but when i run the web client and the application client ,when accessed the database ,it can't show the data in the database.i try many times, but it still doesn't work ,what should i do ?please help me deal the problem,thank you very much.

[432 byte] By [weieila] at [2007-11-27 8:36:55]

«« mysql connector in linux - java.lang.ClassNotFoundException: com.mysql.jdbc
»» executing same file extension

# 1

You can start the database using the command,"start-database"AS_INSTALL_DIR/bin/asadmin start-databaseYou can find exception messages (if your app. is not working fine) in AS_INSTALL_DIR/domains/<domainname>logs/server.log.

Jagadish.Prasatha at 2007-7-12 20:34:02 >

top of Java-index,Enterprise & Remote Computing,Enterprise Technologies...

# 2

first thank you very much.I am a beginner of J2EE ,i see the server.log according you tell me, but i can't understand the information,can you tell me your email, i send you the server.log,and you help me to find what is the real problems. thank you very much.

wweieila at 2007-7-12 20:34:02 >

# 3

You can post just the exception stack traces that you see in server.log

Jagadish.Prasatha at 2007-7-12 20:34:02 >

# 4

the exception stack traces:

com.sun.jdo.api.persistence.support.JDODataStoreException: JDO76400: Got a JDBC SQLException while executing the SQL statement:

SQL statement<select t0."CUSTOMERID", t0."PHONE", t0."STREET", t0."STATE", t0."EMAIL", t0."ZIP", t0."MIDDLEINITIAL", t0."FIRSTNAME", t0."CITY", t0."LASTNAME" from "CUSTOMERBEAN" t0 where t0."CUSTOMERID" = CAST (? AS VARCHAR(32672))> with input values:java.lang.String:200.

Please examine the SQLException for more information.

NestedException: org.apache.derby.client.am.SqlException: Table 'CUSTOMERBEAN' does not exist.

at com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.throwJDOSqlException(SQLStoreManager.java:614)

at com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.executeQuery(SQLStoreManager.java:448)

at com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.retrieve(SQLStoreManager.java:345)

at com.sun.jdo.spi.persistence.support.sqlstore.SQLStateManager.retrieve(SQLStateManager.java:2024)

at com.sun.jdo.spi.persistence.support.sqlstore.SQLStateManager.reload(SQLStateManager.java:1162)

at com.sun.jdo.spi.persistence.support.sqlstore.SQLStateManager.reload(SQLStateManager.java:1118)

at com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerImpl.getObjectById(PersistenceManagerImpl.java:633)

at com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerWrapper.getObjectById(PersistenceManagerWrapper.java:245)

at com.sun.ebank.ejb.customer.CustomerBean1668466742_ConcreteImpl.ejbFindByPrimaryKey(CustomerBean1668466742_ConcreteImpl.java:538)

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

at com.sun.enterprise.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:983)

at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:147)

at com.sun.ejb.containers.EntityContainer.invokeFindByPrimaryKey(EntityContainer.java:738)

at com.sun.ejb.containers.EJBLocalHomeInvocationHandler.invoke(EJBLocalHomeInvocationHandler.java:181)

at $Proxy27.findByPrimaryKey(Unknown Source)

at com.sun.ebank.ejb.customer.CustomerControllerBean.getDetails(Unknown Source)

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

at com.sun.enterprise.security.SecurityUtil$2.run(SecurityUtil.java:153)

at java.security.AccessController.doPrivileged(Native Method)

at com.sun.enterprise.security.application.EJBSecurityManager.doAsPrivileged(EJBSecurityManager.java:957)

at com.sun.enterprise.security.SecurityUtil.invoke(SecurityUtil.java:158)

at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:151)

at $Proxy18.getDetails(Unknown Source)

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

at com.sun.corba.ee.impl.presentation.rmi.ReflectiveTie._invoke(ReflectiveTie.java:123)

at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:648)

at com.sun.corba.ee.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:192)

at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1709)

at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1569)

at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:951)

at com.sun.corba.ee.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:181)

at com.sun.corba.ee.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:721)

at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:469)

at com.sun.corba.ee.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1258)

at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:409)

NestedStackTrace:

org.apache.derby.client.am.SqlException: Table 'CUSTOMERBEAN' does not exist.

at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)

at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)

at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)

at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)

at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)

at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)

at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)

at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)

at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)

at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)

at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)

at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)

at com.sun.gjc.spi.ConnectionHolder.prepareStatement(ConnectionHolder.java:362)

at com.sun.jdo.spi.persistence.support.sqlstore.sql.generator.DBStatement.<init>(DBStatement.java:64)

at com.sun.jdo.spi.persistence.support.sqlstore.SQLStoreManager.executeQuery(SQLStoreManager.java:419)