Yes I need more info.
I'm using createAccountTable.bat and createAccountTable.sql (see attached)
to generate the cloudscape (you need start the cloudscape database server).
======== createAccountTable.bat ==============
set J2EE_HOME=C:\j2sdkee1.2.1
set CLASSPATH=
java
-Dij.connection.CloudscapeDB=jdbc:rmi://localhost:1099/jdbc:cloudscape:ShoppingCartDB\;create=true
-Dcloudscape.system.home=%J2EE_HOME%\cloudscape -classpath
%J2EE_HOME%\lib\cloudscape\client.jar;%J2EE_HOME%\lib\cloudscape\tools.jar;%J2EE_HOME%\lib\cloudscape\cloudscape.jar;%J2EE_HOME%\lib\cloudscape\RmiJdbc.jar;%J2EE_HOME%\lib\cloudscape\license.jar;%CLASSPATH%
-ms16m -mx32m COM.cloudscape.tools.ij createAccountTable.sql
=====================================================
============ createAccountTable.sql ===============
drop table account;
create table account
( id integer,
value integer );
======================================================
I inserted to above table, querry it are all fine. Then I tried to make JRun
sample2a working with above account table. The deploy.properties are listing
as following:
================= sample2a deploy.properties =============
ejipt.classServer.host=localhost
ejipt.ejbJars=sample2a_ejb.jar
ejipt.userHomeName=default.UserHome
ejipt.roleHomeName=default.RoleHome
ejipt.loginSessionHomeName=default.LoginSessionHome
ejipt.users=spender1:pass;spender2:pass;saver1:pass;saver2:pass;chief:pass
ejipt.roles=spender:spender1,spender2,chief;saver:saver1,saver2,chief
ejipt.jdbcSources=source1
source1.ejipt.sourceDriverClassName=COM.cloudscape.core.RmiJdbcDriver
source1.ejipt.sourceURL=jdbc:cloudscape:ShoppingCartDB
#source1.ejipt.sourceUser=scott
#source1.ejipt.sourcePassword=tiger
===========================================================================
I also modified the makew.bat in sample2a as following:
=================== sample2a makew.bat ===============
@echo off
set CLASSPATH=%CLASSPATH%;%J2EE_HOME%\lib\cloudscape\client.jar
set CLASSPATH=%CLASSPATH%;%J2EE_HOME%\lib\cloudscape\tools.jar
set CLASSPATH=%CLASSPATH%;%J2EE_HOME%\lib\cloudscape\cloudscape.jar
set CLASSPATH=%CLASSPATH%;%J2EE_HOME%\lib\cloudscape\RmiJdbc.jar
set CLASSPATH=%CLASSPATH%;%J2EE_HOME%\lib\cloudscape\license.jar
@set sources=Client.java
@call make1.bat %1 %2 %3 %4 %5 %6 %7 %8 %9
=========================================================================
but when I tryied to run the server as stand alone by typing "makew
standalone" I got the following error:
C:\Program Files\Allaire\JRun\samples\sample2a>java
-Dejipt.home="C:\Program Fi
les\Allaire\JRun" -Djava.security.policy="C:\Program
Files\Allaire\JRun\lib\jrun
.policy" -classpath "C:\Program Files\Allaire\JRun\lib\ejipt.jar;C:\Program
File
s\Allaire\JRun\lib\ext\ejb.jar;C:\Program
Files\Allaire\JRun\lib\ext\jms.jar;C:\
Program Files\Allaire\JRun\lib\ext\jndi.jar;C:\Program
Files\Allaire\JRun\lib\ex
t\jta.jar;C:\Program Files\Allaire\JRun\lib\ext\parser.jar;C:\Program
Files\Alla
ire\JRun\lib\ext\jdbc.jar" allaire.ejipt.Ejipt
Exception: [11:44:41] java.lang.ClassNotFoundException:
COM.cloudscape.core.RmiJ
dbcDriver
C:\Program Files\Allaire\JRun\samples\sample2a>
Here is the j2sdkee1.2.1 configuration file for your reference.
=============== defult.properties (under %J2EE_HOME%/config/) ======
# JDBC Driver Examples:
# Oracle thin driver: oracle.jdbc.driver.OracleDriver
# Merant driver: intersolv.jdbc.sequelink.SequeLinkDriver
# Cloudscape driver: COM.cloudscape.core.RmiJdbcDriver
#
jdbc.drivers=COM.cloudscape.core.RmiJdbcDriver
# JDBC URL Examples:
# Oracle thin driver:
# jdbc:oracle:thin:@<host>:<port>:<sid>
# Cloudscape RMI driver:
# jdbc:cloudscape:rmi:<database>;create=true
# Merant driver:
# jdbc:sequelink://<host>:<port>/[SQLServer];Database=<database>
#
#jdbc.datasources=jdbc/Cloudscape|jdbc:cloudscape:rmi:CloudscapeDB;create=true
jdbc.datasources=jdbc/Cloudscape|jdbc:cloudscape:rmi:ShoppingCartDB;create=true
passivation.threshold.memory=128000000
idle.resource.threshold=600
user.transaction.jndiname=java:comp/UserTransaction
log.directory=logs
log.output.file=output.log
log.error.file=error.log
log.event.file=event.log
distributed.transaction.recovery=false
transaction.timeout=0
sessionbean.timeout=0
#
# DataSource configuration for JDBC 2.0 XA drivers only
#
#jdbc20.datasources=jdbc/Merant|jdbc/XAMerant
#xadatasource.0.jndiname=jdbc/XAMerant
#xadatasource.0.classname=com.merant.sequelink.jdbcx.datasource.SequeLinkDataSource
#xadatasource.0.dbuser=<dba user>
#xadatasource.0.dbpassword=<dba password>
#xadatasource.0.prop.url=jdbc:sequelink://<host>:<port>/[Oracle]
#
======================================================================
Thank you very much for your help.
-Sherman Chen
>From: Scott Stirling <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
>Subject: RE: hook up to Cloudscape database
>Date: Fri, 25 Aug 2000 14:22:49 -0400
>
>You need the Cloudscape database driver's class name, the URL to connect to
>Cloudscape via JDBC, and the name of your database and any login parameters
>such as user name and password. Then you can configure a data source to it
>in the JMC JDBC data source panel. Does that help, or do you need more
>info?
>
>Scott Stirling
>Allaire Corporation
>http://www.allaire.com/developer/jrunreferencedesk/
>
> > -----Original Message-----
> > From: Sherman Chen [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, August 25, 2000 1:19 PM
> > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: hook up to Cloudscape database
> >
> >
> > Hi, Scott,
> > We developed a prototype by useing j2sdkee1.2.1 (it has a
> > nice deploytool),
> > so I deploy the ear (which generated by j2sdkee deploy tool)
> > to JRun. After
> > some struggle and with Lisa Lin's help from Allaire, the
> > application is
> > running under JRun default server. The ejb we developed under
> > j2sdkee1.2.1
> > talk to Cloudscape (which is shopped with j2sdkee as free).
> > In order to
> > fully evaluate JRun, we'd like to see its database
> > connection. Could you
> > give me some clues how I can hook up to Cloudscape database
> > (the one shopped
> > with j2sdkee1.2.1)? I saw the question was posted on the JRun
> > forum, but
> > there is no answer.
> >
> > Thanks,
> >
> > -Sherman
>------------------------------------------------------------------------------
>Archives: http://www.egroups.com/group/jrun-interest/
>Unsubscribe:
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
>or send a message to [EMAIL PROTECTED] with 'unsubscribe'
>in the body.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
------------------------------------------------------------------------------
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
