Connecting to Databases
hi everybody,
I'm usin MySQL server and mysql-connector-java-5.0.3-bin.jar driver to connect between the server and the IDE I'm usin which is Sun Java Studio Creator 2
there is a success in the connection but I can't get into the tables in the database.the message is telling me:
No validation table provided.
The ideal validation table exists only for connection validation purposes. Do not use an existing table that has a large number of rows or a table that will be frequently accessed.
when i want to expand sample databases nodes supplied by IDE to see tables i get :
Schema 'TRAVEL' does not exist
The ideal validation table exists only for connection validation purposes. Do not use an existing table that has a large number of rows or a table that will be frequently accessed.
bundled DB and mySQL are running
thanks !
[894 byte] By [
dElay] at [2007-11-26 10:34:39]
# 1
Usually when connection pools are created, you will see the following two lines in the server.xml file:
<resources>
<jdbc-resource enabled="true" pool-name="mySQLconPool" jndi-name="jdbc/mysqlds"/>
<jdbc-connection-pool
... is-connection-validation-required="false"
... connection-validation-method="auto-commit"
...
The purpose of setting "is-connection-validation-required" to true is to make sure that getConnection() always returns a valid connection; otherwise the server would return a connection from the pool without checkinf whether the connection is still valid. (connections go invalid for various reasons like database restart while the appserver is still running...)
You can of course set "is-connection-validation-required" to false to solve your problem.
If you do want to perform the connection validation, then there are three connection-validation-methods available: auto-commit, meta-data, and table. If you set the method to 'table' then you will need to provide which table should be used to verify the connection. Pl. check mysql documentation to see how this is done for mysql. Or you can change the method to 'metadata'; in this case the server will verify the connection by trying to obtain the metadata from the database and will not require a specific table to work with.>
