[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [eclipselink-users] Issue with Stored Procedure call
|
Sorry for the multiple continuations but looking further up the stack thread
here is the section from where it establishes the connection -
[5/13/09 11:06:46:578 CDT] 00000048 SystemOut O [EL Config]: 2009-05-13
11:06:46.577--ServerSession(1028299246)--Connection(817075376)--Thread(Thread[WebContainer
: 2,5,main])--connecting(DatabaseLogin(
platform=>DB2Platform
user name=> ""
connector=>JNDIConnector datasource name=>jdbc/Auth
))
[5/13/09 11:06:46:845 CDT] 00000048 SystemOut O [EL Config]: 2009-05-13
11:06:46.844--ServerSession(1028299246)--Connection(1337149602)--Thread(Thread[WebContainer
: 2,5,main])--Connected:
jdbc:ibm:sqlserver://GMVMSQLITG:1433;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=3;DATABASENAME=websearch;MAXPOOLEDSTATEMENTS=0;ENABLECANCELTIMEOUT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true;CODEPAGEOVERRIDE=;DESCRIBEPARAMETERS=describeIfString;CONNECTIONRETRYCOUNT=0;BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;HOSTPROCESS=0;USESERVERSIDEUPDATABLECURSORS=false;ALWAYSREPORTTRIGGERRESULTS=false;RESULTSETMETADATAOPTIONS=0;QUERYTIMEOUT=0;HOSTNAMEINCERTIFICATE=;CATALOGINCLUDESSYNONYMS=true;SNAPSHOTSERIALIZABLE=false;JAVADOUBLETOSTRING=false;SENDSTRINGPARAMETERSASUNICODE=true;LOADLIBRARYPATH=;IMPORTSTATEMENTPOOL=;PROGRAMNAME=;NETADDRESS=000000000000;ALTERNATESERVERS=;WSID=;ENCRYPTIONMETHOD=NoEncryption;CONVERTNULL=1;TRUSTSTORE=;AUTHENTICATIONMETHOD=None;LONGDATACACHESIZE=2048;LOADBALANCING=false;TRANSACTIONMODE=implicit;WORKAROUNDS=0;INSENSITIVERESULTSETBUFFERSIZE=2048;RECEIVESTRINGPARAMETERTYPE=NVARCHAR;PACKETSIZE=0;DEFAULTSCALE=4;XMLDESCRIBETYPE=LONGVARCHAR;SELECTMETHOD=cursor
User: MSIUser
Database: Microsoft SQL Server Version: Microsoft SQL Server Yukon -
9.00.4035
Driver: SQLServer Version: 3.70.48 (029621.012908.017427)
[5/13/09 11:06:46:846 CDT] 00000048 SystemOut O [EL Config]: 2009-05-13
11:06:46.845--ServerSession(1028299246)--Connection(2055134739)--Thread(Thread[WebContainer
: 2,5,main])--connecting(DatabaseLogin(
platform=>DB2Platform
user name=> ""
connector=>JNDIConnector datasource name=>jdbc/Auth
))
[5/13/09 11:06:46:871 CDT] 00000048 SystemOut O [EL Config]: 2009-05-13
11:06:46.87--ServerSession(1028299246)--Connection(2122249972)--Thread(Thread[WebContainer
: 2,5,main])--Connected:
jdbc:ibm:sqlserver://GMVMSQLITG:1433;CATALOGOPTIONS=2;CONNECTIONRETRYDELAY=3;DATABASENAME=websearch;MAXPOOLEDSTATEMENTS=0;ENABLECANCELTIMEOUT=false;TRUSTSTOREPASSWORD=;VALIDATESERVERCERTIFICATE=true;CODEPAGEOVERRIDE=;DESCRIBEPARAMETERS=describeIfString;CONNECTIONRETRYCOUNT=0;BATCHPERFORMANCEWORKAROUND=false;INITIALIZATIONSTRING=;HOSTPROCESS=0;USESERVERSIDEUPDATABLECURSORS=false;ALWAYSREPORTTRIGGERRESULTS=false;RESULTSETMETADATAOPTIONS=0;QUERYTIMEOUT=0;HOSTNAMEINCERTIFICATE=;CATALOGINCLUDESSYNONYMS=true;SNAPSHOTSERIALIZABLE=false;JAVADOUBLETOSTRING=false;SENDSTRINGPARAMETERSASUNICODE=true;LOADLIBRARYPATH=;IMPORTSTATEMENTPOOL=;PROGRAMNAME=;NETADDRESS=000000000000;ALTERNATESERVERS=;WSID=;ENCRYPTIONMETHOD=NoEncryption;CONVERTNULL=1;TRUSTSTORE=;AUTHENTICATIONMETHOD=None;LONGDATACACHESIZE=2048;LOADBALANCING=false;TRANSACTIONMODE=implicit;WORKAROUNDS=0;INSENSITIVERESULTSETBUFFERSIZE=2048;RECEIVESTRINGPARAMETERTYPE=NVARCHAR;PACKETSIZE=0;DEFAULTSCALE=4;XMLDESCRIBETYPE=LONGVARCHAR;SELECTMETHOD=cursor
User: MSIUser
Database: Microsoft SQL Server Version: Microsoft SQL Server Yukon -
9.00.4035
Driver: SQLServer Version: 3.70.48 (029621.012908.017427)
So for some reason it thinks that the Database is DB2, I have another
Persistence Unit that is DB2 that it loads first, but this persistence.xml
defines it as SQLServer-
<persistence-unit name="cpsjpaSQL" transaction-type="RESOURCE_LOCAL">
<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
<non-jta-data-source>jdbc/Auth</non-jta-data-source>
<mapping-file>META-INF/sql-orm.xml</mapping-file>
<class>com.gmrc.jpa.domain.CpUser</class>
<exclude-unlisted-classes>true</exclude-unlisted-classes>
<properties>
<property name="eclipselink.target-server"
value="WebSphere_6_1"/>
<property name="eclipselink.target-database" value="SQLServer"/>
<property name="eclipselink.logging.level" value="FINE"/>
</properties>
</persistence-unit>
Any reason it would do this?
khaskett wrote:
>
> I am getting this error when I try to make a stored procedure call -
> [5/13/09 10:36:18:816 CDT] 00000048 SystemOut O [EL Fine]: 2009-05-13
> 10:36:18.816--ServerSession(1293761639)--Connection(777115371)--Thread(Thread[WebContainer
> : 2,5,main])--CALL spMSIRetrieve(paramBinarySession = ?, paramAgentNumber
> = ?, paramAgentSubcode = ?, paramInitials = ?, paramUserID = ?,
> paramLastName = ?, paramFirstName = ?, paramEmail = ?, paramReturn = ?)
> bind => [10111010000011011000001010111, => paramAgentNumber, =>
> paramAgentSubcode, => paramInitials, => paramUserID, => paramLastName, =>
> paramFirstName, => paramEmail, => paramReturn]
> [5/13/09 10:36:18:846 CDT] 00000048 SystemOut O [EL Fine]: 2009-05-13
> 10:36:18.846--ServerSession(1293761639)--Thread(Thread[WebContainer :
> 2,5,main])--VALUES(1)
> [5/13/09 10:36:18:849 CDT] 00000048 SystemOut O [EL Info]: 2009-05-13
> 10:36:18.849--UnitOfWork(2028275163)--Thread(Thread[WebContainer :
> 2,5,main])--Communication failure detected when attempting to perform read
> query outside of a transaction. Attempting to retry query.
>
> The weird thing about this is that it works fine for me locally but when
> it is installed at the client that's when they are seeing these errors.
>
>
--
View this message in context: http://www.nabble.com/Issue-with-Stored-Procedure-call-tp23524438p23525301.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.
