• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

MySQL & Sun App Server

 
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all!
I am trying to create a datasoure in Sun AppServer 1.4 Developer Release.
After download and installed the mysql-connector, I created a connection pool in the appserver called mySQLconPool with the following settings:
Datasource Classname: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
Additional Properties
serverName: 127.0.0.1
databaseName:test
port:3306
user:Admin
password:admin
I added the mysql-connector jar file path to the app server> JVM Settings> Classpath sufix.
The problem is that if I try to PING the connection I get the following error:

An error has occurred.
Operation 'pingConnectionPool' failed in 'resources' Config Mbean. Target exception message: Error getting connection from the EIS


What am I doing wrong? Am I missing something?
Please if any of you can help me I will appreciate!!!
Thanks in advance,
JOSEL
SCJP/SCJD
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi
Here is my working solution to connect MySQL with SUN J2EE 1.4 application server. I used this one and it works in my machine. I am sure two things you may need to take into consideration.
1, the property , I just put the url into the property name and the value is the followings,
2, make sure you use the correct username and password.
Database classname: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
You can also use: com.mysql.jdbc.jdbc2.optional.MysqlDataSource
Hope this can help!
Ken
And ive added the property:
url = jdbc:mysql://localhost:3306/stocks?user=stocks&password=stocks
 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You can access the following Document to configure your Oracle with Sun One Application Server
http://www.angelfire.com/nj4/najmi/SunOneOracleConfig.html
 
reply
    Bookmark Topic Watch Topic
  • New Topic