Re: Microsoft JDBC Driver - Issues w/ Data Source

[Morten Wilken]

hi geoff... i think that the jar files for the driver is corrupt somehow...
i solved the problem by unzipping them and voila it worked

also remember to set the correct database schema in the datasource

sincerely
morten wilken
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Orion-Interest" <[EMAIL PROTECTED]>
Sent: 16. november 2001 17:25
Subject: Microsoft JDBC Driver - Issues w/ Data Source


> I'm having some issues with using the Microsoft SQL Server JDBC Driver
with
> Orion.
>
> Let me give you some context:
>
> Although I have some past experience with Orion (servlets, beans, jsp),
I've
> never used its Data Sources, so I know next to nothing about them.  And,
> although the community and documentation have improved of late, Orion's
> documentation is still pretty sparse.  When it came time to spend some
time
> with EJB, I moved over to JBoss, which has stronger documentation, for a
> while, and while on JBoss, I started making use of the Microsoft SQL
Server
> driver beta, which has proved to be quite reasonable (which is not too
> surprising, since it's the Merant driver).
>
> Due to some performance issues, I wanted to see how the application we're
> working on would run under Orion, so I downloaded the latest, and started
to
> try and configure it.  The basic steps were still pretty easy, but now I'm
> stuck on the data source - no matter what I do, I can't seem to get Orion
to
> recognize the SQL Server driver.
>
> Has anyone tried it yet?  Am I missing something obvious?
>
> I put the driver JARs (three of them: msbase, msutil, mssqlserver) in
> orion/lib.  I modified the data-sources.xml to use the driver, as follows:
> 
> name="MicrosoftSqlServer"
>
> location="jdbc/SqlServerDS"
>
>
> connection-driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
>
>
url="jdbc:microsoft:sqlserver://panthro:1433;DatabaseName=dbVoicenetDevGeoff
> ;SelectMethod=cursor"
> username="user"
> password="password"
>
> inactivity-timeout="30"
> class="com.evermind.sql.DriverManagerDataSource"
>
> />
>
> When orion starts, it says the following:
> Error initializing data-source 'jdbc/SqlServerDS': DriverManagerDataSource
> driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' not found
>
> What does this mean?  It can't find the driver?  The JARs are in orion
lib,
> I've checked that several times, including that the driver name is right,
> and the class is in the JAR.  I can't swear that Orion is loading the
JARs,
> because it doesn't put that out to the console or log files, so I don't
> really know that it's doing that, but I'm assuming it is.
>
> It does say 'DriverManagerdataSource driver', so perhaps the driver isn't
> what it's expecting.  Should I be using another class?  Based on the
> descriptions in the API docs and the Hypersonic example, this seems like a
> reasonable class to use.
>
> Suggestions?  Anyone know where I can go from here?
>
> Thanks,
>
> - Geoffrey Wiseman
>
> __
> Geoffrey Wiseman: Internet Applications Manager
> Medium One
> t. 416.977.2101 x. 529
> http://www.mediumone.com/
> __
> Think it.  Build it.  Work it.
>
>
>
>

Re[2]: EJB pool management

[Sergey G. Aslanov]

TK> If your EJB is not the only thing that will be updating a table then you
TK> have to deploy the ejb with "exclusive-write-access=false" in the
TK> orion-ejb-jar.xml.  Checkout the documentation on the orion-ejb-jar.xml at
TK> http://www.orionserver.com/docs/orion-ejb-jar.xml.html
TK>  .  This basically
TK> turns off caching off the EJB.

Thank you for answer, but I don't want to turn off caching. I need
exactly to manage it. EJB caching is rather usefull feature and I
don't want to refuse completely from using it.

TK> -Original Message-
TK> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
TK> Sent: Friday, November 16, 2001 11:07 AM
TK> To: Orion-Interest
TK> Subject: RE: EJB pool management



TK> I am sure there is a way, it is just not documented as the orionconsole.jar 
TK> has provisions for invalidating the pools, and adjusting their sizes. 

TK> it will probably be an ormi: call of some sort? 

TK> -Original Message- 
TK> From: Sergey G. Aslanov [ mailto:[EMAIL PROTECTED]
TK>  ] 
TK> Sent: Friday, November 16, 2001 6:38 AM 
TK> To: Orion-Interest 
TK> Subject: EJB pool management 


TK> Hi all 

TK>   Who knows, can I manage Orion's EJB instances pool from code? For example,

TK>   if data in DBMS was changed without help of EJB and I want to update 
TK>   it in pool. What have I to do? 




-- 
Sergey G. Aslanov
CBOSS Group,
Web-technologies department
mailto:[EMAIL PROTECTED]
tel: +7 095 7555655

look up name to find server transaction manager is needed

[patrick patrick]

Dear all,

I couldn't find the server transaction
manager. if any one can tell me the look up name thru
which we can get the trasaction manager.. it will be
very helpful to me..

Thanking you

patrick

__
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com

Re: Response has been already committed...

[Lachezar Dobrev]

   Hello.
   Number one. That happens, if you try to "sendRedirect" in the body of the
JSP. However the JSP is parsed to a Servlet, and it writes the JSP's body to
the output stream. The problem is, that when the sendRedirect is found later
in the body the output of the Servlet can become quite large, and the
servlet's output is flushed, because the buffer is overrun.

   Solution One (not tested): at the start of the JSP put: <%@ page
buffer="65kb" %>
 That is temporary solution. If you try to redirect after this buffer is
full, you will get the exception again.

   Solution Two (my favorite): At the start of the JSP do whatever work is
needed. That way normally you will not have sent any data and there will
still be possibility to "sendRedirect".

   Solution Three (my current): Use the JSP to display data only. All work
should be done in a Servlet, that does not write anything, but only does
work, and then "sendRedirect"s to the JSP. This is quite flexible.

   Solution Four (ugly, but works): If your JSP ALWAYS redirects to the
other location (no ifs, no cases), and your JSP produces HTML, than you can
always put in the html a  tag to make the redirect.

  


   You may think of more solutions, but it IS normal to receive that
exception. You can not expect Orion to buffer ALL the output of a jsp,
right?

   Lachezar.



> Hello all,
>
> I have a JSP, that processes a form and is attempting to create a record
in my database via CMP EJB (Person). After my form
> has been processed and the PersonHome.create() methods has succeeded
(record has been created), the page tries to
> redirect to another JSP. But this doesn't work; instead i receive an
exception:
>
> java.lang.IllegalStateException: Response has already been committed, be
sure not to write to the OutputStream or to trigger a
> commit due to any other action before calling this method.
>  at com.evermind[Orion/1.5.2 (build
10460)].server.http.EvermindHttpServletResponse.sendRedirect(Unknown Source)
>  at /department.jsp._jspService(/department.jsp.java:54) (JSP page line
19)
>  at com.orionserver[Orion/1.5.2 (build
10460)].http.OrionHttpJspPage.service(Unknown Source)
>  at com.evermind[Orion/1.5.2 (build 10460)]._ah._rad(Unknown Source)
>  at com.evermind[Orion/1.5.2 (build
10460)].server.http.JSPServlet.service(Unknown Source)
>  at com.evermind[Orion/1.5.2 (build 10460)]._cxb._abe(Unknown Source)
>  at com.evermind[Orion/1.5.2 (build 10460)]._cxb._uec(Unknown Source)
>  at com.evermind[Orion/1.5.2 (build 10460)]._io._twc(Unknown Source)
>  at com.evermind[Orion/1.5.2 (build 10460)]._io._gc(Unknown Source)
>  at com.evermind[Orion/1.5.2 (build 10460)]._if.run(Unknown Source)
>
> without PersonHome.create() or response.sendRedirect() everything works
fine (it works fine with either, but not with both).
> What is going on? What am I doing wrong?

RE: Microsoft JDBC Driver - Issues w/ Data Source

[Arjen Schoneveld]

All,
 
We have been using Orion & MS-SQL server successfully in a project.
The JDBC driver we are using is called Opta2000 (see
http://www.inetsoftware.de).
Here's an excerpt from our data-sources.xml:
 
 

We've had no troubles so far.
 
Regards,
Arjen Schoneveld
--
Dexels BV
The Netherlands
 

-Oorspronkelijk bericht- Van: Mitesh Pancholy 
Verzonden: za 17-11-2001 0:29 
Aan: Orion-Interest 
CC: 
Onderwerp: Re: Microsoft JDBC Driver - Issues w/ Data Source



Geoff,

Orion & SQLServer = = bad combo, you will learn through
suffering as we have
:) What you need to do is to unzip the contents of the jar file
under the
lib folder, and you did reference all 3 files in the class path
right. Also
use the orion data source, don't use the msft source.
So your data-source.xml should look like this.
 

RANT: The people who are using Orion & Ms SQL Server need to
start putting
more knowledge on the list. I'll take the lead with some stuff,
but people
also need to contribute :)

