Lenny Sorey
|
| Posted: 03/01/2003, 6:57 AM |
|
Just curious.
Anyone using Firebird Database along with Jaybird JDBC Drivers
successfully within CodeCharge Studio 2.0?
I've had a great deal of success using Servlet / JSP CCS 2.0 with MySQL /MySQL Connector J 3.0, but I'd like to take a stab at trying Firebird / Jaybird with CCS 2.0.
My Platform is as follows:
Windows 2000 Server
Apache 2.0.44 Http Server
Tomcat 4.1.18
Ant 1.5
Just wanted to see if anyone else has had any success with Firebird / Jaybird JDBC before I jump in.
Thanks,
Lenny Sorey
|
|
|
 |
kelvinator
|
| Posted: 04/10/2003, 7:03 AM |
|
Lenny:
How did you do that? I've spent 2 weeks trying to get JSP CCS and MYSQL to work with Tomcat 4.1.24 with no luck. Get error "no suitable driver" found but also see that Tomcat has registered the jdbc driver successfully. Added the jdbc,jar to my classpath and tomcat dir ../common/lib, ../shared/lib and also anywhere else I could think of - same problem. Seems to be a common problem - hits all over the web - but no working solutions.
What did you do? Could you please share it with me?
|
|
|
|
Lenny Sorey
|
| Posted: 04/10/2003, 9:01 AM |
|
First of all make sure you've downloaded the following items from MySQL site.
1. Connector/ODBC 3.51 - This is for the visual side of CCS 2.0 while your are designing your site from a visual prospective. (you'll need this connectivity to define your queries within mysql.)
2. MySQL Connector/J 3.0.7 - You'll need to set up the driver within the Project Settings under the Connection Tab. First setup your ODBC Driver in the Design tab section , then go to the Server tab and enter the following at the JDBC Driver box: com.mysql.jdbc.Driver , then enter the following in the DATABASE URL box: jdbc:mysql://localhost/yourtablenamehere (I'm assuming you are using localhost at the present. If not enter your server name where localhost is located in the Database URL.
I've place the Mysql connector jar in my D:\java\Tomcat41\common\lib subdirectory.
Under the properties of your project settings I would change change the Deploy Webapps property to unpacked so you can see how your jsp's and classes are deployed within your webapp directory.
Be sure to set your server path to D:\java\Tomcat41\webapps\yourapp and server URL to http://localhost:8080/yourapp respectively in the publishing tab under Project settings.
In addition, make sure you have your Environmental Variables for the following:
I don't know how well versed you are in Windows so here goes:
go to the Control Panel, click on the System icon and select the Advanced tab.
Variable - Variable Value (Use your drive and installation directory)
ANT_HOME D:\java\apache-ant-1.5.2 or whatever version of ANT you have.
CLASSPATH D:\java\j2sdk141\lib\tools.jar;D:\java\Tomcat41
\common\lib\servlet.jar;
CATALINA_HOME D:\java\Tomcat41
J2SDK_HOME D:\java\j2sdk141
MYSQL_HOME D:\mysql
TOMCAT_HOME D:\java\Tomcat41
Add the following to your Path Value: (Once again Your drive and directory names)
D:\java\j2sdk141\bin;D:\java\j2sdk141\jre\server;%ANT_HOME%\bin;%MYSQL_HOME%\bin;
Finally, add the following to your D:\java\Tomcat41\conf\server.xml
<!-- Start of Your App Name-->
<Context path="/yourappname" docBase="yourappname" debug="0" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_yourappname_log." suffix=".txt" timestamp="true" /> <Environment name="maxExemptions" type="java.lang.Integer" value="15" />
<Parameter name="context.param.name" value="context.param.value" override="false" />
<Resource name="mail/Session" auth="Container" type="javax.mail.Session" />
<ResourceParams name="mail/Session">
<parameter>
<name>mail.smtp.host</name>
<value>localhost</value>
</parameter>
</ResourceParams>
</Context>
<!-- End of Your App Name-->
Create the Mysql Internet and Intranet database and run the mysql scripts in the examples to create the tables.
Change the example database in the CCS 2.0 example projects to MYSQL database with the items described at the top of this message. Stop Tomcat, build your project, Start Tomcat and log on to http://localhost:8080/yourapp/Default.jsp or what ever default jsp you create.
In addition, the Support Folks at YesSoftware CCS 2.0 JSP / Java are very helpful if your have any questions regarding using the JSP / Java module of CCS 2.0. There is a lady by the name of Helen at YesSoftware who is very sharp and quite knowledgeable on the JSP / Java module of CCS 2.0.
The folks at YesSoftware want you to be successful using this product.
Good Luck. Hope I've given you some useful information.
If you need any additional info, send me your email address and I will be happy to respond to your questions as long as I can.
Lenny Sorey
|
|
|
|
|
