no Exception but no data either when using DerbyClient from jboss5

[Inquistiva]

I have been trying to set up petstore2.0 in jboss.
I have set up the Derby database using the petstore.sql and this works fine. I can start the Network Server and I can reach it as a client through IJ. I can even run the same sql as which is used in the petstore application and I get the data I need.

However now I have my petstore application running in Jboss, the first page that results in a database query does not show any results. There are no errors in the logging of the application. The derby.log remains virtually empty. I am not even sure that the DerbyClient configured is actually used (should any logging from the DerbyClient find its way into derby.log? Can I make the logging more verbose?)

derby.log
derby-ds.xml
server.log
persistence.xml

Could anyone give me a clue?
thanks a million.

[Inquistiva]

Just one addition: I know the server.log contains an Exception. It occured when I removed the <exclude-unlisted-classes>false</exclude-unlisted-classes> from the persistence.xml to try and solve this.

[Inquistiva]

I found that when I access the database throught the Client driver (using IJ and jdbc:derby://locahost..etc) and I also specify the user and password I specify in the derby-ds.xml, I get the same result. Apparently I should use app instead. Then it works from IJ, but still the same result from the jboss application.

Inquistiva wrote:

I have been trying to set up petstore2.0 in jboss.
I have set up the Derby database using the petstore.sql and this works fine. I can start the Network Server and I can reach it as a client through IJ. I can even run the same sql as which is used in the petstore application and I get the data I need.

However now I have my petstore application running in Jboss, the first page that results in a database query does not show any results. There are no errors in the logging of the application. The derby.log remains virtually empty. I am not even sure that the DerbyClient configured is actually used (should any logging from the DerbyClient find its way into derby.log? Can I make the logging more verbose?)

derby.log
derby-ds.xml
server.log
persistence.xml

Could anyone give me a clue?
thanks a million.

[Inquistiva]

Apparently I didn't save something right because a bit later the derby-ds.xml had the old username and password in it again.
And then there were some issues with creating the same database from another location, which somehow left me with a new connection with empty tables. After rummaging around and cleaning up a bit, it all works!



I found that when I access the database throught the Client driver (using IJ and jdbc:derby://locahost..etc) and I also specify the user and password I specify in the derby-ds.xml, I get the same result. Apparently I should use app instead. Then it works from IJ, but still the same result from the jboss application.

Inquistiva wrote:

I have been trying to set up petstore2.0 in jboss.
I have set up the Derby database using the petstore.sql and this works fine. I can start the Network Server and I can reach it as a client through IJ. I can even run the same sql as which is used in the petstore application and I get the data I need.

However now I have my petstore application running in Jboss, the first page that results in a database query does not show any results. There are no errors in the logging of the application. The derby.log remains virtually empty. I am not even sure that the DerbyClient configured is actually used (should any logging from the DerbyClient find its way into derby.log? Can I make the logging more verbose?)

derby.log
derby-ds.xml
server.log
persistence.xml

Could anyone give me a clue?
thanks a million.