-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 
Author Message
 Post subject: Can't get tutorial to work in Netbeans
PostPosted: Tue Dec 02, 2008 7:29 pm 
Newbie

Joined: Tue Dec 02, 2008 6:57 pm
Posts: 3
Location: Minneapolis
Hello,
I am new a programming java web applications, so this may be simple but please help.

I have installed the Maven plugin in Netbeans 6.1 IDE. I opened the project in the tutorial and right clicked and "manualy installed artifacts:" commons-logging-99.0-does-not-exist.jar, commons-logging-api-99.0-does-not-exist.jar, hsqldb-1.8.0.2.jar and hibernate-testing-3.3.1.GA.jar

The GlassFish V2 log:
17:24:34,100 INFO SessionFactoryImpl:805 - closing
17:24:34,102 INFO DriverManagerConnectionProvider:170 - cleaning up connection pool: jdbc:hsqldb:hsql://localhost
deployed with moduleid = org.hibernate_hibernate-tutorial-web_war_3.3.1.GA
validateJarFile(/Users/kevincharles/Scheduling Application/hibernate-distribution-3.3.1.GA/project/tutorials/web/target/hibernate-tutorial-web-3.3.1.GA/WEB-INF/lib/servlet-api-2.3.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
17:24:34,783 INFO Environment:543 - Hibernate 3.3.1.GA
17:24:34,791 INFO Environment:576 - hibernate.properties not found
17:24:34,796 INFO Environment:709 - Bytecode provider name : javassist
17:24:34,801 INFO Environment:627 - using JDK 1.4 java.sql.Timestamp handling
17:24:34,862 INFO Configuration:1460 - configuring from resource: /hibernate.cfg.xml
17:24:34,863 INFO Configuration:1437 - Configuration resource: /hibernate.cfg.xml
17:24:35,128 INFO Configuration:586 - Reading mappings from resource : org/hibernate/tutorial/domain/Event.hbm.xml
17:24:35,213 INFO HbmBinder:322 - Mapping class: org.hibernate.tutorial.domain.Event -> EVENTS
17:24:35,248 INFO HbmBinder:1441 - Mapping collection: org.hibernate.tutorial.domain.Event.participants -> PERSON_EVENT
17:24:35,250 INFO Configuration:586 - Reading mappings from resource : org/hibernate/tutorial/domain/Person.hbm.xml
17:24:35,279 INFO HbmBinder:322 - Mapping class: org.hibernate.tutorial.domain.Person -> PERSON
17:24:35,282 INFO HbmBinder:1441 - Mapping collection: org.hibernate.tutorial.domain.Person.events -> PERSON_EVENT
17:24:35,283 INFO HbmBinder:1441 - Mapping collection: org.hibernate.tutorial.domain.Person.emailAddresses -> PERSON_EMAIL_ADDR
17:24:35,285 INFO Configuration:1575 - Configured SessionFactory: null
17:24:35,341 INFO DriverManagerConnectionProvider:64 - Using Hibernate built-in connection pool (not for production use!)
17:24:35,343 INFO DriverManagerConnectionProvider:65 - Hibernate connection pool size: 2
17:24:35,343 INFO DriverManagerConnectionProvider:68 - autocommit mode: false
17:24:35,346 INFO DriverManagerConnectionProvider:103 - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost
17:24:35,347 INFO DriverManagerConnectionProvider:109 - connection properties: {user=sa, password=****}
17:24:35,416 WARN SettingsFactory:144 - Could not obtain connection metadata
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias does not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
at org.hibernate.tutorial.util.HibernateUtil.<clinit>(HibernateUtil.java:13)
at org.hibernate.tutorial.web.SessionFactoryInitializer.contextInitialized(SessionFactoryInitializer.java:18)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4523)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:5184)
at com.sun.enterprise.web.WebModule.start(WebModule.java:326)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:973)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:957)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:688)
at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1584)
at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1222)
at com.sun.enterprise.server.WebModuleDeployEventListener.moduleDeployed(WebModuleDeployEventListener.java:182)
at com.sun.enterprise.server.WebModuleDeployEventListener.moduleDeployed(WebModuleDeployEventListener.java:278)
at com.sun.enterprise.admin.event.AdminEventMulticaster.invokeModuleDeployEventListener(AdminEventMulticaster.java:974)
at com.sun.enterprise.admin.event.AdminEventMulticaster.handleModuleDeployEvent(AdminEventMulticaster.java:961)
at com.sun.enterprise.admin.event.AdminEventMulticaster.processEvent(AdminEventMulticaster.java:464)
at com.sun.enterprise.admin.event.AdminEventMulticaster.multicastEvent(AdminEventMulticaster.java:176)
at com.sun.enterprise.admin.server.core.DeploymentNotificationHelper.multicastEvent(DeploymentNotificationHelper.java:308)
at com.sun.enterprise.deployment.phasing.DeploymentServiceUtils.multicastEvent(DeploymentServiceUtils.java:226)
at com.sun.enterprise.deployment.phasing.ServerDeploymentTarget.sendStartEvent(ServerDeploymentTarget.java:298)
at com.sun.enterprise.deployment.phasing.ApplicationStartPhase.runPhase(ApplicationStartPhase.java:132)
at com.sun.enterprise.deployment.phasing.DeploymentPhase.executePhase(DeploymentPhase.java:108)
at com.sun.enterprise.deployment.phasing.PEDeploymentService.executePhases(PEDeploymentService.java:919)
at com.sun.enterprise.deployment.phasing.PEDeploymentService.start(PEDeploymentService.java:591)
at com.sun.enterprise.deployment.phasing.PEDeploymentService.start(PEDeploymentService.java:635)
at com.sun.enterprise.admin.mbeans.ApplicationsConfigMBean.start(ApplicationsConfigMBean.java:744)
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.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:375)
at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:358)
at com.sun.enterprise.admin.config.BaseConfigMBean.invoke(BaseConfigMBean.java:464)
at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:213)
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:815)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784)
at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.sun.enterprise.admin.util.proxy.ProxyClass.invoke(ProxyClass.java:90)
at $Proxy1.invoke(Unknown Source)
at com.sun.enterprise.admin.server.core.jmx.SunoneInterceptor.invoke(SunoneInterceptor.java:304)
at com.sun.enterprise.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:174)
at com.sun.enterprise.admin.jmx.remote.server.callers.InvokeCaller.call(InvokeCaller.java:69)
at com.sun.enterprise.admin.jmx.remote.server.MBeanServerRequestHandler.handle(MBeanServerRequestHandler.java:155)
at com.sun.enterprise.admin.jmx.remote.server.servlet.RemoteJmxConnectorServlet.processRequest(RemoteJmxConnectorServlet.java:122)
at com.sun.enterprise.admin.jmx.remote.server.servlet.RemoteJmxConnectorServlet.doPost(RemoteJmxConnectorServlet.java:193)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:196)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:288)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
at com.sun.enterprise.web.connector.grizzly.WorkerThreadImpl.run(WorkerThreadImpl.java:116)
17:24:35,450 INFO Dialect:175 - Using dialect: org.hibernate.dialect.HSQLDialect
17:24:35,458 INFO TransactionFactoryFactory:59 - Using default transaction strategy (direct JDBC transactions)
17:24:35,461 INFO TransactionManagerLookupFactory:80 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
17:24:35,462 INFO SettingsFactory:170 - Automatic flush during beforeCompletion(): disabled
17:24:35,463 INFO SettingsFactory:174 - Automatic session close at end of transaction: disabled
17:24:35,464 INFO SettingsFactory:189 - Scrollable result sets: disabled
17:24:35,465 INFO SettingsFactory:197 - JDBC3 getGeneratedKeys(): disabled
17:24:35,466 INFO SettingsFactory:205 - Connection release mode: auto
17:24:35,467 INFO SettingsFactory:232 - Default batch fetch size: 1
17:24:35,468 INFO SettingsFactory:236 - Generate SQL with comments: disabled
17:24:35,469 INFO SettingsFactory:240 - Order SQL updates by primary key: disabled
17:24:35,470 INFO SettingsFactory:244 - Order SQL inserts for batching: disabled
17:24:35,471 INFO SettingsFactory:420 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
17:24:35,474 INFO ASTQueryTranslatorFactory:47 - Using ASTQueryTranslatorFactory
17:24:35,475 INFO SettingsFactory:252 - Query language substitutions: {}
17:24:35,478 INFO SettingsFactory:257 - JPA-QL strict compliance: disabled
17:24:35,479 INFO SettingsFactory:262 - Second-level cache: enabled
17:24:35,480 INFO SettingsFactory:266 - Query cache: disabled
17:24:35,489 INFO SettingsFactory:405 - Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge
17:24:35,491 INFO RegionFactoryCacheProviderBridge:61 - Cache provider: org.hibernate.cache.NoCacheProvider
17:24:35,492 INFO SettingsFactory:276 - Optimize cache for minimal puts: disabled
17:24:35,493 INFO SettingsFactory:285 - Structured second-level cache entries: disabled
17:24:35,499 INFO SettingsFactory:305 - Echoing all SQL to stdout
17:24:35,502 INFO SettingsFactory:314 - Statistics: disabled
17:24:35,504 INFO SettingsFactory:318 - Deleted entity synthetic identifier rollback: disabled
17:24:35,505 INFO SettingsFactory:333 - Default entity-mode: pojo
17:24:35,511 INFO SettingsFactory:337 - Named query checking : enabled
17:24:35,570 INFO SessionFactoryImpl:187 - building session factory
17:24:35,846 INFO SessionFactoryObjectFactory:105 - Not binding factory to JNDI, no JNDI name configured
17:24:35,854 INFO SchemaExport:226 - Running hbm2ddl schema export
17:24:35,856 DEBUG SchemaExport:242 - import file not found: /import.sql
17:24:35,857 INFO SchemaExport:251 - exporting generated schema to database
17:24:35,859 ERROR SchemaExport:274 - schema export unsuccessful
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias does not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:252)
at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:211)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:343)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1327)
at org.hibernate.tutorial.util.HibernateUtil.<clinit>(HibernateUtil.java:13)
at org.hibernate.tutorial.web.SessionFactoryInitializer.contextInitialized(SessionFactoryInitializer.java:18)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4523)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:5184)
at com.sun.enterprise.web.WebModule.start(WebModule.java:326)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:973)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:957)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:688)
at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1584)
at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1222)
at com.sun.enterprise.server.WebModuleDeployEventListener.moduleDeployed(WebModuleDeployEventListener.java:182)
at com.sun.enterprise.server.WebModuleDeployEventListener.moduleDeployed(WebModuleDeployEventListener.java:278)
at com.sun.enterprise.admin.event.AdminEventMulticaster.invokeModuleDeployEventListener(AdminEventMulticaster.java:974)
at com.sun.enterprise.admin.event.AdminEventMulticaster.handleModuleDeployEvent(AdminEventMulticaster.java:961)
at com.sun.enterprise.admin.event.AdminEventMulticaster.processEvent(AdminEventMulticaster.java:464)
at com.sun.enterprise.admin.event.AdminEventMulticaster.multicastEvent(AdminEventMulticaster.java:176)
at com.sun.enterprise.admin.server.core.DeploymentNotificationHelper.multicastEvent(DeploymentNotificationHelper.java:308)
at com.sun.enterprise.deployment.phasing.DeploymentServiceUtils.multicastEvent(DeploymentServiceUtils.java:226)
at com.sun.enterprise.deployment.phasing.ServerDeploymentTarget.sendStartEvent(ServerDeploymentTarget.java:298)
at com.sun.enterprise.deployment.phasing.ApplicationStartPhase.runPhase(ApplicationStartPhase.java:132)
at com.sun.enterprise.deployment.phasing.DeploymentPhase.executePhase(DeploymentPhase.java:108)
at com.sun.enterprise.deployment.phasing.PEDeploymentService.executePhases(PEDeploymentService.java:919)
at com.sun.enterprise.deployment.phasing.PEDeploymentService.start(PEDeploymentService.java:591)
at com.sun.enterprise.deployment.phasing.PEDeploymentService.start(PEDeploymentService.java:635)
at com.sun.enterprise.admin.mbeans.ApplicationsConfigMBean.start(ApplicationsConfigMBean.java:744)
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.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:375)
at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:358)
at com.sun.enterprise.admin.config.BaseConfigMBean.invoke(BaseConfigMBean.java:464)
at com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:213)
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:815)
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784)
at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.sun.enterprise.admin.util.proxy.ProxyClass.invoke(ProxyClass.java:90)
at $Proxy1.invoke(Unknown Source)
at com.sun.enterprise.admin.server.core.jmx.SunoneInterceptor.invoke(SunoneInterceptor.java:304)
at com.sun.enterprise.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:174)
at com.sun.enterprise.admin.jmx.remote.server.callers.InvokeCaller.call(InvokeCaller.java:69)
at com.sun.enterprise.admin.jmx.remote.server.MBeanServerRequestHandler.handle(MBeanServerRequestHandler.java:155)
at com.sun.enterprise.admin.jmx.remote.server.servlet.RemoteJmxConnectorServlet.processRequest(RemoteJmxConnectorServlet.java:122)
at com.sun.enterprise.admin.jmx.remote.server.servlet.RemoteJmxConnectorServlet.doPost(RemoteJmxConnectorServlet.java:193)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:317)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:196)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:198)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:288)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:568)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:813)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
at com.sun.enterprise.web.connector.grizzl
y.WorkerThreadImpl.run(WorkerThreadImpl.java:116)





