Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 43277 invoked from network); 5 Mar 2008 22:20:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 5 Mar 2008 22:20:16 -0000 Received: (qmail 737 invoked by uid 500); 5 Mar 2008 22:20:10 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 715 invoked by uid 500); 5 Mar 2008 22:20:10 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 704 invoked by uid 99); 5 Mar 2008 22:20:10 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Mar 2008 14:20:10 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of nathan.maves@gmail.com designates 72.14.246.243 as permitted sender) Received: from [72.14.246.243] (HELO ag-out-0708.google.com) (72.14.246.243) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Mar 2008 22:19:33 +0000 Received: by ag-out-0708.google.com with SMTP id 35so2396508aga.11 for ; Wed, 05 Mar 2008 14:19:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; bh=Ui0wOE27YLpGb6AcDRNgzoj+zfBHC5DjP/vS3fF7fa4=; b=ilWic2X1zGeUYLKrLu7TeuLSYIGcLuONarmcEcec6j4x+B/b5OMJ8iV12+WcXg/GPabPoZowMp++kYXHZ9MEi4n2TaMacJkb0oAp2BI9sRXSZkl2IG72BKw8oEbHulG/0YgX0KaMOMI2r/v8msuNN/VvipizmIKr6vjxQkVsysc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=Fjz5Ap334niRYexWn8d6HA9+CkUmnlUP6av7926qtkLu2sogoUxRZEMY3W4gRRjP09BPHVQQD3rMSfAYlWGYe5bhkNx1klRavfYKNt/dKLMpTqp6XjOQqdsUosUUiQ8GGGHhZ+BQu9oUb3xQJklnDsoorGU+g11kPsEZ8oSmP1s= Received: by 10.150.91.20 with SMTP id o20mr1524721ybb.24.1204755571505; Wed, 05 Mar 2008 14:19:31 -0800 (PST) Received: by 10.150.152.15 with HTTP; Wed, 5 Mar 2008 14:19:31 -0800 (PST) Message-ID: <2f55db670803051419w44208b05t43462bd04fda2a00@mail.gmail.com> Date: Wed, 5 Mar 2008 15:19:31 -0700 From: "Nathan Maves" To: user-java@ibatis.apache.org Subject: Re: Need Help in iBatis Configuration In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_18515_17908346.1204755571573" References: <47cf052d.27ba720a.3a2a.ffffc5ff@mx.google.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_18515_17908346.1204755571573 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline my first guess would be hmmmm Oracle! if that one missed you, one might try http://www.google.com/search?q=oracle+driver+for+java On Wed, Mar 5, 2008 at 3:15 PM, Angso, Tony wrote: > Am getting this now > Error while loading properties. Cause: > java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver > > Where can I get the Oracle Driver? > > -----Original Message----- > From: Clinton Begin [mailto:clinton.begin@gmail.com] > Sent: Wednesday, March 05, 2008 3:40 PM > To: user-java@ibatis.apache.org > Subject: RE: Need Help in iBatis Configuration > > > Wow, sorry for such a horribly unhelpful error! That exception is > thrown if any of these keys are missing, not simply null, but completely > missing. > > > value="${jdbc.url.alpha}"/> > > > > But they are indeed there... so I'm confused too, as it should > succeed...? > > Is there any chance this is the wrong XML configuration file that's > being loaded? > > Clinton > > > -----Original Message----- > From: Angso, Tony [mailto:Tony_Angso@medco.com] > Sent: March-05-08 1:23 PM > To: user-java@ibatis.apache.org > Subject: Need Help in iBatis Configuration > > > > Am running in RAD6 and getting the following error > > [3/5/08 14:24:50:692 EST] 00000025 SystemErr R > java.lang.RuntimeException: Error occurred. Cause: > com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: > java.lang.RuntimeException: Error parsing XPath > '/sqlMapConfig/transactionManager/dataSource/end()'. Cause: > com.ibatis.sqlmap.client.SqlMapException: Error initializing DataSource. > Could not instantiate DataSourceFactory. Cause: > java.lang.RuntimeException: SimpleDataSource: Error while loading > properties. Cause: java.lang.RuntimeException: SimpleDataSource: Some > properties were not set. > > my db.properties > > driver=oracle.jdbc.driver.OracleDriver > jdbc.url.alpha=jdbc:oracle:thin:@//mcfl1uaq:1535/MCDBI03 > username.alpha=user > password.alpha=password > > my sqlmapconfig.xml > > > 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd"> > > > lazyLoadingEnabled="true" maxRequests="1024" maxSessions="128" > maxTransactions="32" useStatementNamespaces="false"/> > > > > value="${jdbc.url.alpha}"/> > > > > > > > > Am getting error in > > String resource = "sqlmapconfig.xml"; > Reader reader = Resources.getResourceAsReader(resource); > alphaSqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); // <-- > error on this statement > > Appreciate any help! Thanks > Tony > > > ----------------------------------------- > This e-mail message and any attachments contain confidential > information from Medco. If you are not the intended recipient, you > are hereby notified that disclosure, printing, copying, > distribution, or the taking of any action in reliance on the > contents of this electronic information is strictly prohibited. If > you have received this e-mail message in error, please immediately > notify the sender by reply message and then delete the electronic > message and any attachments. > ------=_Part_18515_17908346.1204755571573 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline my first guess would be hmmmm Oracle!

