Re: sql problems wth JTDS and SQL Server

Jakob Braeuchi Sun, 15 May 2005 08:52:47 -0700

hi bartolomiej,

i do not have a ms-sqlserver here. could you please try the sql-select on a completely up-to-date ms-sqlserver ?

jakob

Bartłomiej Knabel schrieb:

Hi Jakob,

JB> i mean did you enter the select in a gui-application that calls JB> ms-sqlserver ?

it was SQL Querry analyzer

JB> i would like to know which column alias caused the JB> problem because the query looks ok to me. (except 'zp_czznd', is this an JB> indirection table ?)

zp_czznd is an indirection table.

this is full SQL script, whitch generates sql database :

drop table ZestawZlozony;
drop table CzescZlozona;
drop table CzescAtomowa;
drop table ElementProjektowy;
drop table Dokument;
drop table Modul;
drop table Polaczenie;
drop table Manual;
drop table ZestawPodstawowy;
drop table zp_czznd;
drop table zp_czzd;
drop table Parametry;

create table Parametry ( par_id integer not null identity, par_IloscCzANaCzZ integer, par_IloscPolaczenNaAtom integer, par_DlugoscDokumentu integer, par_DlugoscManuala integer, par_IloscCzZlozNaModul integer, par_IloscZestWZestZl integer, par_IloscPoziomow integer, par_IloscCzZWZestPdst integer, par_IloscModulow integer, primary key (par_id) );

create table Dokument (
   dok_id integer not null identity,
   dok_czzId integer,
   dok_tekst text null,
   dok_tytul varchar(40),
   primary key (dok_id)
);

create table Manual (
   man_id integer not null identity,
   man_tytul varchar(40),
   man_tekst text null,
   man_dlTekstu integer not null,
   man_modId integer,
   primary key (man_id)
);
create table Polaczenie (
   pol_id integer not null identity,
   pol_dlugosc integer not null,
   pol_typ varchar(10),
   polZAtomowej integer,
   polDoAtomowej integer,
   primary key (pol_id)
);
create table ElementProjektowy (
   ep_id integer not null identity,
   ep_typ varchar(10),
   ep_data datetime not null,
   primary key (ep_id)
);

create table CzescAtomowa (
   cza_id integer not null ,
   cza_x integer not null,
   cza_y integer not null,
   cza_dokId integer not null,
   cza_czId integer,
   primary key (cza_id)
);
create table CzescZlozona (
   czz_id integer not null ,
   czz_glAtid integer not null,
   czz_dokId integer not null,
   primary key (czz_id)
);
create table Modul (
   mod_id integer not null ,
   mod_manId integer,
   mod_zzId integer,
   primary key (mod_id)
);

create table ZestawPodstawowy (
   zp_id integer not null,
   zp_zz_id integer,
   primary key (zp_id)
);

create table ZestawZlozony (
   zz_id integer not null,
   zz_modId integer,
   zz_zz_id integer,
   primary key (zz_id)
);

create table zp_czzd (
   czz_zp_zpIdd integer not null,
   czz_zp_czpIdd integer not null
);

create table zp_czznd (
   czz_zp_zpIdnd integer not null,
   czz_zp_czpIdnd integer not null
);

create index IndexDokumentTytul on Dokument (dok_tytul);
create index IndexCzaDokId on CzescAtomowa (cza_dokId);


now You can generate my database and chceck it.

Maybye I dont have some SP? I use just SP3 for SQL Server 200, but I
didin't install SP1 and SP2...


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: sql problems wth JTDS and SQL Server

Reply via email to