On 14 Jun, Rickard �berg wrote:
> Hi!
>
> Heiko Seebach wrote:
>> Right now I downloaded the newest binary version, and deploying works fine
>> :-) , but when I let JAWS CMP access a table, it says "table not found" (see
>> below) and the stacktrace shows "org.hsql.jdbcConnection.executeHSQL..." So
>> it's trying to access a HyperSonic table; it should use "oracle.jdbc...."
>> My question: How can I tell JAWS to use one DataSource for one CMP
>> EntitityBean, and another DataSource for another CMP EntitityBean?
>
> Currently this is only possible if you deploy two jars since the
> DataSource setting in JAWS applies to the entire jar.
>
> However...
>
>> in jaws.xml:
>> <datasource>OracleDB</datasource>
>> <type-mapping>Oracle</type-mapping>
>>
>> in jboss.conf:
>> <MLET CODE = "org.jboss.jdbc.DataSourceImpl"
>> ARCHIVE="jboss.jar,classes12.zip" CODEBASE="../lib/ext/">
>> <ARG TYPE="java.lang.String" VALUE="jdbc:oracle:thin:@myhost:1521:prod">
>> <ARG TYPE="java.lang.String" VALUE="OracleDB">
>> <ARG TYPE="java.lang.String" VALUE="oracle.jdbc.driver.OracleDriver">
>> <ARG TYPE="java.lang.String" VALUE="user">
>> <ARG TYPE="java.lang.String" VALUE="password">
>> </MLET>
>
> .. this looks right to me. I don't know what's going on here.. anyone
> else knows?
>
> /Rickard
>
I think you should perhaps look at bug no 86 which may be what is
causing trouble. It depends on where you place the datasource entry in
the jaws file if I remember correctly. To work smothly you will have to
place the <datasource> at the top of the file, and the <type-mapping> in
the bottoms. Seems as for the datasource a default pulls in, and in the
type-mapping case, the parser thinks it is parsing a mapping entry for a
specific database.
Greetings
Peter
--
------------------------------------------------------------
Peter Antman Technology in Media, Box 34105 100 26 Stockholm
Systems Architect WWW: http://www.tim.se
Email: [EMAIL PROTECTED] WWW: http://www.backsource.org
Phone: +46-(0)8-506 381 11 Mobile: 070-675 3942
------------------------------------------------------------
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