- Original Message -
From: <[EMAIL PROTECTED]>
To: "Orion-Interest" <[EMAIL PROTECTED]>
Sent: Friday, November 16, 2001 8:25 AM
Subject: Microsoft JDBC Driver - Issues w/ Data Source


> I'm having some issues with using the Microsoft SQL Server
JDBC Driver
with
> Orion.
>
> Let me give you some context:
>
> Although I have some past experience with Orion (servlets,
beans, jsp),
I've
> never used its Data Sources, so I know next to nothing about
them.  And,
> although the community and documentation have improved of
late, Orion's
> documentation is still pretty sparse.  When it came time to
spend some
time
> with EJB, I moved over to JBoss, which has stronger
documentation, for a
> while, and while on JBoss, I started making use of the
Microsoft SQL
Server
> driver beta, which has proved to be quite reasonable (which is
not too
> surprising, since it's the Merant driver).
>
> Due to some performance issues, I wanted to see how the
application we're
> working on would run under Orion, so I downloaded the latest,
and started
to
> try and configure it.  The basic steps were still pretty easy,
but now I'm
> stuck on the data source - no matter what I do, I can't seem
to get Orion
to
> recognize the SQL Server driver.
>
> Has anyone tried it yet?  Am I missing something obvious?
>
> I put the driver JARs (three of them: msbase, msutil,
mssqlserver) in
> orion/lib.  I modified the data-sources.xml to use the driver,
as follows:
> 
> name="MicrosoftSqlServer"
>
> location="jdbc/SqlServerDS"
>
>
>
connection-driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
>
>

url="jdbc:microsoft:sqlserver://panthro:1433;DatabaseName=dbVoicenetDevG
eoff
> ;SelectMethod=cursor"
> username="user"
> password="password"
>
> inactivity-timeout="30"
> class="com.evermind.sql.DriverManagerDataSource"
>
> />
>
> When orion starts, it says the following:
> Error initializing data-source 'jdbc/SqlServerDS':
DriverManagerDataSource
> driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' not
found
>
> What does this mean?  It can't find the driver?  The JARs are
in orion
lib,
> I've checked that several times, including that the driver
name is right,
> and the class is in the JAR.  I can't swear that Orion is
loading the
JARs,
> because it doesn't put that out to the console or log files,
so I don't
> really know that it's doing that, but I'm assuming it is.
>
> It does say 'DriverManagerdataSource driver', so perhaps the
driver isn't
> what it's expecting.  Should I be using another class?  Based
on the
> descriptions in the API docs and the Hypersonic example, this
seems like a
> reasonable class to use.
>
> Suggestions?  Anyone know where I can go from here?
>
> Thanks,
>
> - Geoffrey Wiseman
>
> __
> Geoffrey Wiseman: Internet Applications Manager
> Medium One
> t. 416.977.2101 x. 529
> http://www.mediumone.com/
> __
> Think it.  Build it.  Work it.
>