-
15. Re: JBoss Bootstrap Environment config
peterj Mar 30, 2006 10:46 AM (in response to johnson4)When you switched to MySQL, did you remember to copy the mysql-connector-xxx.jar file to the server/default/lib directory?
Also, use of the org.gjt.mm.mysql.Driver has been deprecated, you should use com.mysql.jdbc.Driver instead.
Yes, since Coyote (Tomcat) is using port 9002, you should open that port in the firewall. -
16. Re: JBoss Bootstrap Environment config
johnson4 Mar 30, 2006 10:51 AM (in response to johnson4)No I didn't know anything about the mysql-connector-xxx.jar file.
Where can I find it?
Or were you refering to the file I included in my last post, with the db config info? -
17. Re: JBoss Bootstrap Environment config
peterj Mar 30, 2006 10:54 AM (in response to johnson4)The connector jar file is available from the mysql web site. Look for Connctor/J on the Drivers tab in the products download page.
-
18. Re: JBoss Bootstrap Environment config
johnson4 Mar 30, 2006 10:57 AM (in response to johnson4)cool thanks a million, Ill go check that out
sj -
19. Re: JBoss Bootstrap Environment config
johnson4 Mar 31, 2006 10:52 AM (in response to johnson4)Hi
Ive been able to access the jmx-console and the webbased admin for my app (tambur.org) but Im still having issues getting the mysql database to connect.
I receive "Access denied for user: " concerning the connection to the database.
Again I've updated www.nettechglobal.ca/putty.log with my later run.sh output
and heres my db configfile (mysql-ds.xml)<?xml version="1.0" encoding="UTF-8"?> <!-- $Id: mysql-ds.xml,v 1.3.2.3 2006/02/07 14:23:00 acoliver Exp $ --> <!-- Datasource config for MySQL using 3.0.9 available from: http://www.mysql.com/downloads/api-jdbc-stable.html --> <datasources> <local-tx-datasource> <jndi-name>DefaultDS</jndi-name> <connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>dbjbossca</user-name> <password>some_word</password> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name> <!-- should only be used on drivers after 3.22.1 with "ping" support <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name> --> <!-- sql to call when connection is created <new-connection-sql>some arbitrary sql</new-connection-sql> --> <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql> --> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources>
Thanks again for aany help with this.
sj -
20. Re: JBoss Bootstrap Environment config
peterj Mar 31, 2006 11:16 AM (in response to johnson4)I assume that the text "some_word" in your posted -ds.xml file is the actual password for dbjbossca? :-)
Run mysql, and enter the following:use mysql select user,host from user where user='dbjbossca';
What are the hosts that show up? Are any of them 'thecyprusgroup.ca.servermatrix.com'? If not, then you need to grant that user/host combination access to the database. The MySQL documentation is pretty good on explaining this (see the MySQL User Account Management section). -
21. Re: JBoss Bootstrap Environment config
sachin1506 Dec 12, 2008 4:39 AM (in response to johnson4)even i got the same error ....
its just random ....i have got sick of this
so can anyone tell me the way to solve this problem
i m using JBoss 4.0.0RC1
and java version is jdk1.4
and if some one can provide me the solution for configuring oracle9i with jboss
till now i changed my oracle-ds.xml,login-config.xml,standardjaws.xml and even standardjbosscmp-jdbc.xml
so do i need to make some other changes ??
after declaring this to my oracle-ds.xml <jndi-name>OracleDs</jndi-name>
i get the error saying that OracleDS not bound -
22. Re: JBoss Bootstrap Environment config
jaikiran Dec 12, 2008 5:01 AM (in response to johnson4)sachin1506,
This is a 2 year old thread and discusses various issues. Its better to open a separate thread and provide more details about the issue you are running into.