Re: SQL Server - Autoincrement Primary Keys

2000-11-14 Thread Shayne Hughes
I'd be interested to hear what others think of this method of using MSSQL's autoincrement type as PK. I have tried this and it seems to work in simple tests. Yeah it's not portable and probably breaks several rules. For this table... CREATE TABLE [dbo].[Lab] ( [LabID] [int] IDENTITY (1, 1) NOT

Re: database connectivity

2000-08-31 Thread Shayne Hughes
I think you need to change the url line to add the port number...   url="jdbc:inetdae:localhost:1433?database=dBTest"   Shayne   - Original Message - From: Derek Akers To: Orion-Interest Sent: Thursday, August 31, 2000 7:52 AM Subject: database connectivity I am

Re: client jars

2000-04-19 Thread Shayne Hughes
I'd like to know the answer to this one also... - Original Message - From: "Robert Krüger" <[EMAIL PROTECTED]> To: "Orion-Interest" <[EMAIL PROTECTED]> Sent: Wednesday, April 19, 2000 5:33 AM Subject: client jars > > hi, > > are there plans to ship a minimal client.jar file with orion t

Re: CMP and Identity columns

2000-04-08 Thread Shayne Hughes
. > You have to create the primary key within Java. > > Anyone else? > > Mike > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of Shayne Hughes > > Sent: Saturday, 8 April 2000 9:38 > > To: Orion-In

CMP and Identity columns

2000-04-07 Thread Shayne Hughes
I have a table on Microsoft SQL Server that has an identity column such as... CREATE TABLE MyTable ( id int IDENTITY (1, 1) PRIMARY KEY NOT NULL , Name varchar (255) NULL ) I'd like to create a CMP EJB for this table. Is it possible to instruct Orion to not specify a value for the "id" field

Re: Mysterious Hang

2000-02-05 Thread Shayne Hughes
I've seen something very similar (maybe identical), but I wrote it off to my being an EJB newbie. I was using the Cart example and modified the source code to create and destroy ejbs as fast as possible. It ranged from around 100 to 700 creates before it would hang. I didn't have the restart th