RE: Java Pet Store 1.1.2 with Cloudscape in Orion 1.5.2
Thanks, that worked, I was using the COM.cloudscape JDBC driver rather than the RMI JDBC driver. Strangely, the COM.cloudscape driver did work in JBoss and the J2EE reference implementation. Andrew -Original Message- From: Dvornikov Victor [mailto:[EMAIL PROTECTED]] Sent: 22 August 2001 07:27 To: Orion-Interest Subject: RE: Java Pet Store 1.1.2 with Cloudscape in Orion 1.5.2 Try to use these: connection-driver=RmiJdbc.RJDriver url=jdbc:rmi://localhost:1099/jdbc:cloudscape:defaultDB I checked it a half a year ago and it worked just fine. (don't forget to change url defaultDB ) -Original Message- From: Harris, Andrew S [SMTP:[EMAIL PROTECTED]] Sent: ? 21 ?? 2001 20:26 To: Orion-Interest Subject:Java Pet Store 1.1.2 with Cloudscape in Orion 1.5.2 I'm trying to get the Java Pet Store 1.1.2 working with Cloudscape in Orion 1.5.2, and it is failing to get a connection from the datasource in PopulateServlet. I have managed to obtain a connection using the DriverManager, after modifying PopulateServlet. This is the exception which I captured from getDBConnection on datasource.getConnection(): 2001-Aug-21 18:31:05 31145 ERROR [ApplicationServerThread] com.sun.j2ee.bluepri nts.tools.populate.web.PopulateServlet - java.sql.SQLException: The database driver (COM.cloudscape.core.RmiJdbcDriver@31 36e5) returned refusing to connect to the URL jdbc:rmi://localhost:1099/jdbc:clo udscape:CloudscapeDB;create=true at com.evermind.sql.DriverManagerDataSource.getConnection(Unknown Source ) at com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.getDBConne ction(PopulateServlet.java:380) at com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.checkConne ction(PopulateServlet.java:192) at com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.doGet(Popu lateServlet.java:138) at javax.servlet.http.HttpServlet.service(HttpServlet.java:195) at javax.servlet.http.HttpServlet.service(HttpServlet.java:309) at javax.servlet.http.HttpServlet.service(HttpServlet.java:336) at com.evermind._cxb._abe(Unknown Source) at com.evermind._cxb._uec(Unknown Source) at com.evermind._io._twc(Unknown Source) at com.evermind._io._gc(Unknown Source) at com.evermind._if.run(Unknown Source) and this is the line which is failing: if (datasource != null) dbConnection = datasource.getConnection(); Has anyone managed to get jps 1.1.2 working using Cloudscape? What am I missing here? I'm running with jdk1.3.1, the data sources are below. Cloudscape is from j2sdkee1.3 beta 2. data-sources.xml: ?xml version=1.0? !DOCTYPE data-sources PUBLIC Orion data-sources http://www.orionserver.com/dtds/data-sources.dtd; data-sources !-- An example/default DataSource that uses an ordinary JDBC-driver (in this case hsql) to create the connections. This tag creates all the needed kinds of data-sources, transactional, pooled and EJB-aware sources. The source generally used in application code is the EJB one - it provides transactional safety and connection pooling. -- !-- data-source class=com.evermind.sql.DriverManagerDataSource name=Hypersonic location=jdbc/HypersonicCoreDS xa-location=jdbc/xa/HypersonicXADS ejb-location=jdbc/HypersonicDS connection-driver=org.hsql.jdbcDriver username=sa password= url=jdbc:HypersonicSQL:./database/defaultdb inactivity-timeout=30 / -- !-- Java Pet Store - Cloudscape -- data-source class=com.evermind.sql.DriverManagerDataSource name=EstoreDB location=jdbc/EstoreDataSource xa-location=jdbc/xa/EstoreXADS ejb-location=jdbc/EstoreDB connection-driver=COM.cloudscape.core.RmiJdbcDriver username=estoreuser password=estore url=jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB;create=true inactivity-timeout=30
RE: Java Pet Store 1.1.2 with Cloudscape in Orion 1.5.2
Hi Guys, I try to access ejb(it's located other machine)using application Iam geting naming exception. could u pls help me anyone. I set up jndi properties like this. java.naming.factory.initial=com.evermind.server.ApplicationClientInitial ContextFactory java.naming.provider.url=ormi://xyz:5000/PreferencePage java.naming.security.principal=admin java.naming.security.credentials=123 when I try excute application I got this error. javax.naming.NamingException: Lookup error: java.io.StreamCorruptedException: Caught EOFException while reading the stream header; nested exception is: java.io.StreamCorruptedException: Caught EOFException while reading the stream header at com.evermind.server.rmi.RMIContext.lookup(JAX) at com.evermind.naming.ju.lookup(JAX) at javax.naming.InitialContext.lookup(InitialContext.java:350) at TpTestClient.main(TpTestClient.java:38) thanks komal. one requirement java.naming.factory.initial=com.evermind.server.ApplicationClientInitial ContextFactory java.naming.provider.url=ormi://hostname/application-name java.naming.security.principal=username java.naming.security.credentials=password Hi Guys, Iam try to access ejb(it's located other machine)using application. I set up jndi properties like this. java.naming.factory.initial=com.evermind.server.ApplicationClientInitial ContextFactory java.naming.provider.url=ormi://xyz:5000/PreferencePage java.naming.security.principal=admin java.naming.security.credentials=123 when i try excute application iam geting this error. javax.naming.NamingException: Lookup error: java.io.StreamCorruptedException: Caught EOFException while reading the stream header; nested exception is: java.io.StreamCorruptedException: Caught EOFException while reading the stream header at com.evermind.server.rmi.RMIContext.lookup(JAX) at com.evermind.naming.ju.lookup(JAX) at javax.naming.InitialContext.lookup(InitialContext.java:350) at TpTestClient.main(TpTestClient.java:38) anybody will suggest me what wrong iam doing. one requirement java.naming.factory.initial=com.evermind.server.ApplicationClientInitial ContextFactory java.naming.provider.url=ormi://hostname/application-name java.naming.security.principal=username java.naming.security.credentials=password
Java Pet Store 1.1.2 with Cloudscape in Orion 1.5.2
I'm trying to get the Java Pet Store 1.1.2 working with Cloudscape in Orion 1.5.2, and it is failing to get a connection from the datasource in PopulateServlet. I have managed to obtain a connection using the DriverManager, after modifying PopulateServlet. This is the exception which I captured from getDBConnection on datasource.getConnection(): 2001-Aug-21 18:31:05 31145 ERROR [ApplicationServerThread] com.sun.j2ee.bluepri nts.tools.populate.web.PopulateServlet - java.sql.SQLException: The database driver (COM.cloudscape.core.RmiJdbcDriver@31 36e5) returned refusing to connect to the URL jdbc:rmi://localhost:1099/jdbc:clo udscape:CloudscapeDB;create=true at com.evermind.sql.DriverManagerDataSource.getConnection(Unknown Source ) at com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.getDBConne ction(PopulateServlet.java:380) at com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.checkConne ction(PopulateServlet.java:192) at com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.doGet(Popu lateServlet.java:138) at javax.servlet.http.HttpServlet.service(HttpServlet.java:195) at javax.servlet.http.HttpServlet.service(HttpServlet.java:309) at javax.servlet.http.HttpServlet.service(HttpServlet.java:336) at com.evermind._cxb._abe(Unknown Source) at com.evermind._cxb._uec(Unknown Source) at com.evermind._io._twc(Unknown Source) at com.evermind._io._gc(Unknown Source) at com.evermind._if.run(Unknown Source) and this is the line which is failing: if (datasource != null) dbConnection = datasource.getConnection(); Has anyone managed to get jps 1.1.2 working using Cloudscape? What am I missing here? I'm running with jdk1.3.1, the data sources are below. Cloudscape is from j2sdkee1.3 beta 2. data-sources.xml: ?xml version=1.0? !DOCTYPE data-sources PUBLIC Orion data-sources http://www.orionserver.com/dtds/data-sources.dtd; data-sources !-- An example/default DataSource that uses an ordinary JDBC-driver (in this case hsql) to create the connections. This tag creates all the needed kinds of data-sources, transactional, pooled and EJB-aware sources. The source generally used in application code is the EJB one - it provides transactional safety and connection pooling. -- !-- data-source class=com.evermind.sql.DriverManagerDataSource name=Hypersonic location=jdbc/HypersonicCoreDS xa-location=jdbc/xa/HypersonicXADS ejb-location=jdbc/HypersonicDS connection-driver=org.hsql.jdbcDriver username=sa password= url=jdbc:HypersonicSQL:./database/defaultdb inactivity-timeout=30 / -- !-- Java Pet Store - Cloudscape -- data-source class=com.evermind.sql.DriverManagerDataSource name=EstoreDB location=jdbc/EstoreDataSource xa-location=jdbc/xa/EstoreXADS ejb-location=jdbc/EstoreDB connection-driver=COM.cloudscape.core.RmiJdbcDriver username=estoreuser password=estore url=jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB;create=true inactivity-timeout=30 / data-source class=com.evermind.sql.DriverManagerDataSource name=InventoryDB location=jdbc/InventoryDataSource xa-location=jdbc/xa/InventoryXADS ejb-location=jdbc/InventoryDB connection-driver=COM.cloudscape.core.RmiJdbcDriver username=estoreuser password=estore url=jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB;create=true inactivity-timeout=30 / data-source class=com.evermind.sql.DriverManagerDataSource name=SignOnDB location=jdbc/SignOnDataSource xa-location=jdbc/xa/EstoreXADS ejb-location=jdbc/EstoreDB connection-driver=COM.cloudscape.core.RmiJdbcDriver username=estoreuser password=estore url=jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB;create=true inactivity-timeout=30 / /data-sources Thanks Andrew Harris [EMAIL PROTECTED] This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify
Auto-reply: Java Pet Store 1.1.2 with Cloudscape in Orion 1.5.2
Bonjour, En cas d'urgence, vous pouvez contacter mon assistante Stéphanie Vikar. Tél: 01.47.62.23.24 - e-mail:sté[EMAIL PROTECTED] Cordialement, -- Philippe ELINCK Oracle +33 1 47 62 29 28 +33 6 07 34 06 08 [EMAIL PROTECTED] Votre accès privilégié à l'information technologique d'Oracle Your definitive source for Oracle technical information Oracle Technology Network http://technet.oracle.com/ I'm trying to get the Java Pet Store 1.1.2 working with Cloudscape in Orion 1.5.2, and it is failing to get a connection from the datasource in PopulateServlet. I have managed to obtain a connection using the DriverManager, after modifying PopulateServlet. This is the exception which I captured from getDBConnection on datasource.getConnection(): 2001-Aug-21 18:31:05 31145 ERROR [ApplicationServerThread] com.sun.j2ee.bluepri nts.tools.populate.web.PopulateServlet - java.sql.SQLException: The database driver (COM.cloudscape.core.RmiJdbcDriver@31 36e5) returned refusing to connect to the URL jdbc:rmi://localhost:1099/jdbc:clo udscape:CloudscapeDB;create=true at com.evermind.sql.DriverManagerDataSource.getConnection(Unknown Source ) at com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.getDBConne ction(PopulateServlet.java:380) at com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.checkConne ction(PopulateServlet.java:192) at com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.doGet(Popu lateServlet.java:138) at javax.servlet.http.HttpServlet.service(HttpServlet.java:195) at javax.servlet.http.HttpServlet.service(HttpServlet.java:309) at javax.servlet.http.HttpServlet.service(HttpServlet.java:336) at com.evermind._cxb._abe(Unknown Source) at com.evermind._cxb._uec(Unknown Source) at com.evermind._io._twc(Unknown Source) at com.evermind._io._gc(Unknown Source) at com.evermind._if.run(Unknown Source) and this is the line which is failing: if (datasource != null) dbConnection = datasource.getConnection(); Has anyone managed to get jps 1.1.2 working using Cloudscape? What am I missing here? I'm running with jdk1.3.1, the data sources are below. Cloudscape is from j2sdkee1.3 beta 2. data-sources.xml: ?xml version=1.0? !DOCTYPE data-sources PUBLIC Orion data-sources http://www.orionserver.com/dtds/data-sources.dtd; data-sources !-- An example/default DataSource that uses an ordinary JDBC-driver (in this case hsql) to create the connections. This tag creates all the needed kinds of data-sources, transactional, pooled and EJB-aware sources. The source generally used in application code is the EJB one - it provides transactional safety and connection pooling. -- !-- data-source class=com.evermind.sql.DriverManagerDataSource name=Hypersonic location=jdbc/HypersonicCoreDS xa-location=jdbc/xa/HypersonicXADS ejb-location=jdbc/HypersonicDS connection-driver=org.hsql.jdbcDriver username=sa password= url=jdbc:HypersonicSQL:./database/defaultdb inactivity-timeout=30 / -- !-- Java Pet Store - Cloudscape -- data-source class=com.evermind.sql.DriverManagerDataSource name=EstoreDB location=jdbc/EstoreDataSource xa-location=jdbc/xa/EstoreXADS ejb-location=jdbc/EstoreDB connection-driver=COM.cloudscape.core.RmiJdbcDriver username=estoreuser password=estore url=jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB;create=true inactivity-timeout=30 / data-source class=com.evermind.sql.DriverManagerDataSource name=InventoryDB location=jdbc/InventoryDataSource xa-location=jdbc/xa/InventoryXADS ejb-location=jdbc/InventoryDB connection-driver=COM.cloudscape.core.RmiJdbcDriver username=estoreuser password=estore url=jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB;create=true inactivity-timeout=30 / data-source class=com.evermind.sql.DriverManagerDataSource name=SignOnDB location=jdbc/SignOnDataSource xa-location=jdbc/xa/EstoreXADS ejb-location=jdbc/EstoreDB connection-driver=COM.cloudscape.core.RmiJdbcDriver username=estoreuser password=estore url=jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB;create=true inactivity-timeout=30 / /data-sources Thanks Andrew Harris [EMAIL PROTECTED
RE: Java Pet Store 1.1.2 with Cloudscape in Orion 1.5.2
Try to use these: connection-driver=RmiJdbc.RJDriver url=jdbc:rmi://localhost:1099/jdbc:cloudscape:defaultDB I checked it a half a year ago and it worked just fine. (don't forget to change url defaultDB ) -Original Message- From: Harris, Andrew S [SMTP:[EMAIL PROTECTED]] Sent: ? 21 ?? 2001 20:26 To: Orion-Interest Subject:Java Pet Store 1.1.2 with Cloudscape in Orion 1.5.2 I'm trying to get the Java Pet Store 1.1.2 working with Cloudscape in Orion 1.5.2, and it is failing to get a connection from the datasource in PopulateServlet. I have managed to obtain a connection using the DriverManager, after modifying PopulateServlet. This is the exception which I captured from getDBConnection on datasource.getConnection(): 2001-Aug-21 18:31:05 31145 ERROR [ApplicationServerThread] com.sun.j2ee.bluepri nts.tools.populate.web.PopulateServlet - java.sql.SQLException: The database driver (COM.cloudscape.core.RmiJdbcDriver@31 36e5) returned refusing to connect to the URL jdbc:rmi://localhost:1099/jdbc:clo udscape:CloudscapeDB;create=true at com.evermind.sql.DriverManagerDataSource.getConnection(Unknown Source ) at com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.getDBConne ction(PopulateServlet.java:380) at com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.checkConne ction(PopulateServlet.java:192) at com.sun.j2ee.blueprints.tools.populate.web.PopulateServlet.doGet(Popu lateServlet.java:138) at javax.servlet.http.HttpServlet.service(HttpServlet.java:195) at javax.servlet.http.HttpServlet.service(HttpServlet.java:309) at javax.servlet.http.HttpServlet.service(HttpServlet.java:336) at com.evermind._cxb._abe(Unknown Source) at com.evermind._cxb._uec(Unknown Source) at com.evermind._io._twc(Unknown Source) at com.evermind._io._gc(Unknown Source) at com.evermind._if.run(Unknown Source) and this is the line which is failing: if (datasource != null) dbConnection = datasource.getConnection(); Has anyone managed to get jps 1.1.2 working using Cloudscape? What am I missing here? I'm running with jdk1.3.1, the data sources are below. Cloudscape is from j2sdkee1.3 beta 2. data-sources.xml: ?xml version=1.0? !DOCTYPE data-sources PUBLIC Orion data-sources http://www.orionserver.com/dtds/data-sources.dtd; data-sources !-- An example/default DataSource that uses an ordinary JDBC-driver (in this case hsql) to create the connections. This tag creates all the needed kinds of data-sources, transactional, pooled and EJB-aware sources. The source generally used in application code is the EJB one - it provides transactional safety and connection pooling. -- !-- data-source class=com.evermind.sql.DriverManagerDataSource name=Hypersonic location=jdbc/HypersonicCoreDS xa-location=jdbc/xa/HypersonicXADS ejb-location=jdbc/HypersonicDS connection-driver=org.hsql.jdbcDriver username=sa password= url=jdbc:HypersonicSQL:./database/defaultdb inactivity-timeout=30 / -- !-- Java Pet Store - Cloudscape -- data-source class=com.evermind.sql.DriverManagerDataSource name=EstoreDB location=jdbc/EstoreDataSource xa-location=jdbc/xa/EstoreXADS ejb-location=jdbc/EstoreDB connection-driver=COM.cloudscape.core.RmiJdbcDriver username=estoreuser password=estore url=jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB;create=true inactivity-timeout=30 / data-source class=com.evermind.sql.DriverManagerDataSource name=InventoryDB location=jdbc/InventoryDataSource xa-location=jdbc/xa/InventoryXADS ejb-location=jdbc/InventoryDB connection-driver=COM.cloudscape.core.RmiJdbcDriver username=estoreuser
RE: Orion can't find Cloudscape database
this is an example of .bat file for orion cloudscape java -Dcloudscape.system.home=C:\YOUR\DATABASE -Djdbc.connection.debug=true -jar orion.jar -Original Message- From: Lou Farho [SMTP:[EMAIL PROTECTED]] Sent: 14 2001 18:49 To: Orion-Interest Subject: Orion can't find Cloudscape database How do I tell Orion where to find my Cloudscape database? Here is what I have for the data source: data-source class="com.evermind.sql.DriverManagerDataSource" name="Cloudscape" location="jdbc/CloudscapeCoreDS" xa-location="jdbc/xa/CloudscapeXADS" ejb-location="jdbc/myDS" connection-driver="COM.cloudscape.core.JDBCDriver" username="" password="" url="jdbc:cloudscape:myDB" inactivity-timeout="30" / Lou Farho Certes Solutions, Inc. 2485 W MAIN ST SUITE 205 Littleton, CO 80120 303.798.8079 File: Louis Farho.vcf
Re: Orion can't find Cloudscape database
Try putting the cloudscape.jar into the orion\lib directory...it will be able to find it there... --- Lou Farho [EMAIL PROTECTED] wrote: How do I tell Orion where to find my Cloudscape database? Here is what I have for the data source: data-source class=com.evermind.sql.DriverManagerDataSource name=Cloudscape location=jdbc/CloudscapeCoreDS xa-location=jdbc/xa/CloudscapeXADS ejb-location=jdbc/myDS connection-driver=COM.cloudscape.core.JDBCDriver username= password= url=jdbc:cloudscape:myDB inactivity-timeout=30 / Lou Farho Certes Solutions, Inc. 2485 W MAIN ST SUITE 205 Littleton, CO 80120 303.798.8079 BEGIN:VCARD VERSION:2.1 N:Farho;Louis FN:Louis Farho ORG:Certes Solutions TITLE:Consultant ADR;WORK;ENCODING=QUOTED-PRINTABLE:;303.798.8079;2485 W Main St.=0D=0ASuite 205;Littleton;CO;80120 LABEL;WORK;ENCODING=QUOTED-PRINTABLE:303.798.8079=0D=0A2485 W Main St.=0D=0ASuite 205=0D=0ALittleton, CO 80120 URL: URL:http://certes-solutions.com EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20010611T170823Z END:VCARD __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/
Re: Orion can't find Cloudscape database
Iuse Rmi-Jdbc framework to connect to cloudscape. I have RmiJdbc.jar, cloudscape.jar and client.jar in orion/lib directory. my datasource.xml looks like: data-sourceclass="com.evermind.sql.DriverManagerDataSource"name="Cloudscape"location="jdbc/CloudscapeCoreDS"xa-location="jdbc/xa/CloudscapeXADS"ejb-location="jdbc/myDS"connection-driver="COM.cloudscape.core.JDBCDriver"username=""password=""url="jdbc:rmi:jdbc:cloudscape:myDB"inactivity-timeout="30"/ Sergei - Original Message - From: Lou Farho To: Orion-Interest Sent: Thursday, June 14, 2001 7:48 PM Subject: Orion can't find Cloudscape database How do I tell Orion where to find my Cloudscape database? Here is what I have for the data source: data-sourceclass="com.evermind.sql.DriverManagerDataSource"name="Cloudscape"location="jdbc/CloudscapeCoreDS"xa-location="jdbc/xa/CloudscapeXADS"ejb-location="jdbc/myDS"connection-driver="COM.cloudscape.core.JDBCDriver"username=""password=""url="jdbc:cloudscape:myDB"inactivity-timeout="30"/ Lou Farho Certes Solutions, Inc. 2485 W MAIN ST SUITE 205 Littleton, CO 80120 303.798.8079
Orion can't find Cloudscape database
How do I tell Orion where to find my Cloudscape database? Here is what I have for the data source: data-sourceclass="com.evermind.sql.DriverManagerDataSource"name="Cloudscape"location="jdbc/CloudscapeCoreDS"xa-location="jdbc/xa/CloudscapeXADS"ejb-location="jdbc/myDS"connection-driver="COM.cloudscape.core.JDBCDriver"username=""password=""url="jdbc:cloudscape:myDB"inactivity-timeout="30"/ Lou Farho Certes Solutions, Inc. 2485 W MAIN ST SUITE 205 Littleton, CO 80120 303.798.8079 BEGIN:VCARD VERSION:2.1 N:Farho;Louis FN:Louis Farho ORG:Certes Solutions TITLE:Consultant ADR;WORK;ENCODING=QUOTED-PRINTABLE:;303.798.8079;2485 W Main St.=0D=0ASuite 205;Littleton;CO;80120 LABEL;WORK;ENCODING=QUOTED-PRINTABLE:303.798.8079=0D=0A2485 W Main St.=0D=0ASuite 205=0D=0ALittleton, CO 80120 URL: URL:http://certes-solutions.com EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20010611T170823Z END:VCARD
Re: cloudscape database
Nirav Dani wrote: hi, I am using cloudscape database, where do i need to change/mention about it instead of HSQL default? You just need to put the jdbc driver in $ORION_HOME/lib, and change the $ORION_HOME/config/data-sources.xml. Claudio Miranda
Re: cloudscape database
Hi, In order to have Cloudscape embedded in the orion server, I found that I had to amend the data-sources.xml to contain something like the following: data-sources data-source name="CloudscapeSource" class="com.evermind.sql.ConnectionDataSource" location="jdbc/CloudscapeSource" pooled-location="jdbc/DefaultPooledDS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultEJBDS" url="jdbc:cloudscape:insert the location of your DB" connection-driver="COM.cloudscape.core.JDBCDriver" username="" password="" / /data-sources The location of your database can be something like... E:\\Projects\\CloudscapeDB. I am currently working on writing up a paper which will document how to integrate the Cloudscape DB with a number of other application servers, Orion being one of these. The document will eventually be published on the cloudscape website. If you're interested I can let you know when the document gets published :-) Hope this helps, - Linda. Nirav Dani wrote: hi, I am using cloudscape database, where do i need to change/mention about it instead of HSQL default? __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/
Offbeat...Cloudscape
Hello, I know this question doesnot belong here... but any help would be highly appreciated... Can we define a column to be auto increment in Cloudscape database...??? Like if i want to make the id field as auto increment so that I dont have to generate a new id every time and it gets generated automatically. Thanks, Ishpal
Re: Offbeat...Cloudscape
True in case of BMP... But I'm using CMP with the Entity Beans so I myself dont want to write any code and take full advantage of CMP. Ishpal. Magnus Rydin wrote: It doesnt like to good old insert into x (id,something) values ((select max(id)+1 from x),'something') ? -Original Message- From: Ishpal [mailto:[EMAIL PROTECTED]] Sent: den 22 augusti 2000 12:48 To: Orion-Interest Cc: Orion-Interest Subject: Offbeat...Cloudscape Hello, I know this question doesnot belong here... but any help would be highly appreciated... Can we define a column to be auto increment in Cloudscape database...??? Like if i want to make the id field as auto increment so that I dont have to generate a new id every time and it gets generated automatically. Thanks, Ishpal
Re: Trouble with Rmi-Cloudscape from Orion
Hi Ishpal, Have you defined a datasource in datasources.xml that looks something like this? data-source class="com.evermind.sql.DriverManagerDataSource" name="Cloudscape" location="jdbc/CloudscapeCoreDS" xa-location="jdbc/xa/CloudscapeDS" ejb-location="jdbc/CloudscapeDS" connection-driver="RmiJdbc.RJDriver" username="" password="" url="jdbc:rmi://ishpal2:5/jdbc:cloudscape:HelloWorldDB;create=true;autocommit=false" inactivity-timeout="30" schema="database-schemas/cloudscape.xml" / Ishpal wrote: Hi, I'm having trouble connecting to cloudscape database from orion. Using the same driver, host and the port I can connect to the Cloudscape using RmiJdbcDriver from an application running in a different JVM, but when I try the same from orion I get an error like Auto-deploying hello-ejb... SQL error: The database driver (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true Warning: Error creating table: The database driver (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true Its driving me nuts... Is there some kind of setting to be done in some xml file in orion...??? I have to get this thing up or I might be forced to try with other products... please help Ishpal.
Re: Trouble with Rmi-Cloudscape from Orion
Thanks a lot Wim, you got the problem by the hook.. I was using the wrong driver. My application connects to the database with the following code... Class.forName("COM.cloudscape.core.RmiJdbcDriver").newInstance(); Connection conn = DriverManager.getConnection("jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;autocommit=false"); And (now) my datasource in datatsources.xml is as... data-source name="DefaultDS" class="com.evermind.sql.ConnectionDataSource" location="jdbc/DefaultDS" pooled-location="jdbc/DefaultPooledDS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultEJBDS" url="jdbc:rmi://localhost:5/jdbc:cloudscape:HelloWorldDB;autocommit=false" connection-driver="RmiJdbc.RJDriver" inactivity-timeout="20" username="" password="" schema="database-schemas/cloudscape.xml" / The drivers to connect to the database are different , but now I can connect to the database. Thanks (once again). -Ishpal. wim veninga wrote: Hi Ishpal, Have you defined a datasource in datasources.xml that looks something like this? data-source class="com.evermind.sql.DriverManagerDataSource" name="Cloudscape" location="jdbc/CloudscapeCoreDS" xa-location="jdbc/xa/CloudscapeDS" ejb-location="jdbc/CloudscapeDS" connection-driver="RmiJdbc.RJDriver" username="" password="" url="jdbc:rmi://ishpal2:5/jdbc:cloudscape:HelloWorldDB;create=true;autocommit=false" inactivity-timeout="30" schema="database-schemas/cloudscape.xml" / Ishpal wrote: Hi, I'm having trouble connecting to cloudscape database from orion. Using the same driver, host and the port I can connect to the Cloudscape using RmiJdbcDriver from an application running in a different JVM, but when I try the same from orion I get an error like Auto-deploying hello-ejb... SQL error: The database driver (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true Warning: Error creating table: The database driver (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true Its driving me nuts... Is there some kind of setting to be done in some xml file in orion...??? I have to get this thing up or I might be forced to try with other products... please help Ishpal.
Re: Trouble with Rmi-Cloudscape from Orion
Hi Ishpal, Does cloudscape has rmijdbc in cloudscape.jar ? I always use rmijdbc.jar and cloudscape.jar to gether and also the url is different. What version of cloudscape do you use ? Thanks in advance, Greetings Wim Veninga Ishpal wrote: Thanks a lot Wim, you got the problem by the hook.. I was using the wrong driver. My application connects to the database with the following code... Class.forName("COM.cloudscape.core.RmiJdbcDriver").newInstance(); Connection conn = DriverManager.getConnection("jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;autocommit=false"); And (now) my datasource in datatsources.xml is as... data-source name="DefaultDS" class="com.evermind.sql.ConnectionDataSource" location="jdbc/DefaultDS" pooled-location="jdbc/DefaultPooledDS" xa-location="jdbc/xa/DefaultXADS" ejb-location="jdbc/DefaultEJBDS" url="jdbc:rmi://localhost:5/jdbc:cloudscape:HelloWorldDB;autocommit=false" connection-driver="RmiJdbc.RJDriver" inactivity-timeout="20" username="" password="" schema="database-schemas/cloudscape.xml" /> The drivers to connect to the database are different , but now I can connect to the database. Thanks (once again). -Ishpal. wim veninga wrote: > > Hi Ishpal, > > Have you defined a datasource in datasources.xml that looks something like > this? > > data-source > class="com.evermind.sql.DriverManagerDataSource" > name="Cloudscape" > location="jdbc/CloudscapeCoreDS" > xa-location="jdbc/xa/CloudscapeDS" > ejb-location="jdbc/CloudscapeDS" > connection-driver="RmiJdbc.RJDriver" > username="" > password="" > url="jdbc:rmi://ishpal2:5/jdbc:cloudscape:HelloWorldDB;create=true;autocommit=false" > > inactivity-timeout="30" > schema="database-schemas/cloudscape.xml" > /> > > Ishpal wrote: > > > Hi, > > > > I'm having trouble connecting to cloudscape database from orion. > > > > Using the same driver, host and the port I can connect to the Cloudscape > > using RmiJdbcDriver from an application running in a different JVM, but > > when I try the same from orion I get an error like > > > > Auto-deploying hello-ejb... SQL error: The database driver > > (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect > > to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true > > Warning: Error creating table: The database driver > > (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect > > to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true > > > > Its driving me nuts... > > > > Is there some kind of setting to be done in some xml file in orion...??? > > I have to get this thing up or I might be forced to try with other > > products... > > > > please help > > Ishpal.
Re: Orion and Cloudscape
Hi Ishpal, Thanks for the help. I'll try it out later (already have interbase working with orion and interbase is free(opensource since version 6), so the choice is obvious.) Workaround for your error: Use cloudscape with rmijdbc or cloudconnector so you have to start and shutdown the database server and not orion. Ishpal wrote: wim veninga wrote: JavierG wrote: Hi all: Can I make Orion and Clouscape run in the same VM? In that case, how? Wrapping Cloudscape in a servlet and running it within Orion? Any particular measure I should take in that case? All suggestions would be very welcome. Thanks J. Hi Javier, What do you mean with running cloudscape in the same VM. Are you just using cloudscape or do you have a framework (rmijdbc or cloud connector) that you want to run cloudscape in. If you just want to use cloudscape as an embedded db you can use it with orion and run it in the same VM as orion. You have to supply an datasource in datasources.xml and provide a schema for cloudscape and set the cloudscape.system.home property in orion.properties or at the command line when starting orion. Put the cloudscape.jar in the orion/lib directory and the client.jar in the client classpath (for exception etc..) What would be the purpose of wrapping cloudscape in an servlet ? Do you mean that you want to program the acces to the database yourself in the servet? Note I couldn't get cloudscape working with CMP, with BMP there were no problems but with cmp I get an strange error at the client side (object was null but still part of the cache). So if you get cloudscape working with CMP will you please let me know how you did it ? The xml files are supplied as an zip attachment. Hope this helps. Greetings Wim Veninga Name: cloudscapeXML.zip cloudscapeXML.zipType: Zip Compressed Data (application/x-zip-compressed) Encoding: base64 Hello, I can now get Cloudscape running with CMP. You can try the URL as ... url="jdbc:cloudscape:HelloWorldDB;autocommit=false" in the data-sources.xml file... It works pretty cool. The problem now is that when i try to shutdown the server using "admin.jar -shutdown" , the database instance is not shutdown... so next time I get a message like... WARNING: Cloudscape (instance c013800d-00e1-0894-8651-007f0100) is attempting to boot the database /home/ishpal/projects/Cloudscape/system_databases/HelloWorldDB even though cloudscape (instance c013800d-00e1-0880-1eb6-0 Which is scary and I dont want to end up destroying the database... Is there a way I can shutdown the database instance when the server is shutdown Thanks, Ishpal.
Trouble with Rmi-Cloudscape from Orion
Hi, I'm having trouble connecting to cloudscape database from orion. Using the same driver, host and the port I can connect to the Cloudscape using RmiJdbcDriver from an application running in a different JVM, but when I try the same from orion I get an error like Auto-deploying hello-ejb... SQL error: The database driver (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true Warning: Error creating table: The database driver (COM.cloudscape.core.RmiJdbcDriver@bb1928df) returned refused to connect to the URL jdbc:cloudscape:rmi://ishpal2:5/HelloWorldDB;create=true Its driving me nuts... Is there some kind of setting to be done in some xml file in orion...??? I have to get this thing up or I might be forced to try with other products... please help Ishpal.
Re: Orion and Cloudscape
JavierG wrote: Hi all: Can I make Orion and Clouscape run in the same VM? In that case, how? Wrapping Cloudscape in a servlet and running it within Orion? Any particular measure I should take in that case? All suggestions would be very welcome. Thanks J. Hi Javier, What do you mean with running cloudscape in the same VM. Are you just using cloudscape or do you have a framework (rmijdbc or cloud connector) that you want to run cloudscape in. If you just want to use cloudscape as an embedded db you can use it with orion and run it in the same VM as orion. You have to supply an datasource in datasources.xml and provide a schema for cloudscape and set the cloudscape.system.home property in orion.properties or at the command line when starting orion. Put the cloudscape.jar in the orion/lib directory and the client.jar in the client classpath (for exception etc..) What would be the purpose of wrapping cloudscape in an servlet ? Do you mean that you want to program the acces to the database yourself in the servet? Note I couldn't get cloudscape working with CMP, with BMP there were no problems but with cmp I get an strange error at the client side (object was null but still part of the cache). So if you get cloudscape working with CMP will you please let me know how you did it ? The xml files are supplied as an zip attachment. Hope this helps. Greetings Wim Veninga cloudscapeXML.zip
Orion and Cloudscape
Hi all: Can I make Orion and Clouscape run in the same VM? In that case, how? Wrapping Cloudscape in a servlet and running it within Orion? Any particular measure I should take in that case? All suggestions would be very welcome. Thanks J.
anyone have get to run Cloudscape Simple example !!!
Hi, I gave many try to run Cloudscape 3.5 database's "Simple" example on my linux box. here is the detail info. on my profile file and output from cloudscape. Testing for presence of Cloudscape-related libraries for embedded environment. FOUND IN CLASS PATH: Cloudscape primary library (cloudscape.jar or cloudsync.jar) Valid Cloudscape license NOT FOUND IN CLASS PATH: user-specified class (CloudscapeSimfleApp) (CloudscapeSimpleApp not found.) here is my /etc/profile file settings: === # /etc/profile # (c) MandrakeSoft, Chmouel Boudjnah [EMAIL PROTECTED] # Users generally won't see annoyng core files [ "$UID" = "0" ] ulimit -c 100 # System wide environment and startup programs # Functions and aliases go in /etc/bashrc PROFILE_LOADED=1 # Handle by Mandrake Security #PATH="$PATH:/usr/X11R6/bin" # Handle by Mandrake Security #if [ `id -gn` = `id -un` -a `id -u` -gt 14 ]; then # umask 002 #else # umask 022 #fi USER=`id -un` LOGNAME=$USER MAIL="/var/spool/mail/$USER" HOSTNAME=`/bin/hostname` HISTSIZE=1000 if [ -z "$INPUTRC" -a ! -f "$HOME/.inputrc" ]; then export INPUTRC=/etc/inputrc fi export PATH PS1 USER LOGNAME MAIL HOSTNAME HISTSIZE JAVA_HOME=/usr/local/jdk1.3 export JAVA_HOME J2EE_HOME=/usr/local/j2sdkee1.2.1 export J2EE_HOME if [ -x /usr/bin/lesspipe.sh ];then export LESSOPEN="|/usr/bin/lesspipe.sh %s" fi for i in /etc/profile.d/*.sh ; do if [ -x $i ]; then . $i fi done unset i # Mandrake-Security : if you remove this comment, remove the next line too. SECURE_LEVEL=3 # Mandrake-Security : if you remove this comment, remove the next line too. umask 022 # Mandrake-Security : if you remove this comment, remove the next line too. PATH=$PATH:/usr/X11R6.bin:/usr/games:$JAVA_HOME/bin:$J2EE_HOME/bin export PATH SECURE_LEVEL CLOUDSCAPE_INSTALL=/usr/local/j2sdkee1.2.1/cloudscape export CLASSPATH=${CLOUDSCAPE_INSTALL}/lib/cloudscape.jar:${CLOUDSCAPE_INSTALL}/lib/tools.jar:${CLOUDSCAPE_INSTALL}/demo/programs/simple/CloudscapeSimpleApp.class:${CLASSPATH} # Mandrake-Security : if you remove this comment, remove the next line too. export PATH SECURE_LEVEL == Netcenter Help __ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/
Cloudscape database how to????
Hi, I have looked into documentation, in data-sources.xml configuration I have made changes as shown in "How to setup data source". but after that it has been suggested to copy the driver into orion directory. If you have any idea which driver and where it is located please let meknow. another Qestion is where should i install cloudscape? just like HSql under orion folder or somewhere else (like i have installed under /usr/local in my linux box) __ Do You Yahoo!? Get Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/
RE: HOWTO Sun's Java Pet Store Orion 1.0 Cloudscape JDBMS win98
Kirk, I just sent an e-mail to [EMAIL PROTECTED] with a normal e-mail attachment (I am using outlook) and it seemed to work, the stuff even showed up in the e-mail archives on the Orion servers. Hope this helps. Regards, Rob Lapensee Director of Technology Delfour Corporation [EMAIL PROTECTED] www.delfour.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kirk Kalvar Sent: Friday, July 07, 2000 9:59 PM To: Orion-Interest Subject: HOWTO Sun's Java Pet Store Orion 1.0 Cloudscape JDBMS win98 I developed a how to for jps and Orion 1.0 and tried to post it to orion-interest. There was a zip file included in the post so I dont think it made it. What do I need to do to post the how to and zip as an attachment? The zip file contains the Orion configuration files for jps and the updated estore-patched.ear with the orionsecurityadapter included. The howto.txt has detailed instructions on installing jvm, j2ee, Orion (cloudscape) and jps for win98. Would be good for newbies just getting onboard with orion (like me recently). Thanks, Kirk S. Kalvar
RE: HOWTO Sun's Java Pet Store Orion 1.0 Cloudscape JDBMS win98
Seems like a perfect fit for orionsupport.com -Original Message- From: Kirk Kalvar [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 08, 2000 3:09 PM To: Orion-Interest Subject: RE: HOWTO Sun's Java Pet Store Orion 1.0 Cloudscape JDBMS win98 I would be happy to only I'm do not have a public access website. If someone would like to host please contact me. Thanks, Kirk S. Kalvar -Original Message- From: Raphael Gillett [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 08, 2000 2:47 PM To: [EMAIL PROTECTED] Subject: Re: HOWTO Sun's Java Pet Store Orion 1.0 Cloudscape JDBMS win98 Kirk, Simply provide a link to your website. Very nice of you to do this. Thank you. Raphael Gillett Kirk Kalvar wrote: I developed a how to for jps and Orion 1.0 and tried to post it to orion-interest.There was a zip file included in the post so I don't think it made it.What do I need to do to post the how to and zip as an attachment? The zip file contains the Orion configuration files for jps and the updated estore-patched.ear with the orionsecurityadapter included.The howto.txt has detailed instructions on installing jvm, j2ee, Orion (cloudscape) and jps for win98. Would be good for newbies just getting onboard with orion (like me recently). Thanks, Kirk S. Kalvar
HOWTO Sun's Java Pet Store Orion 1.0 Cloudscape JDBMS win98
I developed a how to for jps and Orion 1.0 and tried to post it to orion-interest. There was a zip file included in the post so I dont think it made it. What do I need to do to post the how to and zip as an attachment? The zip file contains the Orion configuration files for jps and the updated estore-patched.ear with the orionsecurityadapter included. The howto.txt has detailed instructions on installing jvm, j2ee, Orion (cloudscape) and jps for win98. Would be good for newbies just getting onboard with orion (like me recently). Thanks, Kirk S. Kalvar
HOWTO PetStore and Cloudscape
For anyone interested. Thanks to Earl Marwil for pointing out the dual data source. cp jps1.0/database.sql/cloudscape.sql J2EE_HOME/doc/guides/ejb/examples/util cd J2EE_HOME/doc/guides/ejb/examples/util cloudij run cloudscape.sql; exit; cloudscape start cp J2EE_HOME/lib/cloudscape/* orion/lib/ orion/config/data-sources.xml data-sources data-source name=JPS EStore data-source class=com.evermind.sql.ConnectionDataSource location=jdbc/EstoreDataSource pooled-location=jdbc/EStorePooledDS xa-location=jdbc/xa/EStoreXADS ejb-location=jdbc/EStoreEJBDS url=jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB\ connection-driver=RmiJdbc.RJDriver username= password= / data-source name=JPS Inventory data-source class=com.evermind.sql.ConnectionDataSource location=jdbc/InventoryDataSource pooled-location=jdbc/InventoryPooledDS xa-location=jdbc/xa/InventoryXADS ejb-location=jdbc/InventoryEJBDS url=jdbc:rmi://localhost:1099/jdbc:cloudscape:CloudscapeDB\ connection-driver=RmiJdbc.RJDriver username= password= / /data-sources database is physically located in J2EE_HOME/cloudscape/CloudscapeDB Kirk S. Kalvar