Hi Ashesh,
This is curious. I was able to get it running on JBoss v2.1 and the same
settings also worked fine with JBoss 2.3 BETA. I didnt have time to build
and test JBoss 2.2 as well. I have attached the config info that worked for
me with both JBoss 2.1 and JBoss 2.3 BETA.
Hope this hepls you to get started as well. Points to check:
1) Double-check that you have the Sprinta2000.jar file in the
%JBOSS_HOME%/lib/ext direct of the *correct* JBoss installation. I have a
few installation and I sometimes get caught out with this one.
2) Double-check that the servername, databasename, portno (and sql7 if you
are using MSSQL7 or MSSQL2K) in your environment. Use another tool to
connect to the database using the same credentials as a sanity check.
3) I missed your original comment below about adding the Sprinta2000.jar
file to the CLASSPATH in run.bat. This is not neccessary. Please remove this
change to the run.bat file. In fact if at all possible, try to exclude your
system CLASSPATH when running JBoss. The distribution is self-contained and
has all the files it needs to run except additional files like your JDBC
driver. Once these are added to %JBOSS_HOME%/lib/ext you are OK.
I have attached the working run.bat as well as the jboss.jcml for
comparison.
Cheers!,
Kunle
----- Original Message -----
From: "Ashesh Sheth" <[EMAIL PROTECTED]>
To: "'Kunle Odutola'" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 3:20 PM
Subject: RE: Problem with SQLServer configuration....(need help)
> Thanks Kunle for your interest and concerns.
> I am still struggling with the ConnectionPool to work on
jboss(v2.1).I
> don't know i have done all the things according to documetnation.But
> somewhere i am missing something which i am not able to figure it out...
<SNIP>
>
> -----Original Message-----
> From: Kunle Odutola [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 4:08 AM
> To: [EMAIL PROTECTED]
> Subject: Fw: Problem with SQLServer configuration....(need help)
>
>
> Hi Ashesh,
>
> How did you get on with your Connection problems?. If you have been able
to
> resolve them I would appreciate a note from you about what the problem was
> and how you eventually resolved it. Also a copy of the settings that
> eventually worked for you.
>
> If your setup is still not working then, you may want to send me your
> JBoss settings and I'll see if I can get it working.
> I'll like to include the info about getting Sprinta working with JBoss in
> the docs if I can.
>
> Thanks
>
> Kunle
>
>
> ----- Original Message -----
> From: "Ashesh Sheth" <[EMAIL PROTECTED]>
> To: "'Kunle Odutola'" <[EMAIL PROTECTED]>
> Sent: Monday, April 02, 2001 4:52 PM
> Subject: RE: Problem with SQLServer configuration....(need help)
>
>
> > Thanks,
> > For your response.Well i guess u are right about the Driver problem!
> But
> > still i am strugling for the ConnectionPool setup with jBoss and
> SQLServer.
> > AS the ur points...
> > 1.> ya i have copied the Sprinta2000.jar file to the lib directory.And
> also
> > added to classpath of jboss\bin\run.bat file to take effect. So driver
> loads
> > fine.
>
> <SNIP>
>
>
SprintaJDBC.zip
