Help w/ JSF: Travel db works with Table, no other DBs do

I have run through the Travel JSF example that camw with Netbeans (J2EE) and everything worked fine.

But if I use any other of my database connections, I get no data when I drop the db table on to the JSF table (in design view).

Ubuntu Linux 6.06

Tomcat 5.5

Java 1.5, EE

mysql Ver 14.7 Distrib 4.1.15

mysql-connector-java 3.0.9

Running this (knowingly broken) app produces this:

java.lang.ClassNotFoundException: com.sun.rave.web.ui.util.UploadFilter

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1494)

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1275)

at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:221)

at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:333)

at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:89)

at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4104)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4765)

at com.sun.enterprise.web.WebModule.start(WebModule.java:292)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1095)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:907)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1095)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:520)

at org.apache.catalina.startup.Embedded.start(Embedded.java:920)

at com.sun.enterprise.web.WebContainer.start(WebContainer.java:784)

at com.sun.enterprise.web.PEWebContainer.startInstance(PEWebContainer.java:722)

at com.sun.enterprise.web.PEWebContainerLifecycle.onStartup(PEWebContainerLifecycle.java:72)

at com.sun.enterprise.server.ondemand.ServiceGroup.startLifecycleServices(ServiceGroup.java:266)

at com.sun.enterprise.server.ondemand.WebServiceGroup.startLifecycleServices(WebServiceGroup.java:210)

at com.sun.enterprise.server.ondemand.WebServiceGroup.start(WebServiceGroup.java:60)

at com.sun.enterprise.server.ondemand.ServiceGroup$1.run(ServiceGroup.java:180)

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

at com.sun.enterprise.server.ondemand.ServiceGroup.startChildren(ServiceGroup.java:177)

at com.sun.enterprise.server.ondemand.MainServiceGroup.start(MainServiceGroup.java:45)

at com.sun.enterprise.server.ondemand.ServerEntryListenerImpl.notifyEntry(ServerEntryListenerImpl.java:72)

at com.sun.enterprise.server.ondemand.entry.ServerEntryHelper.sendEvent(ServerEntryHelper.java:62)

at com.sun.enterprise.server.ondemand.entry.ServerEntryHelper.generateAppLoaderEntryContext(ServerEntryHelper.java:47)

at com.sun.enterprise.server.AbstractLoader.generateEntryContext(AbstractLoader.java:827)

at com.sun.enterprise.server.AbstractLoader.notifyAppEvent(AbstractLoader.java:833)

at com.sun.enterprise.server.DummyWebModuleLoader.load(DummyWebModuleLoader.java:62)

at com.sun.enterprise.server.AbstractManager.load(AbstractManager.java:206)

at com.sun.enterprise.server.ApplicationLifecycle.onStartup(ApplicationLifecycle.java:201)

at com.sun.enterprise.server.ApplicationServer.onStartup(ApplicationServer.java:326)

at com.sun.enterprise.server.ondemand.OnDemandServer.onStartup(OnDemandServer.java:112)

at com.sun.enterprise.server.PEMain.run(PEMain.java:326)

at com.sun.enterprise.server.PEMain.main(PEMain.java:260)

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.server.PELaunch.main(PELaunch.java:272)

[4019 byte] By [r5ta] at [2007-11-26 15:14:37]
# 1

Judging from the stacktrace, it doesn't look like a DB issue. It looks like a classpath problem. Which JAR is the UploadFilter class in? You should make sure it is in your WEB-INF/lib directory.

Also, this page might help...

http://developers.sun.com/prodtech/javatools/jscreator/reference/docs/apis/webui/com/sun/rave/web/ui/component/UploadBase.html

CowKing

IamCowKinga at 2007-7-8 9:06:08 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2

Well, even before the application is run, the data does not load into the table component. I think once that's solved, the other might resolve itself.

For exmple, when dragging a table onto a drop-down list, you should see 'abc' as the text for the list, but instead, I see nothing except the created sessionbean1 with the select statement.

r5ta at 2007-7-8 9:06:08 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 3
And you're not catching any database exceptions? Do you even have a try-catch around your db calls?I think you'll need to post some code snippets.CowKing
IamCowKinga at 2007-7-8 9:06:08 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 4

There are no calls requiring a try/catch. If you load the travel database (derby) and drop it onto a table component, the table changes to match the table, no problem. Any other database doesnt. The other databases work fine in the Runtime tab.

Screenshot:

http://pub.turingshop.com/assets/images/Screenshot.jpg

As you can see, both rowsets are there, but the mySql one is not linked to the table.

r5ta at 2007-7-8 9:06:08 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 5

I'm not familiar with the system you are using. Seems like the GUI is throwing you off. I've always been a fan of handcoding things. At least for the first bit. Then I understand what the system is doing.

Do you have a co-worker that can peep over your shoulder or help you out. I'm not sure if the internet is the easiest way to solve this problem. I suspect it's just something small.

CowKing

IamCowKinga at 2007-7-8 9:06:08 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...