if that one missed you, one might try

http://www.google.com/search?q=oracle+driver+for+java



On Wed, Mar 5, 2008 at 3:15 PM, Angso, Tony <Tony_Angso@medco.com> wrote:
Am getting this now
 Error while loading properties. Cause:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Where can I get the Oracle Driver?

-----Original Message-----
From: Clinton Begin [mailto:clinton.begin@gmail.com]
Sent: Wednesday, March 05, 2008 3:40 PM
To: user-java@ibatis.apache.org
Subject: RE: Need Help in iBatis Configuration


Wow, sorry for such a horribly unhelpful error!  That exception is
thrown if any of these keys are missing, not simply null, but completely
missing.

           <property name="JDBC.Driver" value="${driver}"/>
           <property name="JDBC.ConnectionURL"
value="${jdbc.url.alpha}"/>
           <property name="JDBC.Username" value="${username.alpha}"/>
           <property name="JDBC.Password" value="${password.alpha}"/>

But they are indeed there... so I'm confused too, as it should
succeed...?

Is there any chance this is the wrong XML configuration file that's
being loaded?

Clinton


-----Original Message-----
From: Angso, Tony [mailto:Tony_Angso@medco.com]
Sent: March-05-08 1:23 PM
To: user-java@ibatis.apache.org
Subject: Need Help in iBatis Configuration



Am running in RAD6 and getting the following error

[3/5/08 14:24:50:692 EST] 00000025 SystemErr R
java.lang.RuntimeException: Error occurred. Cause:
com.ibatis.common.xml.NodeletException: Error parsing XML. Cause:
java.lang.RuntimeException: Error parsing XPath
'/sqlMapConfig/transactionManager/dataSource/end()'. Cause:
com.ibatis.sqlmap.client.SqlMapException: Error initializing DataSource.
Could not instantiate DataSourceFactory. Cause:
java.lang.RuntimeException: SimpleDataSource: Error while loading
properties. Cause: java.lang.RuntimeException: SimpleDataSource: Some
properties were not set.

my db.properties

driver=oracle.jdbc.driver.OracleDriver
jdbc.url.alpha=jdbc:oracle:thin:@//mcfl1uaq:1535/MCDBI03
username.alpha=user
password.alpha=password

my sqlmapconfig.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config
2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
   <properties resource="db.properties"/>
   <settings cacheModelsEnabled="true" enhancementEnabled="true"
lazyLoadingEnabled="true" maxRequests="1024" maxSessions="128"
maxTransactions="32" useStatementNamespaces="false"/>
   <transactionManager type="JDBC">
       <dataSource type="SIMPLE">
           <property name="JDBC.Driver" value="${driver}"/>
           <property name="JDBC.ConnectionURL"
value="${jdbc.url.alpha}"/>
           <property name="JDBC.Username" value="${username.alpha}"/>
           <property name="JDBC.Password" value="${password.alpha}"/>
       </dataSource>
   </transactionManager>
   <sqlMap resource="xml/uv_sqlmap.xml"/>
</sqlMapConfig>

Am getting error in

String resource = "sqlmapconfig.xml";
Reader reader = Resources.getResourceAsReader(resource);
alphaSqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);  // <--
error on this statement

Appreciate any help! Thanks
Tony


-----------------------------------------
This e-mail message and any attachments contain confidential
information from Medco. If you are not the intended recipient, you
are hereby notified that disclosure, printing, copying,
distribution, or the taking of any action in reliance on the
contents of this electronic information is strictly prohibited. If
you have received this e-mail message in error, please immediately
notify the sender by reply message and then delete the electronic
message and any attachments.

------=_Part_18515_17908346.1204755571573--