Jivespace: Message List - setup JDBC Drivers (Win2k, Tomcat3.2.3, MySQL) in Jive 2.0.1

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

yinhong.chen@msa.hinet.net — Fri, 17 Aug 2001 01:07:23 GMT

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.. ^_;

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

matt@jivesoftware.com — Wed, 15 Aug 2001 17:31:24 GMT

*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

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

communities@jivesoftware.com — Wed, 15 Aug 2001 17:17:16 GMT

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.

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

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

<username>your_username</username>

<password>your_password</password>

</defaultProvider>

</database>

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

yinhong.chen@msa.hinet.net — Wed, 15 Aug 2001 16:55:08 GMT

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! ^_

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

communities@jivesoftware.com — Wed, 15 Aug 2001 16:36:04 GMT

go to

admin/setup.jsp

follow the step by step instruction

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

yinhong.chen@msa.hinet.net — Wed, 15 Aug 2001 16:31:42 GMT

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.