The hsqldb log:
x:lib kevincharles$ java -cp . org.hsqldb.Server -database.0 file:mydb -dbname.0 xdb
Exception in thread "main" java.lang.NoClassDefFoundError: org/hsqldb/Server
x:lib kevincharles$ java -cp ./hsqldb.jar org.hsqldb.Server -database.0 file:mydb -dbname.0 xdb
[Server@5d173]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@5d173]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@5d173]: Startup sequence initiated from main() method
[Server@5d173]: Loaded properties from [/Users/kevincharles/Downloads/hsqldb/lib/server.properties]
[Server@5d173]: Initiating startup sequence...
[Server@5d173]: Server socket opened successfully in 4 ms.
[Server@5d173]: Database [index=0, id=0, db=file:mydb, alias=xdb] opened sucessfully in 213 ms.
[Server@5d173]: Startup sequence completed in 219 ms.
[Server@5d173]: 2008-12-02 16:50:47.370 HSQLDB server 1.8.0 is online
[Server@5d173]: To close normally, connect and execute SHUTDOWN SQL
[Server@5d173]: From command line, use [Ctrl]+[C] to abort abruptly
[Server@5d173]: [Thread[HSQLDB Connection @138c63,5,HSQLDB Connections @5d173]]: database alias= does not exist
[Server@5d173]: [Thread[HSQLDB Connection @25c828,5,HSQLDB Connections @5d173]]: database alias= does not exist
^Cx-160-94-190-80:lib kevincharles$ java -cp ./hsqldb.jar org.hsqldb.Server -database.0 file:mydb -dbname.0 xdb
[Server@5d173]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@5d173]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@5d173]: Startup sequence initiated from main() method
[Server@5d173]: Loaded properties from [/Users/kevincharles/Downloads/hsqldb/lib/server.properties]
[Server@5d173]: Initiating startup sequence...
[Server@5d173]: Server socket opened successfully in 4 ms.
[Server@5d173]: Database [index=0, id=0, db=file:mydb, alias=xdb] opened sucessfully in 174 ms.
[Server@5d173]: Startup sequence completed in 180 ms.
[Server@5d173]: 2008-12-02 16:55:16.958 HSQLDB server 1.8.0 is online
[Server@5d173]: To close normally, connect and execute SHUTDOWN SQL
[Server@5d173]: From command line, use [Ctrl]+[C] to abort abruptly
[Server@5d173]: [Thread[HSQLDB Connection @f0b7f8,5,HSQLDB Connections @5d173]]: database alias= does not exist
[Server@5d173]: [Thread[HSQLDB Connection @80cac9,5,HSQLDB Connections @5d173]]: database alias= does not exist
[Server@5d173]: [Thread[HSQLDB Connection @8166e5,5,HSQLDB Connections @5d173]]: database alias= does not exist
[Server@5d173]: [Thread[HSQLDB Connection @8a548b,5,HSQLDB Connections @5d173]]: database alias= does not exist


