I have finally fixed this problem. It was to do with the Resource tags
name parameter in server.xml not matching the res-ref-name tag in the
applications WEB-INF/web.xml file.
Thanks for all the patient help I got here.
Hugh Morgan
Pascal wrote:
Hello
Do you tried to connect to your databse normaly (I mean without tomcat)
to see if your user/pwd and database are set correctly in Mysql
Like this for example
#mysql -uUSER -pPASSWORD DATABASE
[EMAIL PROTECTED] [~/temp/java]# mysql -uroot -pROOT_PASSWORD smsserver
Reading
David Smith wrote:
Yes, authority in the url is the name of the database being accessed.
URL syntax looks something like this:
jdbc:mysql//[DNS_name|IP][:portNum]/database
portNum is 3306 if not specified and you can add a ? and connect options
after the database name as needed.
I have made
very simple but sometimes
Pascal
- Original Message -
From: "Hugh Morgan" <[EMAIL PROTECTED]>
To: "Tomcat Users List"
Sent: Monday, May 08, 2006 5:16 PM
Subject: Re: Newbie: Deploying .war file, getting it working with MySQL
Franck Borel wrote:
Try t
Yes, authority in the url is the name of the database being accessed.
URL syntax looks something like this:
jdbc:mysql//[DNS_name|IP][:portNum]/database
portNum is 3306 if not specified and you can add a ? and connect options
after the database name as needed.
Hugh Morgan wrote:
> Franck Borel
Franck Borel wrote:
Try this:
usernameroot
passwordROOT_PASSWORD
driverClassNamecom.mysql.jdbc.Driver
urljdbc:mysql://localhost/authority
Same error (after changing paramater ;) ). Did make me think though,
what is authority? Should I have cganged this (to the name of
Try this:
usernameroot
passwordROOT_PASSWORD
driverClassNamecom.mysql.jdbc.Driver
urljdbc:mysql://localhost/authority
-- Franck
> Franck Borel wrote:
>> Where did you place your Realm block?
>>
>> It must be placed inside the context block like this:
>>
>>
>>
>>
>
>
Franck Borel wrote:
Where did you place your Realm block?
It must be placed inside the context block like this:
I did not have it here, I had it in the Engine tag. I have now changed
it, and stoped and restarted the server. I still get the same error.
The relavent bit of my server.
Where did you place your Realm block?
It must be placed inside the context block like this:
-- Franck
> Franck Borel wrote:
>> Have you set the entry unpackWARs true like this ?
>>
>> > appBase="webapps"
>> unpackWARs="true"
>> autoDeploy="true"
>> xmlValidation="fal
Franck Borel wrote:
Have you set the entry unpackWARs true like this ?
Yes, that is exactly what my Host tag looks like, and the war file is
unpacked correctly;
Thanks for the help.
-
To unsubscribe, e-mail: [EM
Have you set the entry unpackWARs true like this ?
-- Franck
> Franck Borel wrote:
>> Have you installed a mysql-connector?
>>
>> --> http://dev.mysql.com/downloads/connector/j/3.0.html
>>
>> - unpack
>> - find a file called mysql-connector-java-..jar
>> - copy this file into the common/li
Franck Borel wrote:
Have you installed a mysql-connector?
--> http://dev.mysql.com/downloads/connector/j/3.0.html
- unpack
- find a file called mysql-connector-java-..jar
- copy this file into the common/lib directory of your Tomcat installation
-- Franck
On the VPS there is already the
Have you installed a mysql-connector?
--> http://dev.mysql.com/downloads/connector/j/3.0.html
- unpack
- find a file called mysql-connector-java-..jar
- copy this file into the common/lib directory of your Tomcat installation
-- Franck
> I am tring to get an web site that I have developed
I am tring to get an web site that I have developed with Java Studio
Creator working on a VPS. I cannot get tomcat to comunicate with the
MySQL database. I have got a minimal web site working, and I have added
a simple dtabase query to it and I get the error at [1] (for full error
see http://
14 matches
Mail list logo
