Return to Jive Software

Up to Discussions in Jive Forums
This thread is archived
704 Views 5 Replies Last post: Aug 16, 2001 6:07 PM by Yinhong Chen RSS
Yinhong Chen Novice
Yinhong Chen
8 posts since
Aug 15, 2001
Currently Being Moderated

Aug 15, 2001 9:31 AM

setup JDBC Drivers (Win2k, Tomcat3.2.3, MySQL) in Jive 2.0.1

Sir,

I can not figure the MySQL section on the Jive Databse Setup Doc.

It said, In the Jive setup tool, use the following values;

 

driver: org.gjt.mm.mysql.Driver

server:jdbc:mysql://[your_host]/[databse_name]

 

but, where can I find Jive setup tool???

 

also I can only pass the first 2 setup pages...

Thanks for your help so much.

 

 

 

thunderbolt Novice
thunderbolt
33 posts since
Aug 14, 2001
Currently Being Moderated
Aug 15, 2001 9:36 AM in response to: Yinhong Chen
Re: setup JDBC Drivers (Win2k, Tomcat3.2.3, MySQL) in Jive 2.0.1

 

go to

 

admin/setup.jsp

 

 

follow the step by step instruction

Yinhong Chen Novice
Yinhong Chen
8 posts since
Aug 15, 2001
Currently Being Moderated
Aug 15, 2001 9:55 AM in response to: thunderbolt
Re: setup JDBC Drivers (Win2k, Tomcat3.2.3, MySQL) in Jive 2.0.1

Sir,

but I can't go to 3rd step Database.

it appears the following msg,

*org.apache.jasper.JasperException: Unable to compile class for JSPC:\tomcat\work\localhost_8080%2Fjive\_0002fadmin_0002fsetup_0002fsetup_00033_0002ejspsetup3_jsp_0.java:426: Ambiguous class: java.beans.Statement and java.sql.Statement

                                      Statement stmt = con.createStatement();

                                      ^

1 error

*

 

I write a test program to test my JDBC and MySQL.

They were both working well.

can you tell me how to manually configure these 2 values?

(driver and server for the Jive setup tool)

 

Thanks very much! _

thunderbolt Novice
thunderbolt
33 posts since
Aug 14, 2001
Currently Being Moderated
Aug 15, 2001 10:17 AM in response to: Yinhong Chen
Re: setup JDBC Drivers (Win2k, Tomcat3.2.3, MySQL) in Jive 2.0.1

I think you can go to the directory 'WEB-INF\jiveHome'

 

open the configuratin file jive_config.xml,

 

and add these lines. (put them after the locale).

 

Use your own username and password. 

 

 

     <database>

          <defaultProvider>

               <driver>org.gjt.mm.mysql.Driver</driver>

               <serverURL>jdbc:mysql://localhost/jive</serverURL>

               <username>your_username</username>

               <password>your_password</password>

               <minConnections>3</minConnections>

               <maxConnections>10</maxConnections>

               <connectionTimeout>0.5</connectionTimeout>

          </defaultProvider>

     </database>

 

     <setup>true</setup>

 

 

 

Matt Tucker Jive Employee
Matt Tucker
3,657 posts since
Jun 28, 2001
Currently Being Moderated
Aug 15, 2001 10:31 AM in response to: Yinhong Chen
Re: setup JDBC Drivers (Win2k, Tomcat3.2.3, MySQL) in Jive 2.0.1

*org.apache.jasper.JasperException: Unable to

compile class for

JSPC:\tomcat\work\localhost_8080%2Fjive\_0002fadmin_00

2fsetup_0002fsetup_00033_0002ejspsetup3_jsp_0.java:426

Ambiguous class: java.beans.Statement and

java.sql.Statement

Statement stmt =

Statement stmt = con.createStatement();

^

1 error

*

 

What appserver are you using? If you can't compile the JSP pages, you're going to have some more significant problems than trying to get the db settings correct.

 

-Matt

Yinhong Chen Novice
Yinhong Chen
8 posts since
Aug 15, 2001
Currently Being Moderated
Aug 16, 2001 6:07 PM in response to: Matt Tucker
Re: setup JDBC Drivers (Win2k, Tomcat3.2.3, MySQL) in Jive 2.0.1

matt,

I've try different versions of tomcat(3.11, 3.2.3, 4.0..) but still can't get them work.

then sth ccme to my mind me is it jdk's proplem?

so I switch jdk1.4beta1 to jdk1.3.1...

Now, it's working! I don't know why?

the error msg indicates the jspaser, ambiguous classes' problems. I don't know if anyone have this problem.. _;

 

More Like This

  • Retrieving data ...

Bookmarked By (0)

To better serve our customers we have included functionality to automatically follow up on a case after it has been idle for more than 5 days, and then auto close after an additional 3 days of inactivity. Choose No to acknowledge that this case will remain idle for longer than 5 days.
Making cases public allows other customers to learn from the solution of the case. It can also be used to gain feedback from others in the community. Ask our Support Engineers for more info, but we encourage you to make your cases public.