Thank you for any help!!!


Last edited by char0042 on Fri Dec 05, 2008 3:19 pm, edited 11 times in total.

Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 04, 2008 10:20 am 
Beginner
Beginner

Joined: Thu Oct 02, 2008 10:15 am
Posts: 21
I would advise to check that database is up and running and also make sure that you are providing the correct credentials/name in the hibernate/spring properties for the HSQLDB database.
To me this seems to be the root of the problem.
<code>
java.sql.SQLException: S1000 General error java.lang.RuntimeException: database alias does not exist
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
</code>


Top
 Profile  
 
 Post subject: How do I provide the credentials?
PostPosted: Thu Dec 04, 2008 11:34 am 
Newbie

Joined: Tue Dec 02, 2008 6:57 pm
Posts: 3
Location: Minneapolis
Thank you for the response!

Where are the settings for a "database alias"?

These are the settings which came with the tutorial, maybe someone knows what I should modify:

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

<session-factory>

<!-- Database connection settings -->
<property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="connection.url">jdbc:hsqldb:hsql://localhost</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>

<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">2</property>

<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>

<!-- Enable Hibernate's current session context -->
<property name="current_session_context_class">org.hibernate.context.ManagedSessionContext</property>

<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>

<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">create</property>

<mapping resource="org/hibernate/tutorial/domain/Event.hbm.xml"/>
<mapping resource="org/hibernate/tutorial/domain/Person.hbm.xml"/>

</session-factory>

</hibernate-configuration>


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 05, 2008 4:10 pm 
Beginner
Beginner

Joined: Thu Oct 02, 2008 10:15 am
Posts: 21
You should be looking at connection.url. This is where the port , db name etc is specified. and it looks like yours is incomplete.
I have never worked with this tutorial so cannot say what would be the exact value.
But it should have the db-name/alias like
jdbc:hsqldb:hsql://localhost/mydb


Top
 Profile  
 
 Post subject: Thanks for the response
PostPosted: Fri Dec 05, 2008 4:20 pm 
Newbie

Joined: Tue Dec 02, 2008 6:57 pm
Posts: 3
Location: Minneapolis
Thank you for the response.
I don't yet know exactly what fixed the problem but it is working now without errors.
I will post when I know more. I "Manually installed the artifact" again for hsqldb and restarted Netbeans and it "worked".

I now know there is no configuration file I needed to change for the tutorial which comes with the hibernate-core-3.3.1.GA.jar because I didn't change any of them and it started running without error.

-Kevin


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.