Thanks Magnus. It work now. I needed to "save and close" .xml and .inf
files and
restart orion in order to create required tables.
Could you precise how orion is scanning or checking .xml and .inf files ?
Regards, bernard
On Fri, Oct 29, 1999, Magnus Stenman <[EMAIL PROTECTED]> wrote:
>Put hsql.jar in /jre/lib/ext instead (as an extension), the system
classpath is
>not used when using the -jar command (and it doesnt auto-include jars in
a dir,
>you need to explicitly name the jar(s)).
>
>Hope it helps :)
>
>/Magnus Stenman, the Orion team
>
>----- Original Message -----
>From: Bernard Sauterel <[EMAIL PROTECTED]>
>To: Magnus Stenman <[EMAIL PROTECTED]>
>Sent: Friday, October 29, 1999 6:14 PM
>Subject: Re: ejb examples
>
>
>> Hello,
>>
>> I added Hypersonic class files into "../orion/lib/hSql", then added
>> "../orion/lib"
>> to my system classpath, but I still have the problem.
>>
>> I'm using Windows NT 4, Sun JDK 1.2.1
>>
>> Please let me know what I should check.
>>
>> Best regards, Bernard Sauterel.
>>
>> On Fri, Oct 29, 1999, Magnus Stenman <[EMAIL PROTECTED]> wrote:
>>
>> >Hi,
>> >I'd blame JDBC for that one, JDBC is pretty quirky about drivers, and as a
>> >result you need to have hypersonic's driver
>> >in the system classpath (instead of in Orion's lib path). The reason is
>that
>> >JDBC ignores drivers in "children" classloaders (claims to do so as a
>> security
>> >meassure) regardless of who registered it. So: the registration is fine
>> (hence
>> >no error message),
>> >but when you try to get a Connection instance the DriverManager doesnt
>query
>> >the Hypersonic source (due to the caller ClassLoader).
>> >
>> >Hope that clears things up, we're considering circumviening the
>DriverManager
>> >altogether to solve this problem in the future (this is one of the most
>> common
>> >"gotcha's" in the setup).
>> >
>> >Have a nice day! :)
>> >
>> >/Magnus Stenman, the Orion team
>> >
>> >----- Original Message -----
>> >From: Bernard Sauterel <[EMAIL PROTECTED]>
>> >To: <[EMAIL PROTECTED]>
>> >Sent: Friday, October 29, 1999 2:44 PM
>> >Subject: ejb examples
>> >
>> >
>> >> Hi.
>> >>
>> >> Trying to use your "Useless news" example.
>> >>
>> >> I get the following error message when connecting to ".../news" url:
>> >>
>> >> 500 Internal Server Error
>> >>
>> >> javax.ejb.EJBException: Database error: No suitable driver
>> >> at EntityHomeWrapper1.findByContent(Compiled Code)
>> >> at __jspPage3._jspService(Compiled Code)
>> >> at com.evermind.server.http.EvermindHttpJspPage.service(JAX)
>> >> at com.evermind.server.http.HttpApplication.lv(JAX)
>> >> at com.evermind.server.http.JSPServlet.service(JAX)
>> >> at cu.it(JAX)
>> >> at cu.forward(JAX)
>> >> at c4.kr(Compiled Code)
>> >> at c.run(Compiled Code)
>> >>
>> >> Some points:
>> >> - I think classpath to Hypersonic is ok at least for server (otherwise I
>> >> will
>> >> got an error message on startup).
>> >> - Do I needs to add class-path to Hypersonic on others configuration
>> >> files ?
>> >> - Do I needs to create manually a Hypersonic database, and add required
>> >> tables ?
>> >>
>> >> Below are my data-sources.xml and orion-ejb-jar.xml configuration file:
>> >>
>> >> orion-ejb-jar.xml
>> >>
>> >> <orion-ejb-jar>
>> >> <deployment-version>0.7.9</deployment-version>
>> >> <enterprise-beans>
>> >> <entity>
>> >> <data-source-name>/jdbc/xa/DefaultXADS</data-source-name>
>> >> ...
>> >>
>> >> data-sources.xml:
>> >>
>> >> <data-sources>
>> >> <data-source class="com.evermind.sql.ConnectionDataSource"
>> >> location="/jdbc/DefaultDS">
>> >> <name>Default data-source</name>
>> >> <description>
>> >> Hypersonic SQL source.
>> >> </description>
>> >> <url>jdbc:HypersonicSQL:defaultdb</url>
>> >> <connection-driver>hSql.hDriver</connection-driver>
>> >> <username>sa</username>
>> >> <password></password>
>> >> </data-source>
>> >> <data-source class="com.evermind.sql.DefaultConnectionPoolDataSource"
>> >> location="/jdbc/DefaultPooledDS">
>> >> <name>Default ConnectionPool data-source</name>-
>> >> <description></description>
>> >> <source-location>/jdbc/DefaultDS</source-location>
>> >> <username>sa</username>
>> >> <password></password>
>> >> </data-source>
>> >> <data-source class="com.evermind.sql.DefaultXADataSource"
>> >> location="/jdbc/xa/DefaultXADS">
>> >> <name>Default Transactional data-source</name>
>> >> <description></description>
>> >> <source-location>/jdbc/DefaultDS</source-location>
>> >> <username>sa</username>
>> >> <password></password>
>> >> </data-source>
>> >> <data-source class="com.evermind.server.ejb.EJBDataSource"
>> >> location="/jdbc/DefaultEJBDS">
>> >> <name>Default EJB-aware data-source</name>
>> >> <description></description>
>> >> <source-location>/jdbc/xa/DefaultXADS</source-location>
>> >> <username>sa</username>
>> >> <password></password>
>> >> </data-source>
>> >> </data-sources>
>> >
>>
>>
>> --
>> Bernard Sauterel
>> ----------------
>> [EMAIL PROTECTED]
>> +41 78 6044334
>
--
Bernard Sauterel
----------------
[EMAIL PROTECTED]
+41 78 6044334
